SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

CMS_INS Table in SAP | Insurance Application Table Table & Fields List

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

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

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

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
.INCLUDEPrimary Key for Insurance    
INS_GUIDInsurance GUIDCMS_DTE_INS_GUIDSYSUUID
.INCLUDESemantic Key for insurance    
INS_CATEGORYObject CategoryCMS_DTE_OMS_OBJ_CATCMS_OBJ_CAT
INS_TYPInsurance TypeCMS_DTE_INS_TYPECMS_MOV_TYP
INS_IDInsurance IDCMS_DTE_INS_IDCMS_MOV_ID
.INCLUDEInsurance common data    
INS_DESCInsurance DescriptionCMS_DTE_INS_DESCCMS_INS_DESC
.INCLUDEInformation on Insurance Settlement    
INSUR_TAX_DBInsurance tax to the debit of the bankCMS_DTE_INS_TAX_DBCMS_INS_FLG
SETLMNT_TYPEType of settlementCMS_DTE_INS_SETLMNT_TYPECMS_ATT_ID_TYP
INSUR_SUMInsurance SumCMS_DTE_INS_SUMCMS_AMOUNT
INSUR_CURRInsurance CurrencyCMS_DTE_INS_CURRWAERS
PRM_RTPremium RateCMS_DTE_INS_PRM_RTCMS_INS_PRM_RT
INSUR_PREMIUMInsurance PremiumCMS_DTE_INS_PRMCMS_AMOUNT
INSUR_PRM_CURRInsurance CurrencyCMS_DTE_INS_CURRWAERS
INSUR_TAX_RTInsurance tax rate (in %)CMS_DTE_INS_TAX_RTCMS_INS_PRM_RT
INSUR_TAX_AMTInsurance tax amountCMS_DTE_INS_TAX_AMTCMS_AMOUNT
INSUR_TAX_CURRTax CurrencyCMS_DTE_INS_TAX_CURRWAERS
.INCLUDEInsurance cover    
SCOPE_INS_COVERnot used -> package has to be changed CMS_OMS_INSCMS_DTE_INS_COVERCMS_INS_COVER
.INCLUDECommon OMS data    
EXT_ITM_NOExt. Item no / Number for identification of the objectsCMS_DTE_OMS_EXT_ITM_NOCMS_OMS_ID
EXT_REFERENCEReference number for the legacy systemCMS_DTE_OMS_REF_IDCMS_OMS_REFID
FOPFrequency of PaymentCMS_DTE_INS_FOPCMS_INS_FREQ_OF_PAYMENT
FREQ_UNITIndicator: Units of time for revaluationCMS_DTE_INS_FREQ_UNITCMS_INS_IND_FREQ_UNIT
.INCLUDEOther general fields required for a standalone insurance    
INS_CODEInsurance Product CodeCMS_DTE_INS_CODECMS_INS_CODE
ORIG_COUNTRYCountry where Insurance was purchasedCMS_DTE_INS_ORIG_COUNTRYLAND1
ORIG_REGIONRegion where Insurance was purchasedCMS_DTE_INS_ORIG_REGIONREGIO
AUTO_CANCEL_DTAuto Cancellation Date for an Insurance PolicyCMS_DTE_INS_AUTO_CANCEL_DTCMS_DATE
PRM_TYPEType of PremiumCMS_DTE_INS_PRM_TYPECMS_INS_PREMIUM_TYPE
PRM_VALID_FROMDate from when specified Premium is validCMS_DTE_INS_PRM_VALID_FROM_DTCMS_DATE
PAYMNT_METHODPayment method for premiumsCMS_DTE_INS_PAYMENT_METHODCMS_INS_PAYMENT_METHOD
PAYMNT_INFOPayment Info for an insurance policyCMS_DTE_INS_PAY_INFOCMS_PAYMENT_HANDLE
LAST_PAYMENT_DTDate when last premium payment was madeCMS_DTE_INS_LAST_PAYMENT_DTCMS_DATE
NXT_PAYMENT_DTNext Payment Date when insurance premium is dueCMS_DTE_INS_NXT_PAYMENT_DTCMS_DATE
STATEMENT_DTDate when statements for Policy was madeCMS_DTE_INS_STATEMENT_DTCMS_DATE
REBATE_METHODIdentifier for the rebate method used to calculate refundsCMS_DTE_INS_REBATE_METHOD_IDCMS_INS_REBATE_METHOD_ID
PORTFOLIOInsurance PortfolioCMS_DTE_INS_PORTFOLIOCMS_INS_PORTFOLIO
MAX_AGE_LIMITMaximum age limit for Policy ValidityCMS_DTE_INS_MAX_AGE_LIMITCMS_AGE
MAX_COVER_AMTMaximum Coverage AmountCMS_DTE_INS_MAX_COVER_AMTCMS_AMOUNT
MIN_COVER_AMTMinimum Coverage AmountCMS_DTE_INS_MIN_COVER_AMTCMS_AMOUNT
IND_INSURED_EVNTBoolean indicator that insured event occured (X = Occured)CMS_DTE_IND_INSURED_EVENTCMS_IND_OCCURENCE
INSURED_EVENT_DTDate when Insured Event OccuredCMS_DTE_INSURED_EVENT_DTCMS_DATE
IND_FORCE_PLACEDIs Insurance Force Placed? (Default = No)CMS_DTE_INS_IND_FORCE_PLACECMS_IND_INS_FORCE_PLACE
IND_TAX_DEDUCTIndicator that Insurance Policy is Tax DeductibleCMS_DTE_INS_IND_TAX_DEDUCTCMS_IND_INS_TAX_DEDUCTIBLE
INACTIVE_REASONReason for inactivating insurance policyCMS_DTE_INS_INACTIVE_REASONCMS_INS_INACTIVE_REASON
POLICY_STATUSInsurance Policy StatusCMS_DTE_INS_POLICY_STATUSCMS_INS_POLICY_STATUS
.INCLUDEInsurance for object    
.INCLUDEInformation on Insurance Agreement    
INS_STRT_DATStart date of insuranceCMS_DTE_INS_STRT_DATDATUM
INSUR_EXPY_DATDate of expiry of insuranceCMS_DTE_INS_EXPY_DATDATUM
REQD_INSUR_CVRRequired insurance coverCMS_DTE_INS_REQD_CVRCMS_AMOUNT
REQD_INSUR_CURRInsurance CurrencyCMS_DTE_INS_CURRWAERS
.INCLUDEInformation on Insurance / Insurance Broker    
INSURER_NAMName of the insurerCMS_DTE_INS_INSUR_NAMCMS_INS_INSURER
INSURER_INFRemarks on insurerCMS_DTE_INS_INSUR_INFCMS_INS_INSUR_INF
COVER_MKTCover MarketCMS_DTE_INS_COVER_MKTLAND1
SHARE_CVR_MKTShare of cover marketCMS_DTE_INS_SH_CVR_MKTCMS_AMOUNT
SH_CVR_MKT_CURCurrency for Share of Cover MarketCMS_DTE_INS_SH_CVR_MKT_CURWAERS
CONTACT_FIRMContact firmCMS_DTE_INS_CON_FRMCMS_INS_CON_FRM
CONTACT_PARTNERContact partnerCMS_DTE_INS_CON_PRTCMS_INS_CON_PRT
.INCLUDEInsurance as object    
.INCLUDESpecial features for description of insurances    
TARRIFInsurance tariffCMS_DTE_INS_TARRIFCMS_INS_TARRIF
CONTRACT_STRT_DTContract begin dateCMS_DTE_INS_CNTRT_STRT_DTDATUM
CONTRACT_END_DTContract end dateCMS_DTE_INS_CNTRT_END_DTDATUM
CONTRACT_CON_DTDate of conclusion of contractCMS_DTE_INS_CNTRT_CON_DTDATUM
INSUR_STATUSStatus of insuranceCMS_DTE_INS_STATUSCMS_ATT_ID_TYP
INSUR_STATUS_DTStatus date of insuranceCMS_DTE_INS_STATUS_DTDATUM
SUM_ONE_TM_CONSum of one time contributionCMS_DTE_INS_SUM_ONE_TM_CONCMS_AMOUNT
ONE_TM_CON_CKYCurrencyCMS_DTE_INS_ONE_TM_CON_CKYWAERS
DYNAMICSDynamicsCMS_DTE_INS_DYNAMICSCMS_INS_FLG
PER_DYNAMICSPercentage of the dynamicsCMS_DTE_INS_PER_DYNAMICSCMS_SEC_PCT
TERMIN_PRDTermination periodCMS_DTE_INS_TERMIN_PRDCMS_INS_FREQ_OF_PAYMENT
TERM_PRD_UNITIndicator: Units of termination periodCMS_DTE_INS_TERM_PRD_UNITCMS_INS_IND_FREQ_UNT
RECALL_PRDRecall periodCMS_DTE_INS_RECALL_PRDCMS_INS_FREQ_OF_PAYMENT
RECALL_PRD_UNITIndicator: Units of Recall PeriodCMS_DTE_INS_RECALL_PRD_UNITCMS_INS_IND_FREQ_UNT
INS_SUM_SRVLInsurance sum incase of survivalCMS_DTE_INS_SUM_IN_SURVIVALCMS_AMOUNT
INS_SUM_SRVL_CKYInsurance survival CurrencyCMS_DTE_INS_SUM_IN_SURVIVL_CKYWAERS
INS_SUM_DTHInsurance sum in case of deathCMS_DTE_INS_SUM_IN_DEATHCMS_AMOUNT
INS_SUM_DTH_CKYDeath benefit currencyCMS_DTE_INS_SUM_IN_DEATH_CKYWAERS
INS_BENF_EXPProbable benefit on expiryCMS_DTE_INS_PROB_BENFCMS_AMOUNT
INS_BENF_EXP_CKYCurrency for probable benefit on expiryCMS_DTE_INS_PROB_BENF_CKYWAERS
DT_PROB_BEN_EXPDate of probable benefit on expiryCMS_DTE_INS_DT_PRO_BEN_EXPDATUM
.INCLUDEAdministrative organization unit    
ADMIN_ORG_UNITAdministration Organizational UnitCMS_DTE_ADMINORGTEXT12
.INCLUDEBank area    
BANKAREABank Area in Collateral ManagementCMS_DTE_BANKAREACMS_BANKAREA
.INCLUDEStucture to record history of changes in all application tab    
CREATED_BYLogin ID of the User who created the RecordCMS_DTE_USERCMS_USER
CREATED_ATCreation TimestampCMS_DTE_CREATED_ATTZNTSTMPS
CHANGED_BYLast Changed ByCMS_DTE_LAST_CHNG_USERCMS_USER
CHANGED_ATChange TimestampCMS_DTE_CHANGED_ATTZNTSTMPS
SOURCEOFENTRYSource of EntryCMS_DTE_SOURCE_OF_ENTRYCMS_SOURCE

CMS_INS related tables

TableNote
NEHC_INSIS-H: Health Insurance Card (Insurance Data)
NEHC_INS_REPHealth Insurance Card (Additional Insurance Data)
T5J47HR Combination Insurance Type/Insurance Company JPN
T7JPSI_INR_ASNAssign Health Insurance Insurer to Social Insurance Modifier
TCMS_INS_TYP_SETInsurance Types-> Insurance Sets
CMS_INSInsurance Application Table
CRMC_MPK_APPLINKApplication / Application Group Link Table
BSP_APPLCSAP Application Name - CUS Application Name
CRMC_APPL_ALIASMapping - Old Application -> New Application
PPF_TST_APPLPARMApplication Parameters of PPF Test Application
TCACS_ICMCRDAssignment of Credentialing Application to ICM Application
TICL808Reserve Group, Application Years -> Application Method
/SAPSLL/APPIDXStore Application Data in Application Buffer
CRMC_IIN_CLA_MODRelationship table for Insurance Claims
CRMC_IIN_CLA_OBJObject table for the Insurance Claims
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com