Table names for master data

[Former Member]

Hi

Can any one please expalin me what are the diffrent type of masterdata tables and also tables related to infocube in BI 7

Rashmi

[Former Member]

I found the same as above

Rashmi

[Former Member]

Hi

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

hope this helps

Santosh

[Former Member]

Hi

Thanks a lot

Rashmi

[raghu_ram]

Hi Rashmi,

these are master data tables:

S - SID table

T- Text table

P- Tiem dependent masterdat tbale

Q -Tiem independent Masterdata tabe

M - Combination of Pand Q

X - Time dependent Navigational attributes

Y - Time independent Navigational atttributes

H - Hierarchey table

K - Heirarchy SID table

I - Heirarchy structure table

J - Herirarchy tiem interval

Z- table.

Please check the following tables for Infocubes:

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

RSTSODS

RSZCOMPIC

RSZCOMPDIR

hope it helps,

Regards,

Raghu.

Edited by: Raghu on Oct 27, 2009 10:01 PM