SAP+BW+數(shù)據(jù)字典table介紹.doc

/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 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 personal 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 small installation of BW 3.5.BW Useful Tables Posted In: admin , bex , char , delta , elem , event , genuinid , global , infopak , init , lbwq , qrfc , query , rsa7 , settings , tables , text , varia , variant , 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 Dependent 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 :/BI0/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 parameters for DatasourceROOSFIELD - Control parameters for DatasourceROOSPRMSC - Control parameters for DatasourceROOSPRMSF - Control parameters for Datasource- More info ROOSOURCE weblogRSOLTPSOURCE - Replicate Table for OLTP source in BWRSDMDELTA - 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 RSUPDINFO - 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 - 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(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 pak 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 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 SourceBTCEVTJOB -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 E4 X# O# N7 r1 e5 G4 RDD03L - Table Fields# ?. X, i2 |8 n) 1 : a0 T8 l+ DD03T - DD: Texts for fields (language dependent)# k8 J! 0 c v) k! |- EDD04L - Data elements u Z V8 g+ v. z( r 3 DDD04T - R/3 DD: Data element texts$ o- ?! % ; 9 5 ; a# G- kDD01L - Domains) Z; V, 7 g/ X v# LDD01T - R/3 DD: domain texts) X* C2 p a! t1 G+ VDD07L - R/3 DD: values for the domains3 m: V8 )