N_ChangeRecordObjPgPurOrd

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_ChangeRecordObjPgPurOrd.
-- 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: NCHGRECREFPPU

CREATE VIEW N_ChangeRecordObjPgPurOrd AS
SELECT
  ChangeRecordReferenceUUID,
  PurOrder.PurchaseOrder AS PurchaseOrder,
  _PurchaseOrderVH.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrderVH.Supplier AS Supplier,
  _PurchaseOrderVH.SupplyingPlant AS SupplyingPlant,
  _PurchaseOrderVH.PurchaseOrderDate AS PurchaseOrderDate,
  _PurchaseOrderVH.PurchaseContract AS PurchaseContract,
  _PurchaseOrderVH.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderVH.PurchasingOrganization AS PurchasingOrganization,
  _ChangeRecordObjPg.ChangeRecordType AS ChangeRecordType,
  reference_puo.ChangeRecordUUID AS ChangeRecordUUID,
  reference_puo.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_puo.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_puo.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_puo.ChangeRecordReference AS ChangeRecordReference,
  reference_puo.CreatedByUser AS CreatedByUser,
  reference_puo.CreationDateTime AS CreationDateTime,
  cast( '00000000' as /plmb/created_on ) AS CreationDate,
  LastChangedByUser,
  reference_puo.LastChangeDateTime AS LastChangeDateTime,
  cast( '00000000' as /plmb/changed_on ) AS LastChangeDate
FROM I_ChgRecdRefPurOrdBsc AS reference_puo
LEFT OUTER JOIN I_PurchaseOrder AS PurOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrderVH ON PurchaseOrder = _PurchaseOrderVH.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchaseOrderTypeText ON PurchaseOrderType = _PurchaseOrderTypeText.PurchasingDocumentType AND _PurchaseOrderTypeText.PurchasingDocumentCategory = 'F'  -- association [1..*]
LEFT OUTER JOIN I_Plant AS _Plant ON SupplyingPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordItemRelPurVH AS _ChangeRecordItemRelVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelVH.ChangeRecordType AND ( ChangeRecordReferenceType = _ChangeRecordItemRelVH.ChangeRecordReferenceType OR _ChangeRecordItemRelVH.ChangeRecordReferenceType = ' ' )  -- association [1..1]
;