P_CommodityHedgeSwap

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]
;