P_FTR_FS_FIB_DS3

FIB data source for Periods | view: PFTRFSFIBDS3 | Extraction: Not supported | Component: Treasury and Risk Management
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
BookValueAmtInPositionCurrency Amount in Transaction Currency
UtilizedAmountInTransCrcy Utilized Amount in Transaction Currency
TotalAmountInTransactionCrcy Credit Line in Transaction Currency
💲 Transaction Currency (NominalCurrency):
NominalAmountInNominalCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
TransactionDate Posting Date
FiscalYearEndDate End Date of Fiscal Year
FiscalYearStartDate Start Date of Fiscal Year
Column Name Description
FinancialPositionDataSource Data Source Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
TreasuryValuationArea Treasury Valuation Area TPM_VAL_AREA
FinancialInstrumentProductType Product Type VVSART
FinancialInstrTransactionType Financial Transaction Type T_SFHAART
TreasuryValuationClass Valuation Class TPM_VAL_CLASS
Portfolio Portfolio RPORTB
SecurityAccount Security Account RLDEPO
SecurityClass Security Class WP_RANL
TreasuryPositionAccount Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
FinancialTransaction Financial Transaction T_RFHA
Issuer Issuer Identity Key BU_PARTNER
Counterparty Counterparty number BU_PARTNER
CommitmentBusinessPartner Partner with Whom Commitment Exists BU_PARTNER
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_FTR_FS_FIB_DS3.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_FTR_FS_FIB_DS3.MANDT == T003.MANDT
Bank In Bank Group
  • Client
  • Bank In Bank Group
  • P_FTR_FS_FIB_DS3.MANDT == BUT000.CLIENT
  • P_FTR_FS_FIB_DS3.BANKINBANKGROUP == BUT000.PARTNER
Business Area
  • Business Area
  • Client
  • P_FTR_FS_FIB_DS3.BUSINESSAREA == TGSB.GSBER
  • P_FTR_FS_FIB_DS3.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_FTR_FS_FIB_DS3.CHARTOFACCOUNTS == T004.KTOPL
  • P_FTR_FS_FIB_DS3.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_FTR_FS_FIB_DS3.COMPANYCODE == T001.BUKRS
  • P_FTR_FS_FIB_DS3.MANDT == T001.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_FTR_FS_FIB_DS3.COMPANYCODE == SKB1.BUKRS
  • P_FTR_FS_FIB_DS3.GLACCOUNT == SKB1.SAKNR
  • P_FTR_FS_FIB_DS3.MANDT == SKB1.MANDT
House Bank Key
  • ?
  • House Bank Key
  • Client
  • P_FTR_FS_FIB_DS3.[column in domain "BUKRS"] == T012.BUKRS
  • P_FTR_FS_FIB_DS3.HOUSEBANK == T012.HBKID
  • P_FTR_FS_FIB_DS3.MANDT == T012.MANDT
House Bank Account
  • ?
  • House Bank Key
  • House Bank Account
  • Client
  • P_FTR_FS_FIB_DS3.[column in domain "BUKRS"] == T012K.BUKRS
  • P_FTR_FS_FIB_DS3.HOUSEBANK == T012K.HBKID
  • P_FTR_FS_FIB_DS3.HOUSEBANKACCOUNT == T012K.HKTID
  • P_FTR_FS_FIB_DS3.MANDT == T012K.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • P_FTR_FS_FIB_DS3.NOMINALCURRENCY == TCURC.WAERS
  • P_FTR_FS_FIB_DS3.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_FTR_FS_FIB_DS3.MANDT == TCURC.MANDT
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • P_FTR_FS_FIB_DS3.NOMINALCURRENCY == TCURC.WAERS
  • P_FTR_FS_FIB_DS3.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_FTR_FS_FIB_DS3.MANDT == TCURC.MANDT