8 Replies Latest reply: Oct 4, 2007 8:46 AM by Ronald Rene RSS

Table names

Ronald Rene
Currently Being Moderated

Hi,

 

can any one provide me with the table names in BW.

 

Thanks in advance,

 

Ronald

  • Re: Table names
    Gattu Chaithanya
    Currently Being Moderated

    Ronald,

     

    For System tables there is no naming convention as such..

    Usually configuration related tables start with T*..

    few examples:--

    T000 Clients

    T002 Language Keys

    T002C Customizing Data for T002

     

    If you are looking for standard ODS and cubes that are delivered by SAP..

    Example of they look like for dimension tables..

    /BI0/D0BWTC_C02P Data Package

    /BI0/D0BWTC_C02T Time

     

    Usually they start with /BI0/* for standard business content objects and /BIC/* for custom ODS and cubes etc you develop..

     

    We have R* tables that are important for various other things..

     

    Examples:

     

    RODELTAM BW Delta Process

    RODELTAMT BW Delta Process (Text)

    RODIOBJ InfoObjects of the source system

     

    And also please go thru these threads for more information about tables:

     

    Tables in BW

    Master tables  & fact tables

    tables for attributes

    Dim tables

     

    Hope it helps.

     

    ********Assign Points if it helps************

     

    Regards,

     

    Gattu

  • Re: Table names
    Habeebuddin Mohammed
    Currently Being Moderated

    Hi Ronlad,

     

    <b>BW TABLE NAMES:</b> Naming Convention:

    Note: You can replace the BIC with BI0 for business content objects.

     

    1./bic/f (cube name) is the fact table of a content cube

    2./bic/D (cube name) P is the package dimension of a content cube

    3./bic/D(cube name) U is the unit dimension of a content cube

    4./bic/D(cube name) T is the time dimension of a content cube

    5./bic/D(cube name) I is the user defined dimension of a content cube

    6./bic/m (object name) master data of object

    7./bic/t (object name) text data of object

    8./bic/H (object name) hierarchy data of object

     

     

    <i>Others</i>

    1. RSDIOBJ - index of all Info Objects

    2.RSSELDONE - Monitor: Selections for executed request

    3.RSREQDONE - Monitor: Saving of the QM entries, state of the uploads, all info about the upload via request number, field: RNR

     

     

    <i>ODS Table names</i>

     

    1.New data: /BIC/A (ODS NAME)40

     

    2.Active data: /BIC/A (ODS NAME)00

     

    3.Change log: /BIC/B ( NUMBERS)

     

    <i>Compression</i>

    The Fact Table is partitioned by request-id.

    When you compress an info cube, the fact table changes, from /bic/f<info cube> to /bic/e<info cube>. This compressed fact table can be partitioned by time (month or year).

     

     

     

    • RSTSODS (Operational Data Store for the transfer structure) table that contain relation between "ODS Name" and PSA Table.

     

    Hope this helps.

     

    Regards,

    Habeeb

  • Re: Table names
    Patrick Rieken
    Currently Being Moderated

    Hi Ronald, here we go for BW specific tables related to loaded data:

     

    /BIC/H*            Hierarchy: InfoObject

    /BIC/I*             SID Structure of Hierarchies

    /BIC/K*           Conversion of Hierarchy Nodes - SID

    /BIC/P*           Master Data (Time-Ind.): Characteri

    /BIC/Q*           Master Data (Time-Ind.): Characteri

    /BIC/S*           Master Data IDs: InfoObject

    /BIC/T*           Texts: Char.

    /BIC/X*           Attribute SID Table: InfoObject

    /BIC/Y*           Attribute SID Table (Time-Dep.):

    /BIC/B*           Transfer structure PSA/Changelog

    /BIC/A*           ODS Active records

    /BIC/F*           Info cube F-Fact table

    BIC/E*            Info cube E-Fact table (compressed records)

    /BIC/D*           info cube dimension tables

    Regards,  Patrick Rieken.

     

    Message was edited by:

            Patrick Rieken - BI-Formance B.V.

  • Re: Table names
    Habeebuddin Mohammed
    Currently Being Moderated

    Hi,

     

    Here come some more tables not very related only to BW but important when you 'restoring' connection to source systems after upgrades/migrations:

    TBDLS - Logical system customization, when you run TA: BDLS

    EDP21 - Partner Profile, when you run TA: WE20

    RSBASIDOC - Assignment of source systems to BIW systems incl. IDoc type

     

    Reports:

    In V_COMPDIR_COMPIC you can also see all your reports/Info cubes. The advantage is that you can see the name/text of the query, not only the technical id.

     

    RSRREPDIR (Directory of all reports) which is the table containing all your reports.

     

    Regards,

    Habeeb

  • Re: Table names
    Habeebuddin Mohammed
    Currently Being Moderated

    Hi,

     

    Here are some more:

     

    <i>For authorization:</i>

     

    RSSTOBJDIR (Management Table for Authorization Objects): Link between specific authorization object and Info source (table used by transaction RSSM)

     

     

    <i>Relevant Table names:</i>

     

    RSDCUBEIOBJ Objects per Info Cube (where-used list)

    RSDODSOATRNAV Info Object in ODS (navigational attributes)

    RSDODSOIOBJ Info Object in ODS

    RSDIOBJT Info Object texts

    RSDIOBJ Directory of all Info Objects

    RSDKYF Key figures

    RSDBCHATR Master data attributes

    RSBBSQUERYDIR BW: Directory of the Query Sender

    RSBBSQUERY BW: Query Receiver

    RSBBSQUERYT BW: Texts for Query Receiver

    TQOP Compare Operators for View Maintenance Query

    TQOPT Compare operators for view maintenance query (texts)

    TQLOT Logical operators for view maintenance query (texts)

    ROMSDIOBJ BIW: Assignment of master data attributes to Info Objects

    RODCHA BIW: Info Objects / characteristics

    RODIOBJCMP BIW: Info Objects / compounding

    RODKYF BIW: Key figures

    ROAPPLT BIW: Name of the application components

    RSUICDONE BIW: Selection table for user-selection update ICs

    RODTIM BIW: Time characteristics

    RODUNI BIW: Units

    RSIST Info Source texts

    RSIS Info Source (transaction data)

    RSISOSMAP Mapping Between Info Sources and OLTP Sources

    RSOSFIELDMAP Mapping Between OLTP Source Fields and Info Objects

    RSUPDDAT Update rules key figures

    RSUPDKEY Update rule: Key per key figure

    RSUPDROUT Update rules - ABAP routine - check table

    RSRWBINDEXT Titles of binary objects (Excel workbooks) in Info Catalog

    RSRWORKBOOK 'Where-used list' for reports in workbooks

    RSDDIME Dimensions directory

    RSDDIMEIOBJ Info Objects per dimension (where-used list)

    RSDDIMET Dimension Texts

    RSZCOMPDIR Directory of reporting components

    RSZELTATTR Attribute selection per dimension element

    RSZELTDIR Directory of the reporting component elements

    RSZELTTXT Texts of reporting component elements

    RSZELTXREF Directory of query element references

    RSZGLOBV Global Variables in Reporting

    RSDCUBET Texts for the Info Cubes.

     

     

    •Evaluating the table DD02T via transaction SE16 gives you all existing tables.

    A very large list of course, but you can preselect (for example RSD*).

     

    Regards,

    Habeeb

  • Re: Table names
    Krish K
    Currently Being Moderated

    Hi,,,

    Transfer Rules

    RSTS Transfer Structure

    RSTSFIELD Transfer Structure fields

    RSTSRULES Transfer Structure rules

    RSAROUTT Text name of Transfer Routine

    DD03T Text for R/3 Transfer structure Objects

    Update Rules

    RSUPDROUT  Update rules

    RSUPDDAT Update rules with routines

    RSUPDKEY Update rule key fields

    RSUPDINFO InfoProvider to Infosource correlation

    Embedded ABAP coding for Transfer / Update Rules

    RSAABAP ABAP source code per object routine

      InfoPackage

    RSLDPIO Links datasource to infopackages

    RSLDPIOT InfoPackage Text Description

    RSLDPRULE ABAP source code for InfoPackages

    RSLDPSEL Hardcoded selections in InfoPackages

    RSMONICDP Contains the request-id number by data target

    RSPAKPOS List of InfoPackage Groups / InfoPackages

    ProcessChain

    RSEVENTCHAIN Event Chain Processing Event Table

    RSEVENTHEAD Header for the event chain

    RSEVENTHEADT Header for the event chain

    RSPCCHAIN Process chain

    RSPCCHAINATTR Attributes for a Process Chain

    RSPCCHAINEVENTS Multiple Events with Process Chains

    RSPCCHAINT Texts for Chain

    RSPCCOMMANDLOG  System Command Execution Logs (Process Chains)

    RSPCLOGCHAIN Cross-Table Log ID / Chain ID

    RSPCLOGS Application Logs for the Process Chains

    RSPCPROCESSLOG  Logs for the Chain Runs

    RSPCRUNVARIABLES Variables for Process Chains for Runtime

    RSPC_MONITOR Monitor individual process chains

      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

     

     

     

    InfoObject

     

    RSDIOBJ?

    Directory of all InfoObjects

     

    RSDIOBJT?

    Texts of InfoObjects

     

    RSDATRNAV?

    Navigation Attributes

     

    RSDATRNAVT?

    Navigation Attributes

     

    RSDBCHATR?

    Master Data Attributes

     

    RSDCHABAS?

    Basic Characteristics (for Characteristics, Time Characteristics, and Units)

     

    RSDCHA?

    Characteristics Catalog

     

    RSDDPA?

    Data Package Characteristic

     

    RSDIOBJCMP?

    Dependencies of InfoObjects

     

    RSKYF?

    Key Figures

     

    RSDTIM?

    Time Characteristics

     

    RSDUNI   Units

     

     

     

    InfoCube

     

    RSDCUBE Directory of InfoCubes

     

    RSDCUBET Texts on InfoCubes

     

    RSDCUBEIOBJ Objects per InfoCube (where-used list)

     

    RSDDIME Directory of Dimensions

     

    RSDDIMET Texts on Dimensions

     

    RSDDIMEIOBJ InfoObjects for each Dimension (Where-Used List)

     

    RSDCUBEMULTI InfoCubes involved in a MultiCube?

     

    RSDICMULTIIOBJ

    MultiProvider?: Selection/Identification of InfoObjects

     

    RSDICHAPRO Characteristic Properties Specific to an InfoCube

     

    RSDIKYFPRO Flag Properties Specific to an InfoCube

     

    RSDICVALIOBJ  InfoObjects of the Stock Validity Table for the InfoCube

     

     

     

    Aggregates

     

    RSDDAGGRDIR Directory of Aggregates

     

    RSDDAGGRCOMP Description of Aggregates

     

    RSDDAGGRT Text on Aggregates

     

     

     

    ODS Object

     

    RSDODSO Directory of all ODS Objects

     

    RSDODSOT Texts of all ODS Objects

     

    RSDODSOIOBJ InfoObjects of ODS Objects

     

    RSDODSOATRNAV Navigation Attributes for ODS Object

     

    RSDODSOTABL Directory of all ODS Object Tables

     

     

     

    PSA

     

    RSTSODS Directory of all PSA Tables

     

     

     

    DataSource (= OLTP Source)

     

    ROOSOURCE Header Table for SAP BW DataSources (SAP Source System/BW System)

     

    RODELTAM BW Delta Procedure (SAP Source System)

     

    RSOLTPSOURCE Replication Table for DataSources in BW

     

     

     

    InfoSource

     

    RSIS Directory of InfoSources with Flexible Update

     

    RSIST Texts on InfoSources with Flexible Update

     

    RSISFIELD InfoObjects of an InfoSource

    Communications Structure

    RSKS Communications Structure for InfoSources with Flexible Update

    RSKS Communications Structure (View) for Attributes for an InfoSource with Direct Update

    RSKSFIELD Texts on InfoSources with Flexible Update

    RSISFIELD InfoObjects of an InfoSource with Flexible Update

    Transfer Structure

    RSTS Transfer Structure in SAP BW

    ROOSGEN Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System)

    Mapping

    RSISOSMAP Mapping Between InfoSources and DataSources (=OLTP Sources)

    RSOSFIELDMAP Mapping Between DataSource Fields and InfoObjects

    InfoSpoke

    RSBSPOKESELSET InfoSpoke? Directory and Selection Options

    RSBSPOKEVSELSET InfoSpoke? Directory with Selection Options and Versioning

    SAP BW Statistics

    RSDDSTAT Basic Table for InfoCubes/Queries

    RSDDSTATAGGR Detail Table for Aggregate Setup

    RSDDSTATAGGRDEF  Detail Table of Navigation for each InfoCube/Query

    Misc

    RSSELDONE InfoPackage selection and job program

    RSPSADEL PSA Table deletion

    TBTCP  Job Schedule Definition

    TBTCO  Job Schedule Result

    RSMONMESS  Monitor Messages

    RSERRORLOG  Check loading errors in table

    V_RSZGLOBV  Report Variables view table

    DEVACCESS  Developer Keys table

    TSTC  All Transactions in the system

    RSDDAGGRDIR  Directory of the aggregates

    ROIDOCPRMS  Control parameters for data transfer from the source system

    SMEN_BUFFC Objects in User's Favorites

  • Re: Table names
    Ronald Rene
    Currently Being Moderated

    Thanks Habeeb found what I was looking for.

Actions