R_FINTRANSFXOPTION

CDS View

Fin Trans R view for FX Option

R_FINTRANSFXOPTION is a CDS View in S/4HANA. Fin Trans R view for FX Option. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FXOptionTransBusVol view inner COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY FinancialTransaction FinancialTransaction 1
CompanyCode CompanyCode 1
Counterparty Counterparty 1
OptionUndrlgTradedCurrency TransactionCurrency 1 
@AbapCatalog.sqlViewName: 'RFINTRANSFXOPT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Fin Trans R view for FX Option'
define view R_FinTransFXOption
  as select from I_FinancialTransactionOption as Option
    inner join   I_FinTransUndrlgTransaction  as Underlying         on Option.OptionUnderlyingTransaction = Underlying.OptionUnderlyingTransaction
    inner join   I_FinTransUnderlyingActivity as UnderlyingActivity on  Option.OptionUnderlyingTransaction       = UnderlyingActivity.OptionUnderlyingTransaction
                                                                    and Underlying.FinancialInstrProductCategory = '600'
{
      //general option data

  key Option.FinancialTransaction,
  key Underlying.CompanyCode,

      Option.OptionExerciseType,
      Option.OptionUnderlyingTransaction,
      Option.OptionSettlementType,

      Option.OptionPutCallCode,
      Option.OptionExpirationDate,
      Option.TermStartDate,
      Underlying.TermEndDate,
      Underlying.Counterparty,

      Underlying.FinancialInstrumentProductType,
      UnderlyingActivity.FinancialInstrumentActivity,
      cast( UnderlyingActivity.ExchangeRate as option_undrlg_fx_strike_rate preserving type )
                                                             as OptionUndrlgFXStrikeRate,
      cast( UnderlyingActivity.TermEndDate as fx_value_date) as ForeignExchangeValueDate,


      //now fx option specific data

      @Semantics.amount.currencyCode: 'OptionUndrlgTradedCurrency'
      Option.OptionUndrlgTradedAmount,
      @Semantics.currencyCode: true
      Option.OptionUndrlgTradedCurrency,
      @Semantics.currencyCode: true
      UnderlyingActivity.FollowingCurrency,
      @Semantics.currencyCode: true
      UnderlyingActivity.LeadingCurrency
}
//where

//      Option.opttyp    <> '050' //no basket option

//  and Option.opttyp    <> '051' //no basket option average

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALTRANSACTIONOPTION",
"I_FINTRANSUNDERLYINGACTIVITY",
"I_FINTRANSUNDRLGTRANSACTION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More