TICL167 SAP table for – Benefit Type Tree: Sum Insured and Calculation Rules

Here we would like to draw your attention to TICL167 table in SAP. As we know it is being mainly used with the SAP FS-CM (Claims Management in FS) component which is coming under FS module (Financial Services). TICL167 is a SAP standard transp table used for storing Benefit Type Tree: Sum Insured and Calculation Rules related data in SAP. It comes under the package ICL_CDC.

SAP TICL167 table

Table TICL167 technical data

TableTICL167
Data storingBenefit Type Tree: Sum Insured and Calculation Rules
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_CDC
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentINSURANCE
Table CategoryTRANSP

SAP TICL167 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 TICL167 table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BENTREE : Benefit Type Tree
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • GENERAT : Generation of Benefit Type Tree
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • VERSION : Version of Benefit Type Tree
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • BENTYPE : Benefit Type
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ENTRYEXPRESSION : BRF Expression for Calculating Entry Value
    Its data type is CHAR (Character String) with field length 20
  • INSURED_SUM : Sum Insured
    Its data type is CURR (Currency Field) with field length 15
  • SUMEXPRESSION : BRF Expression for Calculating Sum Insured
    Its data type is CHAR (Character String) with field length 20
  • MINSUM : Minimum Sum Insured
    Its data type is CURR (Currency Field) with field length 15
  • MINEXPRESSION : BRF Expression for Calculating the Minimum of Sum Insured
    Its data type is CHAR (Character String) with field length 20
  • MAXSUM : Maximum Sum Insured
    Its data type is CURR (Currency Field) with field length 15
  • MAXEXPRESSION : BRF Expression for Calculating Maximum of Sum Insured
    Its data type is CHAR (Character String) with field length 20
  • CALCEXPRESSION : BRF Expression for Calculating Payout Amount
    Its data type is CHAR (Character String) with field length 20
  • RBENTYPE : Benefit Type of Reference Benefit Type in Contract
    Its data type is CHAR (Character String) with field length 10
  • RCOVTYPE : Coverage Type of Reference Coverage Type in Contract
    Its data type is CHAR (Character String) with field length 10
  • PERCENT : Reference Sum Insured in Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SUMCALCORDER : Calculation Rule for Sum Insured
    Its data type is CHAR (Character String) with field length 1