I_OIL_ExchPurchaseContract

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_OIL_ExchPurchaseContract.
-- 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_OIL_ExchPurchaseContract AS
SELECT
  exgnum AS ExchangeAgreement,
  ebeln AS PurchasingDocument,
  bstyp AS PurchasingDocumentCategory,
  bsart AS PurchasingDocumentType,
  reorg AS ReorganizationProgramDate,
  lvorm AS IndicatorIsRecordDeleted,
  ekorg AS PurchasingOrganization,
  text AS PurchaseContractText,
  erdat AS CreationDate,
  ertim AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aetim AS ChangedTime,
  aenam AS LastChangeByUser
FROM oia03
LEFT OUTER JOIN I_OIL_ExchangeAgreement AS _ExchangeAgreement ON _ExchangeAgreement.ExchangeAgreement = ExchangeAgreement  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON _PurchasingDocument.PurchasingDocument = PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON _PurchasingDocumentType.PurchasingDocumentCategory = PurchasingDocumentCategory AND _PurchasingDocumentType.PurchasingDocumentType = PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_OIL_PurDocumentCategoryVH AS _PurDocumentCategoryVH ON _PurDocumentCategoryVH.PurchasingDocumentCategory = PurchasingDocumentCategory  -- association [1..1]
;