Skip to Content

Inventory is always tricky and painful job when it comes to reload, recently when I enhanced the material movements data source 2LIS_03_BF with two new key figures, I faced the same challenge on reload i.e. “How to reload the data without ECC down time” .Since it is almost impossible to get sufficient amount of ECC downtime, I was pushed to the corner to come up with alternative approach to avoid the ECC down time.

Scenario: Data source BF got enhanced with two new key figures receipts and issues (modeled on the STD key figures 0ISSTOTSTCK & 0RECTOTSTCK) as per the business requirement

            Data flow: source system -> data source -> PSA -> inventory cube.

Solution: I enhanced a master data datasource to bring in some values which I intend to use to calculate the new key figures in the inventory cube.

I created a self upload Transformation for the inventory cube, in which apart from new key figures all other info objects are mapped 1:1, for new key figures I wrote a rule routine by reading the master data to calculate and populate the results.

Reload Technique: Since Inventory deals with Marker and No marker values while performing self reload we should take care of reloading both marker and no marker data.

Marker data reload

1.      Create a DTP using self upload transformation.

2.      Load DTP for marker data image

In DTP use Setting extraction mode “initial non-cumulative for non-cumulative” option.

3.      Selectively delete the data from the info cube with below selections.

Request ID NOT EQUAL current request ID (req id which got loaded by the marker DTP).

      Record type = 1.

4.       Compress the request with marker ( un checking the “No marker” option).

No Marker data reload

1.      Create a DTP using self upload transformation

2.      Load DTP for No marker data ( can use full or delta option).image

3.      Selectively delete the data from the info cube with below selections .

Request ID NOT EQUAL current request ID (req id which got loaded by the No marker DTP) .

Record type = 0.

4.      Compress the request with No marker (  checking the “No marker” option) . 

Conclusion: If correct logic can be identified and coded in to BW transformation to access the data from BW system to populate the enhanced fields , using the reload technique (explained above) ECC downtime can be prevented.

  Note: Apply SAP Note “Note 1426533 – P24: DTP: Non-cumulative IC update from another non-***. IC “which is mandatory to identify Marker & No marker data in the Cube.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply