CMS_INS SAP table for – Insurance Application Table

Here we would like to draw your attention to CMS_INS table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_INS is a SAP standard transp table used for storing Insurance Application Table related data in SAP. It comes under the package CMS_OMS_RIG.

SAP CMS_INS table

Table CMS_INS technical data

TableCMS_INS
Data storingInsurance Application Table
ModuleFS
Sub ModuleFS-CMS-MD-RIG
SAP PackageCMS_OMS_RIG
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary Key for Insurance
    Its a key field.
  • INS_GUID : Insurance GUID
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Semantic Key for insurance
  • INS_CATEGORY : Object Category
    Its data type is CHAR (Character String) with field length 6
  • INS_TYP : Insurance Type
    Its data type is CHAR (Character String) with field length 6
  • INS_ID : Insurance ID
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Insurance common data
  • INS_DESC : Insurance Description
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Information on Insurance Settlement
  • INSUR_TAX_DB : Insurance tax to the debit of the bank
    Its data type is CHAR (Character String) with field length 1
  • SETLMNT_TYPE : Type of settlement
    Its data type is CHAR (Character String) with field length 6
  • INSUR_SUM : Insurance Sum
    Its data type is CURR (Currency Field) with field length 17
  • INSUR_CURR : Insurance Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PRM_RT : Premium Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • INSUR_PREMIUM : Insurance Premium
    Its data type is CURR (Currency Field) with field length 17
  • INSUR_PRM_CURR : Insurance Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INSUR_TAX_RT : Insurance tax rate (in %)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • INSUR_TAX_AMT : Insurance tax amount
    Its data type is CURR (Currency Field) with field length 17
  • INSUR_TAX_CURR : Tax Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Insurance cover
  • SCOPE_INS_COVER : not used -> package has to be changed CMS_OMS_INS
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Common OMS data
  • EXT_ITM_NO : Ext. Item no / Number for identification of the objects
    Its data type is CHAR (Character String) with field length 40
  • EXT_REFERENCE : Reference number for the legacy system
    Its data type is CHAR (Character String) with field length 32
  • FOP : Frequency of Payment
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FREQ_UNIT : Indicator: Units of time for revaluation
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Other general fields required for a standalone insurance
  • INS_CODE : Insurance Product Code
    Its data type is CHAR (Character String) with field length 6
  • ORIG_COUNTRY : Country where Insurance was purchased
    Its data type is CHAR (Character String) with field length 3
  • ORIG_REGION : Region where Insurance was purchased
    Its data type is CHAR (Character String) with field length 3
  • AUTO_CANCEL_DT : Auto Cancellation Date for an Insurance Policy
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PRM_TYPE : Type of Premium
    Its data type is CHAR (Character String) with field length 2
  • PRM_VALID_FROM : Date from when specified Premium is valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PAYMNT_METHOD : Payment method for premiums
    Its data type is CHAR (Character String) with field length 2
  • PAYMNT_INFO : Payment Info for an insurance policy
    Its data type is CHAR (Character String) with field length 30
  • LAST_PAYMENT_DT : Date when last premium payment was made
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NXT_PAYMENT_DT : Next Payment Date when insurance premium is due
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STATEMENT_DT : Date when statements for Policy was made
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REBATE_METHOD : Identifier for the rebate method used to calculate refunds
    Its data type is CHAR (Character String) with field length 6
  • PORTFOLIO : Insurance Portfolio
    Its data type is CHAR (Character String) with field length 6
  • MAX_AGE_LIMIT : Maximum age limit for Policy Validity
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • MAX_COVER_AMT : Maximum Coverage Amount
    Its data type is CURR (Currency Field) with field length 17
  • MIN_COVER_AMT : Minimum Coverage Amount
    Its data type is CURR (Currency Field) with field length 17
  • IND_INSURED_EVNT : Boolean indicator that insured event occured (X = Occured)
    Its data type is CHAR (Character String) with field length 1
  • INSURED_EVENT_DT : Date when Insured Event Occured
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IND_FORCE_PLACED : Is Insurance Force Placed? (Default = No)
    Its data type is CHAR (Character String) with field length 2
  • IND_TAX_DEDUCT : Indicator that Insurance Policy is Tax Deductible
    Its data type is CHAR (Character String) with field length 2
  • INACTIVE_REASON : Reason for inactivating insurance policy
    Its data type is CHAR (Character String) with field length 2
  • POLICY_STATUS : Insurance Policy Status
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Insurance for object
  • .INCLUDE : Information on Insurance Agreement
  • INS_STRT_DAT : Start date of insurance
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSUR_EXPY_DAT : Date of expiry of insurance
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REQD_INSUR_CVR : Required insurance cover
    Its data type is CURR (Currency Field) with field length 17
  • REQD_INSUR_CURR : Insurance Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : Information on Insurance / Insurance Broker
  • INSURER_NAM : Name of the insurer
    Its data type is CHAR (Character String) with field length 30
  • INSURER_INF : Remarks on insurer
    Its data type is CHAR (Character String) with field length 30
  • COVER_MKT : Cover Market
    Its data type is CHAR (Character String) with field length 3
  • SHARE_CVR_MKT : Share of cover market
    Its data type is CURR (Currency Field) with field length 17
  • SH_CVR_MKT_CUR : Currency for Share of Cover Market
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CONTACT_FIRM : Contact firm
    Its data type is CHAR (Character String) with field length 30
  • CONTACT_PARTNER : Contact partner
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Insurance as object
  • .INCLUDE : Special features for description of insurances
  • TARRIF : Insurance tariff
    Its data type is CHAR (Character String) with field length 30
  • CONTRACT_STRT_DT : Contract begin date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONTRACT_END_DT : Contract end date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONTRACT_CON_DT : Date of conclusion of contract
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSUR_STATUS : Status of insurance
    Its data type is CHAR (Character String) with field length 6
  • INSUR_STATUS_DT : Status date of insurance
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SUM_ONE_TM_CON : Sum of one time contribution
    Its data type is CURR (Currency Field) with field length 17
  • ONE_TM_CON_CKY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DYNAMICS : Dynamics
    Its data type is CHAR (Character String) with field length 1
  • PER_DYNAMICS : Percentage of the dynamics
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • TERMIN_PRD : Termination period
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • TERM_PRD_UNIT : Indicator: Units of termination period
    Its data type is CHAR (Character String) with field length 2
  • RECALL_PRD : Recall period
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RECALL_PRD_UNIT : Indicator: Units of Recall Period
    Its data type is CHAR (Character String) with field length 2
  • INS_SUM_SRVL : Insurance sum incase of survival
    Its data type is CURR (Currency Field) with field length 17
  • INS_SUM_SRVL_CKY : Insurance survival Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INS_SUM_DTH : Insurance sum in case of death
    Its data type is CURR (Currency Field) with field length 17
  • INS_SUM_DTH_CKY : Death benefit currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INS_BENF_EXP : Probable benefit on expiry
    Its data type is CURR (Currency Field) with field length 17
  • INS_BENF_EXP_CKY : Currency for probable benefit on expiry
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DT_PROB_BEN_EXP : Date of probable benefit on expiry
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Administrative organization unit
  • ADMIN_ORG_UNIT : Administration Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Bank area
  • BANKAREA : Bank Area in Collateral Management
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32