TDCLI_INSURANCE SAP table for – Table of Credit Life Insurance Rates

Here we would like to draw your attention to TDCLI_INSURANCE table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). TDCLI_INSURANCE is a SAP standard transp table used for storing Table of Credit Life Insurance Rates related data in SAP. It comes under the package FVVCL_KLV.

SAP TDCLI_INSURANCE table

Table TDCLI_INSURANCE technical data

TableTDCLI_INSURANCE
Data storingTable of Credit Life Insurance Rates
ModuleFS
Sub ModuleFS-CML-BD-MD
SAP PackageFVVCL_KLV
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-FINSERV
Table CategoryTRANSP

SAP TDCLI_INSURANCE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in TDCLI_INSURANCE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • EXTERNAL_ID : Key for Insurance Rate
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • .INCLUDE : Data Record Structure of Table for CLI Rates
  • PARTNER : Business Partner Number for Insurance Company
    Its data type is CHAR (Character String) with field length 10
  • RATE : Key for Rate at Insurance Company
    Its data type is CHAR (Character String) with field length 10
  • VERSION : Sequential Version Number for Insurance Rate
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DESCRIPTION : Description for Insurance Rate
    Its data type is CHAR (Character String) with field length 30
  • DATE_FROM : Insurance Rate Valid from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_TO : Insurance Rate Valid to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RISK : Risks to Be Covered by This Rate
    Its data type is CHAR (Character String) with field length 8
  • INS_COMP : Name of Insurance Company
    Its data type is CHAR (Character String) with field length 30
  • MAX_SUM_INS : Credit Life Insurance – Maximum Insured Amount
    Its data type is CURR (Currency Field) with field length 15
  • CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MAX_RUNTIME : Maximum Term for Credit Life Insurance in Months
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • MIN_AGE_FROM : Minimum Entry Age for Credit Life Insurance
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • MAX_AGE_FROM : Maximum Entry Age for Credit Life Insurance
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • MAX_AGE_TO : Maximum Age at End of Term for Credit Life Insurance
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • NOT_PER : Notice Period for Credit Life Insurance in Weeks
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • LIMIT_CANC_ORDER : Rescission Period for Credit Life Insurance in Weeks
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • OCCUPATION : Occupational Group Required
    Its data type is CHAR (Character String) with field length 1
  • POLICYHOLDER : Rate for Policyholder
    Its data type is CHAR (Character String) with field length 1