P_PLANNINGSCOPEEXPLODEDBOM

CDS View

VMP Planning scope expanded materials

P_PLANNINGSCOPEEXPLODEDBOM is a CDS View in S/4HANA. VMP Planning scope expanded materials. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PlanningScopeExplodedBOM view from BASIC VMP Planning scope expanded materials

Fields (11)

KeyField CDS FieldsUsed in Views
KEY DocumentId DocumentId 1
KEY PlanningScopeAlternative PlanningScopeAlternative 1
KEY PlanningScopeItemCount PlanningScopeItemCount 1
KEY SourceMaterial SourceMaterial 1
EBOMPlant EBOMPlant 1
EBOMValidity EBOMValidity 1
ExplosionType ExplosionType 1
Material Material 1
SourceBOMAlternative SourceBOMAlternative 1
SourceBOMType SourceBOMType 1
SourceBOMUsage SourceBOMUsage 1

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PLANNINGSCOPEEXPLODEDBOM (
    DOCUMENTID,
    PLANNINGSCOPEALTERNATIVE,
    PLANNINGSCOPEITEMCOUNT,
    SOURCEMATERIAL,
    EBOMPLANT,
    EBOMVALIDITY,
    EXPLOSIONTYPE,
    MATERIAL,
    SOURCEBOMALTERNATIVE,
    SOURCEBOMTYPE,
    SOURCEBOMUSAGE,
    PRIMARY KEY (DOCUMENTID, PLANNINGSCOPEALTERNATIVE, PLANNINGSCOPEITEMCOUNT, SOURCEMATERIAL)
);