What is C_ContrLatestReleaseValueHelp in SAP S/4HANA?

C_ContrLatestReleaseValueHelp is a consumption CDS view in SAP S/4HANA. Contract Latest Release Value Help It contains 11 fields.

Which tables does C_ContrLatestReleaseValueHelp read from?

C_ContrLatestReleaseValueHelp reads data from: P_PurContrLatestRelease.

What VDM layer is C_ContrLatestReleaseValueHelp?

C_ContrLatestReleaseValueHelp is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ContrLatestReleaseValueHelp

DDL: C_CONTRLATESTRELEASEVALUEHELP SQL: CMMPCLAREL_VH Type: view CONSUMPTION

11 Fields 1 Data Sources

Contract Latest Release Value Help

C_ContrLatestReleaseValueHelp is a Consumption CDS View that provides data about "Contract Latest Release Value Help" in SAP S/4HANA. It reads from 1 data source (P_PurContrLatestRelease) and exposes 11 fields with key fields PurchaseContract, PurchaseContractItem.

Data Sources (1)

Source	Alias	Join Type
P_PurContrLatestRelease	P_PurContrLatestRelease	from

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CMMPCLAREL_VH	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Contract Latest Release Value Help	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.status	#DEPRECATED	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (11)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseContract	P_PurContrLatestRelease	PurchaseContract	Purchasing Doc.
KEY	PurchaseContractItem	P_PurContrLatestRelease	PurchaseContractItem	Item
	ReleaseOrderDate	P_PurContrLatestRelease	ReleaseOrderDate	PO Date
	PurContrLatestRelease	P_PurContrLatestRelease	PurContrLatestRelease
	PurContrLatestReleaseName	_ReleaseText	PurContrLatestReleaseName
	NumberOfContractItems
	PurchaseContractType		PurchaseContractType	Order Type
	PurchasingOrganization		PurchasingOrganization	Purchasing Organization
	PurchasingGroup		PurchasingGroup	Purchasing Group
	Plant		Plant	Valuation Area
	_ReleaseText		_ReleaseText

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 C_ContrLatestReleaseValueHelp.
-- 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: CMMPCLAREL_VH

CREATE VIEW C_ContrLatestReleaseValueHelp AS
SELECT
  P_PurContrLatestRelease.PurchaseContract AS PurchaseContract,
  P_PurContrLatestRelease.PurchaseContractItem AS PurchaseContractItem,
  P_PurContrLatestRelease.ReleaseOrderDate AS ReleaseOrderDate,
  P_PurContrLatestRelease.PurContrLatestRelease AS PurContrLatestRelease,
  _ReleaseText.PurContrLatestReleaseName AS PurContrLatestReleaseName,
  cast( 1 as mm_a_contractitems ) AS NumberOfContractItems,
  PurchaseContractType,
  PurchasingOrganization,
  PurchasingGroup,
  Plant
FROM P_PurContrLatestRelease
;

Depth:

C_ContrLatestReleaseValueHelp view

P_PurContrLatestRelease view