« SAP BW Master Data Attribute Update Steps | Main | SAP Web Application Sample Code »

SAP BW Master Data Text Loading Steps

 SAP BW Master Data Text Loading Steps

Loading text records is similar to (yet simpler than) loading attribute records, because there are no additional SID tables to update:

Master Data Text Update Algorithm

*** STEP 1 - Process data package record by record

Loop at data package. 

*** STEP 2 - Surrogate key handling

  Retrieve/Generate surrogate key.

  Update SID table.

*** STEP 3 - Non time dependent master data texts.

  Retrieve existing non time dependent record.

  Insert/Update non time dependent texts.

*** STEP 4 - Time dependent master data texts.

  Retrieve existing time dependent records.

  Check for validity period overlaps.

  Adjust overlap records accordingly.

  Insert/Update time dependent texts.

End.

Posted by Kevin McDonald on August 23, 2006 01:41 PM |

TrackBack

TrackBack URL for this entry:
http://renditionx.com/blog-mt/mt-tb.fcgi/62


Hosting by Yahoo!

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)