C_DebtAndInvestmentAnalysis

Column Name Description
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
KeyDate Key Date
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
FinancialInstrumentProductType Product Type VVSART
FinancialInstrTransactionType Financial Instrument Transaction Type T_SFHAART
Counterparty Counterparty number BU_PARTNER
Issuer Issuer Identity Key BU_PARTNER
DifferentiationPortfolio Portfolio RPORTB
ReferenceInterestRate Reference Interest Rate ZIREFKU
FreeAttributeLi01 null
FreeAttributeLi02 null
CreditRatingAgency Institute Providing Credit Standing Information BP_SOL_INS
SecurityClassCreditRating Rating BP_RATING
SecurityAccountGroup Securities Account Group TPM_SEC_ACCT_GRP
RiskAnalyzerKeyFigure Key Figure AFWKF_DEFINITION_NEW
TreasuryFinancialObject Object number J_OBJNR
ConditionItemIndex Condition T_KOND
CompanyCodeName Name of Company Code or Company TEXT25
FinancialInstrProdTypeName Name of the Product Type TEXT30
FinancialInstrTransTypeName Name of Financial Instrument Transaction Type T_XTEXT30
TrsyCshFlowDebtInvmtCodeName Short Text for Fixed Values DDTEXT
FixedVariableInterestCatName Short Text for Fixed Values DDTEXT
LongText Long text for reference interest rate TEXT60
IssuerFullName null
CounterpartyFullName Business Partner Name
CurrencyShortName Short text TEXT15
PortfolioName Name of the Portfolio TEXT30
CountryName Country/Region Name TEXT50
SecurityAccountName Name of the Security Account XLDEPO
SecurityClassName Name of the Security Class XKBEZ
SecurityAccountGroupName Name of Securities Account Group FTR_GEN_DESCRIPTION
CreditRatingAgencyName Name of Credit Rating Institute TEXT30
SecurityClassCreditRatingName Rating Description TEXT40
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • C_DEBTANDINVESTMENTANALYSIS.COUNTRY == T005.LAND1
  • C_DEBTANDINVESTMENTANALYSIS.MANDT == T005.MANDT