Generation of SID numbers for records in SID tables of InfoObjects.

[Former Member]

There is an SID table corresponding to each active InfoObject. It will be of great help if, someone could tell me how is the SID generated for each new record in that table, i.e. is it through some sequence or if some table is used to get the value.

[Former Member · Accepted solution]

Hi,

there is a number range object for each characteristic. For custom created characteristics this number range object will be generated. Every time, when a new value is posted to the master data table, table nriv is read and updated, to get the next SID.

regards

Siggi

[Former Member · Accepted solution]

Hi Siggi,

I was not able to figure out the characteristics for which I wanted to see the next sequence no. in the table nriv i.e in the table nriv, in the column 'Object' there was no entry with the characteristics under question. This is a simple characteristic with no master & text data. Does there exist some other table as well which can be looked into.

Thanks & Regards.

[Former Member · Accepted solution]

Hi Praveen,

I think the Object is something like 'BID' for all objects in BW that require SID's. May be you can check the actual highest SID in your SID table and select from NRIV Object 'BID' with your SID +/- one.

Hope it helps.

Siggi

[Former Member]

Tran SNRO will provide list of all of the number roange tables, SIDs, and for Dimensions.

Not sure why you need to know what the next SID value for an InfoObject is going to be - that's why surrogates are used in the first place.

If you have characteristics or dimensions where there is a high volume of new numbers being assigned daily, you can use SNRO to buffer several of the next available numbers (perhaps 100 - 500) in memory. This can improve load times by reducing the the number of times a load process needs to read and update these number range tables in a given load.

[Former Member]

Thanks Siggi , Your answer helped me.

[Former Member]

Hi Praveen.

I donot know the stright forward answer for your question. But i can give a hint to slove your problem .

Activate the SQL trace ,Just before executing the infopackage for populating the master data.And stop it after some time or after completion of data loading.

Then go through tha trace.You may find the algorithum of creating the sid.

With rgds,

Anil