CMS_INS_PSN SAP table for – Insurance – Specifications of Persons

Here we would like to draw your attention to CMS_INS_PSN table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_INS_PSN is a SAP standard transp table used for storing Insurance – Specifications of Persons related data in SAP. It comes under the package CMS_OMS_RIG.

SAP CMS_INS_PSN table

Table CMS_INS_PSN technical data

TableCMS_INS_PSN
Data storingInsurance – Specifications of Persons
ModuleFS
Sub ModuleFS-CMS-MD-RIG
SAP PackageCMS_OMS_RIG
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_INS_PSN Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_INS_PSN table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : PKY for CMS_INS_PSN
    Its a key field.
  • INS_PSN_GUID : Insurance Person GUID
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : LKY for CMS_INS_PSN
  • INS_GUID : Insurance GUID
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Specifications per person
  • INSRD_PRSN_NM : Name of the insured person
    Its data type is CHAR (Character String) with field length 30
  • PRSN_STATUS : Status of insurance
    Its data type is CHAR (Character String) with field length 6
  • PRSN_STATUS_DT : Status date of insurance
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SPEC_INS_RNK_PR : Specification on the insurance rank of the person
    Its data type is CHAR (Character String) with field length 30
  • INSURED_RSK : Insured risk
    Its data type is CHAR (Character String) with field length 6
  • SGLE_PRM : Insurance one time Cntribution /Single Premium insurance
    Its data type is CURR (Currency Field) with field length 17
  • SGLE_PRM_CKY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ONE_TME_CON : Undrawn(unused) one time contribution
    Its data type is CURR (Currency Field) with field length 17
  • ONE_TME_CON_CKY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RENEW_DAT : Renewal date(insurance premium)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32