MBEW

Transparent Table Application Table
4 Fields 13 CDS Views

Material Valuation

MBEW is an SAP database table in S/4HANA. Material Valuation. It contains 4 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
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_CurrentMatlPriceByCostEst view_entity from COMPOSITE Current material price by cost estimate
P_InvtryTurnoverPricing view_entity from CONSUMPTION Inventory Turnover Pricing
P_PreviousMatlPriceByCostEst view_entity from BASIC Previos material price by cost estimate
P_ProductValuationBasic view from BASIC Product Valuation
v_ml_account_l2_view view left_outer LOCAL: Material Ledger Periods

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY bwkey bwkey Valuation Area
KEY bwtar bwtar_d Valuation Type

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]
    PRIMARY KEY (MANDT, MATNR, BWKEY, BWTAR)
);

Learn More