P_ProductionRoutingDEX

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_ProductionRoutingDEX.
-- 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 P_ProductionRoutingDEX AS
SELECT
  plkz.plnty AS BillOfOperationsType,
  plkz.plnnr AS ProductionRoutingGroup,
  plkz.plnal AS ProductionRouting,
  plkz.subtype AS BillOfOperationsVersionType,
  plkz.subtype AS BillOfOperationsSubtype,
  plkz.abdat AS LastUsageDate,
  plkz.abanz AS NumberOfUsages,
  plkz.flg_ecm AS HasChangeNumber,
  plkz.flg_ecm_par AS HasParameterEffectivity,
  plkz.aeuzeit AS LastChangeTime,
  cast(plkz.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  plkz.delkz AS IsMarkedForDeletion,
  plkz.altext AS BillOfOperationsVariantDesc,
  plkz.rework AS RoutingIsReworkRouting,
  plkz.relaxed AS ProdnProcgIsFlexible,
  plkz.execution_in_me AS BillOfOperationIsExecutedInMES,
  plkz.erp_integration AS BillOfOperationsIsTrnsfdToERP,
  plkz.reference_template_category AS ShopFloorRtgTemplateCategory,
  plkz.reference_template_type AS ShopFloorRoutingTemplateType,
  plkz.reference_template_owner AS ShopFloorRoutingTemplateOwner
FROM plkz
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
;