SAP ABAP Table CMS_STR_INS_PSN_DATA_MAP_GET (Insurance PSN Data - GET - MAPI)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-RIG (Application Component) Rights
     ⤷ CMS_OMS_RIG (Package) Collateral Management Rights

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_INS_PSN_DATA_MAP_GET	Table Relationship Diagram
Short Description	Insurance PSN Data - GET - MAPI

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	PKY for CMS_INS_PSN
2	INS_PSN_GUID	☐	CMS_DTE_INS_PSN_GUID	SYSUUID	RAW	16	0	Insurance Person GUID
3	.INCLUDE	☐				0	0	Rights primary key
4	RIG_GUID	☐	CMS_DTE_RIG_GUID	SYSUUID	RAW	16	0	Rights GUID
5	.INCLUDE	☐				0	0	Semantic Key for insurance
6	RIG_CATEGORY	☐	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category	*
7	RIG_TYP	☐	CMS_DTE_RIG_TYP	CMS_RIG_TYP	CHAR	6	0	Right Type
8	RIG_ID	☐	CMS_DTE_RIG_ID	CMS_MOV_ID	CHAR	40	0	Rights ID
9	RIG_CAT_NAME	☐	CMS_DTE_OMS_CAT_NAME	CMS_OMS_CAT_NAME	CHAR	40	0	Object Category Name
10	RIG_TYP_NAME	☐	CMS_DTE_RIG_TYP_NAME	CMS_RIG_NAME	CHAR	40	0	Right Type Name
11	.INCLUDE	☐				0	0	LKY for CMS_INS_PSN
12	INS_GUID	☐	CMS_DTE_INS_GUID	SYSUUID	RAW	16	0	Insurance GUID
13	.INCLUDE	☐				0	0	Specifications per person
14	INSRD_PRSN_NM	☐	CMS_DTE_INS_PRSN_NAME	CMS_INS_PER_NAME	CHAR	30	0	Name of the insured person
15	PRSN_STATUS	☐	CMS_DTE_INS_STATUS	CMS_ATT_ID_TYP	CHAR	6	0	Status of insurance	TCMS_ATT_ID_TY
16	PRSN_STATUS_DT	☐	CMS_DTE_INS_STATUS_DT	DATUM	DATS	8	0	Status date of insurance
17	SPEC_INS_RNK_PR	☐	CMS_DTE_INS_SPEC_RNK_PRSN	CMS_INS_SPEC_RNK_PRSN	CHAR	30	0	Specification on the insurance rank of the person
18	INSURED_RSK	☐	CMS_DTE_INS_RSK	CMS_ATT_ID_TYP	CHAR	6	0	Insured risk	TCMS_ATT_ID_TY
19	SGLE_PRM	☐	CMS_DTE_INS_SGLE_PRM	CMS_AMOUNT	CURR	17	2	Insurance one time Cntribution /Single Premium insurance
20	SGLE_PRM_CKY	☐	CMS_DTE_INS_SGLE_PRM_CKY	WAERS	CUKY	5	0	Currency	TCURC
21	ONE_TME_CON	☐	CMS_DTE_INS_ONE_TME_CON	CMS_AMOUNT	CURR	17	2	Undrawn(unused) one time contribution
22	ONE_TME_CON_CKY	☐	CMS_DTE_INS_ONE_TM_CON_CKY	WAERS	CUKY	5	0	Currency	TCURC
23	RENEW_DAT	☐	CMS_DTE_INS_RENEW_DAT	DATUM	DATS	8	0	Renewal date(insurance premium)
24	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
25	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
26	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
27	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
28	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
29	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_INS_PSN_DATA_MAP_GET	INSURED_RSK	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
2	CMS_STR_INS_PSN_DATA_MAP_GET	ONE_TME_CON_CKY	TCURC	WAERS	REF	1	CN
3	CMS_STR_INS_PSN_DATA_MAP_GET	PRSN_STATUS	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
4	CMS_STR_INS_PSN_DATA_MAP_GET	SGLE_PRM_CKY	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20040819
SAP Release Created in	500