P_IRM_Financial_Transaction

leave it here incase future reuse | view: PFINTRANS | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: VTBFHAZUVTBFHA
Column Name Description
CompanyCode FK Company Code
FinancialTransaction Financial Transaction
FinancialInstrumentActivity Last Active Transaction Activity
Column Name Description
Column Name Description
Column Name Description
TermStartDate Term Start
TermEndDate Term End
Column Name Description
TreasuryContractType Contract Type Show values
Column Name Description Domain name
Counterparty Counterparty number BU_PARTNER
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_IRM_FINANCIAL_TRANSACTION.COMPANYCODE == T001.BUKRS
  • P_IRM_FINANCIAL_TRANSACTION.MANDT == T001.MANDT
Portfolio
  • Portfolio
  • Company Code
  • Client
  • P_IRM_FINANCIAL_TRANSACTION.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
  • P_IRM_FINANCIAL_TRANSACTION.COMPANYCODE == TWPOB.BUKRS
  • P_IRM_FINANCIAL_TRANSACTION.MANDT == TWPOB.MANDT
Financial Instrument Product Category P_IRM_FINANCIAL_TRANSACTION.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Financial Instrument Transaction Type
  • Financial Instrument Transaction Type
  • Client
  • Product Type
  • P_IRM_FINANCIAL_TRANSACTION.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
  • P_IRM_FINANCIAL_TRANSACTION.MANDT == AT10.MANDT
  • P_IRM_FINANCIAL_TRANSACTION.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
Transaction type
  • Client
  • Product Type
  • P_IRM_FINANCIAL_TRANSACTION.MANDT == TZPA.MANDT
  • P_IRM_FINANCIAL_TRANSACTION.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Securities Account
  • Securities Account
  • Company Code
  • Client
  • P_IRM_FINANCIAL_TRANSACTION.SECURITYACCOUNT == TWD01.RLDEPO
  • P_IRM_FINANCIAL_TRANSACTION.COMPANYCODE == TWD01.BUKRS
  • P_IRM_FINANCIAL_TRANSACTION.MANDT == TWD01.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_IRM_FINANCIAL_TRANSACTION.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_IRM_FINANCIAL_TRANSACTION.MANDT == TCURC.MANDT