P_Comonavg_Relconrate_Base

DDL: P_COMONAVG_RELCONRATE_BASE SQL: PCOMONRELCBASE Type: view COMPOSITE Package: ODATA_PRC_OVP
9 Fields 2 Data Sources

Basic view for contract avegare rate

P_Comonavg_Relconrate_Base is a Composite CDS View that provides data about "Basic view for contract avegare rate" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseContract, I_PurchaseContractHistory) and exposes 9 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem. Part of development package ODATA_PRC_OVP.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseContract _PurchaseContract inner
I_PurchaseContractHistory PurchaseContractHistory from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCOMONRELCBASE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractHistory PurchaseContract Purchasing Doc.
KEY PurchaseContractItem I_PurchaseContractHistory PurchaseContractItem Item
KEY ReleaseOrder I_PurchaseContractHistory ReleaseOrder Purchasing Doc.
KEY ReleaseOrderItem I_PurchaseContractHistory ReleaseOrderItem Item
ReleaseOrderItemOrderQuantity I_PurchaseContractHistory ReleaseOrderItemOrderQuantity PO Quantity
ReleaseOrderItemQuantityUnit I_PurchaseContractHistory ReleaseOrderItemQuantityUnit Order Unit
ReleaseOrderCurrency I_PurchaseContractHistory ReleaseOrderCurrency Currency
ReleaseOrderDate
ReleaseOrderItemLastChgDate Changed On

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_Comonavg_Relconrate_Base.
-- 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: PCOMONRELCBASE

CREATE VIEW P_Comonavg_Relconrate_Base AS
SELECT
  PurchaseContractHistory.PurchaseContract AS PurchaseContract,
  PurchaseContractHistory.PurchaseContractItem AS PurchaseContractItem,
  PurchaseContractHistory.ReleaseOrder AS ReleaseOrder,
  PurchaseContractHistory.ReleaseOrderItem AS ReleaseOrderItem,
  PurchaseContractHistory.ReleaseOrderItemOrderQuantity AS ReleaseOrderItemOrderQuantity,
  PurchaseContractHistory.ReleaseOrderItemQuantityUnit AS ReleaseOrderItemQuantityUnit,
  PurchaseContractHistory.ReleaseOrderCurrency AS ReleaseOrderCurrency,
  cast(PurchaseContractHistory.ReleaseOrderDate as bedat) AS ReleaseOrderDate,
  cast(ReleaseOrderItemLastChgDate as aedat) AS ReleaseOrderItemLastChgDate
FROM I_PurchaseContractHistory AS PurchaseContractHistory
INNER JOIN I_PurchaseContract AS _PurchaseContract ON /* join condition not captured in parsed metadata */
;

Learn More