P_Contract_Curr_Conv

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_Contract_Curr_Conv.
-- 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: PCTRCURRCONV

CREATE VIEW P_Contract_Curr_Conv AS
SELECT
  _PurchaseContract.PurchaseContract AS PurchaseContract,
  _PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseContractHistory.ReleaseOrder AS ReleaseOrder,
  _PurchaseContractHistory.ReleaseOrderItem AS ReleaseOrderItem,
  _PurchaseContract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchaseContract.PurchaseContractType AS PurchaseContractType,
  _PurchaseContract.DocumentCurrency AS DocumentCurrency,
  _PurchaseContract.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  _PurchaseContractHistory.ReleaseOrderItemOrderQuantity AS ReleaseOrderItemOrderQuantity,
  _PurContractClassification.PurchaseContractClassification AS PurchaseContractClassification,
  TargetAmount,
  _PurchaseContract.DocumentCurrency AS ReleaseOrderCurrency,
  cast( currency_conversion ( amount => _PurchaseContractHistory.ReleaseOrderItemNetAmount, source_currency => _PurchaseContractHistory.ReleaseOrderCurrency, target_currency => _PurchaseContract.DocumentCurrency, exchange_rate_date => _PurchaseContractHistory.ReleaseOrderItemLastChgDate, exchange_rate_type => 'M', error_handling => 'FAIL_ON_ERROR' ) as abap.curr( 28, 3 ) ) as ReleaseOrderItemNetAmount AS curr283asReleaseOrderItemNetAmount,
  _PurchaseContractHistory.ReleaseOrderItemIsDeleted AS ReleaseOrderItemIsDeleted,
  _PurchaseContractHistory.ReleaseOrderItemLastChgDate AS ReleaseOrderItemLastChgDate,
  _PurchaseContractHistory.ReleaseOrderItemQuantityUnit AS ReleaseOrderItemQuantityUnit,
  ValidityStartDate,
  ValidityEndDate,
  _PurchaseContract.CreatedByUser AS CreatedByUser
FROM I_PurchaseContract AS _PurchaseContract
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseContractHistory AS _PurchaseContractHistory ON /* join condition not captured in parsed metadata */
;