P_CommodityHedgeSwap

DDL: P_COMMODITYHEDGESWAP Type: view COMPOSITE Package: FIN_CMM_CMDTY_HEDGE_FTR
11 Fields 1 Data Sources 4 Associations

Commodity Hedging Financial Transaction

P_CommodityHedgeSwap is a Composite CDS View that provides data about "Commodity Hedging Financial Transaction" in SAP S/4HANA. It reads from 1 data source (I_FinancialTransaction) and exposes 11 fields with key fields FinancialTransactionPortfolio, FinTransGeneralValuationClass. It has 4 associations to related views. Part of development package FIN_CMM_CMDTY_HEDGE_FTR.

Data Sources (1)

SourceAliasJoin Type
I_FinancialTransaction I_FinancialTransaction from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_MarketIdentCode _MIC _MIC.MarketIdentifierCode = _MIC.MarketIdentifierCode
[1..1] I_TimeToMaturity _TimeToMatirity _TimeToMatirity.TimeToMaturity = _TimeToMatirity.TimeToMaturity
[0..1] I_PriceQuotationType _PriceQuotationType _PriceQuotationType.PriceQuotationType = _PriceQuotationType.PriceQuotationType
[1..1] I_CmmdtyHdgFinTransaction _CmmdtyHdgFinTransaction _CmmdtyHdgFinTransaction.FinTransactionDealIdentifier = _CmmdtyHdgFinTransaction.FinTransactionDealIdentifier and _CmmdtyHdgFinTransaction.FinTransactionCompanyCode = _CmmdtyHdgFinTransaction.FinTransactionCompanyCode

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCMMHEDGESWAP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY FinancialTransactionPortfolio Portfolio Portfolio
KEY FinTransGeneralValuationClass TreasuryValuationClass Gen. Valn Class
FinTransHedgingClassification HedgingClassification Hedging Classification
FinTransMarketIdentifierCode _MIC MarketIdentifierCode MIC
FinTransactionProductType FinancialInstrumentProductType Product Type
FinancialInstrTransactionType FinancialInstrTransactionType
FinTransPriceQuotationType _PriceQuotationType PriceQuotationType Price Type
FinTransactionTimeToMaturity _TimeToMatirity TimeToMaturity Time to Maturity
FinancialInstrCharacteristic _CmmdtyHdgFinTransaction FinTransactionCharacteristic
FinTransactionCounterparty _CmmdtyHdgFinTransaction FinTransactionCounterparty
FinancialTransactionHedgeBook _CmmdtyHdgFinTransaction FinancialTransactionHedgeBook

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_CommodityHedgeSwap.
-- 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 P_CommodityHedgeSwap AS
SELECT
  Portfolio AS FinancialTransactionPortfolio,
  TreasuryValuationClass AS FinTransGeneralValuationClass,
  HedgingClassification AS FinTransHedgingClassification,
  _MIC.MarketIdentifierCode AS FinTransMarketIdentifierCode,
  FinancialInstrumentProductType AS FinTransactionProductType,
  FinancialInstrTransactionType,
  _PriceQuotationType.PriceQuotationType AS FinTransPriceQuotationType,
  _TimeToMatirity.TimeToMaturity AS FinTransactionTimeToMaturity,
  _CmmdtyHdgFinTransaction.FinTransactionCharacteristic AS FinancialInstrCharacteristic,
  _CmmdtyHdgFinTransaction.FinTransactionCounterparty AS FinTransactionCounterparty,
  _CmmdtyHdgFinTransaction.FinancialTransactionHedgeBook AS FinancialTransactionHedgeBook
FROM I_FinancialTransaction
LEFT OUTER JOIN I_MarketIdentCode AS _MIC ON _MIC.MarketIdentifierCode = _MIC.MarketIdentifierCode  -- association [1..1]
LEFT OUTER JOIN I_TimeToMaturity AS _TimeToMatirity ON _TimeToMatirity.TimeToMaturity = _TimeToMatirity.TimeToMaturity  -- association [1..1]
LEFT OUTER JOIN I_PriceQuotationType AS _PriceQuotationType ON _PriceQuotationType.PriceQuotationType = _PriceQuotationType.PriceQuotationType  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgFinTransaction AS _CmmdtyHdgFinTransaction ON _CmmdtyHdgFinTransaction.FinTransactionDealIdentifier = _CmmdtyHdgFinTransaction.FinTransactionDealIdentifier AND _CmmdtyHdgFinTransaction.FinTransactionCompanyCode = _CmmdtyHdgFinTransaction.FinTransactionCompanyCode  -- association [1..1]
;

Learn More