R_FinTransCndnFmlaVarbl

@AbapCatalog.sqlViewName: 'RFINTRANSCNDNVAR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Fin. Trans. Condition: Formula Variable'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC
define view R_FinTransCndnFmlaVarbl 
//get normal formula variables

as select from R_FinTransAlternativeCondition
{
  //exposed fields

  key CompanyCode,
  key FinancialTransaction,
  key FinancialInstrumentActivity,
  key FinancialTransactionDirection,
  key FinConditionItem,
  key ConditionItemValidityStartDate,
  key FinConditionFormulaReference,
  key FinCndnFormulaVariable, 
  ConditionPercentageRate,
  InterestReference
}

//first formula variable is stored in the normal condition

union all select from vtbfinko as Condition
{
  //exposed fields

  key Condition.bukrs    as CompanyCode,
  key Condition.rfha     as FinancialTransaction,
  key Condition.rfhazu   as FinancialInstrumentActivity,
  key Condition.rkondgr  as FinancialTransactionDirection,
  key Condition.rkond    as FinConditionItem,
  key Condition.dguel_kp as ConditionItemValidityStartDate,
  key Condition.sformref as FinConditionFormulaReference,
  key Condition.svarname as FinCndnFormulaVariable,  
  Condition.pkond        as ConditionPercentageRate,
  Condition.szsref       as InterestReference
}
where Condition.rgatt    is initial
  and Condition.sformref is not initial
  and Condition.svarname is not initial
  and ( Condition.nstufe is initial or Condition.nstufe = '00' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_FINTRANSALTERNATIVECONDITION",
"VTBFINKO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/