2LIS_03_BF

Goods Movements From Inventory Management | #TRAN | Extraction method: F1 | Delta: ABR1 | Component: Materials Management
Tables used: MSEG, QALS, LIPS, BSEG, VBRP ... +188 more
Column Name Description
AUFNR FK Order Number
BUKRS FK Company Code
BWKEY Valuation area
EBELN Purchasing Document Number
EBELP FK Item Number of Purchasing Document
KUNNR FK Account number of customer
LIFNR FK Vendor's account number
MATNR FK Material Number
MBLNR Number of Material Document
MJAHR Material Document Year
WERKS FK Plant
ZEILE Item in Material Document
Column Name Description
💲 Local Currency (WAERS):
BNBTR Delivery costs in local currency
BWGEO BW: Cost Value in Local Currency
BWGVO BW: Retail Value in Local Currency
BWGVP BW: Retail Value with Tax in Local Currency
DMBTR Amount in local currency
Column Name Description
📏 Base Unit of Measure (MEINS):
BWMNG BW: Quantity in Base Unit of Measure
MENGE Quantity
📏 Unit of entry (ERFME):
ERFMG Quantity in unit of entry
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
BSTAUS Stock Values in the Logistics Information System Show values
BSTTYP Stock categories in the Logistics Information System Show values
KZBEW Movement Indicator Show values
KZBWS Valuation of Special Stock Show values
SHKZG Debit/Credit Indicator Show values
Column Name Description Domain name
AKTNR Promotion WAKTION
AUFPL Routing number of operations in the order AUFPL
BKLAS Valuation Class BKLAS
BWAPPLNM Application Component RSAPPLNM
BWBREL BW: Stock Relevance MCBW_BREL
BWCOUNTER BW: Unique Identification of Line Item MCBW_COUNTER
BWPSPEX Work Breakdown Structure Element (External) PS_PSPEX
BWVORG SAP BW transaction key NUM3
GRUND Reason for goods movment NUMC4
KDEIN Delivery schedule for sales order NUM04
KDPOS Item number in Sales Order NUM06
KSTRG Cost Object KSTRG
PALAN WMS Number of pallets PALAN
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PRCTR Profit Center PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
WEMPF Goods Recipient WEMPF
PERIV Fiscal Year Variant PERIV
NOPOS Counter for Items PL2
Master Data Relations Join Conditions
Order Number
  • Client
  • Order Number
  • 2LIS_03_BF.MANDT == AUFK.MANDT
  • 2LIS_03_BF.AUFNR == AUFK.AUFNR
Company Code
  • Client
  • Company Code
  • 2LIS_03_BF.MANDT == T001.MANDT
  • 2LIS_03_BF.BUKRS == T001.BUKRS
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • 2LIS_03_BF.MANDT == T156.MANDT
  • 2LIS_03_BF.BWART == T156.BWART
Valuation Type
  • Client
  • Valuation Type
  • 2LIS_03_BF.MANDT == T149D.MANDT
  • 2LIS_03_BF.BWTAR == T149D.BWTAR
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Plant
  • 2LIS_03_BF.MANDT == MCHA.MANDT
  • 2LIS_03_BF.CHARG == MCHA.CHARG
  • 2LIS_03_BF.MATNR == MCHA.MATNR
  • 2LIS_03_BF.WERKS == MCHA.WERKS
Unit of entry
  • Client
  • Unit of entry
  • 2LIS_03_BF.MANDT == T006.MANDT
  • 2LIS_03_BF.ERFME == T006.MSEHI
Business Area
  • Client
  • Business Area
  • 2LIS_03_BF.MANDT == TGSB.MANDT
  • 2LIS_03_BF.GSBER == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • 2LIS_03_BF.MANDT == TKA01.MANDT
  • 2LIS_03_BF.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • 2LIS_03_BF.[column in domain "DATBI"] == CSKS.DATBI
  • 2LIS_03_BF.MANDT == CSKS.MANDT
  • 2LIS_03_BF.KOKRS == CSKS.KOKRS
  • 2LIS_03_BF.KOSTL == CSKS.KOSTL
Account number of customer
  • Client
  • Account number of customer
  • 2LIS_03_BF.MANDT == KNA1.MANDT
  • 2LIS_03_BF.KUNNR == KNA1.KUNNR
Warehouse Number / Warehouse Complex
  • Client
  • Warehouse Number / Warehouse Complex
  • 2LIS_03_BF.MANDT == T300.MANDT
  • 2LIS_03_BF.LGNUM == T300.LGNUM
Storage location
  • Client
  • Storage location
  • Plant
  • 2LIS_03_BF.MANDT == T001L.MANDT
  • 2LIS_03_BF.LGORT == T001L.LGORT
  • 2LIS_03_BF.WERKS == T001L.WERKS
Storage Bin
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Bin
  • Storage Type
  • 2LIS_03_BF.MANDT == LAGP.MANDT
  • 2LIS_03_BF.LGNUM == LAGP.LGNUM
  • 2LIS_03_BF.LGPLA == LAGP.LGPLA
  • 2LIS_03_BF.LGTYP == LAGP.LGTYP
Storage Type
  • Client
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • 2LIS_03_BF.MANDT == T301.MANDT
  • 2LIS_03_BF.LGNUM == T301.LGNUM
  • 2LIS_03_BF.LGTYP == T301.LGTYP
Vendor's account number
  • Client
  • Vendor's account number
  • 2LIS_03_BF.MANDT == LFA1.MANDT
  • 2LIS_03_BF.LIFNR == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • 2LIS_03_BF.MANDT == MARA.MANDT
  • 2LIS_03_BF.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_03_BF.MANDT == T006.MANDT
  • 2LIS_03_BF.MEINS == T006.MSEHI
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • 2LIS_03_BF.MANDT == AUFK.MANDT
  • 2LIS_03_BF.NPLNR == AUFK.AUFNR
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • 2LIS_03_BF.[column in domain "KTOPL"] == SKA1.KTOPL
  • 2LIS_03_BF.MANDT == SKA1.MANDT
  • 2LIS_03_BF.SAKTO == SKA1.SAKNR
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • 2LIS_03_BF.MANDT == T148.MANDT
  • 2LIS_03_BF.SOBKZ == T148.SOBKZ
Receiving plant/issuing plant
  • Client
  • Receiving plant/issuing plant
  • 2LIS_03_BF.MANDT == T001W.MANDT
  • 2LIS_03_BF.UMWRK == T001W.WERKS
Plant
  • Client
  • Plant
  • 2LIS_03_BF.MANDT == T001W.MANDT
  • 2LIS_03_BF.WERKS == T001W.WERKS