Material Movements from Inventory
Management 
Technical name: 2LIS_03_BF
Technical Data
|
Type of DataSource |
Transaction Data (Movement Data) |
|
Application Component |
Materials Management (MM) |
|
Available from OLTP Release |
SAP R/3 Enterprise Core 4.70 (SAP_APPL 470) |
|
Available from Plug-In Release |
PI 2002.1 |
|
RemoteCube Compatibility |
No |
Prerequisites
Activation of the DataSource.
Use
This structure is used to extract the material movement data from MM Inventory Management (MM-IM) consistently to a BW system.
Delta Update
A Delta update is supported. Delta procedure: ABR1 – Complete Delta with deletion flag using Delta queue (RemoteCube compatible) with serialization on request.
Fields of Origin in the Extract Structure
|
Field in Extract Structure |
Description of Field in the Extract Structure |
Table of Origin |
Field in Table of Origin |
|
AKTNR |
Action |
MSEG |
|
|
AUFNR |
Order Number |
MSEG |
|
|
AUFPL |
Plan Number for Activities in the Order |
MSEG |
|
|
BKLAS |
Valuation Class |
MBEW |
|
|
BLDAT |
Document Date in Document |
MKPF |
|
|
BNBTR |
Delivery Costs in Local Currency |
MSEG |
|
|
BSTAUS |
Stock Attributes in the Logistics Information System |
Filled by LIS |
|
|
BSTTYP |
Stock Category in the Logistics Information System |
Filled by LIS |
|
|
BUDAT |
Posting Date in the Document |
MKPF |
|
|
BUKRS |
Company Code |
MSEG |
|
|
BWAPPLNM |
Application Component |
BW Enrichment According to Customizing |
|
|
BWART |
Movement Type (Inventory Management) |
MSEG |
|
|
BWBREL |
Stock Relevance |
BW Enrichment |
|
|
BWCOUNTER |
Unique Identification of Document Line |
BW Enrichment |
|
|
BWGEO |
Purchase Value in Local Currency |
BW Enrichment |
|
|
BWGVO |
Retail Value in Local Currency |
BW Enrichment |
|
|
BWGVP |
Retail Value with Tax in Local Currency. |
BW Enrichment |
|
|
BWKEY |
Valuation Area |
MBEW |
|
|
BWMNG |
Quantity in Base Unit of Measure |
BW Enrichment |
|
|
BWPSPEX |
Work Breakdown Schedule Element (External) |
BW Enrichment |
|
|
BWTAR |
Valuation Type |
MSEG |
|
|
BWVORG |
SAP BW Transaction Key |
BW Enrichment |
|
|
CHARG |
Batch Number |
MSEG |
|
|
DMBTR |
Amount in Local Currency |
MSEG |
|
|
EBELN |
Document Number of Purchasing Document |
MSEG |
|
|
EBELP |
Item Number of Purchasing Document |
MSEG |
|
|
ERFME |
Unit of Entry |
MSEG |
|
|
ERFMG |
Quantity in Unit of Entry |
MSEG |
|
|
GRUND |
Reason for the Goods Movement |
MSEG |
|
|
GSBER |
Business Area |
MSEG |
|
|
KDAUF |
Sales Order Number |
MSEG |
|
|
KDEIN |
Schedule Line Sales Order |
MSEG |
|
|
KDPOS |
Item Number in Sales Order |
MSEG |
|
|
KOKRS |
Controlling Area |
MSEG |
|
|
KOSTL |
Cost Center |
MSEG |
|
|
KSTRG |
Cost Object |
MSEG |
|
|
KUNNR |
Customer’s Account Number |
MSEG |
|
|
KZBEW |
Movement Indicator |
MSEG |
|
|
KZBWS |
Valuation Special Stock |
MSEG |
|
|
LGNUM |
Warehouse Number/Warehouse Complex |
MSEG |
|
|
LGORT |
Storage Location |
MSEG |
|
|
LGPLA |
Storage Bin |
MSEG |
|
|
LGTYP |
Storage Type |
MSEG |
|
|
LIFNR |
Vendor’s Account Number |
MSEG |
|
|
MATNR |
Material Number |
MSEG |
|
|
MBLNR |
Material Document Number |
MKPF |
|
|
MEINS |
Base Unit of Measure |
MSEG |
|
|
MENGE |
Quantity |
MSEG |
|
|
MJAHR |
Material Document Year |
MKPF |
|
|
NPLNR |
Network Number for Account Assignment |
MSEG |
|
|
PALAN |
WMS Number of Pallets |
MSEG |
|
|
PAOBJNR |
Number for Event Objects (CO-PA) |
MSEG |
|
|
PRCTR |
Profit Center |
MSEG |
|
|
PS_PSP_PNR |
Work Breakdown Structure Element (WBS Element) |
MSEG |
|
|
SAKTO |
G/L Account Number |
MSEG |
|
|
SHKZG |
Credit/Debit Indicator |
MSEG |
|
|
SOBKZ |
Special Stock Indicator |
MSEG |
|
|
UMWRK |
Receiving/Issuing Plant |
MSEG |
|
|
WAERS |
Local Currency |
MSEG |
|
|
WEMPF |
Goods Recipient |
MSEG |
|
|
WERKS |
Plant |
MSEG |
|
|
ZEILE |
Item in Material Document |
MSEG |
|
|
PERIV |
Fiscal Year Variant |
BW Enrichment |
|
|
NOPOS |
Counter for Items |
BW Enrichment |
|
|
ROCANCEL |
Cancellation of Data Record |
BW Enrichment |
|
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).