R_FinTransSecurity

Fin. Trans.: Securities Information | view: RFINTRANSSCRTY | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: VTBFHAPOVTBFHAPOT001TKA02VTBFHAVWPANLA
Column Name Description
Column Name Description
💲 Payment Currency (FinTransFlowNomAmtCrcy):
FinTransTradedNomAmt Nominal Amount
FinTransTradedOriglNomAmt Original Nominal Amount
💲 Price Currency (QuotationCurrency):
MarketValueInQtanCurrency Market Value in Quotation Currency
💲 Payment Currency (PaymentCurrency):
MarketValInPaytCurrency Payment Amount in Payment Currency
💲 Currency of Position Amount (PositionCurrency):
MarketValueInPositionCurrency Amount that Changes the Position
💲 Currency Key (LocalCurrency):
MarketValueInLocalCurrency Payment Amount in Local Currency
Column Name Description
Column Name Description
FinTransFlowCreationDate Entered On
FinTransFlowCreationTime Entry Time
Column Name Description
Column Name Description Domain name
FinancialInstrumentActivity Transaction Activity T_RFHAZU
FinTransFlowNumber Transaction Flow T_RFHAZB
FinTransTradedNumberOfUnits No. of Units for Financial Instruments ASTUECK
FinTransTradedPricePercent Security Price for Percentage Quotation VVPKTKUR
FinTransTrdPriceCrcyUnitRate Security Price Without Currency Ref. with Unit Quotation VVPKTKUR
FinTransPaymentCrcyCnvrsnRate Currency Conversion Rate FTR_CRCY_CNVERSN_RATE
FinTransPositionCrcyCnvrsnRate Currency Conversion Rate FTR_CRCY_CNVERSN_RATE
FinTransLoclCrcyCnvrsnRate Currency Conversion Rate FTR_CRCY_CNVERSN_RATE
FinTransSpotPricePercent Current Spot Rate in Percentage VVPKTKUR
FinTransSpotPriceCrcyUnitRate Current Spot Rate in Percentage VVPKTKUR
FinTransMaturitySpotPricePct Spot Rate at Maturity in Percentage VVPKTKUR
FinTransMatSpotPrcCrcyUnitRate Spot Rate at Maturity in Percentage VVPKTKUR
FinTransForwardPriceCostRate Forward Rate Cost VVPKTKUR
FinTransFwdPrcIntrstCompRate Forward Rate Interest DECV9_6
FinTransFwdPrcDividendPercent Percentage of Dividend agreed for Payment in OTC Instruments T_DIV_PCTC_OTC
SecurityClass Security Class ID Number WP_RANL
SecurityAccount Securities Account RLDEPO
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • R_FINTRANSSECURITY.COMPANYCODE == T001.BUKRS
  • R_FINTRANSSECURITY.MANDT == T001.MANDT
Financial Transaction
  • Company Code
  • Client
  • Financial Transaction
  • R_FINTRANSSECURITY.COMPANYCODE == VTBFHA.BUKRS
  • R_FINTRANSSECURITY.MANDT == VTBFHA.MANDT
  • R_FINTRANSSECURITY.FINANCIALTRANSACTION == VTBFHA.RFHA
Currency Key
  • Client
  • Currency Key
  • R_FINTRANSSECURITY.MANDT == TCURC.MANDT
  • R_FINTRANSSECURITY.LOCALCURRENCY == TCURC.WAERS