P_CommodityHedgeSwap

DDL: P_COMMODITYHEDGESWAP Type: view COMPOSITE

P_CommodityHedgeSwap is a Composite CDS View 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.

1 data source(s) 11 fields

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
KEY FinTransGeneralValuationClass TreasuryValuationClass
FinTransHedgingClassification HedgingClassification Hedging Classification
FinTransMarketIdentifierCode _MIC MarketIdentifierCode
FinTransactionProductType FinancialInstrumentProductType
FinancialInstrTransactionType FinancialInstrTransactionType
FinTransPriceQuotationType _PriceQuotationType PriceQuotationType
FinTransactionTimeToMaturity _TimeToMatirity TimeToMaturity
FinancialInstrCharacteristic _CmmdtyHdgFinTransaction FinTransactionCharacteristic
FinTransactionCounterparty _CmmdtyHdgFinTransaction FinTransactionCounterparty
FinancialTransactionHedgeBook _CmmdtyHdgFinTransaction FinancialTransactionHedgeBook 
@AbapCatalog: { sqlViewName: 'PCMMHEDGESWAP',
                compiler.compareFilter: true,
                preserveKey: true }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.dataClass: #TRANSACTIONAL,
                usageType.sizeCategory: #L,
                usageType.serviceQuality: #A }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM: { viewType: #COMPOSITE,
        private:  true }


/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK", "CALCULATED_FIELD_CHECK", "KEY_CHECK" ]  } */
define view P_CommodityHedgeSwap
  as select from I_FinancialTransaction
  association [1..1] to I_MarketIdentCode         as _MIC                     on  _MIC.MarketIdentifierCode = _MIC.MarketIdentifierCode
  association [1..1] to I_TimeToMaturity          as _TimeToMatirity          on  _TimeToMatirity.TimeToMaturity = _TimeToMatirity.TimeToMaturity

  association [0..1] to I_PriceQuotationType      as _PriceQuotationType      on  _PriceQuotationType.PriceQuotationType = _PriceQuotationType.PriceQuotationType

  association [1..1] to I_CmmdtyHdgFinTransaction as _CmmdtyHdgFinTransaction on  _CmmdtyHdgFinTransaction.FinTransactionDealIdentifier = _CmmdtyHdgFinTransaction.FinTransactionDealIdentifier
                                                                              and _CmmdtyHdgFinTransaction.FinTransactionCompanyCode    = _CmmdtyHdgFinTransaction.FinTransactionCompanyCode


{
      @Consumption.valueHelpDefinition:[{ entity : { name: 'C_CmmdtyHdgPlnExpsrPortfolioVH',
                                                     element: 'Portfolio'} }]
  key Portfolio                                             as FinancialTransactionPortfolio,

      @Consumption.valueHelpDefinition: [{entity :{ name:     'C_CmmdtyHdgFinInstrValnClassVH',
                                                    element:  'FinancialInstrValuationClass' } }]
  key TreasuryValuationClass                                as FinTransGeneralValuationClass,

      @Consumption.valueHelpDefinition: [{entity: { name:     'C_CmmdtyHdgHdggArHdggClfnVH',
                                                    element:  'HedgingClassification'       } }]
      @EndUserText.label             : 'Hedging Classification'
      @UI.lineItem: [{ position: 10 }]
      HedgingClassification                                 as FinTransHedgingClassification,
      @Consumption.valueHelpDefinition:[{ entity : { name: 'C_CmmdtyHdgPlnExpsrMktIDCodeVH',
                                           element: 'MarketIdentifierCode'                  } }]
      _MIC.MarketIdentifierCode                             as FinTransMarketIdentifierCode,
      @Consumption.valueHelpDefinition: [{entity :{ name:     'C_CmHdgFinAstMgmtProductTypeVH',
                                                    element:  'FinancialAssetsMgmtProductType' } }]
      FinancialInstrumentProductType                        as FinTransactionProductType,
      @Consumption.valueHelpDefinition:[{ entity : { name: 'C_CmmdtyHdgFinInstrTransTypeVH',
                                                     element: 'FinancialInstrTransactionType'}  }]
      FinancialInstrTransactionType,


      @Consumption.valueHelpDefinition: [{entity: { name:     'C_CmmdtyHdgPrcQuotationTypeVH',
                                                    element:  'PriceQuotationType'    }}]
      _PriceQuotationType.PriceQuotationType                as FinTransPriceQuotationType,
      @Consumption.valueHelpDefinition: [{entity: { name:     'C_FinTransTimeToMaturityVH',
                                                    element:  'TimeToMaturity'             } }]
      _TimeToMatirity.TimeToMaturity                        as FinTransactionTimeToMaturity,

      @Consumption.valueHelpDefinition: [{entity :{
                                                  name:     'C_CmmdtyHdgFinInstrCharcVH',
                                                  element:  'FinancialInstrCharacteristic'
                                                 }
                }]
      _CmmdtyHdgFinTransaction.FinTransactionCharacteristic as FinancialInstrCharacteristic,

      @Consumption.valueHelpDefinition: [{entity :{
                                                name:     'C_CmmdtyHedgeCounterpartyVH',
                                                element:  'BusinessPartner'      } }]
      _CmmdtyHdgFinTransaction.FinTransactionCounterparty,

      @Consumption.valueHelpDefinition:[{ entity : { name:    'C_CmmdtyHdgPlnExpsrHedgeBookVH',
                                                    element: 'CmmdtyHdgPlanExposureHedgeBook' } }]
      _CmmdtyHdgFinTransaction.FinancialTransactionHedgeBook

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYHDGFINTRANSACTION",
"I_FINANCIALTRANSACTION",
"I_MARKETIDENTCODE",
"I_PRICEQUOTATIONTYPE",
"I_TIMETOMATURITY"
],
"ASSOCIATED":
[
"I_CMMDTYHDGFINTRANSACTION",
"I_MARKETIDENTCODE",
"I_PRICEQUOTATIONTYPE",
"I_TIMETOMATURITY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More