转自：http://www.cnblogs.com/clsoho/admin/EditPosts.aspx?opt=1
Listed below are some of the tables commonly used in SAP BI ( NW 2004) - however the same has not been tested in NW2004s and please make corrections if required. Some of this material has gone through a lot of eyeballs before making it to the final list and could contain some older references / incorrect references , however most of them have been validated.
| Transfer Structure |
|
RSTS
|
Transfer Structure List
|
RSTSFIELD
|
Transfer Structure fields |
RSTSRULES
|
Transfer Structure rules |
| RSAROUTT |
Text name of Transfer Routine |
| DD03T |
Text for R/3 Transfer structure Objects |
| Update Rules |
|
| RSUPDROUT |
Update rules List
|
| RSUPDDAT |
Update rules with routines |
| RSUPDKEY |
Update rule key fields |
| RSUPDINFO |
InfoProvider to Infosource correlation |
| Embedded ABAP coding for Transfer / Update Rules |
|
RSAABAP
|
ABAP source code per object routine
|
| InfoPackage |
|
RSLDPIO
|
Links datasource to infopackages |
RSLDPIOT
|
InfoPackage Text Description |
RSLDPRULE
|
ABAP source code for InfoPackages |
RSLDPSEL
|
Hardcoded selections in InfoPackages |
| RSMONICDP |
Contains the request-id number by data target |
RSPAKPOS
|
List of InfoPackage Groups / InfoPackages |
| ProcessChain |
|
RSEVENTCHAIN
|
Event Chain Processing Event Table |
RSEVENTHEAD
|
Header for the event chain |
RSEVENTHEADT
|
Header for the event chain |
RSPCCHAIN
|
Process chain details
|
RSPCCHAINATTR
|
Attributes for a Process Chain |
RSPCCHAINEVENTS
|
Multiple Events with Process Chains |
RSPCCHAINT
|
Texts for Chain |
RSPCCOMMANDLOG
|
System Command Execution Logs (Process Chains) |
RSPCLOGCHAIN
|
Cross-Table Log ID / Chain ID |
| RSPCLOGS |
Application Logs for the Process Chains |
| RSPCPROCESSLOG |
Logs for the Chain Runs |
RSPCRUNVARIABLES
|
Variables for Process Chains for Runtime |
RSPC_MONITOR
|
Monitor individual process chains |
Queries
|
|
RSZELTDIR
|
Directory of the reporting component elements
|
| RSZELTTXT |
Texts of reporting component elements |
| RSZELTXREF |
Directory of query element references |
RSRREPDIR
|
Directory of all reports (Query GENUNIID) |
| RSZCOMPDIR |
Directory of reporting components |
| RSZRANGE |
Selection specification for an element |
RSZSELECT
|
Selection properties of an element
|
RSZELTDIR
|
Directory of the reporting component elements |
RSZCOMPIC
|
Assignment reuseable component <-> InfoCube
|
| RSZELTPRIO |
Priorities with element collisions
|
| RSZELTPROP |
Element properties (settings)
|
RSZELTATTR
|
Attribute selection per dimension element |
| RSZCALC |
Definition of a formula element |
RSZCEL
|
Query Designer: Directory of Cells
|
RSZGLOBV
|
Global Variables in Reporting
|
| Workbooks |
|
| RSRWBINDEX |
List of binary large objects (Excel workbooks)
|
RSRWBINDEXT
|
Titles of binary objects (Excel workbooks) |
RSRWBSTORE
|
Storage for binary large objects (Excel workbooks) |
RSRWBTEMPLATE
|
Assignment of Excel workbooks as personal templates |
| RSRWORKBOOK |
Where-used list for reports in workbooks |
| Web templates |
|
RSZWOBJ
|
Storage of the Web Objects
|
RSZWOBJTXT
|
Texts for Templates/Items/Views |
| RSZWOBJXREF |
Structure of the BW Objects in a Template |
RSZWTEMPLATE
|
Header Table for BW HTML Templates |
InfoObject
|
|
RSDIOBJ
|
Directory of all InfoObjects |
RSDIOBJT
|
Texts of InfoObjects |
RSDIOBJ
|
Directory of all InfoObjects |
RSDIOBJT
|
Texts of InfoObjects |
| RSDATRNAV |
Navigation Attributes |
RSDATRNAVT
|
Navigation Attributes |
| RSDBCHATR |
Master Data Attributes |
| RSDCHABAS |
Basic Characteristics (for Characteristics,Time Characteristics, and Units) |
RSDCHA
|
Characteristics Catalog |
RSDDPA
|
Data Package Characteristic |
RSDIOBJCMP
|
Dependencies of InfoObjects |
RSKYF
|
Key Figures |
RSDTIM
|
Time Characteristics |
RSDUNI
|
Units |
| InfoCube |
|
RSDCUBE
|
Directory of InfoCubes
|
| RSDCUBET |
Texts on InfoCubes |
RSDCUBEIOBJ
|
Objects per InfoCube (where-used list) |
RSDDIME
|
Directory of Dimensions |
| RSDDIMET |
Texts on Dimensions |
RSDDIMEIOBJ
|
InfoObjects for each Dimension (Where-Used List) |
| RSDCUBEMULTI |
InfoCubes involved in a MultiCube |
RSDICMULTIIOBJ
|
MultiProvider: Selection/Identification of InfoObjects |
RSDICHAPRO
|
Characteristic Properties Specific to an InfoCube |
| RSDIKYFPRO |
Flag Properties Specific to an InfoCube |
| RSDICVALIOBJ |
InfoObjects of the Stock Validity Table for the InfoCube |
| Aggregates |
|
RSDDAGGRDIR
|
Directory of Aggregates
|
RSDDAGGRCOMP
|
Description of Aggregates |
| RSDDAGGRT |
Text on Aggregates |
| RSDDAGGLT |
Directory of the aggregates, texts |
ODS Object
|
|
RSDODSO
|
Directory of all ODS Objects
|
RSDODSOT
|
Texts of all ODS Objects |
RSDODSOIOBJ
|
InfoObjects of ODS Objects |
| RSDODSOATRNAV |
Navigation Attributes for ODS Object |
RSDODSOTABL
|
Directory of all ODS Object Tables |
PSA
|
|
RSTSODS
|
Directory of all PSA Tables |
DataSource (= OLTP Source)
|
|
ROOSOURCE
|
Header Table for SAP BW DataSources (SAP Source System/BW System)
|
| RODELTAM |
BW Delta Procedure (SAP Source System) |
| RSOLTPSOURCE |
Replication Table for DataSources in BW |
| InfoSource |
|
RSIS
|
Directory of InfoSources with Flexible Update
|
| RSIST |
Texts on InfoSources with Flexible Update |
RSISFIELD
|
InfoObjects of an InfoSource |
Communications Structure
|
|
| RSKS |
Communications Structure for InfoSources with Flexible Update
|
| RSKS |
Communications Structure (View) for Attributes for an InfoSource with Direct Update |
| RSKSFIELD |
Texts on InfoSources with Flexible Update |
| RSISFIELD |
InfoObjects of an InfoSource with Flexible Update |
Transfer Structure
|
|
RSTS
|
Transfer Structure in SAP BW
|
ROOSGEN
|
Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System) |
| Mapping |
|
| RSISOSMAP |
Mapping Between InfoSources and DataSources (=OLTP Sources)
|
| RSOSFIELDMAP |
Mapping Between DataSource Fields and InfoObjects |
InfoSpoke
|
|
| RSBSPOKESELSET |
InfoSpoke Directory and Selection Options
|
| RSBSPOKEVSELSET |
InfoSpoke Directory with Selection Options and Versioning |
| RSBSPOKE |
List of all InfoSpokes with attributes maintained with transaction RSBO which include the name of
the Source & Target Structures |
| RSBSPOKET |
List of all InfoSpokes with the Short & Long Descriptions (only one of these can be maintained). |
| RSBSTEPIDMESS |
Contains all the messages that have been recorded during the execution of an InfoSpoke. This table can
be added to using the ABAP Class/Method i_r_log->add_sy_message. |
| SAP BW Statistics |
|
| RSDDSTAT |
Basic Table for InfoCubes/Queries |
RSDDSTATAGGR
|
Detail Table for Aggregate Setup |
| RSDDSTATAGGRDEF |
Detail Table of Navigation for each InfoCube/Query |
| RSDDSTATCOND |
InfoCube Compression |
| RSDDSTATDELE |
InfoCube Deletions |
| RSDDSTATWHM |
Warehouse Management |
| Misc |
|
RSSELDONE
|
InfoPackage selection and job program, there in field UPDMODE the update status (INIT/DELTA/FULL) |
| RSPSADEL |
PSA Table deletion |
| TBTCP |
Job Schedule Definition |
| TBTCO |
Job Schedule Result |
RSMONMESS
|
Monitor Messages |
| RSERRORLOG |
Check loading errors in table |
| V_RSZGLOBV |
Report Variables view table |
| DEVACCESS |
Developer Keys table |
| TSTC |
All Transactions in the system |
| RSDDAGGRDIR |
Directory of the aggregates |
| ROIDOCPRMS |
Control parameters for data transfer from the source system |
| SMEN_BUFFC |
Objects in User's Favorites |
| Web Item |
|
| RSZWITEM |
Header Table for BW Web Items |
| RSZWMDITEM |
BW Web Metadata: Template Item ( Dataprovider, Item, ... ). |
Archiving
|
|
RSARCHIPRO
|
BW Archiving: General Archiving Properties |
| RSARCHIPROIOBJ |
BW Archiving: General Archiving Properties |
| RSARCHIPROLOC |
BW ARchiving: General Local Properties |
| RSARCHIPROLOCSEL |
BW Archiving: Archived Data Area |
| RSARCHIPROPID |
BW Archiving: Program References of InfoProvider |
| RSARCHREQ |
BW Archiving: Archiving Request |
| RSARCHREQFILES |
BW Archiving: Verfified Archive Files |
| RSARCHREQSEL |
BW Archiving: Request-Selections |
Open Hub Destination
|
|
RSBOHSERVICETP
|
Open Hub: Service Types |
RSBREQUESTDELTA
|
Open Hub: Cross Reference Outbound/Inbound |
| RSBREQUESTMESS |
Open Hub: Log for a Request |
| RSBREQUID |
Open Hub: Requests |
| RSBREQUID3RD |
Open Hub: Status of 3rd Party Requests |
| RSBREQUIDRUN |
Open Hub: Table with Status for a Request |
| RSBSTRUCTURE |
Open Hub: Generated Structures and Tables |
