P_PlanningScopeHeader

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 P_PlanningScopeHeader.
-- 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: PPLNSCPHDR

CREATE VIEW P_PlanningScopeHeader AS
SELECT
  PlanningScopeHeader.DocumentId AS DocumentId,
  PlanningScopeHeader.PlanningScopeAlternative AS PlanningScopeAlternative,
  PlanningScopeHeader.SourceMaterial AS SourceMaterial,
  PlanningScopeHeader.PlanningScopeDescription AS PlanningScopeDescription,
  PlanningScopeHeader.Plant AS Plant,
  PlanningScopeHeader.LastChangeDateTime AS LastChangeDateTime,
  PlanningScopeHeader.ChangeNumber AS ChangeNumber,
  PlanningScopeHeader.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  PlanningScopeHeader.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  PlanningScopeHeader.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  PlanningScopeHeader.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  PlanningScopeHeader.MBOMUsage AS MBOMUsage,
  PlanningScopeHeader.LastChangedByUser AS LastChangedByUser,
  PlanningScopeHeader.Material AS Material,
  PlanningScopeHeader.MfgBillOfMaterialCategory AS MfgBillOfMaterialCategory,
  PlanningScopeHeader.RecordCreationDate AS RecordCreationDate,
  PlanningScopeHeader.CreatedByUser AS CreatedByUser,
  PlanningScopeHeader.SourcePlant AS SourcePlant,
  PlanningScopeHeader.SourceBOMAlternative AS SourceBOMAlternative,
  PlanningScopeHeader.SourceBOMUsage AS SourceBOMUsage,
  PlanningScopeHeader.EBOMValidity AS EBOMValidity,
  PlanningScopeHeader.SourceBOMType AS SourceBOMType,
  PlanningScopeHeader.BOMIsActive AS BOMIsActive,
  PlanningScopeHeader.PlanningSourceType AS PlanningSourceType,
  PlanningScopeHeader.ConfigurationSimulationDate AS ConfigurationSimulationDate,
  PSMNode.ProductStructureNodeUUID AS ProductStructureNodeUUID,
  PSMNode.ProductStructureUsage AS ProductStructureUsage,
  PSMNode.ProductStructureNodeName AS ProductStructureNodeName,
  PSMNode.ProductStructureNodeType AS ProductStructureNodeType,
  PSMNode.ClassType AS ClassType,
  PSMNode.Class AS Class,
  cast ('19000101' as vmp_source_datum) AS ValidityStartDate,
  cast ('99991231' as vmp_source_datum) AS ValidityEndDate,
  cast('' as aennr) AS SourceChangeNumber
FROM I_PlanningScopeHeaderDetail AS PlanningScopeHeader
LEFT OUTER JOIN I_ProductStructureNodeVariant AS PSMNode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PlanningScopeHeaderDetail AS PSEbom ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PlanningScopeHeaderDetail AS PSProductStructure ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_MaterialBOM, I_ProductStructureNodeVariant
;