SAP Table MBEW stores Material Valuationdata

  

In this post, I will try and describe everything you need to know about the SAP mbew table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for MBEW what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from MBEW....Right lets get started!


SAP MBEW dictionary attributes

Object Name: MBEW
Dictionary Type: Transparent table
Description: Material Valuation


MBEW field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
MATNRMATNRCHAR18(0) MARAMaterial NumberMATNRMATMGS_MAT1MATNR
BWKEYBWKEYCHAR4(0) T001KValuation AreaBWKEYBWKMG
BWTARBWTAR_DCHAR10(0) *Valuation TypeBWTARBWTMG
LVORMLVOBACHAR1(0) Deletion flag for all material data of a valuation typeXFELDMG
LBKUMLBKUMQUAN13(3) Total Valuated StockMENG13VMG
SALK3SALK3CURR13(2) Value of Total Valuated StockWERT13NMG
VPRSVVPRSVCHAR1(0) Price control indicatorVPRSVMG
VERPRVERPRCURR11(2) Moving Average Price/Periodic Unit PriceWERT11VMG
STPRSSTPRSCURR11(2) Standard priceWERT11VMG
PEINHPEINHDEC5(0) Price UnitPACK3MG
BKLASBKLASCHAR4(0) T025Valuation ClassBKLASMG
SALKVSALKVCURR13(2) Value based on moving average price (only with price ctrl S)WERT13NMG
VMKUMVMKUMQUAN13(3) Total valuated stock in previous periodMENG13VMG
VMSALVMSALCURR13(2) Value of total valuated stock in previous periodWERT13NMG
VMVPRVMVPRCHAR1(0) Price Control Indicator in Previous PeriodVPRSVMG
VMVERVMVERCURR11(2) Moving Average Price/Periodic Unit Price in Previous PeriodWERT11VMG
VMSTPVMSTPCURR11(2) Standard price in the previous periodWERT11VMG
VMPEIVMPEIDEC5(0) Price unit of previous periodPACK3MG
VMBKLVMBKLCHAR4(0) T025Valuation Class in Previous PeriodBKLASMG
VMSAVVMSAVCURR13(2) Value based on moving average price (previous period)WERT13NMG
VJKUMVJKUMQUAN13(3) Total Valuated Stock in Previous YearMENG13VMG
VJSALVJSALCURR13(2) Value of total valuated stock in previous yearWERT13NMG
VJVPRVJVPRCHAR1(0) Price Control Indicator in Previous YearVPRSVMG
VJVERVJVERCURR11(2) Moving Average Price/Periodic Unit Price in Previous YearWERT11VMG
VJSTPVJSTPCURR11(2) Standard price in previous yearWERT11VMG
VJPEIVJPEIDEC5(0) Price unit of previous yearPACK3MG
VJBKLVJBKLCHAR4(0) T025Valuation Class in Previous YearBKLASMG
VJSAVVJSAVCURR13(2) Value based on moving average price (previous year)WERT13NMG
LFGJALFGJANUMC4(0) Fiscal Year of Current PeriodGJAHRMG
LFMONLFMONNUMC2(0) Current period (posting period)MONATMG
BWTTYBWTTY_DCHAR1(0) T149Valuation CategoryBWTTYMG
STPRVSTPRVCURR11(2) Previous priceWERT11VMG
LAEPRLAEPRDATS8(0) Date of the last price changeDATUMMG
ZKPRSDZKPRSCURR11(2) Future priceWERT11MG
ZKDATDZKDATDATS8(0) Date as of which the price is validDATUMMG
TIMESTAMPTIMESTAMPDEC15(0) UTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPS
BWPRSBWPRSCURR11(2) Valuation price based on tax law: level 1WERT11MG
BWPRHBWPRHCURR11(2) Valuation price based on commercial law: level 1WERT11MG
VJBWSVJBWSCURR11(2) Valuation price based on tax law: level 3WERT11MG
VJBWHVJBWHCURR11(2) Valuation price based on commercial law: level 3WERT11MG
VVJSLVVJSLCURR13(2) Value of total valuated stock in year before lastWERT13NMG
VVJLBVVJLBQUAN13(3) Total valuated stock in year before lastMENG13VMG
VVMLBVVMLBQUAN13(3) Total valuated stock in period before lastMENG13VMG
VVSALVVSALCURR13(2) Value of total valuated stock in period before lastWERT13NMG
ZPLPRDZPLPRCURR11(2) Future planned priceWERT11MG
ZPLP1DZPLP1CURR11(2) Future Planned Price 1WERT11MG
ZPLP2DZPLP2CURR11(2) Future Planned Price 2WERT11MG
ZPLP3DZPLP3CURR11(2) Future Planned Price 3WERT11MG
ZPLD1DZPLD1DATS8(0) Date from Which Future Planned Price 1 Is ValidDATUMMG
ZPLD2DZPLD2DATS8(0) Date from Which Future Planned Price 2 Is ValidDATUMMG
ZPLD3DZPLD3DATS8(0) Date from Which Future Planned Price 3 Is ValidDATUMMG
PPERZPPERZACCP6(0) Period for future standard cost estimate (deactivated)BUPERMG
PPERLPPERLACCP6(0) Period for current standard cost estimate (deactivated)BUPERMG
PPERVPPERVACCP6(0) Period for previous standard cost estimate (deactivated)BUPERMG
KALKZKAXKZCHAR1(0) Indicator: standard cost estimate for future periodXFELDMG
KALKLKALKLCHAR1(0) Standard Cost Estimate for Current PeriodXFELDMG
KALKVKALKVCHAR1(0) Indicator: standard cost estimate for previous periodXFELDMG
KALSCKALSCCHAR6(0) Overhead key (deactivated)KALSCMG
XLIFOXLIFOCHAR1(0) LIFO/FIFO-RelevantLIFO_FIFOMB
MYPOLMYPOOLCHAR4(0) TPOOLPool number for LIFO valuationLIFO_POOLPOLMR
BWPH1BWPH1CURR11(2) Valuation price based on commercial law: level 2WERT11MG
BWPS1BWPS1CURR11(2) Valuation price based on tax law: level 2WERT11MG
ABWKZABWKZNUMC2(0) Lowest value: devaluation indicatorNUMC2MR
PSTATPSTAT_DCHAR15(0) Maintenance statusPSTATMG
KALN1CK_KALNR1NUMC12(0) *Cost Estimate Number - Product CostingCK_KALNRKNECK
KALNRCK_KALNRNUMC12(0) *Cost Estimate Number for Cost Est. w/o Qty StructureCK_KALNRKNRCK
BWVA1CK_BWVA1CHAR3(0) TCK05Valuation Variant for Future Standard Cost EstimateCK_BWVARCK
BWVA2CK_BWVA2CHAR3(0) TCK05Valuation Variant for Current Standard Cost EstimateCK_BWVARCK
BWVA3CK_BWVA3CHAR3(0) TCK05Valuation Variant for Previous Standard Cost EstimateCK_BWVARCK
VERS1CK_TVERS1NUMC2(0) Costing Version of Future Standard Cost EstimateCK_VERSIONVSNCK
VERS2CK_TVERS2NUMC2(0) Costing Version of Current Standard Cost EstimateCK_VERSIONCK
VERS3CK_TVERS3NUMC2(0) Costing Version of Previous Standard Cost EstimateCK_VERSIONCK
HRKFTHRKFTCHAR4(0) TKKH1Origin Group as Subdivision of Cost ElementHRKFTKA
KOSGRCK_KOSGRCHAR10(0) TCK14Costing Overhead GroupCK_KOSGRCK
PPRDZCK_PPRDZNUMC3(0) Period of Future Standard Cost EstimatePOPERBUPFB
PPRDLCK_PPRDLNUMC3(0) Period of Current Standard Cost EstimatePOPER
PPRDVCK_PPRDVNUMC3(0) Period of Previous Standard Cost EstimatePOPER
PDATZCK_PDATZNUMC4(0) Fiscal Year of Future Standard Cost EstimateGJAHRGEJ
PDATLCK_PDATLNUMC4(0) Fiscal Year of Current Standard Cost EstimateGJAHR
PDATVCK_PDATVNUMC4(0) Fiscal Year of Previous Standard Cost EstimateGJAHR
EKALRCK_EKALRELCHAR1(0) Material Is Costed with Quantity StructureXFELD
VPLPRVPLPRCURR11(2) Previous planned priceWERT11
MLMAACK_ML_MAACCHAR1(0) Material ledger activated at material levelXFELD
MLASTCK_ML_ABSTCHAR1(0) Material Price Determination: ControlCK_ML_ABST
LPLPRCK_LPLPRCURR11(2) Current Planned PriceWERT11
VKSALVKSALCURR13(2) Value of Total Valuated Stock at Sales PriceWERT13N
HKMATHKMATCHAR1(0) Material-related originHKMAT
SPERWSPERRCHAR1(0) Physical Inventory Blocking IndicatorSPERRMG
KZIWLKZIWLCHAR3(0) Phys. inventory indicator for value-only materialINVKZ
WLINLDLINLDATS8(0) Date of Last Posted Count for Unrestricted-Use StockDATS
ABCIWABCINCHAR1(0) *Physical inventory indicator for cycle countingABCIN
BWSPABWSPADEC6(2) Valuation marginPRZ32V
LPLPXCK_LPLPXCURR11(2) Fixed Portion of Current Planned PriceWERT11V
VPLPXCK_VPLPXCURR11(2) Fixed Portion of Previous Planned PriceWERT11V
FPLPXCK_ZPLPXCURR11(2) Fixed Portion of Future Planned PriceWERT11V
LBWSTCK_LBWSTCHAR1(0) Val. Strat. for Current Plan Price, Sales Order/Proj. StockCK_BWST
VBWSTCK_VBWSTCHAR1(0) Valuation Strategy for Previous Plan Price, Special StockCK_BWST
FBWSTCK_ZBWSTCHAR1(0) Valuation Strategy for Future Planned Price, Special StockCK_BWST
EKLASEKLASCHAR4(0) T025Valuation Class for Sales Order StockBKLAS
QKLASQKLASCHAR4(0) T025Valuation Class for Project StockBKLAS
MTUSEJ_1BMATUSECHAR1(0) Usage of the materialJ_1BMATUSE
MTORGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
OWNPRJ_1BOWNPROCHAR1(0) Produced in-houseXFELD
XBEWMXBEWWCHAR1(0) Valuation based on the batch-specific unit of measureXFELD
BWPEIBWPEIDEC5(0) Price unit for valuation prices based on tax/commercial lawPACK3MG
MBRUEMBRUECHAR1(0) MBEWH rec. already exists for per. before last of MBEW per.XFELD
OKLASOKLASCHAR4(0) T025Valuation Class for Special Stock at the VendorBKLAS
.INCLU--AP0(0)
OIPPINVJV_PPINVCHAR1(0) Prepaid Inventory Flag for Material Valuation Type SegmentJV_PPINV