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

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

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.

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 Nov 02, 2004 at 12:26 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Nov 02, 2004 at 11:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2004 at 09:00 AM

    Thanks Siggi , Your answer helped me.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2004 at 03:06 PM

    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.

    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.