SAP+BW+数据字典table介绍

1、.：.； HYPERLINK sapbwneelam.blogspot/2007/08/bw-useful-tables.html sapbwneelam.blogspot/2007/08/bw-useful-tables.htmlQueriesRSZELTDIR Directory of the reporting component elementsRSZELTTXT Texts of reporting component elementsRSZELTXREF Directory of query element referencesRSRREPDIR Directory of all

2、reports (Query GENUNIID)RSZCOMPDIR Directory of reporting componentsWorkbooksRSRWBINDEX 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 pers

3、onal templatesRSRWORKBOOK Where-used list for reports in workbooksWeb templatesRSZWOBJ Storage of the Web Objects RSZWOBJTXT Texts for Templates/Items/Views RSZWOBJXREF Structure of the BW Objects in a TemplateRSZWTEMPLATE Header Table for BW HTML TemplatesBTW: There are only 26,000 tables in our sm

4、all installation of BW 3.5. HYPERLINK sapbwneelam.blogspot/2007/08/bw-useful-tables.html o Permanent Link to BW Useful Tables BW Useful Tables Posted In: HYPERLINK sapbwneelam.blogspot/search/label/admin admin , HYPERLINK sapbwneelam.blogspot/search/label/bex bex , HYPERLINK sapbwneelam.blogspot/sea

5、rch/label/char char , HYPERLINK sapbwneelam.blogspot/search/label/delta delta , HYPERLINK sapbwneelam.blogspot/search/label/elem elem , HYPERLINK sapbwneelam.blogspot/search/label/event event , HYPERLINK sapbwneelam.blogspot/search/label/genuinid genuinid , HYPERLINK sapbwneelam.blogspot/search/labe

6、l/global global , HYPERLINK sapbwneelam.blogspot/search/label/infopak infopak , HYPERLINK sapbwneelam.blogspot/search/label/init init , HYPERLINK sapbwneelam.blogspot/search/label/lbwq lbwq , HYPERLINK sapbwneelam.blogspot/search/label/qrfc qrfc , HYPERLINK sapbwneelam.blogspot/search/label/query qu

7、ery , HYPERLINK sapbwneelam.blogspot/search/label/rsa7 rsa7 , HYPERLINK sapbwneelam.blogspot/search/label/settings settings , HYPERLINK sapbwneelam.blogspot/search/label/tables tables , HYPERLINK sapbwneelam.blogspot/search/label/text text , HYPERLINK sapbwneelam.blogspot/search/label/varia varia ,

8、HYPERLINK sapbwneelam.blogspot/search/label/variant variant , HYPERLINK sapbwneelam.blogspot/search/label/workbook workbook . By Srinivas Neelam Custome Infoobjects Tabels:/BIC/M - View of Master data Tables/BIC/P - Master data Table, Time Independent attributes/BIC/Q - Master data Table, Time Depen

9、dent attributes/BIC/X - SID Table, Time Independent/BIC/Y - SID Tabel, Time Dependent/BIC/T - Text Table/BIC/H - Heirarchy Table/BIC/K - Heirarchy SID TableStandard Infoobjects Tabels(Buss. Content):Replace C with 0 in above tables.Ex: /BI0/M - View of Master data TablesStandard InfoCUBE Tables :/BI

10、0/F - Fact Table(Before Compression)/BI0/E - Fact Table(After Compression)/BI0/P - Dimension Table - Data Package/BI0/T - Dimension Table - Time/BI0/U - Dimension Table - Unit/BI0/1, 2, 3, .A,B,C,D : - Dimension TablesBW Tables: BTCEVTJOB - To check List of jobs waiting for eventsROOSOURCE - Control

11、 parameters for DatasourceROOSFIELD - Control parameters for DatasourceROOSPRMSC - Control parameters for DatasourceROOSPRMSF - Control parameters for Datasource- More info HYPERLINK httpssdn.sap/irj/sdn/weblogs?blog=/pub/wlg/2282 ROOSOURCE weblogRSOLTPSOURCE - Replicate Table for OLTP source in BWR

12、SDMDELTA - Datamart Delta ManagementRSSDLINITSEL, RSSDLINITDEL- Last valid Initialization to an OLTP Source RSUPDINFO - Infocube to Infosource correlation RSUPDDAT - Update rules key figures RSUPDENQ - Removal of locks in the update rules RSUPDFORM - BW: Update Rules - Formulas - Checking Table RSUP

13、DINFO - Update info (status and program) RSUPDKEY - Update rule: Key per key figure RSUPDROUT - Update rules - ABAP routine - check table RSUPDSIMULD - Table for saving simulation data update RSUPDSIMULH - Table for saving simulation data header informationRSDCUBEIOBJ - Infoobjects per InfocubeRSIS

14、- Infosouce InfoRSUPDINFO - Update Rules InfoRSTS - Transfer Rules InfoRSKSFIELD - Communication Structure fieldsRSALLOWEDCHAR - Special Characters Table(T Code : RSKC, To maintain)RSDLPSEL - Selection Table for fields scheduler(Infpaks)RSDLPIO - Log data packet noRSMONICTAB - Monitor, Data Targets(

15、Infocube/ODS) Table, request related infoRSTSODS - Operational data store for Transfer structureRSZELTDIR - Query ElementsRSZGLOBV - BEx VariablesRXSELTXREF, RSCOMPDIR - Reports/query relavent tablesRSCUSTV - Query settingsRSDIOBJ - Infoobjects RSLDPSEL - Selection table for fields scheduler(Info pa

16、k list)RSMONIPTAB - InfoPackage for the monitorRSRWORKBOOK - Workbooks & related query genunidsRSRREPDIR - Contains Genuin id, Rep Name, author, etc.RSRINDEXT - Workbook ID & NameRSREQDONE - Monitor: Saving of the QM entriesRSSELDONE - Monitor : Selection for exected requestsRSLDTDONE - Texts on the

17、 requeasted infopacks & groupsRSUICDONE - BIW: Selection table for user-selection update InfocubessRSSDBATCH - Table for Batch run schedulerRSLDPDEL - Selection table for deleting with full update schedulerRSADMINSV - RS Administration RSSDLINIT - Last Valid Initializations to an OLTP SourceBTCEVTJO

18、B -To check event status(scheduled or not)VARI - ABAP Variant related TableVARIDESC - Selection Variants: DescriptionSMQ1 - QRFC Monitor(Out Bound)SM13 - Update Records statusT Code : LBWQ - QRFC related TablesTRFCQOUT,QREFTID,ARFCSDATASAP Data Dictionary用表DD02L - SAP tables& + : h 2 u8 N: YDD02T - R/3 DD: SAP table texts 4 W! B7