Skip to Content

Steps to load 0IC_C03 – Material Stocks/Movements InfoCube in BW on HANA

1. In a small down time interval lock/stop all users/postings in ECC at that time.

         Eg: The day is 09-23-2016 @ 11:00:00 AM).

2. STOP V3 JOB’s for 2LIS_03_* DataSources in ECC.

3. Clear Setup tables, RSA7, SMQ1 in ECC and InfoCube data in BW.

4. Execute Tcode MCNB in ECC, under Data destination Info tab, select 2LIS_03_BX DataSource.

5. Under Data source Info select All Stock Including – non valuated stocks).

6. At the same time (parallel) use Tcode OLI1BW in ECC and give the Posting date range from 01-09-2016 to 23-09-2016. This is

   for 2LIS_03_BF Load.

7. And also you can perform another activity, use Tcode OLIZBW in ECC and give the Company code and Posting date range from

   01-09-2016 to 23-09-2016. This is for 2LIS_03_UM Load.

   If you have multiple company code, repeat the step 6 for all company codes using the same Posting date range selection.

   Note:

   Step 5 and Step 6 can also perform once the 2LIS_03_BX data load is completed, but to save and utilize ECC down time, we can

   do in parallel. It depends on person to person and project to project and also the length of ECC down time.

8. Once Step 3 job is completed in ECC then load the data to BW till PSA using InfoPackage using “Generate Initial Status”

   under Update Tab. This is for 2LIS_03_BX Load.

9. Once the PSA load is success then load data to 0IC_C03 Cube using DTP, before loading data, check the “Extraction” tab in

   DTP, under Extraction tab Extraction Mode = “Initial Non-Cumulative for non-Cumulative values”.

    Set this option in DTP and load the data into InfoCube.

10. No compression is required because it’s HANA, you can’t find “Marker update” option in 0IC_C03 InfoCube.

11. Quickly you can validate the data by comparing data using Tcodes in ECC MB52 or MB5B and simple BEx report.

12. Once Step 5 job is completed in ECC then load the data to BW till PSA using InfoPackage using “Initialize Delta Process, with       Data Transfer” under Update Tab. This is for 2LIS_03_BF Load.

13. Once the PSA load is success then load data to 0IC_C03 Cube using DTP, before loading data, check the “Update” tab in DTP, under     Parameters of the InfoCube tab, CHECK “Historical Transactions” for history loads, because we are loading history data from         1st September 2016 to 23rd September 2016 to set the DELTA pointer in ECC.

    No compression is required because it’s HANA.

    Note:

   

    Once you load all history data, then UN-CHECK this option for delta loads.

    Once Step 6 job is completed in ECC then load the data to BW till PSA using InfoPackage using “Initialize Delta Process, with       Data Transfer” under Update Tab. This is for 2LIS_03_UM Load.

14. Once the PSA load is success then load data to 0IC_C03 Cube using DTP, before loading data, check the “Update” tab in DTP, under     Parameters of the InfoCube tab, CHECK “Historical Transactions” for history loads, because we are loading history data from         1st September 2016 to 23rd September 2016 to set the DELTA pointer in ECC.

    No compression is required because it’s HANA.

    Note:

    Once you load all history data, then UN-CHECK this option for delta loads. 

15. Once data loads are completed then check the BW Data with MB5B/MB51/MB52 Tcodes in ECC, it will match.

16. To perform all the above steps in small ECC down time period, you must practice these steps in Quality/Test system prior

    to implement in Production system to avoid confusion and get confidence. And also validate the data in Quality/test system

    using different BEx report in BW and MB5B/MB51/MB52 Tcodes in ECC.

17. Once Delta Pointer is set in ECC then load all history data using the above steps or you can start delta loads,

    I prefer first load all history data in weekends and then continue DELTA loads.

18. After all history loads are done then schedule V3 jobs for 2LIS_03_* DataSources using LBWE Tcode in ECC and continue

    DELTA Loads in BW.

    Note:

    UN-CHECK “Historical Transactions” option in DTP for BF and UM DataSource delta loads.

To report this post you need to login first.

1 Comment

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

Leave a Reply