C_ProductionRouting

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 C_ProductionRouting.
-- 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 C_ProductionRouting AS
SELECT
  ProductionRoutingGroup,
  ProductionRouting,
  ProductionRoutingInternalVers,
  BillOfOperationsDesc,
  Plant,
  BillOfOperationsUsage,
  _UsageText.BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc,
  BillOfOperationsStatus,
  _StatusText.BillOfOperationsStatusDesc AS BillOfOperationsStatusDesc,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  LastChangedByUser,
  LastChangeDate,
  CreatedByUser,
  CreationDate,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  BillOfOperationsUnit,
  _MatlCount.NumberOfProducts AS NumberOfProducts,
  _Plant.PlantName AS PlantName,
  virtual KeyDate : abap.dats(8) AS dats8
FROM I_ProductionRoutingHeaderTP
LEFT OUTER JOIN C_ProdnRoutingMatlAssgmt AS _MatlAssgmt ON ProductionRoutingGroup = _MatlAssgmt.ProductionRoutingGroup AND ProductionRouting = _MatlAssgmt.ProductionRouting AND ValidityEndDate >= _MatlAssgmt.ValidityStartDate AND ValidityStartDate <= _MatlAssgmt.ValidityEndDate  -- association [0..*]
;