SAP ABAP Table CMS_STR_INS_DATA_SCR (Life Insurance Own Data - Screen)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CMS (Application Component) Collateral Management System
     CMS_OMS_RIG_UI (Package) Collateral Management Rights
Basic Data
Table Category INTTAB    Structure 
Structure CMS_STR_INS_DATA_SCR   Table Relationship Diagram
Short Description Life Insurance Own Data - Screen    
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   Primary Key for Insurance  
2 INS_GUID CMS_DTE_INS_GUID SYSUUID RAW 16   0   Insurance GUID  
3 .INCLUDE       0   0   Semantic Key for insurance  
4 INS_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category *
5 INS_TYP CMS_DTE_INS_TYPE CMS_MOV_TYP CHAR 6   0   Insurance Type *
6 INS_ID CMS_DTE_INS_ID CMS_MOV_ID CHAR 40   0   Insurance ID  
7 .INCLUDE       0   0   Insurance common data  
8 INS_DESC CMS_DTE_INS_DESC CMS_INS_DESC CHAR 30   0   Insurance Description  
9 .INCLUDE       0   0   Information on Insurance Settlement  
10 INSUR_TAX_DB CMS_DTE_INS_TAX_DB CMS_INS_FLG CHAR 1   0   Insurance tax to the debit of the bank  
11 SETLMNT_TYPE CMS_DTE_INS_SETLMNT_TYPE CMS_ATT_ID_TYP CHAR 6   0   Type of settlement TCMS_ATT_ID_TY
12 INSUR_SUM CMS_DTE_INS_SUM CMS_AMOUNT CURR 17   2   Insurance Sum  
13 INSUR_CURR CMS_DTE_INS_CURR WAERS CUKY 5   0   Insurance Currency TCURC
14 PRM_RT CMS_DTE_INS_PRM_RT CMS_INS_PRM_RT DEC 10   7   Premium Rate  
15 INSUR_PREMIUM CMS_DTE_INS_PRM CMS_AMOUNT CURR 17   2   Insurance Premium  
16 INSUR_PRM_CURR CMS_DTE_INS_CURR WAERS CUKY 5   0   Insurance Currency TCURC
17 INSUR_TAX_RT CMS_DTE_INS_TAX_RT CMS_INS_PRM_RT DEC 10   7   Insurance tax rate (in %)  
18 INSUR_TAX_AMT CMS_DTE_INS_TAX_AMT CMS_AMOUNT CURR 17   2   Insurance tax amount  
19 INSUR_TAX_CURR CMS_DTE_INS_TAX_CURR WAERS CUKY 5   0   Tax Currency TCURC
20 .INCLUDE       0   0   Insurance cover  
21 SCOPE_INS_COVER CMS_DTE_INS_COVER CMS_INS_COVER CHAR 6   0   not used -> package has to be changed CMS_OMS_INS  
22 .INCLUDE       0   0   Common OMS data  
23 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
24 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
25 FOP CMS_DTE_INS_FOP CMS_INS_FREQ_OF_PAYMENT NUMC 4   0   Frequency of Payment  
26 FREQ_UNIT CMS_DTE_INS_FREQ_UNIT CMS_INS_IND_FREQ_UNIT CHAR 2   0   Indicator: Units of time for revaluation  
27 .INCLUDE       0   0   Other general fields required for a standalone insurance  
28 INS_CODE CMS_DTE_INS_CODE CMS_INS_CODE CHAR 6   0   Insurance Product Code  
29 ORIG_COUNTRY CMS_DTE_INS_ORIG_COUNTRY LAND1 CHAR 3   0   Country where Insurance was purchased T005
30 ORIG_REGION CMS_DTE_INS_ORIG_REGION REGIO CHAR 3   0   Region where Insurance was purchased T005S
31 AUTO_CANCEL_DT CMS_DTE_INS_AUTO_CANCEL_DT CMS_DATE DATS 8   0   Auto Cancellation Date for an Insurance Policy  
32 PRM_TYPE CMS_DTE_INS_PRM_TYPE CMS_INS_PREMIUM_TYPE CHAR 2   0   Type of Premium  
33 PRM_VALID_FROM CMS_DTE_INS_PRM_VALID_FROM_DT CMS_DATE DATS 8   0   Date from when specified Premium is valid  
34 PAYMNT_METHOD CMS_DTE_INS_PAYMENT_METHOD CMS_INS_PAYMENT_METHOD CHAR 2   0   Payment method for premiums  
35 PAYMNT_INFO CMS_DTE_INS_PAY_INFO CMS_PAYMENT_HANDLE CHAR 30   0   Payment Info for an insurance policy  
36 LAST_PAYMENT_DT CMS_DTE_INS_LAST_PAYMENT_DT CMS_DATE DATS 8   0   Date when last premium payment was made  
37 NXT_PAYMENT_DT CMS_DTE_INS_NXT_PAYMENT_DT CMS_DATE DATS 8   0   Next Payment Date when insurance premium is due  
38 STATEMENT_DT CMS_DTE_INS_STATEMENT_DT CMS_DATE DATS 8   0   Date when statements for Policy was made  
39 REBATE_METHOD CMS_DTE_INS_REBATE_METHOD_ID CMS_INS_REBATE_METHOD_ID CHAR 6   0   Identifier for the rebate method used to calculate refunds TCMS_INS_REB
40 PORTFOLIO CMS_DTE_INS_PORTFOLIO CMS_INS_PORTFOLIO CHAR 6   0   Insurance Portfolio TCMS_INS_PORT
41 MAX_AGE_LIMIT CMS_DTE_INS_MAX_AGE_LIMIT CMS_AGE INT1 3   0   Maximum age limit for Policy Validity  
42 MAX_COVER_AMT CMS_DTE_INS_MAX_COVER_AMT CMS_AMOUNT CURR 17   2   Maximum Coverage Amount  
43 MIN_COVER_AMT CMS_DTE_INS_MIN_COVER_AMT CMS_AMOUNT CURR 17   2   Minimum Coverage Amount  
44 IND_INSURED_EVNT CMS_DTE_IND_INSURED_EVENT CMS_IND_OCCURENCE CHAR 1   0   Boolean indicator that insured event occured (X = Occured)  
45 INSURED_EVENT_DT CMS_DTE_INSURED_EVENT_DT CMS_DATE DATS 8   0   Date when Insured Event Occured  
46 IND_FORCE_PLACED CMS_DTE_INS_IND_FORCE_PLACE CMS_IND_INS_FORCE_PLACE CHAR 2   0   Is Insurance Force Placed? (Default = No)  
47 IND_TAX_DEDUCT CMS_DTE_INS_IND_TAX_DEDUCT CMS_IND_INS_TAX_DEDUCTIBLE CHAR 2   0   Indicator that Insurance Policy is Tax Deductible  
48 INACTIVE_REASON CMS_DTE_INS_INACTIVE_REASON CMS_INS_INACTIVE_REASON CHAR 2   0   Reason for inactivating insurance policy TCMS_INS_SRSN
49 POLICY_STATUS CMS_DTE_INS_POLICY_STATUS CMS_INS_POLICY_STATUS CHAR 2   0   Insurance Policy Status  
50 .INCLUDE       0   0   Insurance as object  
51 .INCLUDE       0   0   Special features for description of insurances  
52 TARRIF CMS_DTE_INS_TARRIF CMS_INS_TARRIF CHAR 30   0   Insurance tariff  
53 CONTRACT_STRT_DT CMS_DTE_INS_CNTRT_STRT_DT DATUM DATS 8   0   Contract begin date  
54 CONTRACT_END_DT CMS_DTE_INS_CNTRT_END_DT DATUM DATS 8   0   Contract end date  
55 CONTRACT_CON_DT CMS_DTE_INS_CNTRT_CON_DT DATUM DATS 8   0   Date of conclusion of contract  
56 INSUR_STATUS CMS_DTE_INS_STATUS CMS_ATT_ID_TYP CHAR 6   0   Status of insurance TCMS_ATT_ID_TY
57 INSUR_STATUS_DT CMS_DTE_INS_STATUS_DT DATUM DATS 8   0   Status date of insurance  
58 SUM_ONE_TM_CON CMS_DTE_INS_SUM_ONE_TM_CON CMS_AMOUNT CURR 17   2   Sum of one time contribution  
59 ONE_TM_CON_CKY CMS_DTE_INS_ONE_TM_CON_CKY WAERS CUKY 5   0   Currency TCURC
60 DYNAMICS CMS_DTE_INS_DYNAMICS CMS_INS_FLG CHAR 1   0   Dynamics  
61 PER_DYNAMICS CMS_DTE_INS_PER_DYNAMICS CMS_SEC_PCT DEC 10   6   Percentage of the dynamics  
62 TERMIN_PRD CMS_DTE_INS_TERMIN_PRD CMS_INS_FREQ_OF_PAYMENT NUMC 4   0   Termination period  
63 TERM_PRD_UNIT CMS_DTE_INS_TERM_PRD_UNIT CMS_INS_IND_FREQ_UNT CHAR 2   0   Indicator: Units of termination period  
64 RECALL_PRD CMS_DTE_INS_RECALL_PRD CMS_INS_FREQ_OF_PAYMENT NUMC 4   0   Recall period  
65 RECALL_PRD_UNIT CMS_DTE_INS_RECALL_PRD_UNIT CMS_INS_IND_FREQ_UNT CHAR 2   0   Indicator: Units of Recall Period  
66 INS_SUM_SRVL CMS_DTE_INS_SUM_IN_SURVIVAL CMS_AMOUNT CURR 17   2   Insurance sum incase of survival  
67 INS_SUM_SRVL_CKY CMS_DTE_INS_SUM_IN_SURVIVL_CKY WAERS CUKY 5   0   Insurance survival Currency TCURC
68 INS_SUM_DTH CMS_DTE_INS_SUM_IN_DEATH CMS_AMOUNT CURR 17   2   Insurance sum in case of death  
69 INS_SUM_DTH_CKY CMS_DTE_INS_SUM_IN_DEATH_CKY WAERS CUKY 5   0   Death benefit currency TCURC
70 INS_BENF_EXP CMS_DTE_INS_PROB_BENF CMS_AMOUNT CURR 17   2   Probable benefit on expiry  
71 INS_BENF_EXP_CKY CMS_DTE_INS_PROB_BENF_CKY WAERS CUKY 5   0   Currency for probable benefit on expiry TCURC
72 DT_PROB_BEN_EXP CMS_DTE_INS_DT_PRO_BEN_EXP DATUM DATS 8   0   Date of probable benefit on expiry  
73 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
74 .INCLUDE       0   0   Basic Asset data  
75 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
76 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
77 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
78 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country *
79 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code TCMS_RISKCODE
80 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
81 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
82 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
83 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount TCURC
84 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
85 .INCLUDE       0   0   Valuation data  
86 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
87 UNIT_VALN_FREQ CMS_DTE_IND_AST_VALN_FREQ_UNIT CMS_IND_AST_VALN_FREQ_UNIT CHAR 2   0   Indicator: Units of time for revaluation of an asset  
88 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
89 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
90 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
91 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
92 .INCLUDE       0   0   Lending rate data  
93 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
94 .INCLUDE       0   0   Lending rates structure  
95 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
96 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
97 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
98 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
99 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
100 .INCLUDE       0   0   Liquidation rights data  
101 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
102 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason TCMS_ATT_ID_TY
103 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
104 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
105 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value TCURC
106 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
107 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed TCURC
108 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
109 .INCLUDE       0   0   Account for liquidation proceeds  
110 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
111 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key T005
112 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
113 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
114 .INCLUDE       0   0   Verfication Data  
115 UNIT_VERF_FREQ CMS_DTE_IND_AST_VERF_FREQ_UNIT CMS_IND_AST_VERF_FREQ_UNIT CHAR 2   0   Indicator: Units of time for verification of an asset  
116 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
117 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
118 .INCLUDE       0   0   Structure for Asset values  
119 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
120 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value TCURC
121 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
122 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value TCURC
123 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
124 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity T006
125 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
126 .INCLUDE       0   0   Purchase price data  
127 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
128 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price TCURC
129 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
130 .INCLUDE       0   0   Administrative organization unit  
131 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
132 .INCLUDE       0   0   Bank area  
133 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management *
134 .INCLUDE       0   0   Organization unit structure  
135 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1 *
136 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2 *
137 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3 *
138 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4 *
139 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5 *
140 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
141 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
142 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
143 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
144 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
145 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
146 .INCLUDE       0   0   Change Hsitory Structure (For screen)  
147 CREATED_DATE CMS_DTE_DATE CMS_DATE DATS 8   0   Date  
148 CREATED_TIME CMS_DTE_TIME CMS_TIME TIMS 6   0   Time  
149 CHANGED_DATE CMS_DTE_DATE CMS_DATE DATS 8   0   Date  
150 CHANGED_TIME CMS_DTE_TIME CMS_TIME TIMS 6   0   Time  
151 .INCLUDE       0   0   Structure for Variable object field names  
152 NOM_VALUE_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
153 AST_VALUE_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
154 OBJECT_REF_ID_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CMS_STR_INS_DATA_SCR AST_VALUE_CURR TCURC WAERS    
2 CMS_STR_INS_DATA_SCR BANK_CNTRY_LIQ T005 LAND1 REF 1 CN
3 CMS_STR_INS_DATA_SCR EXP_PRCD_CURR TCURC WAERS REF 1 CN
4 CMS_STR_INS_DATA_SCR INACTIVE_REASON TCMS_INS_SRSN INACTIVE_REASON REF 1 CN
5 CMS_STR_INS_DATA_SCR INSUR_CURR TCURC WAERS REF 1 CN
6 CMS_STR_INS_DATA_SCR INSUR_PRM_CURR TCURC WAERS REF 1 CN
7 CMS_STR_INS_DATA_SCR INSUR_STATUS TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
8 CMS_STR_INS_DATA_SCR INSUR_TAX_CURR TCURC WAERS REF 1 CN
9 CMS_STR_INS_DATA_SCR INS_BENF_EXP_CKY TCURC WAERS REF 1 CN
10 CMS_STR_INS_DATA_SCR INS_SUM_DTH_CKY TCURC WAERS REF 1 CN
11 CMS_STR_INS_DATA_SCR INS_SUM_SRVL_CKY TCURC WAERS REF 1 CN
12 CMS_STR_INS_DATA_SCR LIQD_CURR TCURC WAERS    
13 CMS_STR_INS_DATA_SCR LIQD_REASON TCMS_ATT_ID_TY INDICATOR_TYPE    
14 CMS_STR_INS_DATA_SCR NOM_VALUE_CURR TCURC WAERS    
15 CMS_STR_INS_DATA_SCR ONE_TM_CON_CKY TCURC WAERS REF 1 CN
16 CMS_STR_INS_DATA_SCR ORIG_COUNTRY T005 LAND1 REF 1 CN
17 CMS_STR_INS_DATA_SCR ORIG_REGION T005S BLAND REF 1 CN
18 CMS_STR_INS_DATA_SCR PORTFOLIO TCMS_INS_PORT PORTFOLIO REF 1 CN
19 CMS_STR_INS_DATA_SCR PUR_PRICE_CURR TCURC WAERS    
20 CMS_STR_INS_DATA_SCR REBATE_METHOD TCMS_INS_REB REBATE_METHOD REF 1 CN
21 CMS_STR_INS_DATA_SCR RISK_CODE TCMS_RISKCODE RISK_CODE    
22 CMS_STR_INS_DATA_SCR SETLMNT_TYPE TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
23 CMS_STR_INS_DATA_SCR SFTY_AMT_CURR TCURC WAERS REF 1 CN
24 CMS_STR_INS_DATA_SCR UNIT_OF_MEASURE T006 MSEHI REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 500