A data record belonging to extractor 2LIS_03_BF is defined in a unique way using the key fields Material Document Number (MBLNR), Material Document Year (MJAHR), Item in Material Document (ZEILE), and Unique.
Identification of Document Line (BWCOUNTER).
2LIS_03_UM:–Go thru the link.
it is detailed out for each field.
some form LIS, BSEG,BKPF.
etc, This InfoSource delivers the data for material movements from MM Inventory Management (MM-IM) DataSource 2LIS_03_BF.
The DataSource 2LIS_03_BF is set up with the report New Setup for Info Structures from Material Movements (RMCBNEUA) or transaction code OLI1BW.
The associated source field in SAP R/3 is KZBWS.
The indicator enables you to make detailed stock evaluations in BW, e.
in particular, quantity statements regarding valuated stocks.
The InfoSource 2LIS_03_BF already contains this InfoObject.
03/02/2016 Field BETC is now added to table TMxCFZ.
Field is NOT available in LBWE selection pool D atasource 2LIS_02_SCL needs to be enhanced with field ZKONNR from table EKPO, however it is not available in LBWE selection pool.
Follow the process below: 1.
Insert new field to the database table.
Example: enhance EKPO by appending ZKONNR 2.
Dear BW Gurus Do any consultant out there has experience of using Data Source 2LIS_03_BF.
If you do, please do you know which R/3 table the data source gets its quantity data.
I am trying to reconcile BW data with R/3, so the r/3 tables will be of help.
I have triend r/3 tables MARD, MARC AND MSEG, but I cannot reconcile the data to r/3 I will.
Save BW Reorganization for MC03BF0 Inventory Controlling.
BW Stock Initialization Storage for MC03BF Inventory Controlling.
Save BW Reorganization for MC03UM0.
Production / Shop Floor Control.
MC04P_0ARBSETUP, 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.
After filling the setup tables go to Tcode: RSA3 Enter the datasource name execute and check weather data got filled in setup tables.
Features of Extractor.
A data record belonging to extractor 2LIS_03_BF is defined in a unique way using the key fields Material Document Number (MBLNR), Material Document Year (MJAHR), Item in Material Document (ZEILE), and Unique Identification of Document Line (BWCOUNTER).
For the ODS capability of this extractor, see the SAP Note 581778: ODS capability of extractors from.
03/04/2014 Fill Setup Table for 2LIS_03_BF using T-code # OLI1BW.
Now, in the same way, fill the set up tables for 2LIS_03_UM using T-code OLIZBW.
But, note that for UM, Company code field is mandatory.
You should give values for company code to fill the set up tables for UM.
Now, after filling the set up tables , you need to trigger the info.
26/06/2018 Base Tables # BKPF and BSEG Usage of 2LIS_03_BX of course depends upon how many years of historical data exists in the S4/HANA MM Inventory Management.
Ideally, if up to only 3 years of Historical Data exists, then entire data can be pulled from 2LIS_03_BF and 2LIS_03_UM.
All the pre-requisites before initial load remain the same.