Inventory Management Guidelines
Introduction
Inventory Management has always been a critical process in Business Intelligence. The data load process in Inventory data sources is different from other scenarios. If we miss even one step during loading, we may get wrong entries. Even after following the steps perfectly, we may sometimes find anomalies in the data loaded.
In the following document, I have tried to include all those extra steps also which sometimes if not included create some or the other problem.
In Inventory management, the most important cube to load data to is 0IC_C03.
Here we load data from three data sources namely 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM.
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.
In the following steps we will specifically show the process of data load to 0IC_C03.
T-code – SBIW
Settings for Application-Specific DataSources (PI)---> Logistics --> Settings: Inventory Controlling --> Determine Industry Sector
In T-code – BF11 Checking the Following – Application – BW and NDI - Mandatory
Stock Initialization: Tcode – MCNB
Note – Important - Select: - All Stocks including (Non-Valuated stock)
Related tables
MC03BX0SETUP - BW Stock Initialization Storage for MC03BF0 Logistics - Logistics Information System (LIS)
Go to T.Code - RSA3 – Checking for 2LIS_03_BX
RSA3 - MAT: CUTTER, BUDAT: 29.09.2007
R/3 Dev T-code – MMBE for confirming the Unrestricted, Quality Inspected and Reserved Stock
Replicate Metadata in BW
InfoCube in BW:- Material Stock/Movements – 0IC_C03
Data source:-
Info package for bringing data into PSA
Transformation for 2LIS_03_BX
Data Transfer Process:- 2LIS_03_BX
For BX Update – after DTP go to Collapse - No TICK in No marker Update
Compression of Historical Transaction Data Records
If you have selected the No Marker Updating indicator, during the compression no markers are adjusted. This function is used to make changes to non-cumulative that have yet to be initialized visible at a later point in time. When loading and compressing historical transaction data records, note the following:
- Before compression, InfoCubes into which historical transaction data records were loaded, show potentially incorrect results. These inconsistencies are resolved during the compression process.
- After historical transaction data records are loaded into an InfoCube, the corresponding aggregates contain incorrect data. All incorrect aggregates are therefore deactivated and rebuilt during a compression run. For performance reasons, we recommend deactivating aggregates before a compression run with historical data, and rebuilding them after the compression run.
- Handling non-cumulative initializations as historical transaction data is not permitted and results in the termination of the compression run.
No update of the non-cumulative marker
- If this option is switched on, the non-cumulative marker is not updated when loading non-cumulative value changes.
- You can use this option to load past non-cumulative value changes into an InfoCube after a successful initialization with the current non-cumulative.
- In this instance, you have to carry out a summarization with this option before you can report from this data.
- The InfoCube must be a non-cumulative InfoCube. If not, this flag is ignored.
Summary – BF with Historical data should have No Marker Update Tick Mark because it shouldn’t get added with Initial Stock (BX data load)
2LIS_03_BF
Logistics - > Application-Specific Setup of Statistical Data -> Inventory Management - Perform Setup. ( T-Code OLI1BW for Material Movements)
Execute in Background
Checking for Extracted Data – RSA3
For Set Up Log in – T-Code NPRT
Path: - Logistics - > Initialization - > LIS Setup Log
Replicate Metadata in BW
Same Info provider - InfoCube in BW:- Material Stock/Movements – 0IC_C03
Info package for bringing data into PSA –> 2LIS_03_BF
Transformation for 2LIS_03_BX
Data Transfer Process:- 2LIS_03_BF
For 2LIS_03_BF – after DTP into Info Provider we have to compress the cube
Summary – BF with Historical data should have No Marker Update Tick Mark because it shouldn’t get added with Initial Stock (BX data load)
02LIS_03_UM
Logistics - > Application-Specific Setup of Statistical Data -> Inventory Management - Perform Setup. (T-Code OLIZBW for Invoice Verification /Revaluation)
Same Info provider - InfoCube in BW: - Material Stock/Movements – 0IC_C03
Data source:-
Info package for bringing data into PSA –> 2LIS_03_UM
Transformation for 2LIS_03_UM
********************************