A_CmmdtyHdgTargetQuotaVersion

DDL: A_CMMDTYHDGTARGETQUOTAVERSION Type: view_entity CONSUMPTION
17 Fields 1 Data Sources

Target Quota Version

A_CmmdtyHdgTargetQuotaVersion is a Consumption CDS View that provides data about "Target Quota Version" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgTargetQuotaVersion) and exposes 17 fields with key fields CmmdtyHedgeTargetQuotaUUID, CmmdtyHdgTgtQuotaPeriodClass.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgTargetQuotaVersion I_CmmdtyHdgTargetQuotaVersion projection

Annotations (10)

NameValueLevelField
EndUserText.label Target Quota Version view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
OData.entityType.name A_CmmdtyHdgTargetQuotaVersion_Type view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey CmmdtyHedgeTargetQuotaUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHedgeTargetQuotaUUID CmmdtyHedgeTargetQuotaUUID
KEY CmmdtyHdgTgtQuotaPeriodClass CmmdtyHdgTgtQuotaPeriodClass
CmmdtyHedgeTargetQuotaVersion CmmdtyHedgeTargetQuotaVersion
CompanyCode CompanyCode Receiver Company Code
DerivativeContrSpecification DerivativeContrSpecification DCS ID
CmmdtyHdgTargetQuotaDirection CmmdtyHdgTargetQuotaDirection
CmmdtyHdgTgtQtaValdFrmDateTime CmmdtyHdgTgtQtaValdFrmDateTime
CommodityHedgeRemarkNote CommodityHedgeRemarkNote
IsActive IsActive Object active?
CmmdtyHedgeTargetQuotaStatusID CmmdtyHedgeTargetQuotaStatusID
CmmdtyHdgTargetQuotaLogHandle CmmdtyHdgTargetQuotaLogHandle
CmmdtyHdgTgtQuotaIsFullyHedged CmmdtyHdgTgtQuotaIsFullyHedged
CmmdtyHdgTgtQuotaCreatedByUser CmmdtyHdgTgtQuotaCreatedByUser
CmmdtyHdgTgtQtaCrtnDateTime CmmdtyHdgTgtQtaCrtnDateTime
CmmdtyHdgTargetQuotaIsObsolete CmmdtyHdgTargetQuotaIsObsolete
CmmdtyHdgTgtQuotaChangedByUser CmmdtyHdgTgtQuotaChangedByUser
CmmdtyHdgTgtQtaChangeDateTime CmmdtyHdgTgtQtaChangeDateTime

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 A_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 A_CmmdtyHdgTargetQuotaVersion AS
SELECT
  CmmdtyHedgeTargetQuotaUUID,
  CmmdtyHdgTgtQuotaPeriodClass,
  CmmdtyHedgeTargetQuotaVersion,
  CompanyCode,
  DerivativeContrSpecification,
  CmmdtyHdgTargetQuotaDirection,
  CmmdtyHdgTgtQtaValdFrmDateTime,
  CommodityHedgeRemarkNote,
  IsActive,
  CmmdtyHedgeTargetQuotaStatusID,
  CmmdtyHdgTargetQuotaLogHandle,
  CmmdtyHdgTgtQuotaIsFullyHedged,
  CmmdtyHdgTgtQuotaCreatedByUser,
  CmmdtyHdgTgtQtaCrtnDateTime,
  CmmdtyHdgTargetQuotaIsObsolete,
  CmmdtyHdgTgtQuotaChangedByUser,
  CmmdtyHdgTgtQtaChangeDateTime
FROM I_CmmdtyHdgTargetQuotaVersion
;

Learn More