I_MaintObjListPurchaseReqn

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 I_MaintObjListPurchaseReqn.
-- 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 I_MaintObjListPurchaseReqn AS
SELECT
  obknr AS MaintenanceObjectList,
  banfn AS PurchaseRequisition,
  bnfpo AS PurchaseRequisitionItem,
  bstyp AS PurchasingDocumentCategory,
  bsart AS PurchasingDocumentType,
  pstyp AS PurchasingDocumentItemCategory,
  werk AS Plant,
  anzsn AS NumberOfSerialNumbers,
  datum AS SerialNumberAssignmentDate
FROM ser09
LEFT OUTER JOIN I_MaintenanceObjectListItem AS _MaintenanceObjectListItem ON MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList  -- association [1..*]
LEFT OUTER JOIN I_PurchaseRequisitionAPI01 AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemAPI01 AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
;