SID TABLE

[Former Member]

Hi All,

What is a SID table and what it contains?

What is the significance is Surrogate ID (SID)?

How SID is generated?

How it links with Dimension table and Fact table?

Please answer in detail.

Points will b rewarded.

Thank you.

Message was edited by:

Harshal Panchal

[Former Member]

Harshal,

SID is surrogate ID generated by the system. The SID tables are created when we create a master data IO. In SAP BW star schema, the distinction is made between two self contained areas: Infocube & master data tables/SID tables.

The master data doesn't reside in the satr schema but resides in separate tables which are shared across all the star schemas in SAP BW. A numer ID is generated which connects the dimension tables of the infocube to that of the master data tables.

The dimension tables contain the dim ID and SID of a particular IO. Using this SID the attributes and texts of an master data Io is accessed.

The SID table is connected to the associated master data tables via teh char key