V_MBEW_MD

95 Fields 13 CDS Views

Generated Table for View

V_MBEW_MD is an SAP database table in S/4HANA. Generated Table for View. It contains 95 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
FCML_MAT_DDL view inner CDS View with structure of table FCML_MAT
fmlv_ckmlpr_compat view union_all Compatibility View for CKMLPR
FMLV_CKMLPR_COMPAT_DB view inner Compatibility View for CKMLPR
I_RO_SAFTProductValuation view from BASIC RO SAFT Product Valuation
P_Matval_Manage_Bal_Split view from BASIC
P_Matval_Manage_Bal_Split view left_outer BASIC
P_Matval_Manage_Bal_Split view union_all BASIC
P_MATVAL_MANAGE_CKML view left_outer BASIC
P_MATVAL_MANAGE_CKML view union_all BASIC
P_Matval_Manage_Cost view inner BASIC
P_Matval_Manage_Cost_Max_Pre view inner BASIC
P_Matval_Manage_Xbew view from BASIC
pchk_par_sel_xbew view from Xbew selection for parallel packaging

Fields (95)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY bwkey BWKEY Valuation Area
KEY bwtar BWTAR_D Valuation Type
lvorm LVOBA DF Val. Type
vprsv VPRSV Price control
verpr VERPR Moving price
stprs STPRS Standard price
peinh PEINH Price unit
bklas BKLAS Valuation Class
vmvpr VMVPR Price ctrl PP
vmver VMVER MovAvgPrice PP
vmstp VMSTP Std price PP
vmpei VMPEI Price unit PP
vmbkl VMBKL Val. class PP
vjvpr VJVPR Price ctrl PY
vjver VJVER MovAvgPrice PY
vjstp VJSTP Std price PY
vjpei VJPEI Price unit PY
vjbkl VJBKL Val. class PY
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
bwprs BWPRS Tax price 1
bwprh BWPRH Comm. price 1
vjbws VJBWS Tax price 3
vjbwh VJBWH Coml price 3
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
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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_MBEW_MD (
    MANDT,                  -- Client [MANDT]
    MATNR,                  -- Material [MATNR]
    BWKEY,                  -- Valuation Area [BWKEY]
    BWTAR,                  -- Valuation Type [BWTAR_D]
    LVORM,                  -- DF Val. Type [LVOBA]
    VPRSV,                  -- Price control [VPRSV]
    VERPR,                  -- Moving price [VERPR]
    STPRS,                  -- Standard price [STPRS]
    PEINH,                  -- Price unit [PEINH]
    BKLAS,                  -- Valuation Class [BKLAS]
    VMVPR,                  -- Price ctrl PP [VMVPR]
    VMVER,                  -- MovAvgPrice PP [VMVER]
    VMSTP,                  -- Std price PP [VMSTP]
    VMPEI,                  -- Price unit PP [VMPEI]
    VMBKL,                  -- Val. class PP [VMBKL]
    VJVPR,                  -- Price ctrl PY [VJVPR]
    VJVER,                  -- MovAvgPrice PY [VJVER]
    VJSTP,                  -- Std price PY [VJSTP]
    VJPEI,                  -- Price unit PY [VJPEI]
    VJBKL,                  -- Val. class PY [VJBKL]
    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]
    BWPRS,                  -- Tax price 1 [BWPRS]
    BWPRH,                  -- Comm. price 1 [BWPRH]
    VJBWS,                  -- Tax price 3 [VJBWS]
    VJBWH,                  -- Coml price 3 [VJBWH]
    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]
    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