I_FinTransMainFlow

DDL: I_FINTRANSMAINFLOW SQL: IFINTRANSMAINFLW Type: view COMPOSITE Package: FTTR_CORE

Financial Transaction Main Flow

I_FinTransMainFlow is a Composite CDS View that provides data about "Financial Transaction Main Flow" in SAP S/4HANA. It reads from 1 data source (I_FinTransFlow) and exposes 39 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowCreationDate, FinTransFlowCreationTime. Part of development package FTTR_CORE.

1 data source(s) 39 fields

Data Sources (1)

SourceAliasJoin Type
I_FinTransFlow Flow from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IFINTRANSMAINFLW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Financial Transaction Main Flow view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view

Fields (39)

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
TreasuryContractType I_FinTransFlow TreasuryContractType
FinancialTransactionDirection I_FinTransFlow FinancialTransactionDirection
FinTransFlowType I_FinTransFlow FinTransFlowType
FinTransFlowPaytAmtDirection I_FinTransFlow FinTransFlowPaytAmtDirection
FinTransFlowPaymentDate I_FinTransFlow FinTransFlowPaymentDate
FinTransFlowPaytAmt I_FinTransFlow FinTransFlowPaytAmt
FinTransFlowPaytAmtCrcy I_FinTransFlow FinTransFlowPaytAmtCrcy
FinTransFlowInLoclCrcyPaytAmt I_FinTransFlow FinTransFlowInLoclCrcyPaytAmt
LocalCurrency I_FinTransFlow LocalCurrency
FinTransFlowLoclCrcyCnvrsnRate I_FinTransFlow FinTransFlowLoclCrcyCnvrsnRate
FinTransFlowNomAmt I_FinTransFlow FinTransFlowNomAmt
FinTransFlowNomAmtCrcy I_FinTransFlow FinTransFlowNomAmtCrcy
FinTransFlowPositionAmount I_FinTransFlow FinTransFlowPositionAmount
FinTransFlwPosAmtCrcy I_FinTransFlow FinTransFlwPosAmtCrcy
AssignmentReference I_FinTransFlow AssignmentReference
FinTransFlwLoclCrcyAmtCalcType I_FinTransFlow FinTransFlwLoclCrcyAmtCalcType
FinTransFlowCalculationDate I_FinTransFlow FinTransFlowCalculationDate
FlowCalcDateIsExclusive I_FinTransFlow FlowCalcDateIsExclusive
FlowCalcDateIsMonthEnd I_FinTransFlow FlowCalcDateIsMonthEnd
FinTransPaytRateInPercent I_FinTransFlow FinTransPaytRateInPercent
FinTransFlowStatus I_FinTransFlow FinTransFlowPostingStatus
FinTransFlowFixingStatus I_FinTransFlow FinTransFlowPostingStatus
PaymentWithAccruedIntrstAmount I_FinTransFlow PaymentWithAccruedIntrstAmount
_CompanyCode _CompanyCode
_FinTrans _FinTrans
_Activity _Activity
_ContractType _ContractType
_FlowType _FlowType
_PaymentCurrency _PaymentCurrency
_NominalCurrency _NominalCurrency
_PositionCurrency _PositionCurrency
_LocalCurrency _LocalCurrency
_Direction _Direction 
@AbapCatalog.sqlViewName: 'IFINTRANSMAINFLW'
@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 Main 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_FinTransMainFlow
  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,
      @Semantics.amount.currencyCode: 'FinTransFlowNomAmtCrcy'
      Flow.FinTransFlowNomAmt             as FinTransFlowNomAmt,
      @ObjectModel.foreignKey.association: '_NominalCurrency'
      Flow.FinTransFlowNomAmtCrcy         as FinTransFlowNomAmtCrcy,
      @Semantics.amount.currencyCode: 'FinTransFlwPosAmtCrcy'
      Flow.FinTransFlowPositionAmount     as FinTransFlowPositionAmount,
      @ObjectModel.foreignKey.association: '_PositionCurrency'
      Flow.FinTransFlwPosAmtCrcy          as FinTransFlwPosAmtCrcy,
      Flow.AssignmentReference            as AssignmentReference,
      Flow.FinTransFlwLoclCrcyAmtCalcType as FinTransFlwLoclCrcyAmtCalcType,
      Flow.FinTransFlowCalculationDate    as FinTransFlowCalculationDate,
      Flow.FlowCalcDateIsExclusive        as FlowCalcDateIsExclusive,
      Flow.FlowCalcDateIsMonthEnd         as FlowCalcDateIsMonthEnd,
      Flow.FinTransPaytRateInPercent      as FinTransPaytRateInPercent,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'FinTransFlowFixingStatus'
      Flow.FinTransFlowPostingStatus      as FinTransFlowStatus,
      Flow.FinTransFlowPostingStatus      as FinTransFlowFixingStatus,
      @Semantics.amount.currencyCode: 'FinTransFlowNomAmtCrcy'
      Flow.PaymentWithAccruedIntrstAmount as PaymentWithAccruedIntrstAmount,

      //exposed dimensions

      _CompanyCode,
      _FinTrans,
      _Activity,
      _ContractType,
      _FlowType,
      _PaymentCurrency,
      _NominalCurrency,
      _PositionCurrency,
      _LocalCurrency,
      _Direction
}
where
     Flow.FinTransFlowCategory = '10'
  or Flow.FinTransFlowCategory = '11'

Learn More