I_PlanningScopeMBOMTP

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_PlanningScopeMBOMTP.
-- 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: IPNSCPMBOMTP

CREATE VIEW I_PlanningScopeMBOMTP AS
SELECT
  PlanningScopeMBOM.DocumentId AS DocumentId,
  PlanningScopeMBOM.PlanningScopeAlternative AS PlanningScopeAlternative,
  PlanningScopeMBOM.SourceMaterial AS SourceMaterial,
  PlanningScopeMBOM.PlanningScopeItemCount AS PlanningScopeItemCount,
  PlanningScopeMBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  PlanningScopeMBOM.Material AS Material,
  PlanningScopeMBOM.TaskListGroupCounter AS TaskListGroupCounter,
  PlanningScopeMBOM.TaskListGroup AS TaskListGroup,
  PlanningScopeMBOM.TaskListType AS TaskListType,
  PlanningScopeMBOM.AlternativeBillOfMaterial AS AlternativeBillOfMaterial,
  PlanningScopeMBOM.MBOMState AS MBOMState,
  PlanningScopeMBOM.MfgBillOfMaterialCategory AS MfgBillOfMaterialCategory,
  PlanningScopeMBOM.MBOMUsage AS MBOMUsage,
  PlanningScopeMBOM.ChangeNumber AS ChangeNumber,
  PlanningScopeMBOM.Plant AS Plant,
  PlanningScopeMBOM.BOMIsActive AS BOMIsActive,
  cast(hextobin('00000000000000000000000000000000') as /bobf/uuid preserving type ) AS BOMHeaderDraftUUID,
  PlanningScopeMBOM.StatusCount AS StatusCount,
  PlanningScopeMBOM.SyncedWithSyncUnitUUID AS SyncedWithSyncUnitUUID,
  PlanningScopeMBOM._BOMHeader AS _BOMHeader,
  PlanningScopeMBOM._BillOfMaterialVariantUsage AS _BillOfMaterialVariantUsage,
  PlanningScopeMBOM._BillOfOperationsGroup AS _BillOfOperationsGroup,
  PlanningScopeMBOM._BillOfOperationsType AS _BillOfOperationsType,
  PlanningScopeMBOM._BillOfMaterialStatusText AS _BillOfMaterialStatusText
FROM I_PlanningScopeMBOM AS PlanningScopeMBOM
LEFT OUTER JOIN I_PlanningScopeHeaderTP AS _PlanningScopeHeader ON DocumentId = _PlanningScopeHeader.DocumentId AND PlanningScopeAlternative = _PlanningScopeHeader.PlanningScopeAlternative AND SourceMaterial = _PlanningScopeHeader.SourceMaterial  -- association [1..1]
;