N_ChgRecdObjPgRateRtg

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 N_ChgRecdObjPgRateRtg.
-- 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: NCHGRCDOBJPGRRO

CREATE VIEW N_ChgRecdObjPgRateRtg AS
SELECT
  ChangeRecordReferenceUUID,
  cast(BillOfOperationsGroup as r_plnnr preserving type) AS BillOfOperationsGroup,
  BillOfOperationsType,
  cast(BillOfOperationsVariant as r_plnal preserving type) AS BillOfOperationsVariant,
  ChangeRecordItemProcgStatus,
  _ChangeRecordTP.ChangeRecordType AS ChangeRecordType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ParentChangeRecordRefUUID,
  ChangeRecordItemRelevance,
  _ChangeRecordTP.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  ChangeRecordReference,
  CreatedByUser,
  CreationDateTime,
  LastChangeDateTime
FROM I_ChgRecdRateRtgTskListBsc AS ReferenceRateRtgBsc
LEFT OUTER JOIN C_ChgRecdRefRateRtgTskListVH AS _RefRateRtgVH ON BillOfOperationsType = _RefRateRtgVH.BillOfOperationsType AND BillOfOperationsGroup = _RefRateRtgVH.BillOfOperationsGroup AND BillOfOperationsVariant = _RefRateRtgVH.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_ChangeRecordDraftTP AS _ChangeRecordTP ON ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN E_ChgRecdRefRateRtgTskListBsc AS _RefRateRtgExtension ON ChangeRecordReferenceUUID = _RefRateRtgExtension.ChangeRecordReferenceUUID  -- association [0..1]
LEFT OUTER JOIN C_ChgRecdItmRlvnceRateRtgVH AS _ChangeRecordItemRelVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelVH.ChangeRecordType AND ( ChangeRecordReferenceType = _ChangeRecordItemRelVH.ChangeRecordReferenceType OR _ChangeRecordItemRelVH.ChangeRecordReferenceType = ' ' )  -- association [1..1]
;