P_FinTransFinancialObjectData

Financial Transaction - Financial Object Data | view: PFINTRANFODAT | TRAN | Extraction: Not supported | Component: Analyzer
Tables used: T001TKA02VTBFHA
Column Name Description
CompanyCode FK Company Code
FinancialTransaction Financial Transaction
Column Name Description
Column Name Description
Column Name Description
FinTransCreationDate Entered On
FinTransCreationTime Entry Time
LastChangeDate Last Change Date
FinInstrumentLastChangedTime Time Changed
TermStartDate Term Start
TermEndDate Term End
Column Name Description
TreasuryContractType Contract Type Show values
TermStartDateIsInclusive Truth Value: True/False Show values
FinTransNoticePeriodUnit Unit of Period of Notice Show values
Column Name Description Domain name
CreatedByUser Entered By SYCHAR12
LastChangedByUser Last Changed By User XUBNAME
FinTransNoticePeriod Period of Notice T_AKUEND
Counterparty Counterparty number BU_PARTNER
FinancialInstrumentGuarantor Guarantor of Financial Transaction BU_PARTNER
TreasuryFinanceProject Finance Project T_TFPROJ
FinancialInstrumentAssignment Free Assignment of Financial Transaction TEXT18
FinancialInstrumentReference Financial Instrument Free Internal Reference CHAR16
FinancialInstrCharacteristic Financial Instrument Free Characteristic CHAR25
SecurityClass Security Class WP_RANL
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • P_FINTRANSFINANCIALOBJECTDATA.COMPANYCODE == T001.BUKRS
  • P_FINTRANSFINANCIALOBJECTDATA.MANDT == T001.MANDT
Financial Instrument Product Category P_FINTRANSFINANCIALOBJECTDATA.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Financial Instrument Transaction Type
  • Client
  • Product Type
  • Financial Instrument Transaction Type
  • P_FINTRANSFINANCIALOBJECTDATA.MANDT == AT10.MANDT
  • P_FINTRANSFINANCIALOBJECTDATA.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
  • P_FINTRANSFINANCIALOBJECTDATA.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
Transaction type
  • Client
  • Product Type
  • P_FINTRANSFINANCIALOBJECTDATA.MANDT == TZPA.MANDT
  • P_FINTRANSFINANCIALOBJECTDATA.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Transaction Category
  • Transaction Category
  • Financial Instrument Product Category
  • P_FINTRANSFINANCIALOBJECTDATA.FININSTRTRANSACTIONCATEGORY == AT01.SFGTYP
  • P_FINTRANSFINANCIALOBJECTDATA.FINANCIALINSTRPRODUCTCATEGORY == AT01.SANLFOR
Factory calendar P_FINTRANSFINANCIALOBJECTDATA.FINTRANSFACTORYCALENDAR1 == TFACD.IDENT
Factory calendar P_FINTRANSFINANCIALOBJECTDATA.FINTRANSFACTORYCALENDAR2 == TFACD.IDENT
Processing Category
  • Processing Category
  • Transaction Category
  • Financial Instrument Product Category
  • P_FINTRANSFINANCIALOBJECTDATA.FINTRANSPROCESSINGCATEGORY == AT05.ABWTYP
  • P_FINTRANSFINANCIALOBJECTDATA.FININSTRTRANSACTIONCATEGORY == AT05.SFGTYP
  • P_FINTRANSFINANCIALOBJECTDATA.FINANCIALINSTRPRODUCTCATEGORY == AT05.SANLF
Portfolio
  • Company Code
  • Client
  • Portfolio
  • P_FINTRANSFINANCIALOBJECTDATA.COMPANYCODE == TWPOB.BUKRS
  • P_FINTRANSFINANCIALOBJECTDATA.MANDT == TWPOB.MANDT
  • P_FINTRANSFINANCIALOBJECTDATA.PORTFOLIO == TWPOB.RPORTB
Security Account
  • Company Code
  • Security Account
  • Client
  • P_FINTRANSFINANCIALOBJECTDATA.COMPANYCODE == TWD01.BUKRS
  • P_FINTRANSFINANCIALOBJECTDATA.SECURITYACCOUNT == TWD01.RLDEPO
  • P_FINTRANSFINANCIALOBJECTDATA.MANDT == TWD01.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_FINTRANSFINANCIALOBJECTDATA.MANDT == TCURC.MANDT
  • P_FINTRANSFINANCIALOBJECTDATA.TRANSACTIONCURRENCY == TCURC.WAERS