MBEWH

Transparent Table Application Table
15 Fields 4 CDS Views

Material Valuation: History

MBEWH is an SAP database table in S/4HANA. Material Valuation: History. It contains 15 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Mbv_Mbewh_Base view from Base V. for compatibility view of MBEWH
Mbv_Mbewh_Mother_Segment view from View for MBEWH Mother Segments
v_ml_invtot_l1_view view left_outer LOCAL: Inventory Stock Totals
v_ml_mig_rc1a_l1_view view left_outer Check if configuration for account determination is missing

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY bwkey BWKEY Valuation Area
KEY bwtar BWTAR_D Valuation Type
KEY lfgja LFGJA Year Cur.Period
KEY lfmon LFMON Current Period
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
vksal VKSAL Total SP value

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: History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MBEWH (
    MANDT,  -- Client [MANDT]
    MATNR,  -- Material [MATNR]
    BWKEY,  -- Valuation Area [BWKEY]
    BWTAR,  -- Valuation Type [BWTAR_D]
    LFGJA,  -- Year Cur.Period [LFGJA]
    LFMON,  -- Current Period [LFMON]
    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]
    VKSAL,  -- Total SP value [VKSAL]
    PRIMARY KEY (MANDT, MATNR, BWKEY, BWTAR, LFGJA, LFMON)
);

Learn More