SAP BW 数据字典table介绍

http://sapbwneelam.blogspot.com/2007/08/bw-useful-tables.htmlQueriesRSZELTDIRDirectoryofthereportingcomponentelementsRSZELTTXTTextsofreportingcomponentelementsRSZELTXREFDirectoryofqueryelementreferencesRSRREPDIRDirectoryofallreports(QueryGENUNIID)RSZCOMPDIRDirectoryofreportingcomponentsWorkbooksRSRWBINDEXListofbinarylargeobjects(Excelworkbooks)RSRWBINDEXTTitlesofbinaryobjects(Excelworkbooks)RSRWBSTOREStorageforbinarylargeobjects(Excelworkbooks)RSRWBTEMPLATEAssignmentofExcelworkbooksaspersonaltemplatesRSRWORKBOOK'Where-usedlist'forreportsinworkbooksWebtemplatesRSZWOBJStorageoftheWebObjectsRSZWOBJTXTTextsforTemplates/Items/ViewsRSZWOBJXREFStructureoftheBWObjectsinaTemplateRSZWTEMPLATEHeaderTableforBWHTMLTemplatesBTW:Thereareonly26,000tablesinoursmallinstallationofBW3.5.BWUsefulTablesPostedIn:admin,bex,char,delta,elem,event,genuinid,global,infopak,init,lbwq,qrfc,query,rsa7,settings,tables,text,varia,variant,workbook.BySrinivasNeelamCustomeInfoobjectsTabels:/BIC/M--ViewofMasterdataTables/BIC/P--MasterdataTable,TimeIndependentattributes/BIC/Q--MasterdataTable,TimeDependentattributes/BIC/X--SIDTable,TimeIndependent/BIC/Y--SIDTabel,TimeDependent/BIC/T--TextTable/BIC/H--HeirarchyTable/BIC/K--HeirarchySIDTableStandardInfoobjectsTabels(Buss.Content):Replace"C"with"0"inabovetables.Ex:/BI0/M--ViewofMasterdataTablesStandardInfoCUBETables:/BI0/F--FactTable(BeforeCompression)/BI0/E--FactTable(AfterCompression)/BI0/P--DimensionTable-DataPackage/BI0/T--DimensionTable-Time/BI0/U--DimensionTable-Unit/BI0/1,2,3,.......A,B,C,D:--DimensionTablesBWTables:BTCEVTJOB--TocheckListofjobswaitingforeventsROOSOURCE--ControlparametersforDatasourceROOSFIELD--ControlparametersforDatasourceROOSPRMSC--ControlparametersforDatasourceROOSPRMSF--ControlparametersforDatasource--Moreinfo@ROOSOURCEweblogRSOLTPSOURCE--ReplicateTableforOLTPsourceinBWRSDMDELTA--DatamartDeltaManagementRSSDLINITSEL,RSSDLINITDEL--LastvalidInitializationtoanOLTPSourceRSUPDINFO--InfocubetoInfosourcecorrelationRSUPDDAT--UpdateruleskeyfiguresRSUPDENQ--RemovaloflocksintheupdaterulesRSUPDFORM--BW:UpdateRules-Formulas-CheckingTableRSUPDINFO--Updateinfo(statusandprogram)RSUPDKEY--Updaterule:KeyperkeyfigureRSUPDROUT--Updaterules-ABAProutine-checktableRSUPDSIMULD--TableforsavingsimulationdataupdateRSUPDSIMULH--TableforsavingsimulationdataheaderinformationRSDCUBEIOBJ--InfoobjectsperInfocubeRSIS--InfosouceInfoRSUPDINFO--UpdateRulesInfoRSTS--TransferRulesInfoRSKSFIELD--CommunicationStructurefieldsRSALLOWEDCHAR--SpecialCharactersTable(TCode:RSKC,Tomaintain)RSDLPSEL--SelectionTableforfieldsscheduler(Infpak's)RSDLPIO--LogdatapacketnoRSMONICTAB--Monitor,DataTargets(Infocube/ODS)Table,requestrelatedinfoRSTSODS--OperationaldatastoreforTransferstructureRSZELTDIR--QueryElementsRSZGLOBV--BExVariablesRXSELTXREF,RSCOMPDIR--Reports/queryrelaventtablesRSCUSTV--QuerysettingsRSDIOBJ--InfoobjectsRSLDPSEL--Selectiontableforfieldsscheduler(Infopaklist)RSMONIPTAB--InfoPackageforthemonitorRSRWORKBOOK--Workbooks&relatedquerygenunid'sRSRREPDIR--ContainsGenuinid,RepName,author,etc...RSRINDEXT--WorkbookID&NameRSREQDONE--Monitor:SavingoftheQMentriesRSSELDONE--Monitor:SelectionforexectedrequestsRSLDTDONE--Textsontherequeastedinfopacks&groupsRSUICDONE--BIW:Selectiontableforuser-selectionupdateInfocubes'sRSSDBATCH--TableforBatchrunschedulerRSLDPDEL--SelectiontablefordeletingwithfullupdateschedulerRSADMINSV--RSAdministrationRSSDLINIT--LastValidInitializationstoanOLTPSourceBTCEVTJOB--Tocheckeventstatus(scheduledornot)VARI--ABAPVariantrelatedTableVARIDESC--SelectionVariants:DescriptionSMQ1--QRFCMonitor(OutBound)SM13--UpdateRecordsstatusTCode:LBWQ-->QRFCrelatedTablesTRFCQOUT,QREFTID,ARFCSDATASAPDataDictionary用表DD02L-SAPtables&`+[:h\2u8N:YDD02T-R/3DD:SAPtabletexts"`4W!B7E4X#O#N7r1e5G4RDD03L-TableFields#?.X,i2|8n)^1}:a0T8l+{DD03T-DD:Textsforfields(languagedependent)#k8J!`0c'v)k!|-EDD04L-Dataelements"uZV8g+v.z(r\3DDD04T-R/3DD:Dataelementtexts$o-?!@%~;]9}5};a#G-`"kDD01L-Domains)Z;V,\7g/X'v#LDD01T-R/3DD:domaintexts)X*C2pa!t1`G+VDD07L-R/3DD:valuesforthedomains3m:V8@)Z,r!A.SDD07T-DD:TextsforDomainFixedValues(Language-Dependent)$Q5k*O(x-R)u2l;N/oTransparenttablescanbeidentifiedusingDD02L-TABCLASS=‘TRANSP’.转载请注明出处,本贴地址[注册查看]：http://www.waiqi8.com/bbs/viewthread.php?tid=1428&fromuid=0