I_PPS_PurReqnItmExtensionBasic

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_PurReqnItmExtensionBasic.
-- 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_PurReqnItmExtensionBasic AS
SELECT
  banfn AS PurchaseRequisition,
  bnfpo AS PurchaseRequisitionItem,
  pps_perop_beg AS PPSPerdOfPerfStartDate,
  pps_perop_end AS PPSPerdOfPerfEndDate,
  pps_itm_smart_number AS PPSSmartNumberItem,
  pps_itm_is_smart_number_manual AS PPSSmartNumberItemIsManual,
  pps_config_item_no AS PPSConfigurableLineItemNumber,
  pps_itm_is_optional AS PPSIsOptionalItem,
  pps_itm_opt_exer_start_date AS PPSOptionExerciseStartDate,
  pps_itm_opt_exer_end_date AS PPSOptionExerciseEndDate,
  pps_estimated_delivery_date AS PPSEstimatedDeliveryDate,
  pps_itm_cmpltn_sts AS PPSPurReqnItemCompletionStatus,
  pps_itm_procg_status AS PPSPurReqnItemProcessingStatus,
  pps_itm_responsible_purchaser AS PPSResponsiblePurchaser,
  pps_itm_srcg_typ AS PPSPurReqnSourcingType,
  pps_itm_approval_date AS PPSPurReqnItemApprovalDate,
  pps_item_status AS PPSPurReqnItemStatus,
  pps_item_status_int AS PPSPurReqnItemStatusInternal,
  pps_itm_earmarked_funds_doc AS PPSEarmarkedFundsDocument,
  pps_itm_is_incremental AS PPSIsIncrementalFundedItem,
  pps_hdr_purreqn_key AS PPSPurchaseRequisitionKey,
  pps_itm_purreqnitm_key AS PPSPurchaseRequisitionItemKey,
  pps_itm_fiscalyear AS PPSFiscalYear,
  pps_itm_doblgn_sts AS PPSPurgDocItmDoblgnStatus,
  pps_itm_appl_loghandle AS PPSAutoSourcingLogHandle,
  pps_itm_isfullyfunded AS PPSItemIsFullyFunded,
  pps_optionalitemstatus AS PPSOptionalItemStatus,
  pps_purgdoc_delv_addr_type AS PurchasingDeliveryAddressType,
  pps_item_process_type AS PPSItemProcessType
FROM pps_eban_ext
;