VMP_EXPLODED_MAT

Transparent Table Application Table
10 Fields 2 CDS Views

VMP Planning scope expanded materials

VMP_EXPLODED_MAT is an SAP database table in S/4HANA. VMP Planning scope expanded materials. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ExplodedMatlPlngScp view from BASIC Exploded Materials for Planning Scope Source Material
P_PlanningScopeExplodedBOM view from BASIC VMP Planning scope expanded materials

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY documentid vmp_plnscp_doc_id Document Id
KEY plan_scope_alt vmp_plnscp_alt Plan Scope Alternate
KEY item_counter cim_count Counter
material_id matnr Material
explosion_type vmp_expl_type VMP Explosion type
source_bom_type stlty BOM category
source_bom_plant werks_d Plant
source_bom_usage stlan Usage
source_bom_alt stlal AlternativeBOM

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.

-- VMP Planning scope expanded materials
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VMP_EXPLODED_MAT (
    MANDT,             -- Client [mandt]
    DOCUMENTID,        -- Document Id [vmp_plnscp_doc_id]
    PLAN_SCOPE_ALT,    -- Plan Scope Alternate [vmp_plnscp_alt]
    ITEM_COUNTER,      -- Counter [cim_count]
    MATERIAL_ID,       -- Material [matnr]
    EXPLOSION_TYPE,    -- VMP Explosion type [vmp_expl_type]
    SOURCE_BOM_TYPE,   -- BOM category [stlty]
    SOURCE_BOM_PLANT,  -- Plant [werks_d]
    SOURCE_BOM_USAGE,  -- Usage [stlan]
    SOURCE_BOM_ALT,    -- AlternativeBOM [stlal]
    PRIMARY KEY (MANDT, DOCUMENTID, PLAN_SCOPE_ALT, ITEM_COUNTER)
);

Learn More