P_ContractConsumedVal

DDL: P_CONTRACTCONSUMEDVAL SQL: PCTRVALCALC Type: view COMPOSITE Package: ODATA_MM_OA_MAINTAIN
6 Fields 1 Data Sources

Contract consumption value calculation

P_ContractConsumedVal is a Composite CDS View that provides data about "Contract consumption value calculation" in SAP S/4HANA. It reads from 1 data source (P_CTR_CALC_TARGETVALUE) and exposes 6 fields with key field PurchaseContract. Part of development package ODATA_MM_OA_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
P_CTR_CALC_TARGETVALUE _CTR_CALC_TARGETVALUE from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCTRVALCALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract P_CTR_CALC_TARGETVALUE PurchaseContract Purchasing Doc.
PurchaseContractType P_CTR_CALC_TARGETVALUE PurchaseContractType Order Type
PurchaseContractClassification P_CTR_CALC_TARGETVALUE PurchaseContractClassification
ValidityStartDate P_CTR_CALC_TARGETVALUE ValidityStartDate Validity Start Date
ValidityEndDate P_CTR_CALC_TARGETVALUE ValidityEndDate ValidTo
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_ContractConsumedVal.
-- 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: PCTRVALCALC

CREATE VIEW P_ContractConsumedVal AS
SELECT
  _CTR_CALC_TARGETVALUE.PurchaseContract AS PurchaseContract,
  _CTR_CALC_TARGETVALUE.PurchaseContractType AS PurchaseContractType,
  _CTR_CALC_TARGETVALUE.PurchaseContractClassification AS PurchaseContractClassification,
  _CTR_CALC_TARGETVALUE.ValidityStartDate AS ValidityStartDate,
  _CTR_CALC_TARGETVALUE.ValidityEndDate AS ValidityEndDate,
  CreatedByUser
FROM P_CTR_CALC_TARGETVALUE AS _CTR_CALC_TARGETVALUE
;

Learn More