I_PPS_PurReqnHdrExtensionBasic

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_PurReqnHdrExtensionBasic.
-- 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_PurReqnHdrExtensionBasic AS
SELECT
  banfn AS PurchaseRequisition,
  bnfpo AS PurchaseRequisitionItem,
  pps_hdr_future_posting_date AS PPSFuturePostingDate,
  pps_hdr_classification AS PPSPurgDocClassfctnCode,
  pps_hdr_smart_number AS PPSSmartNumberHeader,
  pps_hdr_is_smart_number_manual AS PPSSmartNumberHeaderIsManual,
  pps_hdr_status AS PPSPurReqnHeaderStatus,
  pps_hdr_budget_impact AS PPSBudgetImpact,
  pps_hdr_purreqn_key AS PPSPurchaseRequisitionKey,
  doc_is_pps_purchase_request AS DocumentIsPPSPurchaseRequest
FROM pps_eban_ext
;