I_CmmdtyHdgTargetQuotaVersion

DDL: I_CMMDTYHDGTARGETQUOTAVERSION Type: view_entity COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_TQ
19 Fields 1 Data Sources 1 Associations

Target Quota Version

I_CmmdtyHdgTargetQuotaVersion is a Composite CDS View that provides data about "Target Quota Version" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHedgeTargetQuotaHeader) and exposes 19 fields with key fields CmmdtyHedgeTargetQuotaUUID, CmmdtyHdgTgtQuotaPeriodClass. It has 1 association to related views. Part of development package FIN_CMM_CMDTY_HEDGE_TQ.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHedgeTargetQuotaHeader I_CmmdtyHedgeTargetQuotaHeader from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_CmmdtyHdgTgtQtaPosVersion _TargetQuotaPositionVersion

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Target Quota Version view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHedgeTargetQuotaUUID CmmdtyHedgeTargetQuotaUUID UUID
KEY CmmdtyHdgTgtQuotaPeriodClass CmmdtyHdgTgtQuotaPeriodClass Period Class
CmmdtyHedgeTargetQuotaVersion CmmdtyHedgeTargetQuotaVersion XML Vers.
CompanyCode CompanyCode Receiver Company Code
DerivativeContrSpecification DerivativeContrSpecification DCS ID
CmmdtyHdgTargetQuotaDirection CmmdtyHdgTargetQuotaDirection Long/Short Position
CmmdtyHdgTgtQuotaHedgeBookID CmmdtyHdgTgtQuotaHedgeBookID Hedge Book
CmmdtyHdgTgtQtaValdFrmDateTime CmmdtyHdgTgtQtaValdFrmDateTime Validity Start Time
CommodityHedgeRemarkNote CommodityHedgeRemarkNote Status Description
IsActive IsActive Object active?
CmmdtyHedgeTargetQuotaStatusID CmmdtyHedgeTargetQuotaStatusID Trans Doc Status
CmmdtyHdgTargetQuotaLogHandle CmmdtyHdgTargetQuotaLogHandle Migration Log Handle
CmmdtyHdgTgtQuotaIsFullyHedged CmmdtyHdgTgtQuotaIsFullyHedged To Be Fully Hedged
CmmdtyHdgTgtQuotaCreatedByUser CmmdtyHdgTgtQuotaCreatedByUser
CmmdtyHdgTgtQtaCrtnDateTime CmmdtyHdgTgtQtaCrtnDateTime Uploaded On
CmmdtyHdgTargetQuotaIsObsolete CmmdtyHdgTargetQuotaIsObsolete TQ Obslt
CmmdtyHdgTgtQuotaChangedByUser CmmdtyHdgTgtQuotaChangedByUser
CmmdtyHdgTgtQtaChangeDateTime CmmdtyHdgTgtQtaChangeDateTime Timestamp
_TargetQuotaPositionVersion _TargetQuotaPositionVersion

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 I_CmmdtyHdgTargetQuotaVersion.
-- 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 I_CmmdtyHdgTargetQuotaVersion AS
SELECT
  CmmdtyHedgeTargetQuotaUUID,
  CmmdtyHdgTgtQuotaPeriodClass,
  CmmdtyHedgeTargetQuotaVersion,
  CompanyCode,
  DerivativeContrSpecification,
  CmmdtyHdgTargetQuotaDirection,
  CmmdtyHdgTgtQuotaHedgeBookID,
  CmmdtyHdgTgtQtaValdFrmDateTime,
  CommodityHedgeRemarkNote,
  IsActive,
  CmmdtyHedgeTargetQuotaStatusID,
  CmmdtyHdgTargetQuotaLogHandle,
  CmmdtyHdgTgtQuotaIsFullyHedged,
  CmmdtyHdgTgtQuotaCreatedByUser,
  CmmdtyHdgTgtQtaCrtnDateTime,
  CmmdtyHdgTargetQuotaIsObsolete,
  CmmdtyHdgTgtQuotaChangedByUser,
  CmmdtyHdgTgtQtaChangeDateTime
FROM I_CmmdtyHedgeTargetQuotaHeader
LEFT OUTER JOIN I_CmmdtyHdgTgtQtaPosVersion AS _TargetQuotaPositionVersion ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More