QBEW

Transparent Table Application Table
73 Fields 4 CDS Views

Project Stock Valuation

QBEW is an SAP database table in S/4HANA. Project Stock Valuation. It contains 73 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ProductProjectStockValuation view_entity from BASIC Product Project Stock Valuation
Mbv_Qbew view from Compatibility view for QBEW table
P_CHMPMaterialValuation view_entity union_all BASIC
v_ml_account_l2_view view left_outer LOCAL: Material Ledger Periods

Fields (73)

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
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
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
vksal VKSAL Total SP value
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.

-- Project Stock Valuation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QBEW (
    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]
    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]
    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]
    VKSAL,      -- Total SP value [VKSAL]
    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