SAP CMS_INS Insurance Application Table Table data and field list

CMS_INS is a standard SAP Table which is used to store Insurance Application Table data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_INS table consists of various fields, each holding specific information or linking keys about Insurance Application Table data available in SAP. These include INS_GUID (Insurance GUID), INS_CATEGORY (Object Category), INS_TYP (Insurance Type), INS_ID (Insurance ID)... 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. .

CMS_INS table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CMS_INS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_INS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
INS_GUIDInsurance GUID CMS_DTE_INS_GUIDRAW16SYSUUID
INS_CATEGORYObject Category CMS_DTE_OMS_OBJ_CATCHAR6Assigned to domainCMS_OBJ_CAT
INS_TYPInsurance Type CMS_DTE_INS_TYPECHAR6Assigned to domainCMS_MOV_TYPINS_TYPE
INS_IDInsurance ID CMS_DTE_INS_IDCHAR40ALPHACMS_MOV_ID
INS_DESCInsurance Description CMS_DTE_INS_DESCCHAR30CMS_INS_DESC
INSUR_TAX_DB Insurance tax to the debit of the bank CMS_DTE_INS_TAX_DBCHAR1CMS_INS_FLG
SETLMNT_TYPEType of settlement CMS_DTE_INS_SETLMNT_TYPECHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
INSUR_SUMInsurance Sum CMS_DTE_INS_SUMCURR17(2) CMS_AMOUNT
INSUR_CURRInsurance Currency CMS_DTE_INS_CURRCUKY5TCURCWAERS
PRM_RTPremium Rate CMS_DTE_INS_PRM_RTDEC10(7) CMS_INS_PRM_RT
INSUR_PREMIUMInsurance Premium CMS_DTE_INS_PRMCURR17(2) CMS_AMOUNT
INSUR_PRM_CURRInsurance Currency CMS_DTE_INS_CURRCUKY5TCURCWAERS
INSUR_TAX_RTInsurance tax rate (in %) CMS_DTE_INS_TAX_RTDEC10(7) CMS_INS_PRM_RT
INSUR_TAX_AMTInsurance tax amount CMS_DTE_INS_TAX_AMTCURR17(2) CMS_AMOUNT
INSUR_TAX_CURRTax Currency CMS_DTE_INS_TAX_CURRCUKY5TCURCWAERS
SCOPE_INS_COVERnot used -> package has to be changed CMS_OMS_INS CMS_DTE_INS_COVERCHAR6CMS_INS_COVER
EXT_ITM_NOExt. Item no / Number for identification of the objects CMS_DTE_OMS_EXT_ITM_NOCHAR40ALPHACMS_OMS_ID
EXT_REFERENCEReference number for the legacy system CMS_DTE_OMS_REF_IDCHAR32CMS_OMS_REFID
FOPFrequency of Payment CMS_DTE_INS_FOPNUMC4CMS_INS_FREQ_OF_PAYMENT
FREQ_UNITIndicator: Units of time for revaluation CMS_DTE_INS_FREQ_UNITCHAR2CMS_INS_IND_FREQ_UNIT
INS_CODEInsurance Product Code CMS_DTE_INS_CODECHAR6CMS_INS_CODE
ORIG_COUNTRYCountry where Insurance was purchased CMS_DTE_INS_ORIG_COUNTRYCHAR3T005LAND1
ORIG_REGIONRegion where Insurance was purchased CMS_DTE_INS_ORIG_REGIONCHAR3T005SREGIO
AUTO_CANCEL_DTAuto Cancellation Date for an Insurance Policy CMS_DTE_INS_AUTO_CANCEL_DTDATS8CMS_DATE
PRM_TYPEType of Premium CMS_DTE_INS_PRM_TYPECHAR2CMS_INS_PREMIUM_TYPE
PRM_VALID_FROMDate from when specified Premium is valid CMS_DTE_INS_PRM_VALID_FROM_DTDATS8CMS_DATE
PAYMNT_METHODPayment method for premiums CMS_DTE_INS_PAYMENT_METHODCHAR2CMS_INS_PAYMENT_METHOD
PAYMNT_INFOPayment Info for an insurance policy CMS_DTE_INS_PAY_INFOCHAR30CMS_PAYMENT_HANDLE
LAST_PAYMENT_DTDate when last premium payment was made CMS_DTE_INS_LAST_PAYMENT_DTDATS8CMS_DATE
NXT_PAYMENT_DTNext Payment Date when insurance premium is due CMS_DTE_INS_NXT_PAYMENT_DTDATS8CMS_DATE
STATEMENT_DTDate when statements for Policy was made CMS_DTE_INS_STATEMENT_DTDATS8CMS_DATE
REBATE_METHODIdentifier for the rebate method used to calculate refunds CMS_DTE_INS_REBATE_METHOD_IDCHAR6TCMS_INS_REBCMS_INS_REBATE_METHOD_ID
PORTFOLIOInsurance Portfolio CMS_DTE_INS_PORTFOLIOCHAR6TCMS_INS_PORTCMS_INS_PORTFOLIO
MAX_AGE_LIMITMaximum age limit for Policy Validity CMS_DTE_INS_MAX_AGE_LIMITINT13CMS_AGE
MAX_COVER_AMTMaximum Coverage Amount CMS_DTE_INS_MAX_COVER_AMTCURR17(2) CMS_AMOUNT
MIN_COVER_AMTMinimum Coverage Amount CMS_DTE_INS_MIN_COVER_AMTCURR17(2) CMS_AMOUNT
IND_INSURED_EVNTBoolean indicator that insured event occured (X = Occured) CMS_DTE_IND_INSURED_EVENTCHAR1CMS_IND_OCCURENCE
INSURED_EVENT_DTDate when Insured Event Occured CMS_DTE_INSURED_EVENT_DTDATS8CMS_DATE
IND_FORCE_PLACEDIs Insurance Force Placed? (Default = No) CMS_DTE_INS_IND_FORCE_PLACECHAR2CMS_IND_INS_FORCE_PLACE
IND_TAX_DEDUCTIndicator that Insurance Policy is Tax Deductible CMS_DTE_INS_IND_TAX_DEDUCTCHAR2CMS_IND_INS_TAX_DEDUCTIBLE
INACTIVE_REASONReason for inactivating insurance policy CMS_DTE_INS_INACTIVE_REASONCHAR2TCMS_INS_SRSNCMS_INS_INACTIVE_REASON
POLICY_STATUSInsurance Policy Status CMS_DTE_INS_POLICY_STATUSCHAR2CMS_INS_POLICY_STATUS
INS_STRT_DATStart date of insurance CMS_DTE_INS_STRT_DATDATS8DATUM
INSUR_EXPY_DATDate of expiry of insurance CMS_DTE_INS_EXPY_DATDATS8DATUM
REQD_INSUR_CVRRequired insurance cover CMS_DTE_INS_REQD_CVRCURR17(2) CMS_AMOUNT
REQD_INSUR_CURRInsurance Currency CMS_DTE_INS_CURRCUKY5TCURCWAERS
INSURER_NAMName of the insurer CMS_DTE_INS_INSUR_NAMCHAR30CMS_INS_INSURER
INSURER_INFRemarks on insurer CMS_DTE_INS_INSUR_INFCHAR30CMS_INS_INSUR_INF
COVER_MKTCover Market CMS_DTE_INS_COVER_MKTCHAR3Assigned to domainLAND1
SHARE_CVR_MKTShare of cover market CMS_DTE_INS_SH_CVR_MKTCURR17(2) CMS_AMOUNT
SH_CVR_MKT_CURCurrency for Share of Cover Market CMS_DTE_INS_SH_CVR_MKT_CURCUKY5Assigned to domainWAERS
CONTACT_FIRMContact firm CMS_DTE_INS_CON_FRMCHAR30CMS_INS_CON_FRM
CONTACT_PARTNERContact partner CMS_DTE_INS_CON_PRTCHAR30CMS_INS_CON_PRT
TARRIFInsurance tariff CMS_DTE_INS_TARRIFCHAR30CMS_INS_TARRIF
CONTRACT_STRT_DTContract begin date CMS_DTE_INS_CNTRT_STRT_DTDATS8DATUM
CONTRACT_END_DTContract end date CMS_DTE_INS_CNTRT_END_DTDATS8DATUM
CONTRACT_CON_DTDate of conclusion of contract CMS_DTE_INS_CNTRT_CON_DTDATS8DATUM
INSUR_STATUSStatus of insurance CMS_DTE_INS_STATUSCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
INSUR_STATUS_DTStatus date of insurance CMS_DTE_INS_STATUS_DTDATS8DATUM
SUM_ONE_TM_CONSum of one time contribution CMS_DTE_INS_SUM_ONE_TM_CONCURR17(2) CMS_AMOUNT
ONE_TM_CON_CKYCurrency CMS_DTE_INS_ONE_TM_CON_CKYCUKY5TCURCWAERS
DYNAMICSDynamics CMS_DTE_INS_DYNAMICSCHAR1CMS_INS_FLG
PER_DYNAMICSPercentage of the dynamics CMS_DTE_INS_PER_DYNAMICSDEC10(6) CMS_SEC_PCT
TERMIN_PRDTermination period CMS_DTE_INS_TERMIN_PRDNUMC4CMS_INS_FREQ_OF_PAYMENT
TERM_PRD_UNITIndicator: Units of termination period CMS_DTE_INS_TERM_PRD_UNITCHAR2CMS_INS_IND_FREQ_UNT
RECALL_PRDRecall period CMS_DTE_INS_RECALL_PRDNUMC4CMS_INS_FREQ_OF_PAYMENT
RECALL_PRD_UNITIndicator: Units of Recall Period CMS_DTE_INS_RECALL_PRD_UNITCHAR2CMS_INS_IND_FREQ_UNT
INS_SUM_SRVLInsurance sum incase of survival CMS_DTE_INS_SUM_IN_SURVIVALCURR17(2) CMS_AMOUNT
INS_SUM_SRVL_CKYInsurance survival Currency CMS_DTE_INS_SUM_IN_SURVIVL_CKYCUKY5TCURCWAERS
INS_SUM_DTHInsurance sum in case of death CMS_DTE_INS_SUM_IN_DEATHCURR17(2) CMS_AMOUNT
INS_SUM_DTH_CKYDeath benefit currency CMS_DTE_INS_SUM_IN_DEATH_CKYCUKY5TCURCWAERS
INS_BENF_EXPProbable benefit on expiry CMS_DTE_INS_PROB_BENFCURR17(2) CMS_AMOUNT
INS_BENF_EXP_CKYCurrency for probable benefit on expiry CMS_DTE_INS_PROB_BENF_CKYCUKY5TCURCWAERS
DT_PROB_BEN_EXPDate of probable benefit on expiry CMS_DTE_INS_DT_PRO_BEN_EXPDATS8DATUM
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4Assigned to domainCMS_BANKAREACMS_BANKAREA
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE

Key field Non-key field



How do I retrieve data from SAP table CMS_INS using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_INS to SELECT all data from the table
DATA: WA_CMS_INS TYPE CMS_INS.

SELECT SINGLE *
FROM CMS_INS
INTO CORRESPONDING FIELDS OF WA_CMS_INS
WHERE...

How to access SAP table CMS_INS

Within an ECC or HANA version of SAP you can also view further information about CMS_INS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).