P_Ctr_Consumed_Value

DDL: P_CTR_CONSUMED_VALUE SQL: PCTRCONVAL Type: view COMPOSITE Package: ODATA_MM_OA_MAINTAIN
12 Fields 1 Data Sources

P View For Calculation of Consumed Value

P_Ctr_Consumed_Value is a Composite CDS View that provides data about "P View For Calculation of Consumed Value" in SAP S/4HANA. It reads from 1 data source (P_Contract_Curr_Conv) and exposes 12 fields with key field PurchaseContract. Part of development package ODATA_MM_OA_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
P_Contract_Curr_Conv P_Contract_Curr_Conv from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PCTRCONVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
ConsumedAmountForValue
ConsumedAmountForQuantity
TargetAmount TargetAmount Target Value
PurchaseContractTargetAmount PurchaseContractTargetAmount Target Value
PurchaseContractClassification PurchaseContractClassification
PurchaseContractType PurchaseContractType Order Type
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
CreatedByUser CreatedByUser User Name

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_Ctr_Consumed_Value.
-- 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: PCTRCONVAL

CREATE VIEW P_Ctr_Consumed_Value AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  sum(ReleaseOrderItemNetAmount) AS ConsumedAmountForValue,
  sum(ReleaseOrderItemNetAmount) AS ConsumedAmountForQuantity,
  TargetAmount,
  PurchaseContractTargetAmount,
  PurchaseContractClassification,
  PurchaseContractType,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingDocumentCategory,
  CreatedByUser
FROM P_Contract_Curr_Conv
;

Learn More