Skip to Content
author's profile photo Former Member
Former Member

Table name of Cube and ODS

Hi all,

Can anybody tell me from where I found Cube table name or ODS table name where data is store after extraction ??

I saw one scenario in that scenario data is extract from 3 diffrent data sources and store in to ODS , In update rule of ODS I found code for a charactics :

select single /bic/zcprice1

from /bic/azcopco0100

into RESULT

where material = COMM_STRUCTURE-material

and plant = COMM_STRUCTURE-plant

and fiscper = g_fiscper.

Here i don't know from where /bic/azcopco0100 table name comes and how this query works ??

Thanks and regards

Ankit modi.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 06:18 AM

    Hi Ankit,

    Go to Transaction SE11 - > Give * Infocube Name * in Table field and press F4 , you will see all the table names like fact table, Dim tables etc.

    Example if cube name is ZSALES then give * ZSALES *.

    For ODS the Active table name is /BIC/A ODSNAME .

    Hope it helps.

    Regards

    Hemant Khemani

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 06:14 AM

    /bic/azcopco0100 - is the active table of ODS zcopco01.

    Regards,

    B

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 06:16 AM

    Hi,

    there is a naming convention for the tables.

    ods:

    active table /bic/a<name of ods>00

    new data /bic/a<name of ods>40

    change log /bic/b<some number>

    in case of standard objects replace /bic/ with /bi0/.

    For cubes it is

    Facttable /bic/F<name of cube>

    condensed facttable /bic/e<name of cube>

    Dimensions /bic/d<name of cube>x

    where x = R = request dim.

    x = U = Unit dim.

    x = T = time dim.

    x = 1 - D = your defined dimensions.

    for standard objects replace /bic/ with /bi0/.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 06:21 AM

    Namings for Cube:

    /BI<C OR DIGIT>/<TABLE CODE><INFOCUBE><DIMENSION>

    <C or digit>: C = Customer-defined InfoCube

    Digit = SAP-defined InfoCube

    <table code>: D = Dimension table

    E = Compressed fact table

    F = Uncompressed fact table

    <InfoCube>: The name of the InfoCube without leading digits (if any)

    <dimension>: (only used for dimension tables)

    P = Package dimension

    U = Unit dimension

    T = Time dimension

    0-9, A, B, C = User-defined dimension tables

    Namings for DSO:

    /BI<C OR DIGIT>/A<ODS OBJECT><TABLE CODE>

    <C or digit>: C = Customer-defined InfoObjects

    Digit = SAP-defined InfoObjects

    <ODS Object>: The name of the ODS object without leading digits (if any)

    <table code>: 00 = Active records (available for reporting)

    10 = New data records (prior to release 3.0, no longer used)

    40 = Activation queue (release 3.0)

    50 = Rollback queue (release 3.0)

    Thanks..

    Shambhu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.