SAP BW Master Data Attribute Update Steps 

The following steps show a highly simplified master data attributes update process:

Master Data Attribute Update

*** 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.

  Retrieve existing non time dependent record.

  Insert/Update non time dependent attributes.

  Retrieve surrogate keys for attributes.

  If not all SIDs available.

    If master data check requested.

      Log error, start error handling.

    Else.

      Generate new SID.

    End.

  Insert/Update attribute SID table

*** STEP 4 - Time dependent master data.

  Retrieve existing time dependent records.

  Check for validity period overlaps.

  Adjust overlap records accordingly.

  Insert/Update time dependent attributes.

  Retrieve surrogate keys for attributes.

  If not all SIDs available.

    If master data check requested.

      Log error, start error handling.

    Else.

      Generate new SID.

    End.

  Insert/Update attribute SID table

End.