P_CmmdtyHdgSpecTargetQuotaMap

DDL: P_CMMDTYHDGSPECTARGETQUOTAMAP SQL: PCMMDTYTQDTLSMAP Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_TQ
15 Fields 3 Data Sources

Commodity Hedge Target Details Mapping

P_CmmdtyHdgSpecTargetQuotaMap is a Composite CDS View that provides data about "Commodity Hedge Target Details Mapping" in SAP S/4HANA. It reads from 3 data sources (I_CmmdtyHdgTargetQuotaPosition, I_CmmdtyHdgTargetQuotaDetail, P_CmmdtyHdgTgtQtaMaxChangedAt) and exposes 15 fields with key fields CmmdtyHedgeSpecificationUUID, CmmdtyHdgSpecQuotaOrderUUID. Part of development package FIN_CMM_CMDTY_HEDGE_TQ.

Data Sources (3)

SourceAliasJoin Type
I_CmmdtyHdgTargetQuotaPosition _TgtQta inner
I_CmmdtyHdgTargetQuotaDetail _TgtQtaHdr from
P_CmmdtyHdgTgtQtaMaxChangedAt _TgtQtaVer inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCMMDTYTQDTLSMAP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Commodity Hedge Target Details Mapping view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyHedgeSpecificationUUID P_CmmdtyHdgTgtQtaMaxChangedAt CmmdtyHedgeSpecificationUUID
KEY CmmdtyHdgSpecQuotaOrderUUID P_CmmdtyHdgTgtQtaMaxChangedAt CmmdtyHdgSpecQuotaOrderUUID
CmmdtyHdgSpecificationID P_CmmdtyHdgTgtQtaMaxChangedAt CmmdtyHdgSpecificationID
CmmdtyHdgSpecQuotaOrderID P_CmmdtyHdgTgtQtaMaxChangedAt CmmdtyHdgSpecQuotaOrderID
CompanyCode P_CmmdtyHdgTgtQtaMaxChangedAt CompanyCode Receiver Company Code
DerivativeContrSpecification P_CmmdtyHdgTgtQtaMaxChangedAt DerivativeContrSpecification DCS ID
CmmdtyHdgSpecDirection P_CmmdtyHdgTgtQtaMaxChangedAt CmmdtyHdgSpecDirection
CmmdtyHedgeTargetQuotaUUID I_CmmdtyHdgTargetQuotaDetail CmmdtyHedgeTargetQuotaUUID UUID
CmmdtyHdgTgtQuotaHedgeBookID I_CmmdtyHdgTargetQuotaDetail CmmdtyHdgTgtQuotaHedgeBookID Hedge Book
CmmdtyHdgTgtQuotaPositionUUID I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQuotaPositionUUID UUID
CmmdtyHdgTgtQuotaPositionYear I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQuotaPositionYear Position Year
CmmdtyHdgTgtQuotaPeriodNumber I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQuotaPeriodNumber Period Number
CommodityHedgePercentageUnit %
CmmdtyHdgAcctgUprLmtInPercent I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgAcctgUprLmtInPercent
CmmdtyHdgTgtQtaUprLmtInPercent I_CmmdtyHdgTargetQuotaPosition CmmdtyHdgTgtQtaUprLmtInPercent

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_CmmdtyHdgSpecTargetQuotaMap.
-- 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: PCMMDTYTQDTLSMAP

CREATE VIEW P_CmmdtyHdgSpecTargetQuotaMap AS
SELECT
  _TgtQtaVer.CmmdtyHedgeSpecificationUUID AS CmmdtyHedgeSpecificationUUID,
  _TgtQtaVer.CmmdtyHdgSpecQuotaOrderUUID AS CmmdtyHdgSpecQuotaOrderUUID,
  _TgtQtaVer.CmmdtyHdgSpecificationID AS CmmdtyHdgSpecificationID,
  _TgtQtaVer.CmmdtyHdgSpecQuotaOrderID AS CmmdtyHdgSpecQuotaOrderID,
  _TgtQtaVer.CompanyCode AS CompanyCode,
  _TgtQtaVer.DerivativeContrSpecification AS DerivativeContrSpecification,
  _TgtQtaVer.CmmdtyHdgSpecDirection AS CmmdtyHdgSpecDirection,
  _TgtQtaHdr.CmmdtyHedgeTargetQuotaUUID AS CmmdtyHedgeTargetQuotaUUID,
  _TgtQtaHdr.CmmdtyHdgTgtQuotaHedgeBookID AS CmmdtyHdgTgtQuotaHedgeBookID,
  _TgtQta.CmmdtyHdgTgtQuotaPositionUUID AS CmmdtyHdgTgtQuotaPositionUUID,
  _TgtQta.CmmdtyHdgTgtQuotaPositionYear AS CmmdtyHdgTgtQuotaPositionYear,
  _TgtQta.CmmdtyHdgTgtQuotaPeriodNumber AS CmmdtyHdgTgtQuotaPeriodNumber,
  cast( '%' as meins ) AS CommodityHedgePercentageUnit,
  _TgtQta.CmmdtyHdgAcctgUprLmtInPercent AS CmmdtyHdgAcctgUprLmtInPercent,
  _TgtQta.CmmdtyHdgTgtQtaUprLmtInPercent AS CmmdtyHdgTgtQtaUprLmtInPercent
FROM I_CmmdtyHdgTargetQuotaDetail AS _TgtQtaHdr
INNER JOIN P_CmmdtyHdgTgtQtaMaxChangedAt AS _TgtQtaVer ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHdgTargetQuotaPosition AS _TgtQta ON /* join condition not captured in parsed metadata */
;

Learn More