I_PlanningScopeHeaderDetail

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_PlanningScopeHeaderDetail.
-- 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: IPLNSCPHDRDET

CREATE VIEW I_PlanningScopeHeaderDetail AS
SELECT
  PlanningScopeHeader.documentid AS DocumentId,
  PlanningScopeHeader.plan_scope_alt AS PlanningScopeAlternative,
  PlanningScopeHeader.src_matnr AS SourceMaterial,
  PlanningScopeHeader.description AS PlanningScopeDescription,
  PlanningScopeHeader.plant AS Plant,
  PlanningScopeHeader.timestamp AS LastChangeDateTime,
  PlanningScopeHeader.change_number AS ChangeNumber,
  PlanningScopeHeader.dokar AS DocumentInfoRecordDocType,
  PlanningScopeHeader.doknr AS DocumentInfoRecordDocNumber,
  PlanningScopeHeader.doktl AS DocumentInfoRecordDocPart,
  PlanningScopeHeader.dokvr AS DocumentInfoRecordDocVersion,
  PlanningScopeHeader.mbom_usage AS MBOMUsage,
  PlanningScopeHeader.last_synced_by AS LastChangedByUser,
  PlanningScopeHeader.target_matnr AS Material,
  cast('M' as vmp_mbom_type preserving type ) AS MfgBillOfMaterialCategory,
  PlanningScopeHeader.created_on AS RecordCreationDate,
  PlanningScopeHeader.created_by AS CreatedByUser,
  PlanningScopeHeader.source_plant AS SourcePlant,
  PlanningScopeHeader.source_bom_alt AS SourceBOMAlternative,
  PlanningScopeHeader.source_bom_usage AS SourceBOMUsage,
  PlanningScopeHeader.source_validity AS EBOMValidity,
  PlanningScopeHeader.source_bom_type AS SourceBOMType,
  PlanningScopeHeader.stlst AS BOMIsActive,
  PlanningScopeHeader.psm_explosion_date AS ConfigurationSimulationDate,
  PlanningScopeHeader.psm_node_guid AS ProductStructureNodeUUID,
  PlanningScopeHeader.psm_usage AS ProductStructureUsage,
  case PlanningScopeHeader.doknr when '' then case PlanningScopeHeader.psm_usage when '' then cast ('EBOM' as abap.sstring(10) ) else cast('PSM' as abap.sstring(10) ) end else cast('DBOM' as abap.sstring(10) ) end as PlanningSourceType AS sstring10endasPlanningSourceType,
  PlanningScopeHeader.source_change_number AS SourceChangeNumber
FROM vmp_plnscp_hdr AS PlanningScopeHeader
;