I_PLANNINGSCOPEHEADERDETAIL

CDS View
25 Fields 4 CDS Views

VEMP Planning Scope Header Details

I_PLANNINGSCOPEHEADERDETAIL is a CDS View in S/4HANA. VEMP Planning Scope Header Details. It contains 25 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_PlanningScopeExplodedBOM view inner BASIC
P_PlanningScopeHeader view from COMPOSITE
P_PlanningScopeHeader view left_outer COMPOSITE
P_PlanningScopeMBOM view inner BASIC

Fields (25)

KeyField CDS FieldsUsed in Views
KEY DocumentId DocumentId 1
KEY PlanningScopeAlternative PlanningScopeAlternative 1
KEY SourceMaterial ProductStructureNodeName,SourceMaterial 2
BOMIsActive BOMIsActive 2
ChangeNumber ChangeNumber 2
ConfigurationSimulationDate ConfigurationSimulationDate 1
CreatedByUser CreatedByUser 1
DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber 1
DocumentInfoRecordDocPart DocumentInfoRecordDocPart 1
DocumentInfoRecordDocType DocumentInfoRecordDocType 1
DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion 1
EBOMValidity EBOMValidity 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Material Material 1
MBOMUsage MBOMUsage 1
MfgBillOfMaterialCategory MfgBillOfMaterialCategory 1
PlanningScopeDescription PlanningScopeDescription 1
PlanningSourceType PlanningSourceType 1
Plant Plant 2
RecordCreationDate RecordCreationDate 1
SourceBOMAlternative SourceBOMAlternative 1
SourceBOMType SourceBOMType 1
SourceBOMUsage SourceBOMUsage 1
SourcePlant SourcePlant 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.

-- VEMP Planning Scope Header Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLANNINGSCOPEHEADERDETAIL (
    DOCUMENTID,
    PLANNINGSCOPEALTERNATIVE,
    SOURCEMATERIAL,
    BOMISACTIVE,
    CHANGENUMBER,
    CONFIGURATIONSIMULATIONDATE,
    CREATEDBYUSER,
    DOCUMENTINFORECORDDOCNUMBER,
    DOCUMENTINFORECORDDOCPART,
    DOCUMENTINFORECORDDOCTYPE,
    DOCUMENTINFORECORDDOCVERSION,
    EBOMVALIDITY,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    MBOMUSAGE,
    MFGBILLOFMATERIALCATEGORY,
    PLANNINGSCOPEDESCRIPTION,
    PLANNINGSOURCETYPE,
    PLANT,
    RECORDCREATIONDATE,
    SOURCEBOMALTERNATIVE,
    SOURCEBOMTYPE,
    SOURCEBOMUSAGE,
    SOURCEPLANT,
    PRIMARY KEY (DOCUMENTID, PLANNINGSCOPEALTERNATIVE, SOURCEMATERIAL)
);

Learn More