V_QBEW_MD

62 Fields 3 CDS Views

Generated Table for View

V_QBEW_MD is an SAP database table in S/4HANA. Generated Table for View. It contains 62 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FCML_MAT_DDL view inner CDS View with structure of table FCML_MAT
P_Matval_Manage_Xbew view union_all BASIC
pchk_par_sel_xbew view union_all Xbew selection for parallel packaging

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY bwkey BWKEY Valuation Area
KEY bwtar BWTAR_D Valuation Type
KEY sobkz SOBKZ Special Stock
KEY pspnr PS_PSP_PNR WBS Element
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
zplpr DZPLPR Fut. Plnd Price
kalkz KAXKZ Fut. cost est.
kalkl KALKL CurrentCostEst.
kalkv KALKV PreviousCostEst
kaln1 CK_KALNR1 ProdCostEst.No.
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
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.
mbrue MBRUE MBEWH rec. already exists for per. before last of MBEW per.
oklas OKLAS VC: Vendor

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_QBEW_MD (
    MANDT,  -- Client [MANDT]
    MATNR,  -- Material [MATNR]
    BWKEY,  -- Valuation Area [BWKEY]
    BWTAR,  -- Valuation Type [BWTAR_D]
    SOBKZ,  -- Special Stock [SOBKZ]
    PSPNR,  -- WBS Element [PS_PSP_PNR]
    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]
    ZPLPR,  -- Fut. Plnd Price [DZPLPR]
    KALKZ,  -- Fut. cost est. [KAXKZ]
    KALKL,  -- CurrentCostEst. [KALKL]
    KALKV,  -- PreviousCostEst [KALKV]
    KALN1,  -- ProdCostEst.No. [CK_KALNR1]
    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]
    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]
    MBRUE,  -- MBEWH rec. already exists for per. before last of MBEW per. [MBRUE]
    OKLAS,  -- VC: Vendor [OKLAS]
    PRIMARY KEY (MANDT, MATNR, BWKEY, BWTAR, SOBKZ, PSPNR)
);

Learn More