R_FinTransUnfixedFlow

@AbapCatalog.sqlViewName: 'RFINTRANSUNFFLOW'
@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: 'Financial Transaction Unfixed Flow'
@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_FinTransUnfixedFlow 
  as select from vtbfhapo_unfixed as Flow 
  inner join I_CompanyCode as CompanyCode on Flow.bukrs = CompanyCode.CompanyCode
{
  //exposed fields

  key Flow.bukrs       as CompanyCode,
  key Flow.rfha        as FinancialTransaction,
  key Flow.rfhazu      as FinancialInstrumentActivity,
  key Flow.dcrdat      as FinTransFlowCreationDate,
  key cast( Flow.tcrtim as ftr_flow_creation_time preserving type )      
                       as FinTransFlowCreationTime,
  key Flow.rfhazb      as FinTransFlowNumber,
  
  Flow.rantyp as TreasuryContractType,
  cast( Flow.sbktyp as ftr_flow_category preserving type )          
                       as FinTransFlowCategory,
  Flow.sfhazba         as FinTransFlowType,
  
  @Semantics.amount.currencyCode: 'FinTransFlowPaytAmtCrcy'    
  cast( Flow.bzbetr as ftr_flow_payment_amount preserving type )
                       as FinTransFlowPaytAmt,
  Flow.wzbetr as FinTransFlowPaytAmtCrcy,
  cast( Flow.ssign as ftr_flow_payment_amt_direction preserving type )
                       as FinTransFlowPaytAmtDirection,
  @Semantics.amount.currencyCode: 'FinTransFlowNomAmtCrcy' 
  cast( case when Flow.bnwhr is not initial
       then Flow.bnwhr
       else Flow.bzbetr
       end as ftr_flow_norminal_amount )
                       as FinTransFlowNomAmt,
  cast( Flow.wzbetr as ftr_flow_norminal_amount_crcy preserving type )
                       as FinTransFlowNomAmtCrcy,
  @Semantics.amount.currencyCode: 'LocalCurrency'    
  Flow.bhwbetr as FinTransFlowInLoclCrcyPaytAmt,
  CompanyCode.Currency as LocalCurrency,
  cast( Flow.khwkurs as ftr_flow_rate_in_locl_crcy preserving type ) 
                       as FinTransFlowLoclCrcyCnvrsnRate,
  cast( Flow.dzterm as ftr_flow_payment_date preserving type )
                       as FinTransFlowPaymentDate,

  Flow.dfaell          as FinTransFlowPaymentDueDate,
  cast( Flow.dbuchung as ftr_flow_posting_date preserving type )
                       as FinTransFlowPostingDate,
  Flow.dzfest          as FinTransFlowIntrstRateFixDate,
  
  Flow.dbervon         as CalculationPeriodStartDate,
  Flow.sultvon         as CalcPeriodStartDateIsMonthEnd,
  Flow.dberbis         as CalculationPeriodEndDate,
  Flow.sultbis         as CalcPeriodEndDateIsMonthEnd,
  Flow.atage           as NumberOfCalculationDays,
  Flow.szbmeth         as InterestCalculationMethod,
  @Semantics.amount.currencyCode: 'FinTransFlowCalcBaseAmountCrcy'    
  Flow.bbasis          as FinTransFlowCalcBaseAmount,
  Flow.wbasis          as FinTransFlowCalcBaseAmountCrcy,
    
  Flow.pkond           as ConditionPercentageRate,
  
  Flow.present_id      as FinTransPresentationItemID,
  
  Flow.sbewebe         as FinTransFlowPostingStatus,
  Flow.ssprgrd         as FinTransFlowPostingBlkgReason,
  Flow.sbfrei          as FinTransFlowPostingRelease,
  
  Flow.regi_state      as FinInterestRateAdjmtStatus,
  cast( Flow.rpcode as farp_repetitive_code )
                       as RepetitiveCode,
  Flow.rahabki         as HouseBank,
  Flow.rahktid         as HouseBankAccount,
  Flow.rpzahl          as PayerPayee,
  Flow.rpbank          as PayerPayeeBankDetail,
  Flow.zlsch           as PaymentMethod,
  CompanyCode.Country  as Country,
  Flow.zwels           as PaymentMethodsList,
  Flow.uzawe           as PaymentMethodSupplement,
  Flow.sprsng          as TreasuryIndividualPayment,
  Flow.scspay          as TrsyPaytGroupingSameDrctnIsRqd,
  Flow.sprgrd          as TreasuryPaymentRequestGrouping,
  Flow.paygr           as TreasuryIntGrpgForPaytValue,
  Flow.prkey           as PaymentRequest,
  
  Flow.rkondgr         as FinancialTransactionDirection,
  cast( Flow.logic_rkond as ftr_instr_cndn_logic_group preserving type )
                       as FinInstrConditionLogicGroup,
  Flow.dguel_kp        as ConditionItemValidityStartDate,
  Flow.rkond           as FinConditionItem,
  Flow.nstufe          as FinConditionSubItem,
  
  Flow.zuonr           as AssignmentReference,
  Flow.skhwfix         as FinTransFlwLoclCrcyAmtCalcType,
  Flow.dvalut          as FinTransFlowCalculationDate,
  Flow.sincl           as FlowCalcDateIsExclusive,
  Flow.svult           as FlowCalcDateIsMonthEnd,
  Flow.skalidwt        as IntrstCalcMethFactoryCalendar,
  cast ( case
        when Flow.jexpozins      = 'X' then '1'
        when Flow.jexpozins      = 'L' then '5'
        else '0'
        end as tfmsintcalc ) 
                       as InterestCalculationType,                                                                   
  Flow.sexclvon        as CalcPeriodStartDateIsInclusive,
  Flow.sinclbis        as CalcPeriodEndDateIsInclusive,
  Flow.sabverf         as FinTransFlwDerivationProcedure,
  Flow.pwkurs          as FinTransPaytRateInPercent,
  Flow.payment_reason  as PaymentReason
  
}