I_PPS_PurchaseReqnSOSContract

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_PPS_PurchaseReqnSOSContract.
-- 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_PPS_PurchaseReqnSOSContract AS
SELECT
  _PurchaseContractItem.PurchaseContract AS PurchaseContract,
  _PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseContractHdr.PurchasingDocumentName AS PurchasingDocumentName,
  _PurchaseContractItem.PurchaseOrderItemText AS PurchaseContractItemText,
  _PurchaseContractHdr.Supplier AS Supplier,
  _PurchaseContractItem.Material AS Material,
  _PurchaseContractItem.MaterialGroup AS MaterialGroup,
  _PurchaseContractItem.NetPriceAmount AS ContractNetPriceAmount,
  _PurchaseContractHdr.DocumentCurrency AS DocumentCurrency,
  _PurchaseContractHdr.ValidityStartDate AS ValidityStartDate,
  _PurchaseContractHdr.ValidityEndDate AS ValidityEndDate,
  _PurchaseContractHdr.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseContractHdr.PurchasingGroup AS PurchasingGroup,
  _PurchaseContractHdr.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _PurchaseContractHdr.PurchasingDocumentType AS PurchaseContractType,
  _PurchaseContractHdr.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _PurchaseContractHdr.CompanyCode AS CompanyCode,
  _PurchaseContractItem.Plant AS Plant,
  cast(_PurchaseContractHdr.PurchaseContract as vdm_purchasecontract preserving type) AS PPSRootPurchaseContract,
  cast(_PurchaseContractHdr.PurchasingDocumentType as pps_e_eps_doc_type preserving type) AS PurchasingDocumentType,
  cast(_PurchaseContractHdr.PurchasingDocumentCategory as pps_e_novation_doc_cat preserving type) AS PurchasingDocumentCategory,
  _PurchaseContractHdr.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  _PurchaseContractItemExtension.PPSIsOptionalItem AS PPSIsOptionalItem,
  _PurchaseContractItemExtension.PPSOptionalItemStatus AS PPSOptionalItemStatus,
  _PurchaseContractItemExtension.PPSPerdOfPerfStartDate AS PPSPerdOfPerfStartDate,
  _PurchaseContractItemExtension.PPSPerdOfPerfEndDate AS PPSPerdOfPerfEndDate,
  _PurchaseContractItem.PurchaseContractCategory AS PurchaseContractCategory,
  _PurchaseContractHdr.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  _PurchaseContractItem._PurchaseContract AS _PurchaseContract,
  _PurchaseContractHdr._Extension AS _Extension,
  _PurchaseContractItem._PurchasingDocument AS _PurchasingDocument
FROM I_PPS_PurchaseContractItem AS _PurchaseContractItem
INNER JOIN I_PPS_PurchaseContract AS _PurchaseContractHdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingDocumentType AS _PPSPurgDocType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPS_PurgDocItemExtension AS _PurchaseContractItemExtension ON _PurchaseContractItem.PurchaseContract = _PurchaseContractItemExtension.PurchasingDocument AND _PurchaseContractItem.PurchaseContractItem = _PurchaseContractItemExtension.PurchasingDocumentItem  -- association [1..1]
;