dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table CMS_INS

Insurance Application Table

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table CMS_INS (Insurance Application Table) is a standard table in SAP ERP. It belongs to the package CMS_OMS_RIG.

Technical Information

Table CMS_INS
Short Text Insurance Application Table
Package CMS_OMS_RIG
Table Type Transparent Table

Fields for Table CMS_INS

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 *
INS_GUID ✔ Insurance GUID CMS_DTE_INS_GUID RAW 16
INS_CATEGORY Object Category CMS_DTE_OMS_OBJ_CAT CHAR 6 *
INS_TYP Insurance Type CMS_DTE_INS_TYPE CHAR 6 *
INS_ID Insurance ID CMS_DTE_INS_ID CHAR 40
INS_DESC Insurance Description CMS_DTE_INS_DESC CHAR 30
INSUR_TAX_DB Insurance tax to the debit of the bank CMS_DTE_INS_TAX_DB CHAR 1
SETLMNT_TYPE Type of settlement CMS_DTE_INS_SETLMNT_TYPE CHAR 6 TCMS_ATT_ID_TY
INSUR_SUM Insurance Sum CMS_DTE_INS_SUM CURR 17
INSUR_CURR Insurance Currency CMS_DTE_INS_CURR CUKY 5 TCURC
PRM_RT Premium Rate CMS_DTE_INS_PRM_RT DEC 10
INSUR_PREMIUM Insurance Premium CMS_DTE_INS_PRM CURR 17
INSUR_PRM_CURR Insurance Currency CMS_DTE_INS_CURR CUKY 5 TCURC
INSUR_TAX_RT Insurance tax rate (in %) CMS_DTE_INS_TAX_RT DEC 10
INSUR_TAX_AMT Insurance tax amount CMS_DTE_INS_TAX_AMT CURR 17
INSUR_TAX_CURR Tax Currency CMS_DTE_INS_TAX_CURR CUKY 5 TCURC
SCOPE_INS_COVER not used -> package has to be changed CMS_OMS_INS CMS_DTE_INS_COVER CHAR 6
EXT_ITM_NO Ext. Item no / Number for identification of the objects CMS_DTE_OMS_EXT_ITM_NO CHAR 40
EXT_REFERENCE Reference number for the legacy system CMS_DTE_OMS_REF_ID CHAR 32
FOP Frequency of Payment CMS_DTE_INS_FOP NUMC 4
FREQ_UNIT Indicator: Units of time for revaluation CMS_DTE_INS_FREQ_UNIT CHAR 2
INS_CODE Insurance Product Code CMS_DTE_INS_CODE CHAR 6
ORIG_COUNTRY Country where Insurance was purchased CMS_DTE_INS_ORIG_COUNTRY CHAR 3 T005
ORIG_REGION Region where Insurance was purchased CMS_DTE_INS_ORIG_REGION CHAR 3 T005S
AUTO_CANCEL_DT Auto Cancellation Date for an Insurance Policy CMS_DTE_INS_AUTO_CANCEL_DT DATS 8
PRM_TYPE Type of Premium CMS_DTE_INS_PRM_TYPE CHAR 2
PRM_VALID_FROM Date from when specified Premium is valid CMS_DTE_INS_PRM_VALID_FROM_DT DATS 8
PAYMNT_METHOD Payment method for premiums CMS_DTE_INS_PAYMENT_METHOD CHAR 2
PAYMNT_INFO Payment Info for an insurance policy CMS_DTE_INS_PAY_INFO CHAR 30
LAST_PAYMENT_DT Date when last premium payment was made CMS_DTE_INS_LAST_PAYMENT_DT DATS 8
NXT_PAYMENT_DT Next Payment Date when insurance premium is due CMS_DTE_INS_NXT_PAYMENT_DT DATS 8
STATEMENT_DT Date when statements for Policy was made CMS_DTE_INS_STATEMENT_DT DATS 8
REBATE_METHOD Identifier for the rebate method used to calculate refunds CMS_DTE_INS_REBATE_METHOD_ID CHAR 6 TCMS_INS_REB
PORTFOLIO Insurance Portfolio CMS_DTE_INS_PORTFOLIO CHAR 6 TCMS_INS_PORT
MAX_AGE_LIMIT Maximum age limit for Policy Validity CMS_DTE_INS_MAX_AGE_LIMIT INT1 3
MAX_COVER_AMT Maximum Coverage Amount CMS_DTE_INS_MAX_COVER_AMT CURR 17
MIN_COVER_AMT Minimum Coverage Amount CMS_DTE_INS_MIN_COVER_AMT CURR 17
IND_INSURED_EVNT Boolean indicator that insured event occured (X = Occured) CMS_DTE_IND_INSURED_EVENT CHAR 1
INSURED_EVENT_DT Date when Insured Event Occured CMS_DTE_INSURED_EVENT_DT DATS 8
IND_FORCE_PLACED Is Insurance Force Placed? (Default = No) CMS_DTE_INS_IND_FORCE_PLACE CHAR 2
IND_TAX_DEDUCT Indicator that Insurance Policy is Tax Deductible CMS_DTE_INS_IND_TAX_DEDUCT CHAR 2
INACTIVE_REASON Reason for inactivating insurance policy CMS_DTE_INS_INACTIVE_REASON CHAR 2 TCMS_INS_SRSN
POLICY_STATUS Insurance Policy Status CMS_DTE_INS_POLICY_STATUS CHAR 2
INS_STRT_DAT Start date of insurance CMS_DTE_INS_STRT_DAT DATS 8
INSUR_EXPY_DAT Date of expiry of insurance CMS_DTE_INS_EXPY_DAT DATS 8
REQD_INSUR_CVR Required insurance cover CMS_DTE_INS_REQD_CVR CURR 17
REQD_INSUR_CURR Insurance Currency CMS_DTE_INS_CURR CUKY 5 TCURC
INSURER_NAM Name of the insurer CMS_DTE_INS_INSUR_NAM CHAR 30
INSURER_INF Remarks on insurer CMS_DTE_INS_INSUR_INF CHAR 30
COVER_MKT Cover Market CMS_DTE_INS_COVER_MKT CHAR 3 *
SHARE_CVR_MKT Share of cover market CMS_DTE_INS_SH_CVR_MKT CURR 17
SH_CVR_MKT_CUR Currency for Share of Cover Market CMS_DTE_INS_SH_CVR_MKT_CUR CUKY 5 *
CONTACT_FIRM Contact firm CMS_DTE_INS_CON_FRM CHAR 30
CONTACT_PARTNER Contact partner CMS_DTE_INS_CON_PRT CHAR 30
TARRIF Insurance tariff CMS_DTE_INS_TARRIF CHAR 30
CONTRACT_STRT_DT Contract begin date CMS_DTE_INS_CNTRT_STRT_DT DATS 8
CONTRACT_END_DT Contract end date CMS_DTE_INS_CNTRT_END_DT DATS 8
CONTRACT_CON_DT Date of conclusion of contract CMS_DTE_INS_CNTRT_CON_DT DATS 8
INSUR_STATUS Status of insurance CMS_DTE_INS_STATUS CHAR 6 TCMS_ATT_ID_TY
INSUR_STATUS_DT Status date of insurance CMS_DTE_INS_STATUS_DT DATS 8
SUM_ONE_TM_CON Sum of one time contribution CMS_DTE_INS_SUM_ONE_TM_CON CURR 17
ONE_TM_CON_CKY Currency CMS_DTE_INS_ONE_TM_CON_CKY CUKY 5 TCURC
DYNAMICS Dynamics CMS_DTE_INS_DYNAMICS CHAR 1
PER_DYNAMICS Percentage of the dynamics CMS_DTE_INS_PER_DYNAMICS DEC 10
TERMIN_PRD Termination period CMS_DTE_INS_TERMIN_PRD NUMC 4
TERM_PRD_UNIT Indicator: Units of termination period CMS_DTE_INS_TERM_PRD_UNIT CHAR 2
RECALL_PRD Recall period CMS_DTE_INS_RECALL_PRD NUMC 4
RECALL_PRD_UNIT Indicator: Units of Recall Period CMS_DTE_INS_RECALL_PRD_UNIT CHAR 2
INS_SUM_SRVL Insurance sum incase of survival CMS_DTE_INS_SUM_IN_SURVIVAL CURR 17
INS_SUM_SRVL_CKY Insurance survival Currency CMS_DTE_INS_SUM_IN_SURVIVL_CKY CUKY 5 TCURC
INS_SUM_DTH Insurance sum in case of death CMS_DTE_INS_SUM_IN_DEATH CURR 17
INS_SUM_DTH_CKY Death benefit currency CMS_DTE_INS_SUM_IN_DEATH_CKY CUKY 5 TCURC
INS_BENF_EXP Probable benefit on expiry CMS_DTE_INS_PROB_BENF CURR 17
INS_BENF_EXP_CKY Currency for probable benefit on expiry CMS_DTE_INS_PROB_BENF_CKY CUKY 5 TCURC
DT_PROB_BEN_EXP Date of probable benefit on expiry CMS_DTE_INS_DT_PRO_BEN_EXP DATS 8
ADMIN_ORG_UNIT Administration Organizational Unit CMS_DTE_ADMINORG CHAR 12
BANKAREA Bank Area in Collateral Management CMS_DTE_BANKAREA CHAR 4 *
CREATED_BY Login ID of the User who created the Record CMS_DTE_USER CHAR 12
CREATED_AT Creation Timestamp CMS_DTE_CREATED_AT DEC 15
CHANGED_BY Last Changed By CMS_DTE_LAST_CHNG_USER CHAR 12
CHANGED_AT Change Timestamp CMS_DTE_CHANGED_AT DEC 15
SOURCEOFENTRY Source of Entry CMS_DTE_SOURCE_OF_ENTRY CHAR 32