SAP CMS_INS_PSN Insurance - Specifications of Persons Table data and field list

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

The CMS_INS_PSN table consists of various fields, each holding specific information or linking keys about Insurance - Specifications of Persons data available in SAP. These include INS_PSN_GUID (Insurance Person GUID), INS_GUID (Insurance GUID), INSRD_PRSN_NM (Name of the insured person), PRSN_STATUS (Status of insurance)... 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_PSN 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_PSN 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_PSN 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_PSN_GUIDInsurance Person GUID CMS_DTE_INS_PSN_GUIDRAW16SYSUUID
INS_GUIDInsurance GUID CMS_DTE_INS_GUIDRAW16SYSUUID
INSRD_PRSN_NMName of the insured person CMS_DTE_INS_PRSN_NAMECHAR30CMS_INS_PER_NAME
PRSN_STATUSStatus of insurance CMS_DTE_INS_STATUSCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
PRSN_STATUS_DTStatus date of insurance CMS_DTE_INS_STATUS_DTDATS8DATUM
SPEC_INS_RNK_PRSpecification on the insurance rank of the person CMS_DTE_INS_SPEC_RNK_PRSNCHAR30CMS_INS_SPEC_RNK_PRSN
INSURED_RSKInsured risk CMS_DTE_INS_RSKCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
SGLE_PRMInsurance one time Cntribution /Single Premium insurance CMS_DTE_INS_SGLE_PRMCURR17(2) CMS_AMOUNT
SGLE_PRM_CKYCurrency CMS_DTE_INS_SGLE_PRM_CKYCUKY5TCURCWAERS
ONE_TME_CONUndrawn(unused) one time contribution CMS_DTE_INS_ONE_TME_CONCURR17(2) CMS_AMOUNT
ONE_TME_CON_CKYCurrency CMS_DTE_INS_ONE_TM_CON_CKYCUKY5TCURCWAERS
RENEW_DATRenewal date(insurance premium) CMS_DTE_INS_RENEW_DATDATS8DATUM
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_PSN using ABAP code

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

SELECT SINGLE *
FROM CMS_INS_PSN
INTO CORRESPONDING FIELDS OF WA_CMS_INS_PSN
WHERE...

How to access SAP table CMS_INS_PSN

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

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