Solution for Inventory differences in BW due delta issues
There is a program that was built by Yukiti that compare compares the content of MSEG with ODS_IC01 (movements) and ODS_IC02 (revaluations).
Extractor - DTS_IM_VARIANCE based on function module
Function Module - Z_WBW_DTS_IM_001
Main tables used on function module
BKPF - Accounting Document Header
BSEG - Accounting Document Segment (Cluster Table)
CKMI1 - Index for Accounting Documents for Material
EKPO - Purchasing Document Item
MBEW - Material Valuation
MKPF - Header: Material Document
MLIT - Material Ledger Document: Items
MSSA - Total Customer Orders on Hand
MSSQ - Project Stock Total
QBEW - Project Stock Valuation
WB2_V_MKPF_MSEG2 - Data Selection from Material Documents (without WBGT) (view) with tables MKPF and MSEG
Main function module tasks
1) Check data from Movements and Revaluation;
2) Check IF data is in RCS but is not in BW, storing 'DSO_IC07' (/BIC/ADSO_IC0700)
3) IF movement was done in the day, check in 'DSO_IC07' the date (/BIC/C_CPUDT):
...
- IF it is not inserted in the infopackage, the Function Module has a routine to fill this field, If sy-datum <= 15, run the last and current period, IF not, Just the current one.
- IF it is inserted in infopackage, do not run the FM routine.
- Other parameters: 'MBLNR', 'MJAHR', 'BUKRS', 'WERKS', 'MATNR', 'INFOSOURCE', depend on 'BUDAT'.
- Parameter 'INFOSOURCE' , IF it is filled with '2LIS_03_BF', run only Movements routine, but if it is filled with ' 2LIS_03_UM' , so run the Revaluation routine.
- The execution time for a monthly period is around 1 hour, but for revaluation the routine takes more time.
...