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