P_PurContractItemConsumption

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_PurContractItemConsumption.
-- 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: PMMCONTRCNSMPN
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW P_PurContractItemConsumption AS
SELECT
  PurchaseContractHistory.PurchaseContract AS PurchaseContract,
  PurchaseContractHistory.PurchaseContractItem AS PurchaseContractItem,
  ReleaseOrder,
  ReleaseOrderItem,
  ContractClassification.PurchaseContractClassification AS PurchaseContractClassification,
  PurchaseContract.DocumentCurrency AS DocumentCurrency,
  OrderQuantityUnit,
  ReleaseOrderDate,
  CalendarDate.CalendarMonth AS CalendarMonth,
  CalendarDate.CalendarQuarter AS CalendarQuarter,
  CalendarDate.CalendarWeek AS CalendarWeek,
  CalendarDate.CalendarYear AS CalendarYear,
  PurchaseContract.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  TargetQuantity,
  cast( unit_conversion ( quantity => ReleaseOrderItemOrderQuantity, source_unit => ReleaseOrderItemQuantityUnit, target_unit => PurchaseContractItem.OrderQuantityUnit, error_handling => 'KEEP_UNCONVERTED' ) as abap.quan( 13, 0 ) ) as ReleaseOrderItemOrderQuantity AS quan130asReleaseOrderItemOrderQuantity,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  cast( 1 as mm_number_release_order) AS NumberOfReleasedOrders,
  PurchaseContractHistory.Plant AS Plant,
  PurchaseContractHistory.PurchasingOrganization AS PurchasingOrganization,
  PurchaseContractHistory.CompanyCode AS CompanyCode,
  PurchaseContract.PurchasingGroup AS PurchasingGroup
FROM I_PurchaseContractHistory AS PurchaseContractHistory
INNER JOIN I_PurchaseContract AS PurchaseContract ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurContractClassification AS ContractClassification ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseContractItem AS PurchaseContractItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS CalendarDate ON /* join condition not captured in parsed metadata */
;