Important Tables in SAP BI (NW2004)

hwl198212

　　转自：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 fieldsRSTSRULES
Transfer Structure rulesRSAROUTTText name of Transfer RoutineDD03TText for R/3 Transfer structure ObjectsUpdate Rules RSUPDROUTUpdate rules List
RSUPDDAT  Update rules with routinesRSUPDKEY   Update rule key fieldsRSUPDINFOInfoProvider to Infosource correlationEmbedded ABAP coding for Transfer / Update Rules RSAABAP
ABAP source code per object routine
InfoPackage RSLDPIO
Links datasource to infopackagesRSLDPIOT
InfoPackage Text DescriptionRSLDPRULE
ABAP source code for InfoPackagesRSLDPSEL  
Hardcoded selections in InfoPackagesRSMONICDPContains the request-id number by data targetRSPAKPOS
List of InfoPackage Groups / InfoPackagesProcessChain
RSEVENTCHAIN  
Event Chain Processing Event TableRSEVENTHEAD   
Header for the event chainRSEVENTHEADT   
Header for the event chainRSPCCHAIN
Process chain details
RSPCCHAINATTR
Attributes for a Process ChainRSPCCHAINEVENTS
Multiple Events with Process ChainsRSPCCHAINT
Texts for ChainRSPCCOMMANDLOG
System Command Execution Logs (Process Chains)RSPCLOGCHAIN
Cross-Table Log ID / Chain IDRSPCLOGSApplication Logs for the Process ChainsRSPCPROCESSLOGLogs for the Chain RunsRSPCRUNVARIABLES
Variables for Process Chains for RuntimeRSPC_MONITOR
Monitor individual process chainsQueries
RSZELTDIR
Directory of the reporting component elements
RSZELTTXTTexts of reporting component elementsRSZELTXREFDirectory of query element referencesRSRREPDIR
Directory of all reports (Query GENUNIID)RSZCOMPDIRDirectory of reporting componentsRSZRANGESelection specification for an elementRSZSELECT
Selection properties of an element
RSZELTDIR
Directory of the reporting component elementsRSZCOMPIC
Assignment reuseable component <-> InfoCube
RSZELTPRIOPriorities with element collisions
RSZELTPROPElement properties (settings)
RSZELTATTR
Attribute selection per dimension elementRSZCALCDefinition of a formula elementRSZCEL
Query Designer: Directory of Cells
RSZGLOBV
Global Variables in Reporting
Workbooks RSRWBINDEXList 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 templatesRSRWORKBOOKWhere-used list for reports in workbooksWeb templates RSZWOBJ
Storage of the Web Objects
RSZWOBJTXT
Texts for Templates/Items/ViewsRSZWOBJXREFStructure of the BW Objects in a TemplateRSZWTEMPLATE
Header Table for BW HTML TemplatesInfoObject

RSDIOBJ                              
Directory of all InfoObjectsRSDIOBJT
Texts of InfoObjectsRSDIOBJ  
Directory of all InfoObjectsRSDIOBJT
Texts of InfoObjectsRSDATRNAVNavigation AttributesRSDATRNAVT
Navigation AttributesRSDBCHATRMaster Data AttributesRSDCHABASBasic Characteristics (for Characteristics,Time Characteristics, and Units)RSDCHA
Characteristics CatalogRSDDPA
Data Package CharacteristicRSDIOBJCMP
Dependencies of InfoObjectsRSKYF
Key FiguresRSDTIM
Time CharacteristicsRSDUNI
UnitsInfoCube RSDCUBE
Directory of InfoCubes
RSDCUBETTexts on InfoCubesRSDCUBEIOBJ
Objects per InfoCube (where-used list)RSDDIME
Directory of DimensionsRSDDIMETTexts on DimensionsRSDDIMEIOBJ
InfoObjects for each Dimension (Where-Used List)RSDCUBEMULTIInfoCubes involved in a MultiCubeRSDICMULTIIOBJ
MultiProvider: Selection/Identification of InfoObjectsRSDICHAPRO
Characteristic Properties Specific to an InfoCubeRSDIKYFPROFlag Properties Specific to an InfoCubeRSDICVALIOBJInfoObjects of the Stock Validity Table for the InfoCubeAggregates RSDDAGGRDIR
Directory of Aggregates
RSDDAGGRCOMP
Description of AggregatesRSDDAGGRTText on AggregatesRSDDAGGLTDirectory of the aggregates, textsODS Object
RSDODSO
Directory of all ODS Objects
RSDODSOT
Texts of all ODS ObjectsRSDODSOIOBJ
InfoObjects of ODS ObjectsRSDODSOATRNAVNavigation Attributes for ODS ObjectRSDODSOTABL
Directory of all ODS Object TablesPSA
RSTSODS
Directory of all PSA TablesDataSource (= OLTP Source)
ROOSOURCE  
Header Table for SAP BW DataSources (SAP Source System/BW System)
RODELTAMBW Delta Procedure (SAP Source System)RSOLTPSOURCEReplication Table for DataSources in BWInfoSource RSIS
Directory of InfoSources with Flexible Update
RSISTTexts on InfoSources with Flexible UpdateRSISFIELD
InfoObjects of an InfoSourceCommunications Structure
RSKSCommunications Structure for InfoSources with Flexible Update
RSKSCommunications Structure (View) for Attributes for an InfoSource with Direct UpdateRSKSFIELDTexts on InfoSources with Flexible UpdateRSISFIELDInfoObjects of an InfoSource with Flexible UpdateTransfer Structure
RSTS
Transfer Structure in SAP BW
ROOSGEN
Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System)Mapping RSISOSMAPMapping Between InfoSources and DataSources (=OLTP Sources)
RSOSFIELDMAPMapping Between DataSource Fields and InfoObjectsInfoSpoke
RSBSPOKESELSETInfoSpoke Directory and Selection Options
RSBSPOKEVSELSETInfoSpoke Directory with Selection Options and VersioningRSBSPOKEList of all InfoSpokes with attributes maintained with transaction RSBO which include the name of
the Source & Target StructuresRSBSPOKETList of all InfoSpokes with the Short & Long Descriptions (only one of these can be maintained).RSBSTEPIDMESSContains 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 RSDDSTATBasic Table for InfoCubes/QueriesRSDDSTATAGGR
Detail Table for Aggregate SetupRSDDSTATAGGRDEFDetail Table of Navigation for each InfoCube/QueryRSDDSTATCONDInfoCube CompressionRSDDSTATDELEInfoCube DeletionsRSDDSTATWHMWarehouse ManagementMisc RSSELDONE
InfoPackage selection and job program, there in field UPDMODE the update status (INIT/DELTA/FULL)RSPSADELPSA Table deletionTBTCPJob Schedule DefinitionTBTCOJob Schedule ResultRSMONMESS
Monitor MessagesRSERRORLOGCheck loading errors in tableV_RSZGLOBVReport Variables view tableDEVACCESSDeveloper Keys tableTSTCAll Transactions in the systemRSDDAGGRDIRDirectory of the aggregatesROIDOCPRMSControl parameters for data transfer from the source systemSMEN_BUFFCObjects in User's FavoritesWeb Item RSZWITEMHeader Table for BW Web ItemsRSZWMDITEMBW Web Metadata: Template Item ( Dataprovider, Item, ... ).Archiving
RSARCHIPRO
BW Archiving: General Archiving PropertiesRSARCHIPROIOBJBW Archiving: General Archiving PropertiesRSARCHIPROLOCBW ARchiving: General Local PropertiesRSARCHIPROLOCSELBW Archiving: Archived Data AreaRSARCHIPROPIDBW Archiving: Program References of InfoProviderRSARCHREQBW Archiving: Archiving RequestRSARCHREQFILESBW Archiving: Verfified Archive FilesRSARCHREQSELBW Archiving: Request-SelectionsOpen Hub Destination
RSBOHSERVICETP
Open Hub: Service TypesRSBREQUESTDELTA
Open Hub: Cross Reference Outbound/InboundRSBREQUESTMESSOpen Hub: Log for a RequestRSBREQUIDOpen Hub: RequestsRSBREQUID3RDOpen Hub: Status of 3rd Party RequestsRSBREQUIDRUNOpen Hub: Table with Status for a RequestRSBSTRUCTUREOpen Hub: Generated Structures and Tables