R_PPS_PurContractItemExtension

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 R_PPS_PurContractItemExtension.
-- 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 R_PPS_PurContractItemExtension AS
SELECT
  ebeln AS PurchaseContract,
  ebelp AS PurchaseContractItem,
  pps_tolerance_key AS PPSDeliveryToleranceKey,
  pps_perop_beg AS PPSPerdOfPerfStartDate,
  pps_perop_end AS PPSPerdOfPerfEndDate,
  pps_isoptionalitem AS PPSIsOptionalItem,
  pps_optionalitemstatus AS PPSOptionalItemStatus,
  pps_optionexercisestartdate AS PPSOptionExerciseStartDate,
  pps_optionexerciseenddate AS PPSOptionExerciseEndDate,
  pps_itm_smart_number AS PPSSmartNumberItem,
  pps_itm_is_smart_number_manual AS PPSSmartNumberItemIsManual,
  pps_config_item_no AS PPSConfigurableLineItemNumber,
  pps_item_status AS PPSPurContrItemStatus,
  _OptionalItemStatusText.PPSOptionalItemStatusText AS PPSOptionalItemStatusText,
  pps_document_currency AS DocumentCurrency,
  pps_arrangement_id AS PPSPricingArrangementType,
  pps_ceiling_amount AS PPSCeilingAmount,
  pps_maximum_fee AS PPSMaximumFee,
  pps_minimum_fee AS PPSMinimumFee,
  pps_gov_share_above AS PPSGovtShareAbovePercent,
  pps_gov_share_below AS PPSGovtShareBelowPercent,
  pps_is_direct_oitem AS PPSIsDirectOrderItem,
  pps_is_pa_childitem AS PPSIsPrcgArrgmtChildItm,
  pps_pa_component_type AS PPSPrcgArrgmtCompType,
  pps_itm_responsible_purchaser AS PPSResponsiblePurchaser,
  pps_unit AS PPSMinimumOrderQuantityUnit,
  pps_min_ord_qty AS PPSMinimumOrderQuantity,
  pps_min_ord_val AS PPSMinimumOrderAmount,
  pps_rel_ord_qty AS PPSReleaseOrderQuantity,
  pps_pc_itm_down_payment_flag AS PPSPurContrItmHasDwnPaytInAmt,
  PPSSourceSrcgProjectQuotation,
  PPSSourceSrcgProjQuotationItem,
  pps_consqty_item AS ContractConsumptionInPct,
  pps_pur_doc_itm_key AS PPSPurchaseContractItemKey,
  pps_direct_purorderitm AS PPSDirectPurchaseOrderItem,
  pps_item_process_type AS PPSItemProcessType
FROM pps_ekpo_ext
LEFT OUTER JOIN I_PPS_OptionalItemStatusVH AS _OptionalItemStatusText ON PPSOptionalItemStatus = _OptionalItemStatusText.DomainValueLow  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurgDocItemStatusText AS _ItemStatusText ON PPSPurContrItemStatus = _ItemStatusText.DomainValue  -- association [1..*]
LEFT OUTER JOIN I_PPS_PurgDocToleranceText AS _ToleranceText ON PPSDeliveryToleranceKey = _ToleranceText.PPSDeliveryToleranceKey  -- association [1..*]
LEFT OUTER JOIN I_PPS_PrcgArrgmtTypeVH AS _PricingArrangementType ON PPSPricingArrangementType = _PricingArrangementType.PPSPricingArrangementType  -- association [1..1]
;