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