BW:数据字典 整理

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

   

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

   

BTW: 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 Table

   

Standard Infoobjects Tabels(Buss. Content):

Replace "C" with "0" in above tables.

Ex: /BI0/M -- View of Master data Tables

   

Standard 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 Tables

   

BW Tables:

BTCEVTJOB -- To check List of jobs waiting for events

ROOSOURCE -- Control parameters for Datasource

ROOSFIELD -- Control parameters for Datasource

ROOSPRMSC -- Control parameters for Datasource

ROOSPRMSF -- Control parameters for Datasource

-- More info @ ROOSOURCE weblog

RSOLTPSOURCE -- Replicate Table for OLTP source in BW

RSDMDELTA -- Datamart Delta Management

RSSDLINITSEL, 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 information

RSDCUBEIOBJ -- Infoobjects per Infocube

RSIS -- Infosouce Info

RSUPDINFO -- Update Rules Info

RSTS -- Transfer Rules Info

RSKSFIELD -- Communication Structure fields

RSALLOWEDCHAR -- Special Characters Table(T Code : RSKC, To maintain)

RSDLPSEL -- Selection Table for fields scheduler(Infpak's)

RSDLPIO -- Log data packet no

RSMONICTAB -- Monitor, Data Targets(Infocube/ODS) Table, request related info

RSTSODS -- Operational data store for Transfer structure

RSZELTDIR -- Query Elements

RSZGLOBV -- BEx Variables

RXSELTXREF, RSCOMPDIR -- Reports/query relavent tables

RSCUSTV -- Query settings

RSDIOBJ -- Infoobjects

RSLDPSEL -- Selection table for fields scheduler(Info pak list)

RSMONIPTAB -- InfoPackage for the monitor

RSRWORKBOOK -- Workbooks & related query genunid's

RSRREPDIR -- Contains Genuin id, Rep Name, author, etc...

RSRINDEXT -- Workbook ID & Name

RSREQDONE -- Monitor: Saving of the QM entries

RSSELDONE -- Monitor : Selection for exected requests

RSLDTDONE -- Texts on the requeasted infopacks & groups

RSUICDONE -- BIW: Selection table for user-selection update Infocubes's

RSSDBATCH -- Table for Batch run scheduler

RSLDPDEL -- Selection table for deleting with full update scheduler

RSADMINSV -- RS Administration

RSSDLINIT -- Last Valid Initializations to an OLTP Source

BTCEVTJOB --To check event status(scheduled or not)

VARI -- ABAP Variant related Table

VARIDESC -- Selection Variants: Description

   

T Code : SMQ1 --> QRFC Monitor(Out Bound)

T Code : SM13 --> Update Records status

T Code : LBWQ --> QRFC related Tables

TRFCQOUT,

QREFTID,

ARFCSDATA

   

SAP Data Dictionary用表

DD02L - SAP tables

DD02T - R/3 DD: SAP table text

DD03L - Table Fields

DD03T - DD: Texts for fields (language dependent)

EDD04L - Data elements

DD04T - R/3 DD: Data element texts

DD01L - Domains

DD01T - R/3 DD: domain texts

DD07L - R/3 DD: values for the domains

DD07T - DD: Texts for Domain Fixed Values (Language-Dependent)

Transparent tables can be identified using DD02L-TABCLASS = 'TRANSP'.