CMS_INS_PSN

Insurance - Specifications of Persons | #masterdata | Component: Rights
Column Name Description
MANDT Client
INS_PSN_GUID Insurance Person GUID
Column Name Description
💲 Currency (SGLE_PRM_CKY):
SGLE_PRM Insurance one time Cntribution /Single Premium insurance
💲 Currency (ONE_TME_CON_CKY):
ONE_TME_CON Undrawn(unused) one time contribution
Column Name Description
Column Name Description
PRSN_STATUS_DT Status date of insurance
RENEW_DAT Renewal date(insurance premium)
Column Name Description
Column Name Description Domain name
INS_GUID Insurance GUID SYSUUID
INSRD_PRSN_NM Name of the insured person CMS_INS_PER_NAME
SPEC_INS_RNK_PR Specification on the insurance rank of the person CMS_INS_SPEC_RNK_PRSN
CREATED_BY Login ID of the User who created the Record CMS_USER
CREATED_AT Creation Timestamp TZNTSTMPS
CHANGED_BY Last Changed By CMS_USER
CHANGED_AT Change Timestamp TZNTSTMPS
SOURCEOFENTRY Source of Entry CMS_SOURCE
Master Data Relations Join Conditions
Insured risk
  • ?
  • Client
  • Insured risk
Currency
  • CMS_INS_PSN.MANDT == TCURC.MANDT
  • CMS_INS_PSN.ONE_TME_CON_CKY == TCURC.WAERS
Status of insurance
  • ?
  • Client
  • Status of insurance
Currency
  • CMS_INS_PSN.MANDT == TCURC.MANDT
  • CMS_INS_PSN.SGLE_PRM_CKY == TCURC.WAERS