TDCLI_INSURANCE SAP (Table of Credit Life Insurance Rates) Table details
Description: Table of Credit Life Insurance Rates
Related tables to TDCLI_INSURANCE
Access table TDCLI_INSURANCE
Table field list including key, data, relationships and ABAP select examples
TDCLI_INSURANCE 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_INSURANCE 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 EXTERNAL_ID (Key for Insurance Rate), PARTNER (Business Partner Number for Insurance Company), RATE (Key for Rate at Insurance Company), VERSION (Sequential Version Number 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)
Text table = TDCLI_INSURANCET
SAP TDCLI_INSURANCE 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
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_INSURANCE using ABAP code
The following ABAP code Example will allow you to do a basic selection on TDCLI_INSURANCE to SELECT all data from the tableDATA: WA_TDCLI_INSURANCE TYPE TDCLI_INSURANCE.
SELECT SINGLE *
FROM TDCLI_INSURANCE
INTO CORRESPONDING FIELDS OF WA_TDCLI_INSURANCE
WHERE...
How to access SAP table TDCLI_INSURANCE
Within an ECC or HANA version of SAP you can also view further information about TDCLI_INSURANCE 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