2LIS_03_UM

Revaluations | #TRAN | Extraction method: F1 | Delta: ABR | Component: Materials Management
Tables used: MSEG, BSEG, QALS, LIPS, VBRP ... +188 more
Column Name Description
BELNR Document Number of an Accounting Document
BUKRS FK Company Code
BWKEY Valuation area
GJAHR Fiscal Year
KUNNR FK Account number of customer
LIFNR FK Vendor's account number
MATNR FK Material Number
WERKS FK Plant
Column Name Description
💲 Local Currency (WAERS):
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
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
KZBWS Valuation of Special Stock Show values
SHKZG Debit/Credit Indicator Show values
Column Name Description Domain name
AKTNR Promotion WAKTION
BKLAS Valuation Class BKLAS
BWAPPLNM Application Component RSAPPLNM
BWVORG SAP BW transaction key NUM3
PERIV Fiscal Year Variant PERIV
NOPOS Counter for Items PL2
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • 2LIS_03_UM.MANDT == T001.MANDT
  • 2LIS_03_UM.BUKRS == T001.BUKRS
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • 2LIS_03_UM.MANDT == T156.MANDT
  • 2LIS_03_UM.BWART == T156.BWART
Business Area
  • Client
  • Business Area
  • 2LIS_03_UM.MANDT == TGSB.MANDT
  • 2LIS_03_UM.GSBER == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • 2LIS_03_UM.MANDT == TKA01.MANDT
  • 2LIS_03_UM.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • 2LIS_03_UM.[column in domain "DATBI"] == CSKS.DATBI
  • 2LIS_03_UM.MANDT == CSKS.MANDT
  • 2LIS_03_UM.KOKRS == CSKS.KOKRS
  • 2LIS_03_UM.KOSTL == CSKS.KOSTL
Account number of customer
  • Client
  • Account number of customer
  • 2LIS_03_UM.MANDT == KNA1.MANDT
  • 2LIS_03_UM.KUNNR == KNA1.KUNNR
Vendor's account number
  • Client
  • Vendor's account number
  • 2LIS_03_UM.MANDT == LFA1.MANDT
  • 2LIS_03_UM.LIFNR == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • 2LIS_03_UM.MANDT == MARA.MANDT
  • 2LIS_03_UM.MATNR == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • 2LIS_03_UM.MANDT == T006.MANDT
  • 2LIS_03_UM.MEINS == T006.MSEHI
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • 2LIS_03_UM.[column in domain "KTOPL"] == SKA1.KTOPL
  • 2LIS_03_UM.MANDT == SKA1.MANDT
  • 2LIS_03_UM.SAKTO == SKA1.SAKNR
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • 2LIS_03_UM.MANDT == T148.MANDT
  • 2LIS_03_UM.SOBKZ == T148.SOBKZ
Plant
  • Client
  • Plant
  • 2LIS_03_UM.MANDT == T001W.MANDT
  • 2LIS_03_UM.WERKS == T001W.WERKS