I_CmmdtyTrdOrdCkptTargetQuota

DDL: I_CMMDTYTRDORDCKPTTARGETQUOTA SQL: ITQTRDORDCKPT Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_SPEC
29 Fields 2 Data Sources

Exposure Details for Trade Order

I_CmmdtyTrdOrdCkptTargetQuota is a Composite CDS View that provides data about "Exposure Details for Trade Order" in SAP S/4HANA. It reads from 2 data sources (I_CmmdtyHdgTargetQuotaDetail, I_CmmdtyHdgTargetQuotaPosition) and exposes 29 fields with key fields CmmdtyHdgTgtQuotaPositionUUID, CmmdtyHedgeTargetQuotaUUID, CompanyCode. Part of development package FIN_CMM_CMDTY_HEDGE_SPEC.

Data Sources (2)

SourceAliasJoin Type
I_CmmdtyHdgTargetQuotaDetail _TgtQta from
I_CmmdtyHdgTargetQuotaPosition _TQPosition inner

Parameters (2)

NameTypeDefault
P_CompanyCode bukrs
P_ValidFrom cmm_plan_valid_from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITQTRDORDCKPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Exposure Details for Trade Order view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHdgTgtQuotaPositionUUID I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQuotaPositionUUID UUID
KEY CmmdtyHedgeTargetQuotaUUID I_CmmdtyHdgTargetQuotaDetail CmmdtyHedgeTargetQuotaUUID UUID
KEY CompanyCode I_CmmdtyHdgTargetQuotaDetail CompanyCode Receiver Company Code
CmmdtyHdgTgtQtaPosValdDateTime I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQtaPosValdDateTime Valid-From Date of Target Quota Position
CmmdtyHdgTgtQuotaPositionYear I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQuotaPositionYear Position Year
CmmdtyHdgTgtQuotaPeriodNumber I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQuotaPeriodNumber Period Number
CmmdtyHdgTgtQtaUprLmtInPercent I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQtaUprLmtInPercent
CmmdtyHdgAcctgUprLmtInPercent I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgAcctgUprLmtInPercent
CmmdtyHdgTradeOrderRemarkNote I_CmmdtyHdgTargetQuotaPosition CommodityHedgeRemarkNote Status Description
CmmdtyHdgTgtQtaPosCrtedByUser I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQtaPosCrtedByUser
CmmdtyHdgTgtQtaPosCrtnDateTime I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQtaPosCrtnDateTime Uploaded On
CmmdtyHdgTgtQtaPosChgdByUser I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQtaPosChgdByUser
CmmdtyHdgTgtQtaPosChgDateTime I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQtaPosChgDateTime Timestamp
CmmdtyHedgeTargetQuotaVersion I_CmmdtyHdgTargetQuotaDetail CmmdtyHedgeTargetQuotaVersion XML Vers.
DerivativeContrSpecification I_CmmdtyHdgTargetQuotaDetail DerivativeContrSpecification DCS ID
CmmdtyHdgTargetQuotaDirection I_CmmdtyHdgTargetQuotaDetail CmmdtyHdgTargetQuotaDirection Long/Short Position
CmmdtyHdgTgtQtaValdtyStartDate I_CmmdtyHdgTargetQuotaDetail CmmdtyHdgTgtQtaValdtyStartDate
CmmdtyHdgTgtQuotaHedgeBookID I_CmmdtyHdgTargetQuotaDetail CmmdtyHdgTgtQuotaHedgeBookID Hedge Book
CmmdtyHdgTgtQtaValdFrmDateTime I_CmmdtyHdgTargetQuotaDetail CmmdtyHdgTgtQtaValdFrmDateTime Validity Start Time
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
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 I_CmmdtyTrdOrdCkptTargetQuota.
-- 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.
-- SQL view name: ITQTRDORDCKPT
-- Parameters: P_CompanyCode : bukrs, P_ValidFrom : cmm_plan_valid_from

CREATE VIEW I_CmmdtyTrdOrdCkptTargetQuota AS
SELECT
  _TQPosition.CmmdtyHdgTgtQuotaPositionUUID AS CmmdtyHdgTgtQuotaPositionUUID,
  _TgtQta.CmmdtyHedgeTargetQuotaUUID AS CmmdtyHedgeTargetQuotaUUID,
  _TgtQta.CompanyCode AS CompanyCode,
  _TQPosition.CmmdtyHdgTgtQtaPosValdDateTime AS CmmdtyHdgTgtQtaPosValdDateTime,
  _TQPosition.CmmdtyHdgTgtQuotaPositionYear AS CmmdtyHdgTgtQuotaPositionYear,
  _TQPosition.CmmdtyHdgTgtQuotaPeriodNumber AS CmmdtyHdgTgtQuotaPeriodNumber,
  _TQPosition.CmmdtyHdgTgtQtaUprLmtInPercent AS CmmdtyHdgTgtQtaUprLmtInPercent,
  _TQPosition.CmmdtyHdgAcctgUprLmtInPercent AS CmmdtyHdgAcctgUprLmtInPercent,
  _TQPosition.CommodityHedgeRemarkNote AS CmmdtyHdgTradeOrderRemarkNote,
  _TQPosition.CmmdtyHdgTgtQtaPosCrtedByUser AS CmmdtyHdgTgtQtaPosCrtedByUser,
  _TQPosition.CmmdtyHdgTgtQtaPosCrtnDateTime AS CmmdtyHdgTgtQtaPosCrtnDateTime,
  _TQPosition.CmmdtyHdgTgtQtaPosChgdByUser AS CmmdtyHdgTgtQtaPosChgdByUser,
  _TQPosition.CmmdtyHdgTgtQtaPosChgDateTime AS CmmdtyHdgTgtQtaPosChgDateTime,
  _TgtQta.CmmdtyHedgeTargetQuotaVersion AS CmmdtyHedgeTargetQuotaVersion,
  _TgtQta.DerivativeContrSpecification AS DerivativeContrSpecification,
  _TgtQta.CmmdtyHdgTargetQuotaDirection AS CmmdtyHdgTargetQuotaDirection,
  _TgtQta.CmmdtyHdgTgtQtaValdtyStartDate AS CmmdtyHdgTgtQtaValdtyStartDate,
  _TgtQta.CmmdtyHdgTgtQuotaHedgeBookID AS CmmdtyHdgTgtQuotaHedgeBookID,
  _TgtQta.CmmdtyHdgTgtQtaValdFrmDateTime AS CmmdtyHdgTgtQtaValdFrmDateTime,
  _TgtQta.CmmdtyHdgTgtQuotaPeriodClass AS CmmdtyHdgTgtQuotaPeriodClass,
  _TgtQta.CommodityHedgeRemarkNote AS CommodityHedgeRemarkNote,
  _TgtQta.IsActive AS IsActive,
  _TgtQta.CmmdtyHedgeTargetQuotaStatusID AS CmmdtyHedgeTargetQuotaStatusID,
  _TgtQta.CmmdtyHdgTargetQuotaLogHandle AS CmmdtyHdgTargetQuotaLogHandle,
  _TgtQta.CmmdtyHdgTgtQuotaIsFullyHedged AS CmmdtyHdgTgtQuotaIsFullyHedged,
  _TgtQta.CmmdtyHdgTgtQuotaCreatedByUser AS CmmdtyHdgTgtQuotaCreatedByUser,
  _TgtQta.CmmdtyHdgTgtQtaCrtnDateTime AS CmmdtyHdgTgtQtaCrtnDateTime,
  _TgtQta.CmmdtyHdgTgtQuotaChangedByUser AS CmmdtyHdgTgtQuotaChangedByUser,
  _TgtQta.CmmdtyHdgTgtQtaChangeDateTime AS CmmdtyHdgTgtQtaChangeDateTime
FROM I_CmmdtyHdgTargetQuotaDetail AS _TgtQta
INNER JOIN I_CmmdtyHdgTargetQuotaPosition AS _TQPosition ON /* join condition not captured in parsed metadata */
;

Learn More