I_PLANNINGSCOPEHEADER

CDS View
45 Fields 1 CDS Views

Document and BOM Links

I_PLANNINGSCOPEHEADER is a CDS View in S/4HANA. Document and BOM Links. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PlanningScopeHeaderTP view from TRANSACTIONAL Document and BOM Links

Fields (45)

KeyField CDS FieldsUsed in Views
KEY DocumentId DocumentId 1
KEY PlanningScopeAlternative PlanningScopeAlternative 1
KEY SourceMaterial SourceMaterial 1
_CreatedByUser _CreatedByUser 1
_LastChangedByUser _LastChangedByUser 1
_MBOMUsage _MBOMUsage 1
_SourceBOMUsage _SourceBOMUsage 1
_SourceMaterial _SourceMaterial 1
_SourcePlant _SourcePlant 1
_TargetPlant _TargetPlant 1
AlignmentStatusCriticality AlignmentStatusCriticality 1
AlignmentStatusValue AlignmentStatusValue 1
BOMIsActive BOMIsActive 1
ChangeNumber ChangeNumber 1
Class Class 1
ClassType ClassType 1
ConfigurationSimulationDate ConfigurationSimulationDate 1
CreatedByUser CreatedByUser 1
DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber 1
DocumentInfoRecordDocPart DocumentInfoRecordDocPart 1
DocumentInfoRecordDocType DocumentInfoRecordDocType 1
DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion 1
EBOMValidity EBOMValidity 1
HeaderValidityEndDate HeaderValidityEndDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Material Material 1
MBOMUsage MBOMUsage 1
MfgBillOfMaterialCategory MfgBillOfMaterialCategory 1
PlanningScopeDescription PlanningScopeDescription 1
PlanningSourceType PlanningSourceType 1
Plant Plant 1
ProductStructureNodeName ProductStructureNodeName 1
ProductStructureNodeType ProductStructureNodeType 1
ProductStructureNodeUUID ProductStructureNodeUUID 1
ProductStructureUsage ProductStructureUsage 1
RecordCreationDate RecordCreationDate 1
SourceBOMAlternative SourceBOMAlternative 1
SourceBOMType SourceBOMType 1
SourceBOMUsage SourceBOMUsage 1
SourceChangeNumber SourceChangeNumber 1
SourceMaterialForEdit SourceMaterialForEdit 1
SourcePlant SourcePlant 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Document and BOM Links
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLANNINGSCOPEHEADER (
    DOCUMENTID,
    PLANNINGSCOPEALTERNATIVE,
    SOURCEMATERIAL,
    _CREATEDBYUSER,
    _LASTCHANGEDBYUSER,
    _MBOMUSAGE,
    _SOURCEBOMUSAGE,
    _SOURCEMATERIAL,
    _SOURCEPLANT,
    _TARGETPLANT,
    ALIGNMENTSTATUSCRITICALITY,
    ALIGNMENTSTATUSVALUE,
    BOMISACTIVE,
    CHANGENUMBER,
    CLASS,
    CLASSTYPE,
    CONFIGURATIONSIMULATIONDATE,
    CREATEDBYUSER,
    DOCUMENTINFORECORDDOCNUMBER,
    DOCUMENTINFORECORDDOCPART,
    DOCUMENTINFORECORDDOCTYPE,
    DOCUMENTINFORECORDDOCVERSION,
    EBOMVALIDITY,
    HEADERVALIDITYENDDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    MBOMUSAGE,
    MFGBILLOFMATERIALCATEGORY,
    PLANNINGSCOPEDESCRIPTION,
    PLANNINGSOURCETYPE,
    PLANT,
    PRODUCTSTRUCTURENODENAME,
    PRODUCTSTRUCTURENODETYPE,
    PRODUCTSTRUCTURENODEUUID,
    PRODUCTSTRUCTUREUSAGE,
    RECORDCREATIONDATE,
    SOURCEBOMALTERNATIVE,
    SOURCEBOMTYPE,
    SOURCEBOMUSAGE,
    SOURCECHANGENUMBER,
    SOURCEMATERIALFOREDIT,
    SOURCEPLANT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (DOCUMENTID, PLANNINGSCOPEALTERNATIVE, SOURCEMATERIAL)
);

Learn More