C_CmmdtyHdgTargetQuotaDetailTP

DDL: C_CMMDTYHDGTARGETQUOTADETAILTP Type: view_entity CONSUMPTION
30 Fields 1 Data Sources 2 Associations

Commodity Hedge Target Quota

C_CmmdtyHdgTargetQuotaDetailTP is a Consumption CDS View that provides data about "Commodity Hedge Target Quota" in SAP S/4HANA. It reads from 1 data source (R_CmmdtyHdgTargetQuotaDetailTP) and exposes 30 fields with key field CmmdtyHedgeTargetQuotaUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_CmmdtyHdgTargetQuotaDetailTP R_CmmdtyHdgTargetQuotaDetailTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_CmmdtyHdgTargetQuotaVersion _TargetQtaVers $projection.CompanyCode = _TargetQtaVers.CompanyCode and $projection.DerivativeContrSpecification = _TargetQtaVers.DerivativeContrSpecification and $projection.CmmdtyHdgTargetQuotaDirection = _TargetQtaVers.CmmdtyHdgTargetQuotaDirection and $projection.CmmdtyHdgTgtQuotaPeriodClass = _TargetQtaVers.CmmdtyHdgTgtQuotaPeriodClass and $projection.CmmdtyHdgTgtQuotaHedgeBookID = _TargetQtaVers.CmmdtyHdgTgtQuotaHedgeBookID
[0..*] C_CmmdtyHedgeTargetQuotaStatus _TQStatus $projection.CmmdtyHedgeTargetQuotaUUID = _TQStatus.CmmdtyHedgeObjectDocumentUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Commodity Hedge Target Quota view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHedgeTargetQuotaUUID CmmdtyHedgeTargetQuotaUUID
CmmdtyHedgeTargetQuotaVersion CmmdtyHedgeTargetQuotaVersion
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CCText CompanyCodeName Company Name
DerivativeContrSpecification DerivativeContrSpecification DCS ID
DerivativeContrSpecName _DCSText DerivativeContrSpecName
CmmdtyHdgTargetQuotaDirection CmmdtyHdgTargetQuotaDirection
CmmdtyHdgTgtQuotaDirectionText _DircText CmmdtyHdgTgtQuotaDirectionText
CmmdtyHdgTgtQtaValdFrmDateTime CmmdtyHdgTgtQtaValdFrmDateTime
CmmdtyHdgTgtQuotaPeriodClass CmmdtyHdgTgtQuotaPeriodClass
CmmdtyHdgTgtQtaPerdLengthText _PrdClassText CmmdtyHdgTgtQtaPerdLengthText
CmmdtyHdgTgtQuotaHedgeBookID CmmdtyHdgTgtQuotaHedgeBookID
CmmdtyHedgeBookDescription CmmdtyHedgeBookDescription
CommodityHedgeRemarkNote CommodityHedgeRemarkNote
IsActive IsActive Object active?
CmmdtyHedgeTargetQuotaStatusID CmmdtyHedgeTargetQuotaStatusID
CmmdtyHdgTargetQuotaStatusText CmmdtyHdgTargetQuotaStatusText
CmmdtyHdgTargetQuotaLogHandle CmmdtyHdgTargetQuotaLogHandle
CmmdtyHdgTgtQuotaIsFullyHedged CmmdtyHdgTgtQuotaIsFullyHedged
CmmdtyHdgTgtQuotaCriticality CmmdtyHdgTgtQuotaCriticality
CmmdtyHdgTgtQuotaCreatedByUser CmmdtyHdgTgtQuotaCreatedByUser
CmmdtyHdgTgtQtaCrtedByUserText CmmdtyHdgTgtQtaCrtedByUserText
CmmdtyHdgTgtQtaCrtnDateTime CmmdtyHdgTgtQtaCrtnDateTime
CmmdtyHdgTgtQuotaChangedByUser CmmdtyHdgTgtQuotaChangedByUser
CmmdtyHdgTgtQtaChgdByUserText CmmdtyHdgTgtQtaChgdByUserText
CmmdtyHdgTgtQtaChangeDateTime CmmdtyHdgTgtQtaChangeDateTime
_DCSText _DCSText
_TargetQtaVers _TargetQtaVers
_TQStatus _TQStatus
CmmdtyHdgTgtQtaStsReasonText _tqStatusReason CmmdtyHdgTgtQtaStsReasonText

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_CmmdtyHdgTargetQuotaDetailTP.
-- 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_CmmdtyHdgTargetQuotaDetailTP AS
SELECT
  CmmdtyHedgeTargetQuotaUUID,
  CmmdtyHedgeTargetQuotaVersion,
  CompanyCode,
  _CCText.CompanyCodeName AS CompanyCodeName,
  DerivativeContrSpecification,
  _DCSText.DerivativeContrSpecName AS DerivativeContrSpecName,
  CmmdtyHdgTargetQuotaDirection,
  _DircText.CmmdtyHdgTgtQuotaDirectionText AS CmmdtyHdgTgtQuotaDirectionText,
  CmmdtyHdgTgtQtaValdFrmDateTime,
  CmmdtyHdgTgtQuotaPeriodClass,
  _PrdClassText.CmmdtyHdgTgtQtaPerdLengthText AS CmmdtyHdgTgtQtaPerdLengthText,
  CmmdtyHdgTgtQuotaHedgeBookID,
  CmmdtyHedgeBookDescription,
  CommodityHedgeRemarkNote,
  IsActive,
  CmmdtyHedgeTargetQuotaStatusID,
  CmmdtyHdgTargetQuotaStatusText,
  CmmdtyHdgTargetQuotaLogHandle,
  CmmdtyHdgTgtQuotaIsFullyHedged,
  CmmdtyHdgTgtQuotaCriticality,
  CmmdtyHdgTgtQuotaCreatedByUser,
  CmmdtyHdgTgtQtaCrtedByUserText,
  CmmdtyHdgTgtQtaCrtnDateTime,
  CmmdtyHdgTgtQuotaChangedByUser,
  CmmdtyHdgTgtQtaChgdByUserText,
  CmmdtyHdgTgtQtaChangeDateTime,
  _tqStatusReason.CmmdtyHdgTgtQtaStsReasonText AS CmmdtyHdgTgtQtaStsReasonText
FROM R_CmmdtyHdgTargetQuotaDetailTP
LEFT OUTER JOIN C_CmmdtyHdgTargetQuotaVersion AS _TargetQtaVers ON CompanyCode = _TargetQtaVers.CompanyCode AND DerivativeContrSpecification = _TargetQtaVers.DerivativeContrSpecification AND CmmdtyHdgTargetQuotaDirection = _TargetQtaVers.CmmdtyHdgTargetQuotaDirection AND CmmdtyHdgTgtQuotaPeriodClass = _TargetQtaVers.CmmdtyHdgTgtQuotaPeriodClass AND CmmdtyHdgTgtQuotaHedgeBookID = _TargetQtaVers.CmmdtyHdgTgtQuotaHedgeBookID  -- association [0..*]
LEFT OUTER JOIN C_CmmdtyHedgeTargetQuotaStatus AS _TQStatus ON CmmdtyHedgeTargetQuotaUUID = _TQStatus.CmmdtyHedgeObjectDocumentUUID  -- association [0..*]
;

Learn More