TDCLI_INS_1 SAP (Table of Credit Life Insurance Rates) Table details
Dictionary Type: Table
Description: Table of Credit Life Insurance Rates
Description: Table of Credit Life Insurance Rates
Table field list including key, data, relationships and ABAP select examples
TDCLI_INS_1 is a standard SAP Table which is used to store Table of Credit Life Insurance Rates data and is available within R/3 SAP systems depending on the version and release level.
The TDCLI_INS_1 table consists of various fields, each holding specific information or linking keys about Table of Credit Life Insurance Rates data available in SAP. These include PARTNER (Business Partner Number for Insurance Company), RATE (Key for Rate at Insurance Company), VERSION (Sequential Version Number for Insurance Rate), DESCRIPTION (Description for Insurance Rate).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TDCLI_INS_1 table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| EXTERNAL_ID | Key for Insurance Rate | TB_CLI_EXTERNAL_RATE | CHAR | 8 | CHAR08 | ||||
| PARTNER | Business Partner Number for Insurance Company | TB_CLI_INSURANCE_PARTNER | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
| RATE | Key for Rate at Insurance Company | TB_CLI_INSURENCE_RATE | CHAR | 10 | ALPHA | T_CLI_INSURANCE_RATE | |||
| VERSION | Sequential Version Number for Insurance Rate | TB_CLI_INSURANCE_VERSION | NUMC | 3 | T_CLI_INSURANCE_VERSION | ||||
| DESCRIPTION | Description for Insurance Rate | TB_CLI_DESCRIPTION | CHAR | 30 | T_CLI_UPPER_LOWER_CASE | ||||
| DATE_FROM | Insurance Rate Valid from | TB_CLI_DATE_FROM | DATS | 8 | DATUM | ||||
| DATE_TO | Insurance Rate Valid to | TB_CLI_DATE_TO | DATS | 8 | DATUM | ||||
| RISK | Risks to Be Covered by This Rate | TB_CLI_RISK | CHAR | 8 | T_CLI_RISK | ||||
| INS_COMP | Name of Insurance Company | TB_CLI_INSURANCE_COMPANY | CHAR | 30 | T_CLI_UPPER_LOWER_CASE | ||||
| MAX_SUM_INS | Credit Life Insurance - Maximum Insured Amount | TB_CLI_MAX_SUM_INSURED | CURR | 15(2) | WERTV8 | ||||
| CURR | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| MAX_RUNTIME | Maximum Term for Credit Life Insurance in Months | TB_CLI_MAX_RUNTIME | NUMC | 3 | NUM03 | ||||
| MIN_AGE_FROM | Minimum Entry Age for Credit Life Insurance | TB_CLI_MIN_FROM_AGE | NUMC | 2 | NUM02 | ||||
| MAX_AGE_FROM | Maximum Entry Age for Credit Life Insurance | TB_CLI_MAX_FROM_AGE | NUMC | 2 | NUM02 | ||||
| MAX_AGE_TO | Maximum Age at End of Term for Credit Life Insurance | TB_CLI_MAX_TO_AGE | NUMC | 2 | NUM02 | ||||
| NOT_PER | Notice Period for Credit Life Insurance in Weeks | TB_CLI_NOTICE_PERIOD | NUMC | 1 | NUM1 | ||||
| LIMIT_CANC_ORDER | Rescission Period for Credit Life Insurance in Weeks | TB_CLI_TIME_CANCELLED_OF_ORDER | NUMC | 1 | NUM01 | ||||
| OCCUPATION | Occupational Group Required | TB_CLI_OCCUPATION_REQUIRED | CHAR | 1 | T_CLI_BOOLE | ||||
| POLICYHOLDER | Rate for Policyholder | TB_CLI_TARIFF_FOR_POLICYHOLDER | CHAR | 1 | T_CLI_BOOLE |
| Key field | Non-key field |
How do I retrieve data from SAP table TDCLI_INS_1 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TDCLI_INS_1 to SELECT all data from the tableDATA: WA_TDCLI_INS_1 TYPE TDCLI_INS_1.
SELECT SINGLE *
FROM TDCLI_INS_1
INTO CORRESPONDING FIELDS OF WA_TDCLI_INS_1
WHERE...
How to access SAP table TDCLI_INS_1
Within an ECC or HANA version of SAP you can also view further information about TDCLI_INS_1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects