MBEW_SRC

Source Records Of OTC 194, Table MBEW | #masterdata | Component: Material.
Column Name Description
CLIENT Client
SOURCE_SYSTEM Source System
SOURCE_ID Master Data Consolidation: ID of a Source Objects
BWKEY Valuation area
BWTAR Valuation Type
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
BWPRS Valuation price based on tax law: level 1
BWPRH Valuation price based on commercial law: level 1
VJBWS Valuation price based on tax law: level 3
VJBWH Valuation price based on commercial law: level 3
VVJSL Value of total valuated stock in year before last
VVSAL Value of total valuated stock in period before last
ZPLPR Future planned price
ZPLP1 Future Planned Price 1
ZPLP2 Future Planned Price 2
ZPLP3 Future Planned Price 3
BWPH1 Valuation price based on commercial law: level 2
BWPS1 Valuation price based on tax law: level 2
VPLPR Previous Planned Price
LPLPR Current Planned Price
VKSAL Value of Total Valuated Stock at Sales Price
LPLPX Fixed Portion of Current Planned Price
VPLPX Fixed Portion of Previous Planned Price
FPLPX Fixed Portion of Future Planned 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
VVJLB Total valuated stock in year before last
VVMLB Total valuated stock in period before last
Column Name Description
LAEPR Date of Last Price Change
ZKDAT Date as of which the price is valid
ZPLD1 Date from Which Future Planned Price 1 Is Valid
ZPLD2 Date from Which Future Planned Price 2 Is Valid
ZPLD3 Date from Which Future Planned Price 3 Is Valid
WLINL Date of Last Posted Count
Column Name Description
LVORM Deletion flag for all material data of a valuation type Show values
VPRSV Price control indicator Show values
VMVPR Price Control Indicator in Previous Period Show values
VJVPR Price Control Indicator in Previous Year Show values
KALKZ Indicator: standard cost estimate for future period Show values
KALKL Standard Cost Estimate for Current Period Show values
KALKV Indicator: Standard Cost Estimate for Previous Period Show values
XLIFO LIFO/FIFO-Relevant Show values
EKALR Material Is Costed with Quantity Structure Show values
MLMAA Material Ledger Activated at Material Level Show values
MLAST Material Price Determination: Control Show values
HKMAT Material-related origin Show values
SPERW Physical Inventory Blocking Indicator Show values
LBWST Val. Strat. for Current Plan Price, Sales Order/Proj. Stock Show values
VBWST Valuation Strategy for Previous Planned Price, Special Stock Show values
FBWST Valuation Strategy for Future Planned Price, Special Stock Show values
MTUSE Usage of the material Show values
MTORG Origin of the material Show values
OWNPR Produced in-house Show values
XBEWM Valuation based on the batch-specific unit of measure Show values
MBRUE MBEWH rec. already exists for per. before last of MBEW per. Show values
OIPPINV Prepaid Inventory Flag for Material Valuation Type Segment 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
PPERZ Period for future standard cost estimate (deactivated) BUPER
PPERL Period for current standard cost estimate (deactivated) BUPER
PPERV Period for previous standard cost estimate (deactivated) BUPER
KALSC Overhead key (deactivated) KALSC
ABWKZ Lowest value: devaluation indicator NUMC2
PSTAT Maintenance status PSTAT
KALN1 Cost Estimate Number - Product Costing CK_KALNR
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR
VERS1 Costing Version of Future Standard Cost Estimate CK_VERSION
VERS2 Costing Version of Current Standard Cost Estimate CK_VERSION
VERS3 Costing Version of Previous Standard Cost Estimate CK_VERSION
PPRDZ Period of Future Standard Cost Estimate POPER
PPRDL Period of Current Standard Cost Estimate POPER
PPRDV Period of Previous Standard Cost Estimate POPER
PDATZ Fiscal Year of Future Standard Cost Estimate GJAHR
PDATL Fiscal Year of Current Standard Cost Estimate GJAHR
PDATV Fiscal Year of Previous Standard Cost Estimate GJAHR
KZIWL Phys. inventory indicator for value-only material INVKZ
ABCIW Physical Inventory Indicator for Cycle Counting ABCIN
BWSPA Valuation margin PRZ32V
BWPEI Price unit for valuation prices based on tax/commercial law PACK3
DUMMY_VAL_INCL_EEW_PS MD Product valuation extension field element VAL_INCL_EEW
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS
Master Data Relations Join Conditions
Valuation Class
  • Valuation Class
  • Client
  • MBEW_SRC.BKLAS == T025.BKLAS
  • MBEW_SRC.CLIENT == T025.MANDT
Valuation area/valuation category
  • Valuation Category
  • Client
  • MBEW_SRC.BWTTY == T149C.BWTTY
  • MBEW_SRC.CLIENT == T149C.MANDT
Valuation variant for future period
  • MBEW_SRC.CLIENT == TCK05.MANDT
  • MBEW_SRC.BWVA1 == TCK05.BWVAR
Valuation variant for current period
  • MBEW_SRC.CLIENT == TCK05.MANDT
  • MBEW_SRC.BWVA2 == TCK05.BWVAR
Valuation variant for previous period
  • MBEW_SRC.CLIENT == TCK05.MANDT
  • MBEW_SRC.BWVA3 == TCK05.BWVAR
Valuation Class for Sales Order Stock
  • Valuation Class for Sales Order Stock
  • Client
  • MBEW_SRC.EKLAS == T025.BKLAS
  • MBEW_SRC.CLIENT == T025.MANDT
Origin of cost estimate
  • Origin Group as Subdivision of Cost Element
  • Client
  • ?
  • ?
  • MBEW_SRC.HRKFT == TKKH1.HRKFT
  • MBEW_SRC.CLIENT == TKKH1.MANDT
  • MBEW_SRC.[column in domain "KOKRS"] == TKKH1.KOKRS
  • MBEW_SRC.[column in domain "HRKTYP"] == TKKH1.KOATY
Overhead group
  • Valuation area
  • Costing Overhead Group
  • MBEW_SRC.CLIENT == TCK14.MANDT
  • MBEW_SRC.BWKEY == TCK14.BWKEY
  • MBEW_SRC.KOSGR == TCK14.KOSGR
LIFO valuation key/pool number
  • Pool number for LIFO valuation
  • Client
  • ?
  • MBEW_SRC.MYPOL == TPOOL.MYPOOL
  • MBEW_SRC.CLIENT == TPOOL.MANDT
  • MBEW_SRC.[column in domain "MYKEY"] == TPOOL.MYKEY
Valuation Class for Special Stock at the Vendor
  • Valuation Class for Special Stock at the Vendor
  • Client
  • MBEW_SRC.OKLAS == T025.BKLAS
  • MBEW_SRC.CLIENT == T025.MANDT
Valuation Class for Project Stock
  • Valuation Class for Project Stock
  • Client
  • MBEW_SRC.QKLAS == T025.BKLAS
  • MBEW_SRC.CLIENT == T025.MANDT
Valuation Class in Previous Year
  • Valuation Class in Previous Year
  • Client
  • MBEW_SRC.VJBKL == T025.BKLAS
  • MBEW_SRC.CLIENT == T025.MANDT
Valuation Class in Previous Period
  • Valuation Class in Previous Period
  • Client
  • MBEW_SRC.VMBKL == T025.BKLAS
  • MBEW_SRC.CLIENT == T025.MANDT