P_CmmdtyHdgTargetQuotaAtDate

DDL: P_CMMDTYHDGTARGETQUOTAATDATE Type: view_entity COMPOSITE
19 Fields 1 Data Sources

P_CmmdtyHdgTargetQuotaAtDate is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CmmdtyHdgTargetQuotaDetail) and exposes 19 fields with key field CmmdtyHedgeTargetQuotaUUID.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyHdgTargetQuotaDetail Tq from

Parameters (1)

NameTypeDefault
p_evaluation_date abap.dats

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (19)

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

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 P_CmmdtyHdgTargetQuotaAtDate.
-- 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.
-- Parameters: p_evaluation_date : abap.dats

CREATE VIEW P_CmmdtyHdgTargetQuotaAtDate AS
SELECT
  Tq.CmmdtyHedgeTargetQuotaUUID AS CmmdtyHedgeTargetQuotaUUID,
  Tq.CmmdtyHedgeTargetQuotaVersion AS CmmdtyHedgeTargetQuotaVersion,
  Tq.CompanyCode AS CompanyCode,
  Tq.DerivativeContrSpecification AS DerivativeContrSpecification,
  Tq.CmmdtyHdgTargetQuotaDirection AS CmmdtyHdgTargetQuotaDirection,
  Tq.CmmdtyHdgTgtQtaValdFrmDateTime AS CmmdtyHdgTgtQtaValdFrmDateTime,
  Tq.CmmdtyHdgTgtQuotaHedgeBookID AS CmmdtyHdgTgtQuotaHedgeBookID,
  Tq.CmmdtyHdgTgtQtaValdtyStartDate AS CmmdtyHdgTgtQtaValdtyStartDate,
  Tq.CmmdtyHdgTgtQuotaPeriodClass AS CmmdtyHdgTgtQuotaPeriodClass,
  Tq.CommodityHedgeRemarkNote AS CommodityHedgeRemarkNote,
  Tq.IsActive AS IsActive,
  Tq.CmmdtyHedgeTargetQuotaStatusID AS CmmdtyHedgeTargetQuotaStatusID,
  Tq.CmmdtyHdgTargetQuotaLogHandle AS CmmdtyHdgTargetQuotaLogHandle,
  Tq.CmmdtyHdgTgtQuotaIsFullyHedged AS CmmdtyHdgTgtQuotaIsFullyHedged,
  Tq.CmmdtyHdgTgtQuotaCreatedByUser AS CmmdtyHdgTgtQuotaCreatedByUser,
  Tq.CmmdtyHdgTgtQtaCrtnDateTime AS CmmdtyHdgTgtQtaCrtnDateTime,
  Tq.CmmdtyHdgTargetQuotaIsObsolete AS CmmdtyHdgTargetQuotaIsObsolete,
  Tq.CmmdtyHdgTgtQuotaChangedByUser AS CmmdtyHdgTgtQuotaChangedByUser,
  Tq.CmmdtyHdgTgtQtaChangeDateTime AS CmmdtyHdgTgtQtaChangeDateTime
FROM I_CmmdtyHdgTargetQuotaDetail AS Tq
;

Learn More