P_FinTransHistlFcstFeeFlow

private view for combining historical and forecast fee data | view: PHISTLFCSTFEE | Extraction: Not supported | Component: Treasury and Risk Management
Column Name Description
CompanyCode FK Company Code
FinancialTransaction FK Financial Transaction
FinancialInstrumentActivity Transaction Activity
FinTransFlowCreationDate Entered On
FinTransFlowCreationTime Entry Time
FinTransFlowNumber Transaction Flow
FinTransFeeDataSource Data source for FinTrans Fee Show values
Column Name Description
💲 Payment Currency (FinTransFlowPaytAmtCrcy):
FinTransFlowPaytAmt Payment Amount in Payment Currency
Column Name Description
Column Name Description
FinTransFlowCreationDate Entered On
FinTransFlowCreationTime Entry Time
FinTransFlowPaymentDate Payment or Delivery Date
Column Name Description
FinTransFeeDataSource Data source for FinTrans Fee Show values
TreasuryContractType Contract Type Show values
FinTransFlowPostingStatus Posting Status of Flow Show values
Column Name Description Domain name
BankGroup Bank Group ID BU_PARTNER
Counterparty Counterparty number BU_PARTNER
YearMonth Year Month NUM6
YearQuarter Year Quarter NUM5
CalendarYear Calendar Year NUM4
Master Data Relations Join Conditions
Company code
  • Client
  • Company Code
  • P_FINTRANSHISTLFCSTFEEFLOW.MANDT == T001.MANDT
  • P_FINTRANSHISTLFCSTFEEFLOW.COMPANYCODE == T001.BUKRS
Financial Instrument Transaction Type
  • Client
  • Financial Instrument Transaction Type
  • Product Type
  • P_FINTRANSHISTLFCSTFEEFLOW.MANDT == AT10.MANDT
  • P_FINTRANSHISTLFCSTFEEFLOW.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
  • P_FINTRANSHISTLFCSTFEEFLOW.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
Transaction type
  • Client
  • Product Type
  • P_FINTRANSHISTLFCSTFEEFLOW.MANDT == TZPA.MANDT
  • P_FINTRANSHISTLFCSTFEEFLOW.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Financial Transaction
  • Client
  • Company Code
  • Financial Transaction
  • P_FINTRANSHISTLFCSTFEEFLOW.MANDT == VTBFHA.MANDT
  • P_FINTRANSHISTLFCSTFEEFLOW.COMPANYCODE == VTBFHA.BUKRS
  • P_FINTRANSHISTLFCSTFEEFLOW.FINANCIALTRANSACTION == VTBFHA.RFHA
Currency of payment amount
  • Client
  • Payment Currency
  • P_FINTRANSHISTLFCSTFEEFLOW.MANDT == TCURC.MANDT
  • P_FINTRANSHISTLFCSTFEEFLOW.FINTRANSFLOWPAYTAMTCRCY == TCURC.WAERS
Portfolio
  • Client
  • Company Code
  • Portfolio
  • P_FINTRANSHISTLFCSTFEEFLOW.MANDT == TWPOB.MANDT
  • P_FINTRANSHISTLFCSTFEEFLOW.COMPANYCODE == TWPOB.BUKRS
  • P_FINTRANSHISTLFCSTFEEFLOW.PORTFOLIO == TWPOB.RPORTB
Security Account
  • Client
  • Security Account
  • Company Code
  • P_FINTRANSHISTLFCSTFEEFLOW.MANDT == TWD01.MANDT
  • P_FINTRANSHISTLFCSTFEEFLOW.SECURITYACCOUNT == TWD01.RLDEPO
  • P_FINTRANSHISTLFCSTFEEFLOW.COMPANYCODE == TWD01.BUKRS
Transaction Currency
  • Client
  • Transaction Currency
  • P_FINTRANSHISTLFCSTFEEFLOW.MANDT == TCURC.MANDT
  • P_FINTRANSHISTLFCSTFEEFLOW.TRANSACTIONCURRENCY == TCURC.WAERS