R_ProdnRoutingOpCompAllocTP_2

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 R_ProdnRoutingOpCompAllocTP_2.
-- 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.

CREATE VIEW R_ProdnRoutingOpCompAllocTP_2 AS
SELECT
  CompAlloc.BillOfOperationsGroup AS ProductionRoutingGroup,
  CompAlloc.BillOfOperationsVariant AS ProductionRouting,
  CompAlloc.BillOfOperationsSequence AS ProductionRoutingSequence,
  CompAlloc.BOOOperationInternalID AS ProductionRoutingOpIntID,
  CompAlloc.BOOOpBOMItemInternalID AS ProdnRtgOpBOMItemInternalID,
  CompAlloc.BOOOpBOMItemIntVersCounter AS ProdnRtgOpBOMItemIntVersion,
  CompAlloc.BillOfMaterialCategory AS BillOfMaterialCategory,
  CompAlloc.BillOfMaterial AS BillOfMaterial,
  CompAlloc._BillOfMaterialItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  CompAlloc.BillOfMaterialVariant AS BillOfMaterialVariant,
  CompAlloc.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  CompAlloc.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  CompAlloc.CreationDate AS CreationDate,
  CompAlloc.CreatedByUser AS CreatedByUser,
  CompAlloc.LastChangeDate AS LastChangeDate,
  CompAlloc.LastChangedByUser AS LastChangedByUser,
  cast(CompAlloc.ValidityStartDate as pph_begda preserving type) AS ValidityStartDate,
  cast(CompAlloc.ValidityEndDate as pph_endda preserving type) AS ValidityEndDate,
  CompAlloc.ChangeNumber AS ChangeNumber,
  _NonSqncTP.ChangedDateTime AS ChangedDateTime,
  CompAlloc.BillOfMaterialHierarchyLevel AS BillOfMaterialHierarchyLevel,
  CompAlloc.BillOfMaterialHierarchyPath AS BillOfMaterialHierarchyPath,
  CompAlloc.BillOfMaterialRootCategory AS BillOfMaterialRootCategory,
  CompAlloc.BillOfMaterialRoot AS BillOfMaterialRoot,
  CompAlloc.BillOfMaterialRootVariant AS BillOfMaterialRootVariant
FROM I_ProductionRoutingCompAlloc AS CompAlloc
INNER JOIN I_ProdnRtgOpCompAllocToOp AS OperCompAlloc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_ProductionRoutingHeaderTP_2 AS _Header ON ProductionRoutingGroup = _Header.ProductionRoutingGroup AND ProductionRouting = _Header.ProductionRouting AND ValidityEndDate >= _Header.ValidityStartDate AND ValidityStartDate <= _Header.ValidityEndDate  -- association [1..*]
;