CMS_INS is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of CMS_INS in SAP.
- Table description : Insurance Application Table
- Module : FS-CMS-MD-RIG
- Parent Module : FS
- Package : CMS_OMS_RIG
- Software Component : EA-FINSERV
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP CMS_INS Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
.INCLUDE | Primary Key for Insurance | ||
INS_GUID | Insurance GUID | CMS_DTE_INS_GUID | SYSUUID |
.INCLUDE | Semantic Key for insurance | ||
INS_CATEGORY | Object Category | CMS_DTE_OMS_OBJ_CAT | CMS_OBJ_CAT |
INS_TYP | Insurance Type | CMS_DTE_INS_TYPE | CMS_MOV_TYP |
INS_ID | Insurance ID | CMS_DTE_INS_ID | CMS_MOV_ID |
.INCLUDE | Insurance common data | ||
INS_DESC | Insurance Description | CMS_DTE_INS_DESC | CMS_INS_DESC |
.INCLUDE | Information on Insurance Settlement | ||
INSUR_TAX_DB | Insurance tax to the debit of the bank | CMS_DTE_INS_TAX_DB | CMS_INS_FLG |
SETLMNT_TYPE | Type of settlement | CMS_DTE_INS_SETLMNT_TYPE | CMS_ATT_ID_TYP |
INSUR_SUM | Insurance Sum | CMS_DTE_INS_SUM | CMS_AMOUNT |
INSUR_CURR | Insurance Currency | CMS_DTE_INS_CURR | WAERS |
PRM_RT | Premium Rate | CMS_DTE_INS_PRM_RT | CMS_INS_PRM_RT |
INSUR_PREMIUM | Insurance Premium | CMS_DTE_INS_PRM | CMS_AMOUNT |
INSUR_PRM_CURR | Insurance Currency | CMS_DTE_INS_CURR | WAERS |
INSUR_TAX_RT | Insurance tax rate (in %) | CMS_DTE_INS_TAX_RT | CMS_INS_PRM_RT |
INSUR_TAX_AMT | Insurance tax amount | CMS_DTE_INS_TAX_AMT | CMS_AMOUNT |
INSUR_TAX_CURR | Tax Currency | CMS_DTE_INS_TAX_CURR | WAERS |
.INCLUDE | Insurance cover | ||
SCOPE_INS_COVER | not used -> package has to be changed CMS_OMS_INS | CMS_DTE_INS_COVER | CMS_INS_COVER |
.INCLUDE | Common OMS data | ||
EXT_ITM_NO | Ext. Item no / Number for identification of the objects | CMS_DTE_OMS_EXT_ITM_NO | CMS_OMS_ID |
EXT_REFERENCE | Reference number for the legacy system | CMS_DTE_OMS_REF_ID | CMS_OMS_REFID |
FOP | Frequency of Payment | CMS_DTE_INS_FOP | CMS_INS_FREQ_OF_PAYMENT |
FREQ_UNIT | Indicator: Units of time for revaluation | CMS_DTE_INS_FREQ_UNIT | CMS_INS_IND_FREQ_UNIT |
.INCLUDE | Other general fields required for a standalone insurance | ||
INS_CODE | Insurance Product Code | CMS_DTE_INS_CODE | CMS_INS_CODE |
ORIG_COUNTRY | Country where Insurance was purchased | CMS_DTE_INS_ORIG_COUNTRY | LAND1 |
ORIG_REGION | Region where Insurance was purchased | CMS_DTE_INS_ORIG_REGION | REGIO |
AUTO_CANCEL_DT | Auto Cancellation Date for an Insurance Policy | CMS_DTE_INS_AUTO_CANCEL_DT | CMS_DATE |
PRM_TYPE | Type of Premium | CMS_DTE_INS_PRM_TYPE | CMS_INS_PREMIUM_TYPE |
PRM_VALID_FROM | Date from when specified Premium is valid | CMS_DTE_INS_PRM_VALID_FROM_DT | CMS_DATE |
PAYMNT_METHOD | Payment method for premiums | CMS_DTE_INS_PAYMENT_METHOD | CMS_INS_PAYMENT_METHOD |
PAYMNT_INFO | Payment Info for an insurance policy | CMS_DTE_INS_PAY_INFO | CMS_PAYMENT_HANDLE |
LAST_PAYMENT_DT | Date when last premium payment was made | CMS_DTE_INS_LAST_PAYMENT_DT | CMS_DATE |
NXT_PAYMENT_DT | Next Payment Date when insurance premium is due | CMS_DTE_INS_NXT_PAYMENT_DT | CMS_DATE |
STATEMENT_DT | Date when statements for Policy was made | CMS_DTE_INS_STATEMENT_DT | CMS_DATE |
REBATE_METHOD | Identifier for the rebate method used to calculate refunds | CMS_DTE_INS_REBATE_METHOD_ID | CMS_INS_REBATE_METHOD_ID |
PORTFOLIO | Insurance Portfolio | CMS_DTE_INS_PORTFOLIO | CMS_INS_PORTFOLIO |
MAX_AGE_LIMIT | Maximum age limit for Policy Validity | CMS_DTE_INS_MAX_AGE_LIMIT | CMS_AGE |
MAX_COVER_AMT | Maximum Coverage Amount | CMS_DTE_INS_MAX_COVER_AMT | CMS_AMOUNT |
MIN_COVER_AMT | Minimum Coverage Amount | CMS_DTE_INS_MIN_COVER_AMT | CMS_AMOUNT |
IND_INSURED_EVNT | Boolean indicator that insured event occured (X = Occured) | CMS_DTE_IND_INSURED_EVENT | CMS_IND_OCCURENCE |
INSURED_EVENT_DT | Date when Insured Event Occured | CMS_DTE_INSURED_EVENT_DT | CMS_DATE |
IND_FORCE_PLACED | Is Insurance Force Placed? (Default = No) | CMS_DTE_INS_IND_FORCE_PLACE | CMS_IND_INS_FORCE_PLACE |
IND_TAX_DEDUCT | Indicator that Insurance Policy is Tax Deductible | CMS_DTE_INS_IND_TAX_DEDUCT | CMS_IND_INS_TAX_DEDUCTIBLE |
INACTIVE_REASON | Reason for inactivating insurance policy | CMS_DTE_INS_INACTIVE_REASON | CMS_INS_INACTIVE_REASON |
POLICY_STATUS | Insurance Policy Status | CMS_DTE_INS_POLICY_STATUS | CMS_INS_POLICY_STATUS |
.INCLUDE | Insurance for object | ||
.INCLUDE | Information on Insurance Agreement | ||
INS_STRT_DAT | Start date of insurance | CMS_DTE_INS_STRT_DAT | DATUM |
INSUR_EXPY_DAT | Date of expiry of insurance | CMS_DTE_INS_EXPY_DAT | DATUM |
REQD_INSUR_CVR | Required insurance cover | CMS_DTE_INS_REQD_CVR | CMS_AMOUNT |
REQD_INSUR_CURR | Insurance Currency | CMS_DTE_INS_CURR | WAERS |
.INCLUDE | Information on Insurance / Insurance Broker | ||
INSURER_NAM | Name of the insurer | CMS_DTE_INS_INSUR_NAM | CMS_INS_INSURER |
INSURER_INF | Remarks on insurer | CMS_DTE_INS_INSUR_INF | CMS_INS_INSUR_INF |
COVER_MKT | Cover Market | CMS_DTE_INS_COVER_MKT | LAND1 |
SHARE_CVR_MKT | Share of cover market | CMS_DTE_INS_SH_CVR_MKT | CMS_AMOUNT |
SH_CVR_MKT_CUR | Currency for Share of Cover Market | CMS_DTE_INS_SH_CVR_MKT_CUR | WAERS |
CONTACT_FIRM | Contact firm | CMS_DTE_INS_CON_FRM | CMS_INS_CON_FRM |
CONTACT_PARTNER | Contact partner | CMS_DTE_INS_CON_PRT | CMS_INS_CON_PRT |
.INCLUDE | Insurance as object | ||
.INCLUDE | Special features for description of insurances | ||
TARRIF | Insurance tariff | CMS_DTE_INS_TARRIF | CMS_INS_TARRIF |
CONTRACT_STRT_DT | Contract begin date | CMS_DTE_INS_CNTRT_STRT_DT | DATUM |
CONTRACT_END_DT | Contract end date | CMS_DTE_INS_CNTRT_END_DT | DATUM |
CONTRACT_CON_DT | Date of conclusion of contract | CMS_DTE_INS_CNTRT_CON_DT | DATUM |
INSUR_STATUS | Status of insurance | CMS_DTE_INS_STATUS | CMS_ATT_ID_TYP |
INSUR_STATUS_DT | Status date of insurance | CMS_DTE_INS_STATUS_DT | DATUM |
SUM_ONE_TM_CON | Sum of one time contribution | CMS_DTE_INS_SUM_ONE_TM_CON | CMS_AMOUNT |
ONE_TM_CON_CKY | Currency | CMS_DTE_INS_ONE_TM_CON_CKY | WAERS |
DYNAMICS | Dynamics | CMS_DTE_INS_DYNAMICS | CMS_INS_FLG |
PER_DYNAMICS | Percentage of the dynamics | CMS_DTE_INS_PER_DYNAMICS | CMS_SEC_PCT |
TERMIN_PRD | Termination period | CMS_DTE_INS_TERMIN_PRD | CMS_INS_FREQ_OF_PAYMENT |
TERM_PRD_UNIT | Indicator: Units of termination period | CMS_DTE_INS_TERM_PRD_UNIT | CMS_INS_IND_FREQ_UNT |
RECALL_PRD | Recall period | CMS_DTE_INS_RECALL_PRD | CMS_INS_FREQ_OF_PAYMENT |
RECALL_PRD_UNIT | Indicator: Units of Recall Period | CMS_DTE_INS_RECALL_PRD_UNIT | CMS_INS_IND_FREQ_UNT |
INS_SUM_SRVL | Insurance sum incase of survival | CMS_DTE_INS_SUM_IN_SURVIVAL | CMS_AMOUNT |
INS_SUM_SRVL_CKY | Insurance survival Currency | CMS_DTE_INS_SUM_IN_SURVIVL_CKY | WAERS |
INS_SUM_DTH | Insurance sum in case of death | CMS_DTE_INS_SUM_IN_DEATH | CMS_AMOUNT |
INS_SUM_DTH_CKY | Death benefit currency | CMS_DTE_INS_SUM_IN_DEATH_CKY | WAERS |
INS_BENF_EXP | Probable benefit on expiry | CMS_DTE_INS_PROB_BENF | CMS_AMOUNT |
INS_BENF_EXP_CKY | Currency for probable benefit on expiry | CMS_DTE_INS_PROB_BENF_CKY | WAERS |
DT_PROB_BEN_EXP | Date of probable benefit on expiry | CMS_DTE_INS_DT_PRO_BEN_EXP | DATUM |
.INCLUDE | Administrative organization unit | ||
ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | TEXT12 |
.INCLUDE | Bank area | ||
BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | CMS_BANKAREA |
.INCLUDE | Stucture to record history of changes in all application tab | ||
CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CMS_USER |
CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | TZNTSTMPS |
CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CMS_USER |
CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | TZNTSTMPS |
SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CMS_SOURCE |
CMS_INS related tables
Table | Note |
---|---|
NEHC_INS | IS-H: Health Insurance Card (Insurance Data) |
NEHC_INS_REP | Health Insurance Card (Additional Insurance Data) |
T5J47 | HR Combination Insurance Type/Insurance Company JPN |
T7JPSI_INR_ASN | Assign Health Insurance Insurer to Social Insurance Modifier |
TCMS_INS_TYP_SET | Insurance Types-> Insurance Sets |
CMS_INS | Insurance Application Table |
CRMC_MPK_APPLINK | Application / Application Group Link Table |
BSP_APPLC | SAP Application Name - CUS Application Name |
CRMC_APPL_ALIAS | Mapping - Old Application -> New Application |
PPF_TST_APPLPARM | Application Parameters of PPF Test Application |
TCACS_ICMCRD | Assignment of Credentialing Application to ICM Application |
TICL808 | Reserve Group, Application Years -> Application Method |
/SAPSLL/APPIDX | Store Application Data in Application Buffer |
CRMC_IIN_CLA_MOD | Relationship table for Insurance Claims |
CRMC_IIN_CLA_OBJ | Object table for the Insurance Claims |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP