I_PLNGSCPBASIC

CDS View
17 Fields 1 CDS Views

Planning Scope Basic View

I_PLNGSCPBASIC is a CDS View in S/4HANA. Planning Scope Basic View. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PlngScpHdr view from COMPOSITE Planning Scope Header Details (Stop Gap )

Fields (17)

KeyField CDS FieldsUsed in Views
KEY DocumentId DocumentId 1
KEY PlanningScopeAlternative PlanningScopeAlternative 1
ChangeNumber ChangeNumber 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
HierarchyRelevantPlngScp HierarchyRelevantPlngScp 1
MBOMUsage MBOMUsage 1
PlanningScopeDescription PlanningScopeDescription 1
PlanningScopeScenario PlanningScopeScenario 1
PlanningScopeTimeStamp PlanningScopeTimeStamp 1
Plant Plant 1
SourceBOMAlternative SourceBOMAlternative 1
SourceBOMType SourceBOMType 1
SourceBOMUsage SourceBOMUsage 1
SourceMaterial SourceMaterial 1
SourcePlant SourcePlant 1
TargetMaterial TargetMaterial 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.

-- Planning Scope Basic View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLNGSCPBASIC (
    DOCUMENTID,
    PLANNINGSCOPEALTERNATIVE,
    CHANGENUMBER,
    CREATEDBYUSER,
    CREATIONDATE,
    HIERARCHYRELEVANTPLNGSCP,
    MBOMUSAGE,
    PLANNINGSCOPEDESCRIPTION,
    PLANNINGSCOPESCENARIO,
    PLANNINGSCOPETIMESTAMP,
    PLANT,
    SOURCEBOMALTERNATIVE,
    SOURCEBOMTYPE,
    SOURCEBOMUSAGE,
    SOURCEMATERIAL,
    SOURCEPLANT,
    TARGETMATERIAL,
    PRIMARY KEY (DOCUMENTID, PLANNINGSCOPEALTERNATIVE)
);

Learn More