I_FinancialTransactionOption

DDL: I_FINANCIALTRANSACTIONOPTION SQL: IFINTRANSOPTION Type: view BASIC

Financial Transction Option

I_FinancialTransactionOption is a Basic CDS View that provides data about "Financial Transction Option" in SAP S/4HANA. It reads from 1 data source (vtiof) and exposes 19 fields with key field FinTransOptionNumber. It has 6 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
vtiof Option from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_FinancialinstrProductType _FinancialInstrProdType $projection.FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType
[1..1] I_OptionExerciseType _OptionExerciseType $projection.OptionExerciseType = _OptionExerciseType.OptionExerciseType
[1..1] I_OptionSettlementType _OptionSettlementType $projection.OptionSettlementType = _OptionSettlementType.OptionSettlementType
[0..1] I_Currency _LeadingCurrency $projection.LeadingCurrency = _LeadingCurrency.Currency
[0..1] I_Currency _FollowingCurrency $projection.FollowingCurrency = _FollowingCurrency.Currency
[1..1] I_OptionPutCallCode _OptionPutCall $projection.OptionPutCallCode = _OptionPutCall.OptionPutCallCode

Annotations (10)

NameValueLevelField
EndUserText.label Financial Transction Option view
AbapCatalog.sqlViewName IFINTRANSOPTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY FinTransOptionNumber vtiof optnr
FinancialTransaction vtiof orfha
FinancialInstrumentProductType vtiof sgsart
OptionExerciseType vtiof soptaus
OptionUnderlyingTransaction
OptionSettlementType
LeadingCurrency vtiof wlwaers
FollowingCurrency vtiof wfwaers
OptionPutCallCode vtiof sputcal
OptionExpirationDate vtiof dmatur
TermStartDate vtiof dofstar
OptionUndrlgTradedAmount vtiof ostrike
OptionUndrlgTradedCurrency vtiof ofwaers
_FinancialInstrProdType _FinancialInstrProdType
_OptionExerciseType _OptionExerciseType
_OptionSettlementType _OptionSettlementType
_LeadingCurrency _LeadingCurrency
_FollowingCurrency _FollowingCurrency
_OptionPutCall _OptionPutCall 
@EndUserText.label: 'Financial Transction Option'
@AbapCatalog.sqlViewName: 'IFINTRANSOPTION'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_FinancialTransactionOption
  as select from vtiof as Option
  
  association [0..1] to I_FinancialinstrProductType as _FinancialInstrProdType on $projection.FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType
  association [1..1] to I_OptionExerciseType        as _OptionExerciseType     on $projection.OptionExerciseType = _OptionExerciseType.OptionExerciseType
  association [1..1] to I_OptionSettlementType      as _OptionSettlementType   on $projection.OptionSettlementType = _OptionSettlementType.OptionSettlementType
  association [0..1] to I_Currency                  as _LeadingCurrency        on $projection.LeadingCurrency = _LeadingCurrency.Currency
  association [0..1] to I_Currency                  as _FollowingCurrency      on $projection.FollowingCurrency = _FollowingCurrency.Currency
  association [1..1] to I_OptionPutCallCode         as _OptionPutCall          on $projection.OptionPutCallCode = _OptionPutCall.OptionPutCallCode
{
  key Option.optnr   as FinTransOptionNumber,
      Option.orfha   as FinancialTransaction,
      Option.sgsart  as FinancialInstrumentProductType,

      Option.soptaus as OptionExerciseType,
      cast( Option.rfha as OPTION_UNDERLYING_TRANSACTION preserving type )
                     as OptionUnderlyingTransaction,
      cast( Option.settlfl as OPTION_SETTLEMENT_TYPE preserving type )
                     as OptionSettlementType,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_LeadingCurrency'
      Option.wlwaers as LeadingCurrency,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_FollowingCurrency'
      Option.wfwaers as FollowingCurrency,
      Option.sputcal as OptionPutCallCode,
      Option.dmatur  as OptionExpirationDate,
      Option.dofstar as TermStartDate,
      @Semantics.amount.currencyCode: 'OptionUndrlgTradedCurrency'
      Option.ostrike as OptionUndrlgTradedAmount,
      @Semantics.currencyCode: true
      Option.ofwaers as OptionUndrlgTradedCurrency,

      //association

      _FinancialInstrProdType,
      _OptionExerciseType,
      _OptionSettlementType,
      _LeadingCurrency,
      _FollowingCurrency,
      _OptionPutCall
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VTIOF"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_FINANCIALINSTRPRODUCTTYPE",
"I_OPTIONEXERCISETYPE",
"I_OPTIONPUTCALLCODE",
"I_OPTIONSETTLEMENTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More