P_SchedgAgrmtItemHistory

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 P_SchedgAgrmtItemHistory.
-- 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.
-- SQL view name: PSCAGTITMHIS
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW P_SchedgAgrmtItemHistory AS
SELECT
  SchedulingAgreementItem.SchedulingAgreement AS SchedulingAgreement,
  SchedulingAgreementItem.SchedulingAgreementItem AS SchedulingAgreementItem,
  Supplier,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingDocumentType,
  PurchasingDocumentCategory,
  Plant,
  StorageLocation,
  MaterialGroup,
  Material,
  NetPriceAmount,
  NetPriceQuantity,
  OrderQuantityUnit,
  cast(SchedulingAgreementItem.ScheduleLineOrderQuantity as mm_schedg_agrmt_target_qty ) AS ScheduleLineOrderQuantity,
  PurchasingDocumentOrderDate,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  ProductType,
  MaterialType,
  TargetQuantity,
  cast( $parameters.P_DisplayCurrency as displaycurrency) AS DisplayCurrency,
  cast(TargetAmount as mm_a_target_amount) AS TargetAmount,
  cast( SchedulingAgreementItem.ScheduleLineOrderQuantity * NetPriceAmount as mm_a_released_amt ) AS SchedulingAgreementSpend,
  cast( GoodsReceiptAmountInDspCrcy as mm_goods_receipt_amount ) AS GoodsReceiptAmountInDspCrcy,
  cast( InvoiceAmtInDisplayCurrency as mm_pur_ana_de_invoice_amount ) AS InvoiceAmtInDisplayCurrency,
  cast( GoodsReceiptQuantity as mm_schedg_agrmt_goods_receipt ) AS GoodsReceiptQuantity,
  cast (InvoiceReceiptQty as abap.quan(13, 3) ) AS InvoiceReceiptQty,
  _DueDelivQty.SchedgAgrmtItmDueDeliveryQty AS SchedgAgrmtItmDueDeliveryQty,
  _OverdueQty.SchedgAgrmtItmOverdueQty AS SchedgAgrmtItmOverdueQty,
  _DelivSchedule.ScheduleLineOrderQuantity AS SchedgAgrmtItmNextDelivQty,
  _DelivSchedule.ScheduleLineDeliveryDate AS NextDeliveryDate
FROM P_SchedgAgrmtItemHistory1
LEFT OUTER JOIN P_SchedAgrmtDelivSchedule AS _DelivSchedule ON _DelivSchedule.SchedulingAgreement = SchedulingAgreementItem.SchedulingAgreement AND _DelivSchedule.SchedulingAgreementItem = SchedulingAgreementItem.SchedulingAgreementItem  -- association [0..1]
LEFT OUTER JOIN P_SchedAgrmtOverdueQtyCalc AS _OverdueQty ON _OverdueQty.SchedulingAgreement = SchedulingAgreementItem.SchedulingAgreement AND _OverdueQty.SchedulingAgreementItem = SchedulingAgreementItem.SchedulingAgreementItem  -- association [0..1]
LEFT OUTER JOIN P_SchedAgrmtDueDelivQtyCalc AS _DueDelivQty ON _DueDelivQty.SchedulingAgreement = SchedulingAgreementItem.SchedulingAgreement AND _DueDelivQty.SchedulingAgreementItem = SchedulingAgreementItem.SchedulingAgreementItem  -- association [0..1]
LEFT OUTER JOIN I_ProcmtDelivSchedDate AS _NextDeliveryDateText ON SchedgAgreementItemNextRelDate = _NextDeliveryDateText.PlannedDeliveryDuration  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtOverdueDelivSts AS _DeliveryStatusText ON SchedAgrmtItemIsOverdue = _DeliveryStatusText.SchedAgrmtItemIsOverdue  -- association [0..1]
LEFT OUTER JOIN I_ProcmtApprovalStsWthDelivDte AS _ApprovalStatusText ON SchedAgrmtItmInApprvlSts = _ApprovalStatusText.SchedAgrmtItmInApprvlSts  -- association [0..1]
LEFT OUTER JOIN I_PurContrValidityText AS _ValidityStatusText ON SchedAgrmtValidityStatus = _ValidityStatusText.PurchaseContractValidityStatus AND _ValidityStatusText.Language = $session.system_language  -- association [0..1]
;