C_Ftr_Cl_Utilize_Query

Credit Line Analysis | view: CFTRCLUTILQUERY | Extraction: Not supported | Component: Treasury and Risk Management
Column Name Description
CompanyCode Company Code
FinancialTransaction Financial Transaction
KeyDate Key Date
Column Name Description
💲 Transaction Currency (TransactionCurrency):
TotalAmountInTransactionCrcy Credit Line in Transaction Currency
UtilizedAmountInTransCrcy Utilized Amount in Transaction Currency
AvailableAmountInTransCrcy Available Amount in Transaction Currency
💲 Display Currency (DisplayCurrency):
TotalAmountInDisplayCrcy Credit Line in Display Currency
UtilizedAmountInDisplayCrcy Utilized Amount in Display Currency
AvailableAmountInDisplayCrcy Available Amount in Display Currency
Column Name Description
Column Name Description
KeyDate Key Date
Column Name Description
Column Name Description Domain name
Counterparty Counterparty number BU_PARTNER
SyndicatedCounterparty Syndicated Counterparty BU_PARTNER
CreditLineReportingPeriod Reporting Period
CreditLineUtilizationRatio Utilization Rate (%)
CrdtLineUnderUtilizationRatio Underutilization Rate (%)
ExchangeRateType null
Master Data Relations Join Conditions
Country/Region Key of Company Code
  • Country/Region Key of Company Code
  • Client
  • C_FTR_CL_UTILIZE_QUERY.COMPANYCODECOUNTRY == T005.LAND1
  • C_FTR_CL_UTILIZE_QUERY.MANDT == T005.MANDT
Financial Instrument Product Category C_FTR_CL_UTILIZE_QUERY.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Financial Instrument Transaction Type
  • Product Type
  • Client
  • Financial Instrument Transaction Type
  • C_FTR_CL_UTILIZE_QUERY.FINANCIALINSTRUMENTPRODUCTTYPE == AT10.SGSART
  • C_FTR_CL_UTILIZE_QUERY.MANDT == AT10.MANDT
  • C_FTR_CL_UTILIZE_QUERY.FINANCIALINSTRTRANSACTIONTYPE == AT10.SFHAART
Transaction type
  • Product Type
  • Client
  • C_FTR_CL_UTILIZE_QUERY.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
  • C_FTR_CL_UTILIZE_QUERY.MANDT == TZPA.MANDT
Transaction Category
  • Transaction Category
  • ?
  • C_FTR_CL_UTILIZE_QUERY.FININSTRTRANSACTIONCATEGORY == AT01.SFGTYP
  • C_FTR_CL_UTILIZE_QUERY.[column in domain "TB_SANLF"] == AT01.SANLFOR
Portfolio
  • ?
  • Portfolio
  • Client
  • C_FTR_CL_UTILIZE_QUERY.[column in domain "BUKRS"] == TWPOB.BUKRS
  • C_FTR_CL_UTILIZE_QUERY.PORTFOLIO == TWPOB.RPORTB
  • C_FTR_CL_UTILIZE_QUERY.MANDT == TWPOB.MANDT