Skip to Content

This document explains step by step Inventory loading to 0IC_C03 Cube.

Inventory Scenario

Is it required to load data using 2LIS_03_BX data source to get initialize stock opening balances…!!

2LIS_03_BX –> This structure is used to extract the stock data from MM Inventory Management for initialization to a BW system.

2LIS_03_BF –> This structure is used to extract the material movement data from MM Inventory Management (MM-IM) consistently to a BW system

2LIS_03_UM –> This structure is used to extract the revaluation data from MM Inventory Management (MM-IM) consistently to a BW system. Contains only value changes, no quantity changes.

Before you can extract data for revaluations to a BW system, you must ensure that the transaction/event key is active.
For this, see the following SAP Notes:
· 353042: How To: Activate transaction key (PROCESSKEY)
· 315880: Missing event control after PI-A installation

Usage of BX datasource is depends on business requirement.

Requirement1: For example data getting pulled from R/3 system. It contains 10 years of History Data.
Business requirement is want to see Inventory / Stocks data for last 2 years only.
In this case, to get opening balances can only get through BX datasource and compress WITH Maker update. after that we can load only last 2 years of historic data using BF & UM datasources and compress WITHOUT Marker update.

Requirement2: For example data getting pulled from R/3 system. It contains 2 years of History Data only and entire data needed from reporting.
In this case, we can use BX to pull opening stock balances and compress WITH Marker update and
Pull BF & UM for 2 years of historic data and compress WITHOUT Marker update. Same as above.

OR

Just Pull entire historic data – stock movements (2 years) using BF and UM datasources and compress WITH Marker update . It creates Opening Balances. In this case no need to Load BX datasource.

How To… Handle Inventory Management Scenarios in BW: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0

1) First thing we need lock the all users

2) In Init load we should maintain given serialization First 2LIS_03_BX,2LIS_03_BF and then 2LIS_03_UM with following given markerupdates.

3) In delta load we should load 2LIS_03_BF first then 2LIS_03_UM.

4) Every delta load should be compress with marker update.

invetory1.JPG

Inventory data loading step by step procedure

1)2LIS_03_BX(Stock Initialization for Inventory Management

Deleting the setup tables using Tcode: LBWG Select the inventory controlling application component

inventory2.JPG

Then Click on execute button

INV3.JPG

Setup Tables: Its place where BW Come and pick the Init Data load

To fill the setup tables of 2LIS_03_BX using Tocde: MCNB in transfer structur tap Select the 2LIS_03_BX

Change the Time of termination and click on Execute button

INV4.JPG

After filling the setup tables go to Tcode: RSA3 Enter the datasource name execute and check weather data got filled in setup tables.  RSA3 Showing data means your setup tables got filled.

INV5.JPG

Login into BI Side Select and expand the tree of 0IC_C03 (2LIS_03_BX) Trigger the Infopackage for the data load upto PSA and then Trigger the DTP to load the  from PSA to 0IC_C03. 

Make sure  DTP Should contain the following settings .

INV6.JPG

Check the data successfully got loaded into cube. Go to  Manage screen Click on Collapse tab and make sure No Marker Update should not be checked, enter the request id  and click on Release. Now data got compress with marker update

INV7.JPG

2LIS_03_BF: Goods Movements From Inventory Management

To fill the setup tables of 2LIS_03_BF using Tocde: OLI1BW Enter the Name of run Change the Termination time and click on Execute button.

INV8.JPG

After filling the setup tables go to Tcode: RSA3 Enter the datasource name execute and check weather data got filled in setup tables.  RSA3 Showing data means your setup tables got filled.

INV9.JPG

Login into BI Side Select and expand the tree of 0IC_C03 Select the infopackage of (2LIS_03_BF) and Trigger the Infopackage to load the data upto PSA and then Trigger the DTP to load the  data from PSA to ZIC_C03.

INV10.JPG

Check the data successfully got loaded into cube. Go to Manage screen Click on Collapse tab and make sure No Marker Update should be checked, enter the request id and click on Release button. Now data got compress without marker update

INV11.JPG

Revaluations: 2LIS_03_UM

To fill the setup tables of 2LIS_03_UM Enter the  Tocde: OLIZBW Give the Name of run, Company code   Change the Termination time and click on Execute button.

INV12.JPG

After filling the setup tables go to Tcode: RSA3 Enter the datasource name execute and check weather data got filled in setup tables.  In RSA3 Showing data means your setup tables got filled.

INV13.JPG

Login into BI Side Select and expand the tree of 0IC_C03 Select the Init infopackage of (2LIS_03_UM) and Trigger the Infopackage to load the data upto PSA and then Trigger the DTP to load the  data from PSA to ZIC_C03.

INV14.JPG

Check the data successfully got loaded into cube. Go to Manage screen Click on Collapse tab and make sure No Marker Update should be checked, enter the request id and click on Release button. Now data got compress without marker update.

INV15.JPG

Inventory Delta Load 2LIS_03_BF

Go to Tcode: LBWE then Click on Job Control Tab

INV16.JPG

1)Click on Start Date you will get following screen enter the date and time to trigger the delta load from lbwq to RSA7.

INV17.JPG

Then click on Print Parameters

INV18.JPG

INV19.JPG

After entering print parameters Click on schedule job.

INV20.JPG

Login into BI Side Select and expand the tree of 0IC_C03 Select the Delta infopackage of (2LIS_03_BF) and Trigger the Infopackage to load the data upto PSA and then Trigger the DTP to load the  data from PSA to ZIC_C03.

INV21.JPG

Check the data successfully got loaded into cube. Go to Manage screen Click on Collapse tab and make sure No Marker Update should not be checked, enter the request id and click on Release button. Now data got compress with marker update.

INV22.JPG

Inventory Delta Load: 2LIS_03_UM

Select and expand the tree of 0IC_C03 Select the Delta infopackage of (2LIS_03_UM) and Trigger the Infopackage to load the data upto PSA and then trigger the DTP to load the data from PSA to ZIC_C03.

INV23.JPG

Check the data successfully got loaded into cube. Go to Manage screen Click on Collapse tab and make sure No Marker Update should not be checked, enter the request id and click on Release button. Now data got compress with marker update.

INV24.JPG

To report this post you need to login first.

11 Comments

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

  1. Madhusudhan Raju Prathigadapa

    Hi Shakeer,

     

    Thanks for the detailed explanation. I am a bit confused with the statement “

    Just Pull entire historic data – stock movements (2 years) using BF and UM datasources and compress WITH Marker update . It creates Opening Balances. In this case no need to Load BX datasource“.

     

    Do you mean if in ECC we have only historical data and no new data is posted?

     

    For example in ECC I have data from Jan’13 and no. of records is 400,000 till date. Do I need to use BX datasource or just pull data from BF as Full and Run Init without data transfer and then run delta for new records.

     

    Appreciate if you could share your views on this.

     

    Many thanks.

    Madhu

    (0) 
  2. Surendra PSG

    Hi ,

     

    please can any one give me an  explanation about what happens if we use marker while loading Inventory  Data

    1.With Marker——- with example ..?

    2.Without Marker—-with example…?

     

    Please help me……..

     

    Regards

    Surendra P

    (0) 
    1. Andreas Tenholte

      Hi Surendra,

       

      I would recommend to check SAP Note 1548125 chapter II.

       

      And be aware that the behavior changed if you are using HANA optimized Inventory Cubes or ADSOs, see chapter VII in the above mentioned SAP Note…

       

      All the best for your project,

      Andreas

      (0) 

Leave a Reply