Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
siva123hana
Explorer
1,944
Business Case: Large gaps between SIDs. Due to this, if SIDs reach 2 billion records. Then, data load is not possible to dependent target.

Execute a Program: ZSAP_SIDVALDISTRIB to find the Gaps by providing inputs as shown in below screen shot


Output of Program with percent filled between the splits

Screen Shot for reference:


Solution: Implemented following solutions to reduce the GAPs

  1. Apply Semantic Grouping in DTP based on Uniqueness value (even consider Compounding InfoObject also, if main InfoObject is part of Semantic group)

  2. Apply settings to parallel Buffering in Transaction code: SNRO for corresponding InfoObject


Changed to Parallel Buffering 


Result: Executed Program: ZSAP_SIDVALDISTRIB, by providing inputs to find the Gaps by providing inputs as shown in below screen shot


Output: No gaps between SIDs and 100 percent filled


Above implemented solutions, will not minimize / remove the gaps for already existing gaps.

Note:

If need to remove SID Gaps for already existing between SIDs, need to consult SAP for execution of program: ZSAP_SIDHI2LO. Because, SAP team will check which is the best appropriate solution.

Key points:

  1. Apply Semantic Grouping in DTP based on Uniqueness value

  2. Apply settings to parallel processing in Transaction code: SNRO for corresponding InfoObject

  3. Use SAP standard program: ZSAP_SIDHI2LO (with SAP Consulting) for renumbering of SIDs

  4. Program will be provided by SAP from OSS Note: 1331403

    1. ZSAP_SIDMAXGET – To find the InfoObject with Maximum SIDs

    2. ZSAP_SIDHI2LO – To renumber the already SID

    3. ZSAP_SIDVALDISTRIB – To find the percent filled between distribution of SIDs




 

Reference:

1331403 - SIDs, Numberranges and BW Infoobjects - SAP ONE Support Launchpad

 

 

 
1 Comment
Labels in this area