CMS_INS_PSN SAP (Insurance - Specifications of Persons) Table details

Dictionary Type: Table
Description: Insurance - Specifications of Persons




ABAP Code to SELECT data from CMS_INS_PSN
Related tables to CMS_INS_PSN
Access table CMS_INS_PSN




Table field list including key, data, relationships and ABAP select examples

CMS_INS_PSN is a standard SAP Table which is used to store Insurance - Specifications of Persons data and is available within R/3 SAP systems 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. .

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

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).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!