SAP ABAP Table CMS_INS_PSN (Insurance - Specifications of Persons)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CMS-MD-RIG (Application Component) Rights
⤷ CMS_OMS_RIG (Package) Collateral Management Rights
⤷ FS-CMS-MD-RIG (Application Component) Rights
⤷ CMS_OMS_RIG (Package) Collateral Management Rights
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CMS_INS_PSN | Table Relationship Diagram |
Short Description | Insurance - Specifications of Persons |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | .INCLUDE | 0 | 0 | PKY for CMS_INS_PSN | |||||
3 | INS_PSN_GUID | CMS_DTE_INS_PSN_GUID | SYSUUID | RAW | 16 | 0 | Insurance Person GUID | ||
4 | .INCLUDE | 0 | 0 | LKY for CMS_INS_PSN | |||||
5 | INS_GUID | CMS_DTE_INS_GUID | SYSUUID | RAW | 16 | 0 | Insurance GUID | ||
6 | .INCLUDE | 0 | 0 | Specifications per person | |||||
7 | INSRD_PRSN_NM | CMS_DTE_INS_PRSN_NAME | CMS_INS_PER_NAME | CHAR | 30 | 0 | Name of the insured person | ||
8 | PRSN_STATUS | CMS_DTE_INS_STATUS | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Status of insurance | TCMS_ATT_ID_TY | |
9 | PRSN_STATUS_DT | CMS_DTE_INS_STATUS_DT | DATUM | DATS | 8 | 0 | Status date of insurance | ||
10 | 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 | ||
11 | INSURED_RSK | CMS_DTE_INS_RSK | CMS_ATT_ID_TYP | CHAR | 6 | 0 | Insured risk | TCMS_ATT_ID_TY | |
12 | SGLE_PRM | CMS_DTE_INS_SGLE_PRM | CMS_AMOUNT | CURR | 17 | 2 | Insurance one time Cntribution /Single Premium insurance | ||
13 | SGLE_PRM_CKY | CMS_DTE_INS_SGLE_PRM_CKY | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
14 | ONE_TME_CON | CMS_DTE_INS_ONE_TME_CON | CMS_AMOUNT | CURR | 17 | 2 | Undrawn(unused) one time contribution | ||
15 | ONE_TME_CON_CKY | CMS_DTE_INS_ONE_TM_CON_CKY | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
16 | RENEW_DAT | CMS_DTE_INS_RENEW_DAT | DATUM | DATS | 8 | 0 | Renewal date(insurance premium) | ||
17 | .INCLUDE | 0 | 0 | Stucture to record history of changes in all application tab | |||||
18 | CREATED_BY | CMS_DTE_USER | CMS_USER | CHAR | 12 | 0 | Login ID of the User who created the Record | ||
19 | CREATED_AT | CMS_DTE_CREATED_AT | TZNTSTMPS | DEC | 15 | 0 | Creation Timestamp | ||
20 | CHANGED_BY | CMS_DTE_LAST_CHNG_USER | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
21 | CHANGED_AT | CMS_DTE_CHANGED_AT | TZNTSTMPS | DEC | 15 | 0 | Change Timestamp | ||
22 | 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_INS_PSN | INSURED_RSK | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
2 | CMS_INS_PSN | ONE_TME_CON_CKY | TCURC | WAERS | REF | 1 | CN |
3 | CMS_INS_PSN | PRSN_STATUS | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
4 | CMS_INS_PSN | SGLE_PRM_CKY | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20040819 |
SAP Release Created in | 500 |