SID Table

[Former Member]

what is a SID table and what do you mean by deleting master data with SID or without SID ?

[Former Member]

Being Simple SID - surrogate id is an INT4 key which is used to hold the link between the dimension tables n the master data tables / char info object .

It is recommended to load master data first and then transaction data , SIDs r created when the TD is loaded for that particular master data .

it is also possible to load the TD with the option available in the upate tahb of the scheduler screen .......

let us know if u have any queries .....

regards .... Kumar Sarvepalli .....,,,, Honor points if useful.

[Former Member]

Hai Samruddhi,

SID Table acts as link between Dimension table and Master data Table.

i.e for every Dim Id in Dimension table a system generated Surrogate ID will be generated in the SID table which will link this Dimension Table to the respective Master table.

U can find the star schema in the link

http://www.bridgeport.edu/sed/projects/cs597/Fall_2003/vijaykse/extended_star_schema.htm

Deleting Master data with SID will delete the link between Dimension table and master data table.

Deleting Master data with out SID means the SID table will be present but the data will be deleted in the master table.

Regards

Madhavi

[Former Member]

Hi Samrudhhi,

SID(Surrogate ID) table : This are tables which store a specific integer for each infoobject you load as the Master data.

"what do you mean by deleting master data with SID or without SID ? "

in maintain master data you have the option to delete the master records with or without SID's.

if only master data is deleted,the SID's remain,as there will be existing reference in the transaction data.BW will not let you delete master data if the SID or value is used anywhere in the system.

cheers

Sunil

[Former Member]

Hi

SID table is one which stores the surrogative id's which inturn used to link master data with dimension tables. generally we will delete master data with SID's.

http://help.sap.com/saphelp_nw04s/helpdata/en/80/1a6365e07211d2acb80000e829fbfe/frameset.htm

Regards

Kiran