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

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