What is C_CmmdtyHdgTgtQuotaPositionTP in SAP S/4HANA?

C_CmmdtyHdgTgtQuotaPositionTP is a consumption CDS view in SAP S/4HANA. Commodity Hedge Target Quota Position It contains 23 fields.

Which tables does C_CmmdtyHdgTgtQuotaPositionTP read from?

C_CmmdtyHdgTgtQuotaPositionTP reads data from: R_CmmdtyHdgTgtQuotaPositionTP.

What VDM layer is C_CmmdtyHdgTgtQuotaPositionTP?

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

C_CmmdtyHdgTgtQuotaPositionTP

DDL: C_CMMDTYHDGTGTQUOTAPOSITIONTP Type: view_entity CONSUMPTION

23 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Commodity Hedge Target Quota Position

C_CmmdtyHdgTgtQuotaPositionTP is a Consumption CDS View that provides data about "Commodity Hedge Target Quota Position" in SAP S/4HANA. It reads from 1 data source (R_CmmdtyHdgTgtQuotaPositionTP) and exposes 23 fields with key fields CmmdtyHedgeTargetQuotaUUID, CmmdtyHdgTgtQuotaPositionYear, CmmdtyHdgTgtQuotaPositionUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_CMMDTYHDGTARGETQUOTA). It is used in 1 Fiori application: Manage Target Quotas.

Data Sources (1)

Source	Alias	Join Type
R_CmmdtyHdgTgtQuotaPositionTP	R_CmmdtyHdgTgtQuotaPositionTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	C_CmmdtyHdgTgtQtaPosVersion	_PosVersion	`$projection.CmmdtyHedgeTargetQuotaUUID = _PosVersion.CmmdtyHedgeTargetQuotaUUID and $projection.CmmdtyHdgTgtQuotaPositionYear = _PosVersion.CmmdtyHdgTgtQuotaPositionYear and $projection.CmmdtyHdgTgtQuotaPeriodNumber = _PosVersion.CmmdtyHdgTgtQuotaPeriodNumber`

Annotations (7)

Name	Value	Level
EndUserText.label	Commodity Hedge Target Quota Position	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_CMMDTYHDGTARGETQUOTA	UI_CMMDTYHDGTARGETQUOTA	V2	C1	NOT_RELEASED

Fiori Apps (1)

App ID	App Name	Type	Description
F5795	Manage Target Quotas	Transactional

Manage Target Quotas

Business Role: Commodity Risk Manager - Hedge Accounting

With this Fiori app (ID F5795) you define target quotas on the basis of derivative contract specifications (DCS) to support traders in making the right hedging decisions. Target quotas set a limit up to the exposures shall be hedged.

Fields (23)

Key	Field	Source Table	Source Field	Description
KEY	CmmdtyHedgeTargetQuotaUUID		CmmdtyHedgeTargetQuotaUUID
KEY	CmmdtyHdgTgtQuotaPositionYear		CmmdtyHdgTgtQuotaPositionYear
KEY	CmmdtyHdgTgtQuotaPositionUUID		CmmdtyHdgTgtQuotaPositionUUID
	CmmdtyHdgTgtQtaPosValdDateTime		CmmdtyHdgTgtQtaPosValdDateTime
	CmmdtyHdgTgtQtaPosPerdCatText	_PrdCat	CmmdtyHdgTgtQtaPosPerdCatText
	CmmdtyHdgTgtQtaPosPerdCategory	_PrdCat	CmmdtyHdgTgtQtaPosPerdCategory
	CmmdtyHdgTgtQuotaPeriodClass		CmmdtyHdgTgtQuotaPeriodClass
	PlngDataDeliveryCategoryText		PlngDataDeliveryCategoryText
	CmmdtyHdgTgtQuotaPeriodNumber		CmmdtyHdgTgtQuotaPeriodNumber
	CmmdtyHdgTgtQtaYrPeriodNumber		CmmdtyHdgTgtQtaYrPeriodNumber
	CommodityHedgePercentageUnit		CommodityHedgePercentageUnit
	CmmdtyHdgTgtQtaUprLmtInPercent		CmmdtyHdgTgtQtaUprLmtInPercent
	CmmdtyHdgAcctgUprLmtInPercent		CmmdtyHdgAcctgUprLmtInPercent
	CommodityHedgeRemarkNote		CommodityHedgeRemarkNote
	IsActive		IsActive	Object active?
	CmmdtyHdgTgtQtaPosCrtedByUser		CmmdtyHdgTgtQtaPosCrtedByUser
	CmmdtyHdgTgtQtaPosCrtnUserText		CmmdtyHdgTgtQtaPosCrtnUserText
	CmmdtyHdgTgtQtaPosCrtnDateTime		CmmdtyHdgTgtQtaPosCrtnDateTime
	CmmdtyHdgTgtQtaPosChgdByUser		CmmdtyHdgTgtQtaPosChgdByUser
	CmmdtyHdgTgtQtaPosChgdByUsrTxt		CmmdtyHdgTgtQtaPosChgdByUsrTxt
	CmmdtyHdgTgtQtaPosChgDateTime		CmmdtyHdgTgtQtaPosChgDateTime
	CmmdtyHdgTargetQuotaIsSelected		CmmdtyHdgTargetQuotaIsSelected
	_PosVersion		_PosVersion

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_CmmdtyHdgTgtQuotaPositionTP.
-- 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.

CREATE VIEW C_CmmdtyHdgTgtQuotaPositionTP AS
SELECT
  CmmdtyHedgeTargetQuotaUUID,
  CmmdtyHdgTgtQuotaPositionYear,
  CmmdtyHdgTgtQuotaPositionUUID,
  CmmdtyHdgTgtQtaPosValdDateTime,
  _PrdCat.CmmdtyHdgTgtQtaPosPerdCatText AS CmmdtyHdgTgtQtaPosPerdCatText,
  _PrdCat.CmmdtyHdgTgtQtaPosPerdCategory AS CmmdtyHdgTgtQtaPosPerdCategory,
  CmmdtyHdgTgtQuotaPeriodClass,
  PlngDataDeliveryCategoryText,
  CmmdtyHdgTgtQuotaPeriodNumber,
  CmmdtyHdgTgtQtaYrPeriodNumber,
  CommodityHedgePercentageUnit,
  CmmdtyHdgTgtQtaUprLmtInPercent,
  CmmdtyHdgAcctgUprLmtInPercent,
  CommodityHedgeRemarkNote,
  IsActive,
  CmmdtyHdgTgtQtaPosCrtedByUser,
  CmmdtyHdgTgtQtaPosCrtnUserText,
  CmmdtyHdgTgtQtaPosCrtnDateTime,
  CmmdtyHdgTgtQtaPosChgdByUser,
  CmmdtyHdgTgtQtaPosChgdByUsrTxt,
  CmmdtyHdgTgtQtaPosChgDateTime,
  CmmdtyHdgTargetQuotaIsSelected
FROM R_CmmdtyHdgTgtQuotaPositionTP
LEFT OUTER JOIN C_CmmdtyHdgTgtQtaPosVersion AS _PosVersion ON CmmdtyHedgeTargetQuotaUUID = _PosVersion.CmmdtyHedgeTargetQuotaUUID AND CmmdtyHdgTgtQuotaPositionYear = _PosVersion.CmmdtyHdgTgtQuotaPositionYear AND CmmdtyHdgTgtQuotaPeriodNumber = _PosVersion.CmmdtyHdgTgtQuotaPeriodNumber  -- association [0..*]
;

Depth:

C_CmmdtyHdgTgtQuotaPositionTP view_entity

R_CmmdtyHdgTgtQuotaPositionTP view_entity