P_PurchaseContractleakage1

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_PurchaseContractleakage1.
-- 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: PMMCONTRLEAKAGE1
-- Parameters: P_DisplayCurrency : displaycurrency, P_Date : sydate, P_EvaluationTimeFrameInDays : mm_a_evaluation_period

CREATE VIEW P_PurchaseContractleakage1 AS
SELECT
  PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.CompanyCode AS CompanyCode,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  PurchaseOrderItem.PurchaseContract AS PurchaseOutlineAgreement,
  PurchaseOrderItem.ProfitCenter AS ProfitCenter,
  PurchaseOrderItem.OrderPriceUnit AS OrderPriceUnit,
  PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _Calendar.CalendarYear AS CalendarYear,
  _Calendar.YearQuarter AS YearQuarter,
  _Calendar.YearMonth AS YearMonth,
  _Calendar.YearWeek AS YearWeek,
  cast(currency_conversion( amount => PurchaseOrderItem.NetAmount, source_currency => PurchaseOrderItem.DocumentCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => PurchaseOrderItem._PurchaseOrder.PurchaseOrderDate, exchange_rate_type => 'M', error_handling => 'FAIL_ON_ERROR' )as abap.dec( 17, 5 )) as PurchaseOrderNetAmount AS dec175asPurchaseOrderNetAmount
FROM I_PurchaseOrderItem AS PurchaseOrderItem
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
INNER JOIN P_RelevantDates ON /* join condition not captured in parsed metadata */
;