Mbv_Mbew_Base

Base View for compatibility view of MBEW | view: MBVMBEWBASE | Extraction: Not supported | Component: Basic Functions
Column Name Description
matnr FK Material Number
bwkey FK Valuation area
bwtar Valuation Type
Column Name Description
salk3 null
verpr Moving Average Price/Periodic Unit Price
stprs Standard price
salkv Value Based on Periodic Unit Price (with Price Ctrl S Only)
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 null
lplpx Fixed Portion of Current Planned Price
vplpx Fixed Portion of Previous Planned Price
fplpx Fixed Portion of Future Planned Price
Column Name Description
lbkum null
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
Column Name Description Domain name
kaln1 Cost Estimate Number - Product Costing CK_KALNR
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
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
Master Data Relations Join Conditions
Valuation Class
  • Client
  • Valuation Class
  • MBV_MBEW_BASE.MANDT == T025.MANDT
  • MBV_MBEW_BASE.BKLAS == T025.BKLAS
Valuation area
  • Client
  • Valuation area
  • MBV_MBEW_BASE.MANDT == T001K.MANDT
  • MBV_MBEW_BASE.BWKEY == T001K.BWKEY
Valuation area/valuation category
  • Valuation Category
  • Client
  • Valuation area
  • MBV_MBEW_BASE.BWTTY == T149.BWTTY
  • MBV_MBEW_BASE.MANDT == T149.MANDT
  • MBV_MBEW_BASE.BWKEY == T149.BWKEY
Valuation variant for future period
  • Client
  • Valuation Variant for Future Standard Cost Estimate
  • MBV_MBEW_BASE.MANDT == TCK05.MANDT
  • MBV_MBEW_BASE.BWVA1 == TCK05.BWVAR
Valuation variant for current period
  • Client
  • Valuation Variant for Current Standard Cost Estimate
  • MBV_MBEW_BASE.MANDT == TCK05.MANDT
  • MBV_MBEW_BASE.BWVA2 == TCK05.BWVAR
Valuation variant for previous period
  • Valuation Variant for Previous Standard Cost Estimate
  • Client
  • MBV_MBEW_BASE.BWVA3 == TCK05.BWVAR
  • MBV_MBEW_BASE.MANDT == TCK05.MANDT
Valuation Class for Sales Order Stock
  • Client
  • Valuation Class for Sales Order Stock
  • MBV_MBEW_BASE.MANDT == T025.MANDT
  • MBV_MBEW_BASE.EKLAS == T025.BKLAS
Origin of cost estimate
  • Origin Group as Subdivision of Cost Element
  • Client
  • ?
  • ?
  • MBV_MBEW_BASE.HRKFT == TKKH1.HRKFT
  • MBV_MBEW_BASE.MANDT == TKKH1.MANDT
  • MBV_MBEW_BASE.[column in domain "KOKRS"] == TKKH1.KOKRS
  • MBV_MBEW_BASE.[column in domain "HRKTYP"] == TKKH1.KOATY
Overhead group
  • Costing Overhead Group
  • Client
  • Valuation area
  • MBV_MBEW_BASE.KOSGR == TCK14.KOSGR
  • MBV_MBEW_BASE.MANDT == TCK14.MANDT
  • MBV_MBEW_BASE.BWKEY == TCK14.BWKEY
Material Number
  • Client
  • Material Number
  • MBV_MBEW_BASE.MANDT == MARA.MANDT
  • MBV_MBEW_BASE.MATNR == MARA.MATNR
LIFO valuation key/pool number
  • Client
  • ?
  • Pool number for LIFO valuation
  • MBV_MBEW_BASE.MANDT == TPOOL.MANDT
  • MBV_MBEW_BASE.[column in domain "MYKEY"] == TPOOL.MYKEY
  • MBV_MBEW_BASE.MYPOL == TPOOL.MYPOOL
Valuation Class for Special Stock at the Vendor
  • Client
  • Valuation Class for Special Stock at the Vendor
  • MBV_MBEW_BASE.MANDT == T025.MANDT
  • MBV_MBEW_BASE.OKLAS == T025.BKLAS
Valuation Class for Project Stock
  • Client
  • Valuation Class for Project Stock
  • MBV_MBEW_BASE.MANDT == T025.MANDT
  • MBV_MBEW_BASE.QKLAS == T025.BKLAS
Valuation Class in Previous Year
  • Client
  • Valuation Class in Previous Year
  • MBV_MBEW_BASE.MANDT == T025.MANDT
  • MBV_MBEW_BASE.VJBKL == T025.BKLAS
Valuation Class in Previous Period
  • Client
  • Valuation Class in Previous Period
  • MBV_MBEW_BASE.MANDT == T025.MANDT
  • MBV_MBEW_BASE.VMBKL == T025.BKLAS