MBEW
Material Valuation
MBEW is an SAP database table in S/4HANA. Material Valuation. It contains 110 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_Productmlaccount | view | from | EXTENSION | Extension view-product ML Account |
| E_Productvaluation | view | from | EXTENSION | Extension core view-product valuation |
| F_Mmim_Mbew_Plant | view | left_outer | Inventory Valuation Type from MBEW | |
| I_ProductValuation | view | from | COMPOSITE | Product Valuation |
| Mbv_Mbew | view | from | Compatibility view for MBEW table | |
| Mbv_Mbew_Base | view | from | Base view for compatibility view of MBEW | |
| Mbv_Mbew_Mother_Segment | view | from | View for MBEW Mother Segments | |
| NSDM_E_MFAUF | view | inner | MFAUF Compatibility View | |
| P_CHMPMaterialValuation | view_entity | from | BASIC | |
| P_FBV_PAR_SEL_MAT | view | inner | BASIC | |
| P_InvtryTurnoverPricing | view | from | CONSUMPTION | Inventory Turnover Pricing |
| P_ProductValuationBasic | view | from | BASIC | |
| v_ml_account_l2_view | view | left_outer | LOCAL: Material Ledger Periods |
Fields (110)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | matnr | MATNR | Material | |||
| KEY | bwkey | BWKEY | Valuation Area | |||
| KEY | bwtar | BWTAR_D | Valuation Type | |||
| lvorm | LVOBA | DF Val. Type | ||||
| lbkum | LBKUM | Total Stock | ||||
| salk3 | SALK3 | Total Value | ||||
| vprsv | VPRSV | Price control | ||||
| verpr | VERPR | Moving price | ||||
| stprs | STPRS | Standard price | ||||
| peinh | PEINH | Price unit | ||||
| bklas | BKLAS | Valuation Class | ||||
| salkv | SALKV | Value/MA price | ||||
| vmkum | VMKUM | Total stock PP | ||||
| vmsal | VMSAL | Total value PP | ||||
| vmvpr | VMVPR | Price ctrl PP | ||||
| vmver | VMVER | MovAvgPrice PP | ||||
| vmstp | VMSTP | Std price PP | ||||
| vmpei | VMPEI | Price unit PP | ||||
| vmbkl | VMBKL | Val. class PP | ||||
| vmsav | VMSAV | Value prev.per. | ||||
| vjkum | VJKUM | Total stock PY | ||||
| vjsal | VJSAL | Total value PY | ||||
| vjvpr | VJVPR | Price ctrl PY | ||||
| vjver | VJVER | MovAvgPrice PY | ||||
| vjstp | VJSTP | Std price PY | ||||
| vjpei | VJPEI | Price unit PY | ||||
| vjbkl | VJBKL | Val. class PY | ||||
| vjsav | VJSAV | Value prev.year | ||||
| lfgja | LFGJA | Year Cur.Period | ||||
| lfmon | LFMON | Current Period | ||||
| bwtty | BWTTY_D | Valuation Cat. | ||||
| stprv | STPRV | Previous Price | ||||
| laepr | LAEPR | Last Price Chg. | ||||
| zkprs | DZKPRS | Future Price | ||||
| zkdat | DZKDAT | Valid from | ||||
| timestamp | TIMESTAMP | Time Stamp | ||||
| bwprs | BWPRS | Tax price 1 | ||||
| bwprh | BWPRH | Comm. price 1 | ||||
| vjbws | VJBWS | Tax price 3 | ||||
| vjbwh | VJBWH | Coml price 3 | ||||
| vvjsl | VVJSL | Valued at | ||||
| vvjlb | VVJLB | Total stock YBL | ||||
| vvmlb | VVMLB | Total stock PBL | ||||
| vvsal | VVSAL | Valued at | ||||
| zplpr | DZPLPR | Fut. Plnd Price | ||||
| zplp1 | DZPLP1 | Planned price 1 | ||||
| zplp2 | DZPLP2 | Planned price 2 | ||||
| zplp3 | DZPLP3 | Planned price 3 | ||||
| zpld1 | DZPLD1 | Plnd pr. date 1 | ||||
| zpld2 | DZPLD2 | Plnd pr. date 2 | ||||
| zpld3 | DZPLD3 | Plnd pr. date 3 | ||||
| pperz | PPERZ | Fut. c/e period | ||||
| pperl | PPERL | Current c/e pd | ||||
| pperv | PPERV | Prev. c/e per. | ||||
| kalkz | KAXKZ | Fut. cost est. | ||||
| kalkl | KALKL | CurrentCostEst. | ||||
| kalkv | KALKV | PreviousCostEst | ||||
| kalsc | KALSC | Overhead key | ||||
| xlifo | XLIFO | LIFO/FIFO-Rel. | ||||
| mypol | MYPOOL | LIFO Pool | ||||
| bwph1 | BWPH1 | Commercial pr.2 | ||||
| bwps1 | BWPS1 | Tax price 2 | ||||
| abwkz | ABWKZ | Devaluation Ind | ||||
| pstat | PSTAT_D | Maint. Status | ||||
| kaln1 | CK_KALNR1 | ProdCostEst.No. | ||||
| kalnr | CK_KALNR | Cost EstimateNo | ||||
| bwva1 | CK_BWVA1 | Valuation Var. | ||||
| bwva2 | CK_BWVA2 | Valuatn Variant | ||||
| bwva3 | CK_BWVA3 | Valuation Var. | ||||
| vers1 | CK_TVERS1 | Costing Version | ||||
| vers2 | CK_TVERS2 | Costing Version | ||||
| vers3 | CK_TVERS3 | Costing Version | ||||
| hrkft | HRKFT | Origin Group | ||||
| kosgr | CK_KOSGR | Overhead Group | ||||
| pprdz | CK_PPRDZ | Posting Period | ||||
| pprdl | CK_PPRDL | Current Period | ||||
| pprdv | CK_PPRDV | Previous Period | ||||
| pdatz | CK_PDATZ | Fut. FYyear | ||||
| pdatl | CK_PDATL | Curr. Fiscal Yr | ||||
| pdatv | CK_PDATV | Prev. Fiscal Yr | ||||
| ekalr | CK_EKALREL | Cost Est. w/QS | ||||
| vplpr | VPLPR | Prev. Plnd Prc. | ||||
| mlmaa | CK_ML_MAAC | ML Act. | ||||
| mlast | CK_ML_ABST | Price Determ. | ||||
| lplpr | CK_LPLPR | Curr.Plnd Price | ||||
| vksal | VKSAL | Total SP value | ||||
| hkmat | HKMAT | Material origin | ||||
| sperw | SPERR | Phys. Inv. Blk | ||||
| kziwl | KZIWL | Ph.inv. VO mat. | ||||
| wlinl | DLINL | Last Count Date | ||||
| abciw | ABCIN | CC Phys. Inv. | ||||
| bwspa | BWSPA | Val. Margin | ||||
| lplpx | CK_LPLPX | Fix. Cur. Plnd Prc. | ||||
| vplpx | CK_VPLPX | Fixed Prev. PlndPrc. | ||||
| fplpx | CK_ZPLPX | Fut. PlanPrice, Fxd | ||||
| lbwst | CK_LBWST | Curr. Valn Strat. | ||||
| vbwst | CK_VBWST | Prev. Valn Strat. | ||||
| fbwst | CK_ZBWST | Fut. Valn Strat. | ||||
| eklas | EKLAS | VC: Sal.Ord.Stk | ||||
| qklas | QKLAS | Project stk VC | ||||
| mtuse | J_1BMATUSE | Material Usage | ||||
| mtorg | J_1BMATORG | Material Origin | ||||
| ownpr | J_1BOWNPRO | Prod. in-house | ||||
| xbewm | XBEWW | Valuated UoM | ||||
| bwpei | BWPEI | Price Unit | ||||
| mbrue | MBRUE | MBEWH rec. already exists for per. before last of MBEW per. | ||||
| oklas | OKLAS | VC: Vendor | ||||
| dummy_val_incl_eew_ps | VAL_INCL_EEW | MD Product valuation extension field element | ||||
| oippinv | JV_PPINV | Prepaid Inv |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Material Valuation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MBEW (
MANDT, -- Client [MANDT]
MATNR, -- Material [MATNR]
BWKEY, -- Valuation Area [BWKEY]
BWTAR, -- Valuation Type [BWTAR_D]
LVORM, -- DF Val. Type [LVOBA]
LBKUM, -- Total Stock [LBKUM]
SALK3, -- Total Value [SALK3]
VPRSV, -- Price control [VPRSV]
VERPR, -- Moving price [VERPR]
STPRS, -- Standard price [STPRS]
PEINH, -- Price unit [PEINH]
BKLAS, -- Valuation Class [BKLAS]
SALKV, -- Value/MA price [SALKV]
VMKUM, -- Total stock PP [VMKUM]
VMSAL, -- Total value PP [VMSAL]
VMVPR, -- Price ctrl PP [VMVPR]
VMVER, -- MovAvgPrice PP [VMVER]
VMSTP, -- Std price PP [VMSTP]
VMPEI, -- Price unit PP [VMPEI]
VMBKL, -- Val. class PP [VMBKL]
VMSAV, -- Value prev.per. [VMSAV]
VJKUM, -- Total stock PY [VJKUM]
VJSAL, -- Total value PY [VJSAL]
VJVPR, -- Price ctrl PY [VJVPR]
VJVER, -- MovAvgPrice PY [VJVER]
VJSTP, -- Std price PY [VJSTP]
VJPEI, -- Price unit PY [VJPEI]
VJBKL, -- Val. class PY [VJBKL]
VJSAV, -- Value prev.year [VJSAV]
LFGJA, -- Year Cur.Period [LFGJA]
LFMON, -- Current Period [LFMON]
BWTTY, -- Valuation Cat. [BWTTY_D]
STPRV, -- Previous Price [STPRV]
LAEPR, -- Last Price Chg. [LAEPR]
ZKPRS, -- Future Price [DZKPRS]
ZKDAT, -- Valid from [DZKDAT]
TIMESTAMP, -- Time Stamp [TIMESTAMP]
BWPRS, -- Tax price 1 [BWPRS]
BWPRH, -- Comm. price 1 [BWPRH]
VJBWS, -- Tax price 3 [VJBWS]
VJBWH, -- Coml price 3 [VJBWH]
VVJSL, -- Valued at [VVJSL]
VVJLB, -- Total stock YBL [VVJLB]
VVMLB, -- Total stock PBL [VVMLB]
VVSAL, -- Valued at [VVSAL]
ZPLPR, -- Fut. Plnd Price [DZPLPR]
ZPLP1, -- Planned price 1 [DZPLP1]
ZPLP2, -- Planned price 2 [DZPLP2]
ZPLP3, -- Planned price 3 [DZPLP3]
ZPLD1, -- Plnd pr. date 1 [DZPLD1]
ZPLD2, -- Plnd pr. date 2 [DZPLD2]
ZPLD3, -- Plnd pr. date 3 [DZPLD3]
PPERZ, -- Fut. c/e period [PPERZ]
PPERL, -- Current c/e pd [PPERL]
PPERV, -- Prev. c/e per. [PPERV]
KALKZ, -- Fut. cost est. [KAXKZ]
KALKL, -- CurrentCostEst. [KALKL]
KALKV, -- PreviousCostEst [KALKV]
KALSC, -- Overhead key [KALSC]
XLIFO, -- LIFO/FIFO-Rel. [XLIFO]
MYPOL, -- LIFO Pool [MYPOOL]
BWPH1, -- Commercial pr.2 [BWPH1]
BWPS1, -- Tax price 2 [BWPS1]
ABWKZ, -- Devaluation Ind [ABWKZ]
PSTAT, -- Maint. Status [PSTAT_D]
KALN1, -- ProdCostEst.No. [CK_KALNR1]
KALNR, -- Cost EstimateNo [CK_KALNR]
BWVA1, -- Valuation Var. [CK_BWVA1]
BWVA2, -- Valuatn Variant [CK_BWVA2]
BWVA3, -- Valuation Var. [CK_BWVA3]
VERS1, -- Costing Version [CK_TVERS1]
VERS2, -- Costing Version [CK_TVERS2]
VERS3, -- Costing Version [CK_TVERS3]
HRKFT, -- Origin Group [HRKFT]
KOSGR, -- Overhead Group [CK_KOSGR]
PPRDZ, -- Posting Period [CK_PPRDZ]
PPRDL, -- Current Period [CK_PPRDL]
PPRDV, -- Previous Period [CK_PPRDV]
PDATZ, -- Fut. FYyear [CK_PDATZ]
PDATL, -- Curr. Fiscal Yr [CK_PDATL]
PDATV, -- Prev. Fiscal Yr [CK_PDATV]
EKALR, -- Cost Est. w/QS [CK_EKALREL]
VPLPR, -- Prev. Plnd Prc. [VPLPR]
MLMAA, -- ML Act. [CK_ML_MAAC]
MLAST, -- Price Determ. [CK_ML_ABST]
LPLPR, -- Curr.Plnd Price [CK_LPLPR]
VKSAL, -- Total SP value [VKSAL]
HKMAT, -- Material origin [HKMAT]
SPERW, -- Phys. Inv. Blk [SPERR]
KZIWL, -- Ph.inv. VO mat. [KZIWL]
WLINL, -- Last Count Date [DLINL]
ABCIW, -- CC Phys. Inv. [ABCIN]
BWSPA, -- Val. Margin [BWSPA]
LPLPX, -- Fix. Cur. Plnd Prc. [CK_LPLPX]
VPLPX, -- Fixed Prev. PlndPrc. [CK_VPLPX]
FPLPX, -- Fut. PlanPrice, Fxd [CK_ZPLPX]
LBWST, -- Curr. Valn Strat. [CK_LBWST]
VBWST, -- Prev. Valn Strat. [CK_VBWST]
FBWST, -- Fut. Valn Strat. [CK_ZBWST]
EKLAS, -- VC: Sal.Ord.Stk [EKLAS]
QKLAS, -- Project stk VC [QKLAS]
MTUSE, -- Material Usage [J_1BMATUSE]
MTORG, -- Material Origin [J_1BMATORG]
OWNPR, -- Prod. in-house [J_1BOWNPRO]
XBEWM, -- Valuated UoM [XBEWW]
BWPEI, -- Price Unit [BWPEI]
MBRUE, -- MBEWH rec. already exists for per. before last of MBEW per. [MBRUE]
OKLAS, -- VC: Vendor [OKLAS]
DUMMY_VAL_INCL_EEW_PS, -- MD Product valuation extension field element [VAL_INCL_EEW]
OIPPINV, -- Prepaid Inv [JV_PPINV]
PRIMARY KEY (MANDT, MATNR, BWKEY, BWTAR)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA