P_FinTransOpenFlowBusVol

The Business Volume for Open Trans Flow | view: PTRANSOPENBUSVOL | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: SCAL_TT_DATE, TLCT_ACTIVITY, VTBFHAZU, VTBFHAPO, VTBFHAPO_UNFIXED, T001, TKA02, VTBFHA, AT06
Column Name Description
CompanyCode FK Company Code
FinancialTransaction FK Financial Transaction
FinancialInstrumentActivity Transaction Activity
KeyDate Key Date
FinTransFlowCreationDate Entered On
FinTransFlowCreationTime Entry Time
FinTransFlowNumber Transaction Flow
Column Name Description
💲 Valuation Currency (TransactionCurrency):
AmountInTransactionCurrency null
FinTransFlowNomAmt Payment Amount in Payment Currency
FinTransFlowPaytAmt Payment Amount in Payment Currency
Column Name Description
Column Name Description
KeyDate Key Date
FinTransFlowCreationDate Entered On
FinTransFlowCreationTime Entry Time
FinTransFlowPaymentDate Payment or Delivery Date
Column Name Description
FinancialTransactionDirection Direction of Transaction Show values
FinTransFlowPaytAmtDirection Direction of Flow Show values
FinTransProductGroup product group for Fin Trans Show values
Column Name Description Domain name
Counterparty Counterparty number BU_PARTNER
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_FINTRANSOPENFLOWBUSVOL.COMPANYCODE == T001.BUKRS
  • P_FINTRANSOPENFLOWBUSVOL.MANDT == T001.MANDT
Transaction Activity Category
  • ?
  • ?
  • Transaction Activity Category
  • P_FINTRANSOPENFLOWBUSVOL.[column in domain "TB_SFGTYP"] == AT02.SFGTYP
  • P_FINTRANSOPENFLOWBUSVOL.[column in domain "TB_SANLF"] == AT02.SANLFOR
  • P_FINTRANSOPENFLOWBUSVOL.FINANCIALINSTRACTIVITYCATEGORY == AT02.SFGZUSTT
Financial Instrument Product Category P_FINTRANSOPENFLOWBUSVOL.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Financial Instrument Transaction Type
  • Client
  • Financial Instrument Transaction Type
  • Product Type
  • P_FINTRANSOPENFLOWBUSVOL.MANDT == AT10.MANDT
  • P_FINTRANSOPENFLOWBUSVOL.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
  • P_FINTRANSOPENFLOWBUSVOL.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
Transaction type
  • Client
  • Product Type
  • P_FINTRANSOPENFLOWBUSVOL.MANDT == TZPA.MANDT
  • P_FINTRANSOPENFLOWBUSVOL.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Financial Transaction
  • Company Code
  • Client
  • Financial Transaction
  • P_FINTRANSOPENFLOWBUSVOL.COMPANYCODE == VTBFHA.BUKRS
  • P_FINTRANSOPENFLOWBUSVOL.MANDT == VTBFHA.MANDT
  • P_FINTRANSOPENFLOWBUSVOL.FINANCIALTRANSACTION == VTBFHA.RFHA
Currency of payment amount
  • Client
  • Payment Currency
  • Payment Currency
  • P_FINTRANSOPENFLOWBUSVOL.MANDT == TCURC.MANDT
  • P_FINTRANSOPENFLOWBUSVOL.FINTRANSFLOWNOMAMTCRCY == TCURC.WAERS
  • P_FINTRANSOPENFLOWBUSVOL.FINTRANSFLOWPAYTAMTCRCY == TCURC.WAERS
Currency of payment amount
  • Client
  • Payment Currency
  • Payment Currency
  • P_FINTRANSOPENFLOWBUSVOL.MANDT == TCURC.MANDT
  • P_FINTRANSOPENFLOWBUSVOL.FINTRANSFLOWNOMAMTCRCY == TCURC.WAERS
  • P_FINTRANSOPENFLOWBUSVOL.FINTRANSFLOWPAYTAMTCRCY == TCURC.WAERS
Portfolio
  • Company Code
  • Client
  • Portfolio
  • P_FINTRANSOPENFLOWBUSVOL.COMPANYCODE == TWPOB.BUKRS
  • P_FINTRANSOPENFLOWBUSVOL.MANDT == TWPOB.MANDT
  • P_FINTRANSOPENFLOWBUSVOL.PORTFOLIO == TWPOB.RPORTB
Security Account
  • Company Code
  • Client
  • Security Account
  • P_FINTRANSOPENFLOWBUSVOL.COMPANYCODE == TWD01.BUKRS
  • P_FINTRANSOPENFLOWBUSVOL.MANDT == TWD01.MANDT
  • P_FINTRANSOPENFLOWBUSVOL.SECURITYACCOUNT == TWD01.RLDEPO