I_FinTransAdditionalFlow

@AbapCatalog.sqlViewName: 'IFINTRANSADDFLOW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Financial Transaction Additional Flow'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions:false
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
define view I_FinTransAdditionalFlow
  as select from I_FinTransFlow as Flow
{
      //exposed fields

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key Flow.CompanyCode                    as CompanyCode,
      @ObjectModel.foreignKey.association: '_FinTrans'
  key Flow.FinancialTransaction           as FinancialTransaction,
      @ObjectModel.foreignKey.association: '_Activity'
  key Flow.FinancialInstrumentActivity    as FinancialInstrumentActivity,
  key Flow.FinTransFlowCreationDate       as FinTransFlowCreationDate,
  key Flow.FinTransFlowCreationTime       as FinTransFlowCreationTime,
  key Flow.FinTransFlowNumber             as FinTransFlowNumber,

      @ObjectModel.foreignKey.association: '_ContractType'
      Flow.TreasuryContractType           as TreasuryContractType,
      @ObjectModel.foreignKey.association: '_Direction'
      Flow.FinancialTransactionDirection  as FinancialTransactionDirection,
      @ObjectModel.foreignKey.association: '_FlowType'
      Flow.FinTransFlowType               as FinTransFlowType,
      Flow.FinTransFlowPaytAmtDirection   as FinTransFlowPaytAmtDirection,
      Flow.FinTransFlowPaymentDate        as FinTransFlowPaymentDate,
      @Semantics.amount.currencyCode: 'FinTransFlowPaytAmtCrcy'
      Flow.FinTransFlowPaytAmt            as FinTransFlowPaytAmt,
      @ObjectModel.foreignKey.association: '_PaymentCurrency'
      @Semantics.currencyCode: true
      Flow.FinTransFlowPaytAmtCrcy        as FinTransFlowPaytAmtCrcy,
      @Semantics.amount.currencyCode: 'LocalCurrency'
      Flow.FinTransFlowInLoclCrcyPaytAmt  as FinTransFlowInLoclCrcyPaytAmt,
      @ObjectModel.foreignKey.association: '_LocalCurrency'
      Flow.LocalCurrency                  as LocalCurrency,
      Flow.FinTransFlowLoclCrcyCnvrsnRate as FinTransFlowLoclCrcyCnvrsnRate,
      Flow.InterestCalculationMethod      as InterestCalculationMethod,
      Flow.CalculationPeriodStartDate     as CalculationPeriodStartDate,
      @Semantics.booleanIndicator: true
      Flow.CalcPeriodStartDateIsMonthEnd  as CalcPeriodStartDateIsMonthEnd,
      Flow.CalculationPeriodEndDate       as CalculationPeriodEndDate,
      @Semantics.booleanIndicator: true
      Flow.CalcPeriodEndDateIsMonthEnd    as CalcPeriodEndDateIsMonthEnd,
      @Semantics.amount.currencyCode: 'FinTransFlowCalcBaseAmountCrcy'
      Flow.FinTransFlowCalcBaseAmount     as FinTransFlowCalcBaseAmount,
      @ObjectModel.foreignKey.association: '_BaseAmtCurrency'
      Flow.FinTransFlowCalcBaseAmountCrcy as FinTransFlowCalcBaseAmountCrcy,
      Flow.ConditionPercentageRate        as ConditionPercentageRate,
      Flow.AssignmentReference            as AssignmentReference,
      Flow.FinTransFlwLoclCrcyAmtCalcType as FinTransFlwLoclCrcyAmtCalcType,
      Flow.IntrstCalcMethFactoryCalendar  as IntrstCalcMethFactoryCalendar,
      Flow.InterestCalculationType        as InterestCalculationType,
      Flow.CalcPeriodStartDateIsInclusive as CalcPeriodStartDateIsInclusive,
      Flow.CalcPeriodEndDateIsInclusive   as CalcPeriodEndDateIsInclusive,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'FinTransFlowFixingStatus'
      Flow.FinTransFlowPostingStatus      as FinTransFlowStatus,
      Flow.FinTransFlowPostingStatus      as FinTransFlowFixingStatus,

      //exposed dimensions

      _CompanyCode,
      _FinTrans,
      _Activity,
      _ContractType,
      _FlowType,
      _PaymentCurrency,
      _LocalCurrency,
      _BaseAmtCurrency,
      _Direction
}
where
      Flow.FinTransFlowCategory           = '90'
  and Flow.FinTransFlwDerivationProcedure = ''