The CMS_INS_PSN table in SAP ERP or S/4HANA stores Insurance – Specifications of Persons data. There are total 18 fields in CMS_INS_PSN table. The Insurance – Specifications of Persons table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMS_INS_PSN table. It is in Collateral Management Rights (CMS_OMS_RIG) ABAP package and is part of the Rights (FS-CMS-MD-RIG) module.
SAP CMS_INS_PSN Table Fields
Following is the list of fields that are available in SAP CMS_INS_PSN table. The primary key fields of the table are MANDT (Client), INS_PSN_GUID (Insurance Person GUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| INS_PSN_GUID | Insurance Person GUID | CMS_DTE_INS_PSN_GUID | RAW (16) | |
| INS_GUID | Insurance GUID | CMS_DTE_INS_GUID | RAW (16) | |
| INSRD_PRSN_NM | Name of the insured person | CMS_DTE_INS_PRSN_NAME | CHAR (30) | |
| PRSN_STATUS | Status of insurance | CMS_DTE_INS_STATUS | TCMS_ATT_ID_TY | CHAR (6) |
| PRSN_STATUS_DT | Status date of insurance | CMS_DTE_INS_STATUS_DT | DATS (8) | |
| SPEC_INS_RNK_PR | Specification on the insurance rank of the person | CMS_DTE_INS_SPEC_RNK_PRSN | CHAR (30) | |
| INSURED_RSK | Insured risk | CMS_DTE_INS_RSK | TCMS_ATT_ID_TY | CHAR (6) |
| SGLE_PRM | Insurance one time Cntribution /Single Premium insurance | CMS_DTE_INS_SGLE_PRM | CURR (17) | |
| SGLE_PRM_CKY | Currency | CMS_DTE_INS_SGLE_PRM_CKY | TCURC | CUKY (5) |
| ONE_TME_CON | Undrawn(unused) one time contribution | CMS_DTE_INS_ONE_TME_CON | CURR (17) | |
| ONE_TME_CON_CKY | Currency | CMS_DTE_INS_ONE_TM_CON_CKY | TCURC | CUKY (5) |
| RENEW_DAT | Renewal date(insurance premium) | CMS_DTE_INS_RENEW_DAT | DATS (8) | |
| 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) |
