P_ContrWithRelevantValidity

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_ContrWithRelevantValidity.
-- 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: PCRELVAL

CREATE VIEW P_ContrWithRelevantValidity AS
SELECT
  _PurchaseContractItem.PurchaseContract AS PurchaseContract,
  _PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseContractItem._PurchaseContractHistory.ReleaseOrder AS ReleaseOrder,
  _PurchaseContractItem._PurchaseContractHistory.ReleaseOrderItem AS ReleaseOrderItem,
  _PurchaseContractItem.PurchasingObjectCategory AS Purchasingdocumentcategory,
  _PurchaseContractItem.PurchaseContractType AS PurchaseContractType,
  _PurchaseContractItem.DocumentCurrency AS DocumentCurrency,
  _PurchaseContractItem.OutlineAgreementTargetAmount AS PurchaseContractTargetAmount,
  _PurchaseContractItem._PurchaseContractHistory.ReleaseOrderItemOrderQuantity AS ReleaseOrderItemOrderQuantity,
  _PurContractClassification.PurchaseContractClassification AS PurchaseContractClassification,
  _PurchaseContractItem.TargetQuantity AS TargetQuantity,
  _PurchaseContractItem.TargetAmount AS TargetAmount,
  _PurchaseContractItem.DocumentCurrency AS ReleaseOrderCurrency,
  cast( currency_conversion ( amount => _PurchaseContractItem._PurchaseContractHistory.ReleaseOrderItemNetAmount, source_currency => _PurchaseContractItem._PurchaseContractHistory.ReleaseOrderCurrency, target_currency => _PurchaseContractItem.DocumentCurrency, exchange_rate_date => _PurchaseContractItem._PurchaseContractHistory.ReleaseOrderItemLastChgDate, exchange_rate_type => 'M', error_handling => 'SET_TO_NULL' ) as abap.curr( 28, 3 ) ) as ReleaseOrderItemNetAmount AS curr283asReleaseOrderItemNetAmount,
  _PurchaseContractItem._PurchaseContractHistory.ReleaseOrderItemIsDeleted AS ReleaseOrderItemIsDeleted,
  _PurchaseContractItem._PurchaseContractHistory.ReleaseOrderItemLastChgDate AS ReleaseOrderItemLastChgDate,
  _PurchaseContractItem._PurchaseContractHistory.ReleaseOrderItemQuantityUnit AS ReleaseOrderItemQuantityUnit,
  _PurchaseContractItem.PurchaseContractCreatedByUser AS CreatedByUser,
  _PurchaseContractItem.PurContrValidityStartDate AS ValidityStartDate,
  dats_days_between(cast( substring( cast( tstmp_current_utctimestamp() as abap.char(17) ), 1, 8 ) as abap.dats), _PurchaseContractItem.PurContrValidityStartDate) AS PurContrValidityDateDifference,
  3650 AS Max_notexpired,
  0 AS Min_expired,
  _PurchaseContractItem.PurchasingGroup AS PurchasingGroup,
  _PurchaseContractItem.ActivePurchasingDocument AS ActivePurchasingDocument
FROM I_PurchaseContractItem AS _PurchaseContractItem
LEFT OUTER JOIN I_PurchaseContractHistory AS _PurchaseContractHistory ON PurchaseContract = _PurchaseContractHistory.PurchaseContract AND PurchaseContractItem = _PurchaseContractHistory.PurchaseContractItem AND _PurchaseContractHistory.ReleaseOrderItemIsDeleted = ''  -- association [1..*]
;