C_ChangeRecordObjPgRouting

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_ChangeRecordObjPgRouting.
-- 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: CCHGRECREFROU

CREATE VIEW C_ChangeRecordObjPgRouting AS
SELECT
  ChangeRecordReferenceUUID,
  _ChangeRecordRefObjIcons[ChangeRecordType = ChangeRecordType].ChangeRecordRefObjIcon AS ChangeRecordRefObjIcon,
  cast (ChangeRecordReferenceRTGTP.BillOfOperationsGroup as mpe_rtg_routing_group preserving type ) AS BillOfOperationsGroup,
  ChangeRecordReferenceRTGTP.BillOfOperationsType AS BillOfOperationsType,
  ChangeRecordReferenceRTGTP.BillOfOperationsVariant AS BillOfOperationsVariant,
  ChangeRecordReferenceRTGTP.BillOfOperationsVersion AS BillOfOperationsVersion,
  cast ('' as matnr) AS Material,
  cast ('' as maktx) AS MaterialDescription,
  cast (0 as abap.int1 ) AS NumberOfMaterials,
  _ChangeRecordObjPg.ChangeRecordType AS ChangeRecordType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ParentChangeRecordRefUUID,
  ChangeRecordItemRelevance,
  _BillOfOperationsGroupVH._BillOfOperations.RoutingIsReworkRouting AS RoutingIsReworkRouting,
  cast(_BOOMaterialAssgmtChangeState.SalesOrder as cs_vbeln preserving type ) AS SalesOrder,
  _BOOMaterialAssgmtChangeState.SalesOrderItem AS SalesOrderItem,
  ChangeRecordReference,
  _ChangeRecordObjPg.ChgRecdItemProcgStatusIsEnbld AS ChgRecdItemProcgStatusIsEnbld,
  _ChangeRecordObjPg.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  ChangeRecordItemProcgStatus,
  ChgRecdCurrentItemProcgStatus,
  ChgRecdItmDSgntr,
  cast( '' as boolean) AS DigitalSignUserIsAuthorized,
  _DigSignStatusText.ChgRecdDigSignStatusTxt AS ChgRecdDigSignStatusTxt,
  cast( '' as boolean) AS ChgRecdObjDgtlSgntrEnable,
  CreatedByUser,
  CreationDateTime,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  LastChangedByUser,
  LastChangeDateTime,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate,
  ChgRecdReasonForChange,
  ExpdCompltnDte,
  ChgRecdAuthznGrpText,
  ChgRecdNmbrChgSts,
  ChangeNumber,
  ChangeRecordReferenceRTGTP.Plant AS Plant,
  _ProductionModel.ProductionModelUUID AS ProductionModelUUID,
  _ProductionModel.ProductionModelProcessType AS ProductionModelProcessType
FROM I_ChgRecdRefRoutingTP AS ChangeRecordReferenceRTGTP
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsTypeVH ON BillOfOperationsType = _BillOfOperationsTypeVH.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsVersion AS _BillOfOperationsGroupVH ON BillOfOperationsType = _BillOfOperationsGroupVH.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroupVH.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsGroupVH.BillOfOperationsVariant AND BillOfOperationsVersion = _BillOfOperationsGroupVH.BillOfOperationsVersion  -- association [1..1]
LEFT OUTER JOIN I_BOOMaterialAssgmtChangeState AS _BOOMaterialAssgmtChangeState ON BillOfOperationsType = _BOOMaterialAssgmtChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BOOMaterialAssgmtChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOMaterialAssgmtChangeState.BillOfOperationsVariant AND BillOfOperationsVersion = _BOOMaterialAssgmtChangeState.BillOfOperationsVersion AND _BOOMaterialAssgmtChangeState.SalesOrder <> ' '  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecordItemRelRouVH AS _ChangeRecordItemRelVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelVH.ChangeRecordType  -- association [1..1]
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN I_ChangeRecordRefObjIcons AS _ChangeRecordRefObjIcons ON ChangeRecordUUID = _ChangeRecordRefObjIcons.ChangeRecordUUID AND ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType  -- association [0..*]
LEFT OUTER JOIN C_ChgRecordItemProcgStatusVH AS _ProcessingStatusVH ON ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus AND ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus AND ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus  -- association [1..1]
LEFT OUTER JOIN I_ChgRecdItemProcgStatusText AS _ProcessingStatusTxt ON ChangeRecordItemProcgStatus = _ProcessingStatusTxt.ChangeRecordItemProcgStatus  -- association [0..*]
LEFT OUTER JOIN C_ChangeRecdDigSignStatusVH AS _DigSignStatusText ON ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus  -- association [0..*]
LEFT OUTER JOIN I_ProductionModelBasic AS _ProductionModel ON BillOfOperationsType = _ProductionModel.BillOfOperationsType AND BillOfOperationsGroup = _ProductionModel.BillOfOperationsGroup AND BillOfOperationsVariant = _ProductionModel.BillOfOperationsVariant  -- association [0..1]
;