SAP BW4HANA 1.0 SPS9 Inventory Management Implementation

[former_member216525]

Hi Experts,

We are implementing Inventory Management as per the standard SAP Content on SAP BW4HANA 1.0 SPS 9

-Completed the Initial loads for all target ADSO as per guidelines in the SAP Link provided below for BW4HANA

-In Stock overview report (STD SAP report) “Quantity Total Stock” are showing exactly twice the quantity when executing the report, I can observer that it is because both Delta Movements (/IMO/CMMMIM01 -> ADSO /IMO/D_MMIM01) and Historical Movements ADSO (ADSO /IMO/CMMMIMH1 -> ADSO /IMO/D_MMIM01) are being loaded to Target ADSO D_MMIM01 with DTP settings (uncheck the historical Transactions for delta) for all delta loads

Can you please suggest if these two ADSO i.e, Delta Movements and historical movements should be loaded to target if yes are we missing any settings in DTP/ADSO for delta loads to get the correct output in report.

Other way is that should we load Historical Movements ADSO (ADSO /IMO/CMMMIMH1 -> ADSO /IMO/D_MMIM01) for the first time, and for delta’s only the Delta Movements (/IMO/CMMMIM01 -> ADSO /IMO/D_MMIM01) ADSO should be loading part of daily loads.

The query applies for Revaluations flow as well. Please suggest

https://help.sap.com/viewer/06e872f914a44d77b6c692b0273ca400/1.0.10/en-US/e94584e3d34c4c7e8dfa8e34c0...

Thanks,

Mahesh Kumar. A

[former_member71289 · Accepted solution]

Hi Mahesh,

totally correct, DTP into the 'delta' staging DSOs /IMO/CMMIM01 for movements and /IMO/CMMIM02 for revaluations should be done with setting "Delta init without data".

For the issue

1) "DTP flowing from /IMO/CMMMIM01 to /IMO/D_MMIM01 (...) is automatically getting checked even though it is unchecked manually". What exactly did you do? Activating of DTP, closing and reopening, and the option was checked again automatically? Did you close Eclipse in the interim or was it potentially caused by cache problem?

If the problem persists raising a Support ticket with screenshots or screencam might be the way to go.

2) After load is finished it takes around 5 minutes that the report is reflecting the updated numbers: It might be worth to check the runtime properties of the composite provider and/or query, e.g. 'query cache'.

All the best,

Andreas

Update: Below some pics trying to visualize the data load procedure, hope it helps...

[former_member71289 · Accepted solution]

Hi,

I just want to add one more critical SAP Note that might fix potential issues when loading inventory data. Without the note RECORDTP might be loaded with wrong value, causing e.g. stock numbers showing with double or 0 value in reporting:

https://launchpad.support.sap.com/#/notes/2543774

Best regards,

Andreas

[lourdes_raj3]

Does data initialization(First time full Loads) need downtime with BW7.5 using above process flow?

[former_member216525]

Hi Andreas,

Thanks for your quick response.

Similar steps were considered during Inventory data loads and I would like to add some additional points

-As informed, post one time load with flag "Historical Transactions" into the EDW Core Layer DSO's(/IMO/D_MMIM01) is done, the later loads i.e., from /IMO/CMMMIM01 to /IMO/D_MMIM01 should be loaded with ‘perform delta initialization without data transfer’ and then later movements will follow with normal ongoing deltas into the EDW Core layer DSO’s from the same flow, if this is not considered than Data would be loaded twice to the Integrated Layer /IMO/D_MMIM01.

The same can be considered for Revaluations flow as well, correct me here please.

Also two other issues in this flow were observed:

-The delta DTP flowing from /IMO/CMMMIM01 to /IMO/D_MMIM01 having ‘Historical Transaction’ option in update tab is getting automatically modified to with a check box even though it is unchecked manually

-The other issue is that after loads are completed to /IMO/D_MMIM01 in the report “Stock Overview” report, one of the key figure “Quantity Total Stock” (based on Inflow and outflow calculation) is having slight delay in providing the output in reports (around 5 mins) including RSRT as well. Is this the Normal behavior.

Let me know if you have came across this else I will raise it with SAP Support if required.

Thanks/Mahesh

[former_member71289]

Hi Mahesh,

the movement data from the extractor 2LIS_03_BF (same for 2LIS_03_UM) should be only loaded ones.

The historical movements, that is the data coming from the setup table, should be loaded with FULL into the staging DSO /IMO/CMMMIMH1 only. From there, one time load with flag "Historical Transactions" into the EDW Core Layer DSO's.

The later delta movements, that are the movements captured after the stock initialization took place, should be loaded into the staging DSO /IMO/CMMMIM01. From there load the data as 'normal' ongoing deltas into the EDW Core Layer DSOs.

https://help.sap.com/viewer/06e872f914a44d77b6c692b0273ca400/1.0.10/en-US/adf82631fe684079907375706c...

One more possible reason for the issue you mentioned (but happens quite often...): Twice the stock amount might also appear in the stock report, when the stock initialization (OLI1BW & OLIZBW) was carried out twice without deleting the setup tables in the interim.

Hope it helps to fix your issue,

Andreas