P_FTR_FS_TPM_DS3

TPM data source for Periods | view: PFTRFSTPMDS3 | Extraction: Not supported | Component: Treasury and Risk Management
Column Name Description
Column Name Description
💲 Nominal Currency (NominalCurrency):
NominalAmountInNominalCurrency Nominal Amount
💲 Position Currency (TransactionCurrency):
BookValueAmtInPositionCurrency Book Value in Position Currency
UtilizedAmountInTransCrcy Utilized Amount in Transaction Currency
TotalAmountInTransactionCrcy Credit Line in Transaction Currency
Column Name Description
Column Name Description
TransactionDate Treasury Ledger Date
TreasuryPositionZeroDate Date of Zero Position
Column Name Description
FinancialPositionDataSource Data Source Show values
FinInstrProductGroup Financial Instrument Product Group Show values
TreasuryPosAssetLiabilityCode Assets/Liabilities Position Show values
TreasuryBusinessTransStatus Status of a Business Transaction Show values
Column Name Description Domain name
Portfolio Portfolio RPORTB
Issuer Issuer Identity Key BU_PARTNER
Counterparty Counterparty number BU_PARTNER
GLAccount G/L Account SAKNR
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
FiscalYear Fiscal Year GJAHR
AccountingDocumentType Journal Entry Type BLART
Ledger Ledger in General Ledger Accounting FINS_LEDGER
AccountingDocument Document Number of an Accounting Document BELNR
CommitmentBusinessPartner Partner with Whom Commitment Exists BU_PARTNER
BankInBankGroup Partner with Whom Commitment Exists BU_PARTNER
Master Data Relations | to Other Relations ↓ Join Conditions
Business Area
  • Client
  • Business Area
  • P_FTR_FS_TPM_DS3.MANDT == TGSB.MANDT
  • P_FTR_FS_TPM_DS3.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • P_FTR_FS_TPM_DS3.COMPANYCODE == T001.BUKRS
  • P_FTR_FS_TPM_DS3.MANDT == T001.MANDT
Portfolio as Differentiation Characteristic
  • Company Code
  • Portfolio as Differentiation Characteristic
  • Client
  • P_FTR_FS_TPM_DS3.COMPANYCODE == TWPOB.BUKRS
  • P_FTR_FS_TPM_DS3.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
  • P_FTR_FS_TPM_DS3.MANDT == TWPOB.MANDT
Financial Instrument Transaction Type
  • Financial Instrument Transaction Type
  • Client
  • ?
  • P_FTR_FS_TPM_DS3.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
  • P_FTR_FS_TPM_DS3.MANDT == AT10.MANDT
  • P_FTR_FS_TPM_DS3.[column in domain "VVSART"] == AT10.SGSART
Product Type
  • Product Type
  • Client
  • P_FTR_FS_TPM_DS3.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
  • P_FTR_FS_TPM_DS3.MANDT == TZPA.MANDT
Transaction Number
  • Company Code
  • Financial Transaction
  • Client
  • P_FTR_FS_TPM_DS3.COMPANYCODE == VTBFHA.BUKRS
  • P_FTR_FS_TPM_DS3.FINANCIALTRANSACTION == VTBFHA.RFHA
  • P_FTR_FS_TPM_DS3.MANDT == VTBFHA.MANDT
Security Account
  • Company Code
  • Security Account
  • Client
  • P_FTR_FS_TPM_DS3.COMPANYCODE == TWD01.BUKRS
  • P_FTR_FS_TPM_DS3.SECURITYACCOUNT == TWD01.RLDEPO
  • P_FTR_FS_TPM_DS3.MANDT == TWD01.MANDT
Security Class
  • Client
  • Security Class
  • P_FTR_FS_TPM_DS3.MANDT == VWPANLA.MANDT
  • P_FTR_FS_TPM_DS3.SECURITYCLASS == VWPANLA.RANL
Foreign Key Futures Account
  • Company Code
  • Futures Account for Listed Options and Futures
  • Client
Valuation Class
  • Treasury Valuation Area
  • Valuation Class
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Company Code
  • Securities Account Group
  • Client
Treasury Valuation Area
  • Treasury Valuation Area
  • Client