WBEW

Active Ingredient Valuation | #masterdata | Component: Batches
Column Name Description
MANDT FK Client
MATNR FK Material Number
BWKEY FK Valuation area
BWTAR FK Valuation Type
MEINH FK Alternative Unit of Measure for Stockkeeping Unit
Column Name Description
💲 Currency Key (T001.WAERS):
SALK3 Value of Total Valuated Stock
VERPR Moving Average Price/Periodic Unit Price
STPRS Standard price
SALKV Value based on moving average price (only with price ctrl S)
VMSAL Value of total valuated stock in previous period
VMVER Moving Average Price/Periodic Unit Price in Previous Period
VMSTP Standard price in the previous period
VMSAV Value based on moving average price (previous period)
VJSAL Value of total valuated stock in previous year
VJVER Moving Average Price/Periodic Unit Price in Previous Year
VJSTP Standard price in previous year
VJSAV Value based on moving average price (previous year)
STPRV Previous Price
ZKPRS Future Price
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
LBKUM Total Valuated Stock
VMKUM Total valuated stock in previous period
VJKUM Total Valuated Stock in Previous Year
Column Name Description
LAEPR Date of Last Price Change
ZKDAT Date as of which the price is valid
Column Name Description
VPRSV Price control indicator Show values
VMVPR Price Control Indicator in Previous Period Show values
VJVPR Price Control Indicator in Previous Year Show values
Column Name Description Domain name
PEINH Price unit PACK3
VMPEI Price unit of previous period PACK3
VJPEI Price unit of previous year PACK3
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Valuation Class
  • Valuation Class
  • Client
  • WBEW.BKLAS == T025.BKLAS
  • WBEW.MANDT == T025.MANDT
Valuation area
  • Material Number
  • Valuation area
  • Valuation Type
  • WBEW.MANDT == MBEW.MANDT
  • WBEW.MATNR == MBEW.MATNR
  • WBEW.BWKEY == MBEW.BWKEY
  • WBEW.BWTAR == MBEW.BWTAR
Valuation type
  • WBEW.MANDT == T149D.MANDT
  • WBEW.BWTAR == T149D.BWTAR
Valuation area/valuation category
  • Valuation Category
  • Client
  • WBEW.BWTTY == T149C.BWTTY
  • WBEW.MANDT == T149C.MANDT
Client WBEW.MANDT == T000.MANDT
Material Number
  • Material Number
  • Alternative Unit of Measure for Stockkeeping Unit
  • WBEW.MANDT == MARM.MANDT
  • WBEW.MATNR == MARM.MATNR
  • WBEW.MEINH == MARM.MEINH
Unit of measure
  • Material Number
  • Alternative Unit of Measure for Stockkeeping Unit
  • WBEW.MANDT == MARM.MANDT
  • WBEW.MATNR == MARM.MATNR
  • WBEW.MEINH == MARM.MEINH
Valuation Class in Previous Year
  • Valuation Class in Previous Year
  • Client
  • WBEW.VJBKL == T025.BKLAS
  • WBEW.MANDT == T025.MANDT
Valuation Class in Previous Period
  • Valuation Class in Previous Period
  • Client
  • WBEW.VMBKL == T025.BKLAS
  • WBEW.MANDT == T025.MANDT