MBEW

Transparent Table Application Table
4 Fields 26 CDS Views

Material Valuation

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

CDS Views using this table (26)

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
fmlv_ckmlpr_compat view inner Compatibility View for CKMLPR
I_COPCCMaterialValuation view from BASIC CO PCC Material Valuation
I_FldLogsValuationType view from BASIC Field Logistics Valuation type
I_FldLogsValuationTypeVH view from BASIC Material Valuation Type in Field Logistics
I_MaterialValuation view from BASIC Material Valuation
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_CHMPMaterialValuation view_entity from BASIC
P_FBV_PAR_SEL_MAT view inner BASIC
P_InvtryTurnoverPricing view from CONSUMPTION Inventory Turnover Pricing
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_Cost view inner BASIC
P_Matval_Manage_Cost_Max_Pre view inner BASIC
P_Matval_Manage_Xbew view from BASIC
P_ProductValuationBasic view from BASIC
P_SLLMINMAXRELEVANTPOITEMS view inner BASIC
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