I_DebtAndInvestmentAnalysis

Column Name Description
TreasuryFinancialObject Object number
ConditionItemIndex Condition
CreditRatingAgency Institute Providing Credit Standing Information
Column Name Description
💲 Nominal Currency (NominalCurrency):
NominalAmountInNominalCurrency Nominal Amount
💲 Position Currency (PositionCurrency):
BookValueAmtInPositionCurrency Book Value in Position Currency
💲 Evaluation Currency (ValuationCurrency):
NetPresentValueInValuationCrcy Net Present Value of OTC Transaction
💲 null (DisplayCurrency):
NominalAmountInReportingCrcy Financial Position Amount in Display Currency
BookValueAmountInReportingCrcy Financial Position Amount in Display Currency
NetPresentValueInDisplayCrcy Net Present Value of OTC Transaction
Column Name Description
Column Name Description
Column Name Description
TrsyCshFlowDebtInvmtCode Debt Investment Indicator Show values
FixedVariableInterestRateCat Interest Rate Category (for Interest Rate Management) Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
FinancialTransaction Financial Transaction T_RFHA
SecurityAccount Security Account RLDEPO
SecurityClass Security Class WP_RANL
FinancialInstrProductCategory Product Category VVSANLF
FinancialInstrumentProductType Product Type VVSART
Counterparty Counterparty number BU_PARTNER
Issuer Issuer Identity Key BU_PARTNER
ReferenceInterestRate Reference Interest Rate ZIREFKU
SecurityClassCreditRating Rating BP_RATING
SecurityAccountGroup Securities Account Group TPM_SEC_ACCT_GRP
RiskAnalyzerKeyFigure Key Figure AFWKF_DEFINITION_NEW
HasError Single-Character Flag CHAR1
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • I_DEBTANDINVESTMENTANALYSIS.COUNTRY == T005.LAND1
  • I_DEBTANDINVESTMENTANALYSIS.MANDT == T005.MANDT
Portfolio
  • Portfolio
  • ?
  • Client
  • I_DEBTANDINVESTMENTANALYSIS.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
  • I_DEBTANDINVESTMENTANALYSIS.[column in domain "BUKRS"] == TWPOB.BUKRS
  • I_DEBTANDINVESTMENTANALYSIS.MANDT == TWPOB.MANDT
Financial Instrument Transaction Type
  • Financial Instrument Transaction Type
  • Client
  • ?
  • I_DEBTANDINVESTMENTANALYSIS.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
  • I_DEBTANDINVESTMENTANALYSIS.MANDT == AT10.MANDT
  • I_DEBTANDINVESTMENTANALYSIS.[column in domain "VVSART"] == AT10.SGSART