I_PlngScpHdr

DDL: I_PLNGSCPHDR SQL: IPLNGSCPHDR Type: view COMPOSITE Package: MPE_PLAN_MEC
18 Fields 2 Data Sources

Planning Scope Header Details (Stop Gap )

I_PlngScpHdr is a Composite CDS View that provides data about "Planning Scope Header Details (Stop Gap )" in SAP S/4HANA. It reads from 2 data sources (I_MfgBOMUsageCtrlData, I_PlngScpBasic) and exposes 18 fields with key fields DocumentId, PlanningScopeAlternative. Part of development package MPE_PLAN_MEC.

Data Sources (2)

SourceAliasJoin Type
I_MfgBOMUsageCtrlData BOMUsageCtrl left_outer
I_PlngScpBasic PlngScpHdr from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPLNGSCPHDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Planning Scope Header Details (Stop Gap ) view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DocumentId I_PlngScpBasic DocumentId Routing slip doc. ID
KEY PlanningScopeAlternative I_PlngScpBasic PlanningScopeAlternative Plan Scope Alternate
ChangeNumber I_PlngScpBasic ChangeNumber Change Number
CreatedByUser I_PlngScpBasic CreatedByUser User Name
CreationDate I_PlngScpBasic CreationDate Time Stamp
MBOMUsage I_PlngScpBasic MBOMUsage Usage
PlanningScopeDescription I_PlngScpBasic PlanningScopeDescription Well Code Des.
PlanningScopeScenario I_PlngScpBasic PlanningScopeScenario Scenario ID
PlanningScopeTimeStamp I_PlngScpBasic PlanningScopeTimeStamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Plant I_PlngScpBasic Plant Valuation Area
SourceBOMAlternative I_PlngScpBasic SourceBOMAlternative Source BOM alt
SourceBOMType I_PlngScpBasic SourceBOMType EBom Type
SourceBOMUsage I_PlngScpBasic SourceBOMUsage Usage
SourceMaterial I_PlngScpBasic SourceMaterial Material
SourcePlant I_PlngScpBasic SourcePlant Source plant
TargetMaterial I_PlngScpBasic TargetMaterial Material
HierarchyRelevantPlngScp I_PlngScpBasic HierarchyRelevantPlngScp
IsVersionBillOfMaterial

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PlngScpHdr.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPLNGSCPHDR

CREATE VIEW I_PlngScpHdr AS
SELECT
  PlngScpHdr.DocumentId AS DocumentId,
  PlngScpHdr.PlanningScopeAlternative AS PlanningScopeAlternative,
  PlngScpHdr.ChangeNumber AS ChangeNumber,
  PlngScpHdr.CreatedByUser AS CreatedByUser,
  PlngScpHdr.CreationDate AS CreationDate,
  PlngScpHdr.MBOMUsage AS MBOMUsage,
  PlngScpHdr.PlanningScopeDescription AS PlanningScopeDescription,
  PlngScpHdr.PlanningScopeScenario AS PlanningScopeScenario,
  PlngScpHdr.PlanningScopeTimeStamp AS PlanningScopeTimeStamp,
  PlngScpHdr.Plant AS Plant,
  PlngScpHdr.SourceBOMAlternative AS SourceBOMAlternative,
  PlngScpHdr.SourceBOMType AS SourceBOMType,
  PlngScpHdr.SourceBOMUsage AS SourceBOMUsage,
  PlngScpHdr.SourceMaterial AS SourceMaterial,
  PlngScpHdr.SourcePlant AS SourcePlant,
  PlngScpHdr.TargetMaterial AS TargetMaterial,
  PlngScpHdr.HierarchyRelevantPlngScp AS HierarchyRelevantPlngScp,
  cast('X' as cs_versnind) AS IsVersionBillOfMaterial
FROM I_PlngScpBasic AS PlngScpHdr
LEFT OUTER JOIN I_MfgBOMUsageCtrlData AS BOMUsageCtrl ON /* join condition not captured in parsed metadata */
;

Learn More