I_FinTransFeeFlow

DDL: I_FINTRANSFEEFLOW SQL: IFINTRANSFEE Type: view COMPOSITE

Fin Trans Flows Relevant For Fee

I_FinTransFeeFlow is a Composite CDS View that provides data about "Fin Trans Flows Relevant For Fee" in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, I_FinTransFlow) and exposes 25 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowCreationDate, FinTransFlowCreationTime. It has 4 associations to related views.

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate Calendar inner
I_FinTransFlow Flow from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_FinancialTransaction _FinTrans $projection.CompanyCode = _FinTrans.CompanyCode and $projection.FinancialTransaction = _FinTrans.FinancialTransaction
[1..1] I_FinTransFlowType _FlowType $projection.TreasuryContractType = _FlowType.TreasuryContractType and $projection.FinTransFlowType = _FlowType.FinTransFlowType
[1..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFINTRANSFEE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Fin Trans Flows Relevant For Fee view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransFlow CompanyCode
KEY FinancialTransaction I_FinTransFlow FinancialTransaction
KEY FinancialInstrumentActivity I_FinTransFlow FinancialInstrumentActivity
KEY FinTransFlowCreationDate I_FinTransFlow FinTransFlowCreationDate
KEY FinTransFlowCreationTime I_FinTransFlow FinTransFlowCreationTime
KEY FinTransFlowNumber I_FinTransFlow FinTransFlowNumber
FinTransFlowPaymentDate I_FinTransFlow FinTransFlowPaymentDate
FinTransFlowType I_FinTransFlow FinTransFlowType
TreasuryContractType I_FinTransFlow TreasuryContractType
FinTransFlowPostingStatus I_FinTransFlow FinTransFlowPostingStatus
FinTransFlowPaytAmt I_FinTransFlow FinTransFlowPaytAmt
FinTransFlowPaytAmtCrcy I_FinTransFlow FinTransFlowPaytAmtCrcy
TransactionCurrency _FinTrans TransactionCurrency
Counterparty _FinTrans Counterparty
FinancialInstrumentProductType _FinTrans FinancialInstrumentProductType
Portfolio _FinTrans Portfolio
SecurityAccount _FinTrans SecurityAccount
FinancialInstrTransactionType _FinTrans FinancialInstrTransactionType
YearMonth I_CalendarDate YearMonth
YearQuarter I_CalendarDate YearQuarter
CalendarYear I_CalendarDate CalendarYear
_FlowType _FlowType
_CompanyCode _CompanyCode
_FinTrans _FinTrans
_TransactionCurrency _TransactionCurrency 
@AbapCatalog.sqlViewName: 'IFINTRANSFEE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
      serviceQuality: #D,
      sizeCategory: #L,
      dataClass: #MIXED
 }
@EndUserText.label: 'Fin Trans Flows Relevant For Fee'
define view I_FinTransFeeFlow
  as select from I_FinTransFlow as Flow
    inner join   I_CalendarDate as Calendar on Flow.FinTransFlowPaymentDate = Calendar.CalendarDate

  association [1..1] to I_CompanyCode          as _CompanyCode         on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_FinancialTransaction as _FinTrans            on  $projection.CompanyCode          = _FinTrans.CompanyCode
                                                                       and $projection.FinancialTransaction = _FinTrans.FinancialTransaction
  association [1..1] to I_FinTransFlowType     as _FlowType            on  $projection.TreasuryContractType = _FlowType.TreasuryContractType
                                                                       and $projection.FinTransFlowType     = _FlowType.FinTransFlowType

  association [1..1] to I_Currency             as _TransactionCurrency on  $projection.TransactionCurrency = _TransactionCurrency.Currency

{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key Flow.CompanyCode                         as CompanyCode,
      @ObjectModel.foreignKey.association: '_FinTrans'
  key Flow.FinancialTransaction                as FinancialTransaction,
  key Flow.FinancialInstrumentActivity         as FinancialInstrumentActivity,
  key Flow.FinTransFlowCreationDate            as FinTransFlowCreationDate,
  key Flow.FinTransFlowCreationTime            as FinTransFlowCreationTime,
  key Flow.FinTransFlowNumber                  as FinTransFlowNumber,
      Flow.FinTransFlowPaymentDate             as FinTransFlowPaymentDate,
      @ObjectModel.foreignKey.association: '_FlowType'
      Flow.FinTransFlowType                    as FinTransFlowType,
      Flow.TreasuryContractType                as TreasuryContractType,
      Flow.FinTransFlowPostingStatus           as FinTransFlowPostingStatus,
      @Semantics.amount.currencyCode: 'FinTransFlowPaytAmtCrcy'
      Flow.FinTransFlowPaytAmt                 as FinTransFlowPaytAmt,
      @Semantics.currencyCode: true
      Flow.FinTransFlowPaytAmtCrcy             as FinTransFlowPaytAmtCrcy,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      _FinTrans.TransactionCurrency            as TransactionCurrency,
      _FinTrans.Counterparty                   as Counterparty,
      _FinTrans.FinancialInstrumentProductType as FinancialInstrumentProductType,
      _FinTrans.Portfolio                      as Portfolio,
      _FinTrans.SecurityAccount                as SecurityAccount,
      _FinTrans.FinancialInstrTransactionType  as FinancialInstrTransactionType,
      Calendar.YearMonth                       as YearMonth,
      Calendar.YearQuarter                     as YearQuarter,
      Calendar.CalendarYear                    as CalendarYear,

      _FlowType,
      _CompanyCode,
      _FinTrans,
      _TransactionCurrency
}
where
  _FlowType.TransFlowTypeIsRelevantForFee = 'X'

Learn More