SAP CMS_STR_LIF_INS_DATA_SET Life Insurance Data - GET Table data and field list

CMS_STR_LIF_INS_DATA_SET is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Life Insurance Data - GET" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMS_STR_LIF_INS_DATA_SET TYPE CMS_STR_LIF_INS_DATA_SET.

The CMS_STR_LIF_INS_DATA_SET table consists of various fields, each holding specific information or linking keys about Life Insurance Data - GET data available in SAP. These include INS_GUID (Insurance GUID), INS_CATEGORY (Object Category), INS_TYP (Insurance Type), INS_ID (Insurance ID)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_STR_LIF_INS_DATA_SET structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CMS_STR_LIF_INS_DATA_SET structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_STR_LIF_INS_DATA_SET table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
INS_GUIDInsurance GUID CMS_DTE_INS_GUIDRAW16SYSUUID
INS_CATEGORYObject Category CMS_DTE_OMS_OBJ_CATCHAR6Assigned to domainCMS_OBJ_CAT
INS_TYPInsurance Type CMS_DTE_INS_TYPECHAR6Assigned to domainCMS_MOV_TYPINS_TYPE
INS_IDInsurance ID CMS_DTE_INS_IDCHAR40ALPHACMS_MOV_ID
INS_DESCInsurance Description CMS_DTE_INS_DESCCHAR30CMS_INS_DESC
INSUR_TAX_DB Insurance tax to the debit of the bank CMS_DTE_INS_TAX_DBCHAR1CMS_INS_FLG
SETLMNT_TYPEType of settlement CMS_DTE_INS_SETLMNT_TYPECHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
INSUR_SUMInsurance Sum CMS_DTE_INS_SUMCURR17(2) CMS_AMOUNT
INSUR_CURRInsurance Currency CMS_DTE_INS_CURRCUKY5TCURCWAERS
PRM_RTPremium Rate CMS_DTE_INS_PRM_RTDEC10(7) CMS_INS_PRM_RT
INSUR_PREMIUMInsurance Premium CMS_DTE_INS_PRMCURR17(2) CMS_AMOUNT
INSUR_PRM_CURRInsurance Currency CMS_DTE_INS_CURRCUKY5TCURCWAERS
INSUR_TAX_RTInsurance tax rate (in %) CMS_DTE_INS_TAX_RTDEC10(7) CMS_INS_PRM_RT
INSUR_TAX_AMTInsurance tax amount CMS_DTE_INS_TAX_AMTCURR17(2) CMS_AMOUNT
INSUR_TAX_CURRTax Currency CMS_DTE_INS_TAX_CURRCUKY5TCURCWAERS
SCOPE_INS_COVERnot used -> package has to be changed CMS_OMS_INS CMS_DTE_INS_COVERCHAR6CMS_INS_COVER
EXT_ITM_NOExt. Item no / Number for identification of the objects CMS_DTE_OMS_EXT_ITM_NOCHAR40ALPHACMS_OMS_ID
EXT_REFERENCEReference number for the legacy system CMS_DTE_OMS_REF_IDCHAR32CMS_OMS_REFID
FOPFrequency of Payment CMS_DTE_INS_FOPNUMC4CMS_INS_FREQ_OF_PAYMENT
FREQ_UNITIndicator: Units of time for revaluation CMS_DTE_INS_FREQ_UNITCHAR2CMS_INS_IND_FREQ_UNIT
INS_CODEInsurance Product Code CMS_DTE_INS_CODECHAR6CMS_INS_CODE
ORIG_COUNTRYCountry where Insurance was purchased CMS_DTE_INS_ORIG_COUNTRYCHAR3T005LAND1
ORIG_REGIONRegion where Insurance was purchased CMS_DTE_INS_ORIG_REGIONCHAR3T005SREGIO
AUTO_CANCEL_DTAuto Cancellation Date for an Insurance Policy CMS_DTE_INS_AUTO_CANCEL_DTDATS8CMS_DATE
PRM_TYPEType of Premium CMS_DTE_INS_PRM_TYPECHAR2CMS_INS_PREMIUM_TYPE
PRM_VALID_FROMDate from when specified Premium is valid CMS_DTE_INS_PRM_VALID_FROM_DTDATS8CMS_DATE
PAYMNT_METHODPayment method for premiums CMS_DTE_INS_PAYMENT_METHODCHAR2CMS_INS_PAYMENT_METHOD
PAYMNT_INFOPayment Info for an insurance policy CMS_DTE_INS_PAY_INFOCHAR30CMS_PAYMENT_HANDLE
LAST_PAYMENT_DTDate when last premium payment was made CMS_DTE_INS_LAST_PAYMENT_DTDATS8CMS_DATE
NXT_PAYMENT_DTNext Payment Date when insurance premium is due CMS_DTE_INS_NXT_PAYMENT_DTDATS8CMS_DATE
STATEMENT_DTDate when statements for Policy was made CMS_DTE_INS_STATEMENT_DTDATS8CMS_DATE
REBATE_METHODIdentifier for the rebate method used to calculate refunds CMS_DTE_INS_REBATE_METHOD_IDCHAR6TCMS_INS_REBCMS_INS_REBATE_METHOD_ID
PORTFOLIOInsurance Portfolio CMS_DTE_INS_PORTFOLIOCHAR6TCMS_INS_PORTCMS_INS_PORTFOLIO
MAX_AGE_LIMITMaximum age limit for Policy Validity CMS_DTE_INS_MAX_AGE_LIMITINT13CMS_AGE
MAX_COVER_AMTMaximum Coverage Amount CMS_DTE_INS_MAX_COVER_AMTCURR17(2) CMS_AMOUNT
MIN_COVER_AMTMinimum Coverage Amount CMS_DTE_INS_MIN_COVER_AMTCURR17(2) CMS_AMOUNT
IND_INSURED_EVNTBoolean indicator that insured event occured (X = Occured) CMS_DTE_IND_INSURED_EVENTCHAR1CMS_IND_OCCURENCE
INSURED_EVENT_DTDate when Insured Event Occured CMS_DTE_INSURED_EVENT_DTDATS8CMS_DATE
IND_FORCE_PLACEDIs Insurance Force Placed? (Default = No) CMS_DTE_INS_IND_FORCE_PLACECHAR2CMS_IND_INS_FORCE_PLACE
IND_TAX_DEDUCTIndicator that Insurance Policy is Tax Deductible CMS_DTE_INS_IND_TAX_DEDUCTCHAR2CMS_IND_INS_TAX_DEDUCTIBLE
INACTIVE_REASONReason for inactivating insurance policy CMS_DTE_INS_INACTIVE_REASONCHAR2TCMS_INS_SRSNCMS_INS_INACTIVE_REASON
POLICY_STATUSInsurance Policy Status CMS_DTE_INS_POLICY_STATUSCHAR2CMS_INS_POLICY_STATUS
TARRIFInsurance tariff CMS_DTE_INS_TARRIFCHAR30CMS_INS_TARRIF
CONTRACT_STRT_DTContract begin date CMS_DTE_INS_CNTRT_STRT_DTDATS8DATUM
CONTRACT_END_DTContract end date CMS_DTE_INS_CNTRT_END_DTDATS8DATUM
CONTRACT_CON_DTDate of conclusion of contract CMS_DTE_INS_CNTRT_CON_DTDATS8DATUM
INSUR_STATUSStatus of insurance CMS_DTE_INS_STATUSCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
INSUR_STATUS_DTStatus date of insurance CMS_DTE_INS_STATUS_DTDATS8DATUM
SUM_ONE_TM_CONSum of one time contribution CMS_DTE_INS_SUM_ONE_TM_CONCURR17(2) CMS_AMOUNT
ONE_TM_CON_CKYCurrency CMS_DTE_INS_ONE_TM_CON_CKYCUKY5TCURCWAERS
DYNAMICSDynamics CMS_DTE_INS_DYNAMICSCHAR1CMS_INS_FLG
PER_DYNAMICSPercentage of the dynamics CMS_DTE_INS_PER_DYNAMICSDEC10(6) CMS_SEC_PCT
TERMIN_PRDTermination period CMS_DTE_INS_TERMIN_PRDNUMC4CMS_INS_FREQ_OF_PAYMENT
TERM_PRD_UNITIndicator: Units of termination period CMS_DTE_INS_TERM_PRD_UNITCHAR2CMS_INS_IND_FREQ_UNT
RECALL_PRDRecall period CMS_DTE_INS_RECALL_PRDNUMC4CMS_INS_FREQ_OF_PAYMENT
RECALL_PRD_UNITIndicator: Units of Recall Period CMS_DTE_INS_RECALL_PRD_UNITCHAR2CMS_INS_IND_FREQ_UNT
INS_SUM_SRVLInsurance sum incase of survival CMS_DTE_INS_SUM_IN_SURVIVALCURR17(2) CMS_AMOUNT
INS_SUM_SRVL_CKYInsurance survival Currency CMS_DTE_INS_SUM_IN_SURVIVL_CKYCUKY5TCURCWAERS
INS_SUM_DTHInsurance sum in case of death CMS_DTE_INS_SUM_IN_DEATHCURR17(2) CMS_AMOUNT
INS_SUM_DTH_CKYDeath benefit currency CMS_DTE_INS_SUM_IN_DEATH_CKYCUKY5TCURCWAERS
INS_BENF_EXPProbable benefit on expiry CMS_DTE_INS_PROB_BENFCURR17(2) CMS_AMOUNT
INS_BENF_EXP_CKYCurrency for probable benefit on expiry CMS_DTE_INS_PROB_BENF_CKYCUKY5TCURCWAERS
DT_PROB_BEN_EXPDate of probable benefit on expiry CMS_DTE_INS_DT_PRO_BEN_EXPDATS8DATUM
DESCRIPTIONDescription CMS_DTE_AST_DESCCHAR30CMS_DSC
OBJECT_REF_IDReference ID for the object CMS_DTE_OBJ_REFIDCHAR40CMS_OBJ_REFID
OBJECT_TYPNot used CMS_DTE_OBJ_TYPCHAR32CMS_OBJ_TYP
COUNTRY_KEYIdentification Key for Country CMS_DTE_AST_COUNTRY_KEYCHAR3Assigned to domainLAND1
RISK_CODERisk Code CMS_DTE_RISK_CODECHAR6Assigned to domainCMS_RISK_CODE
SFTY_INDIndicates if the Asset has a Default Safety Discount CMS_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTPercentage of Safety Discount CMS_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTAmount of Safety Discount CMS_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety Discount Amount CMS_DTE_SAFETY_AMT_CURRCUKY5TCURCWAERS
OBJSYSIDObject System Reference ID CMS_DTE_OBJ_SYSIDCHAR6CMS_SYSCMS_OBJSYSTEMIDCMS_OBJ_SYS
VALUATION_TYPType of Valuation Check performed on Collateral Object CMS_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator: Units of time for revaluation of an asset CMS_DTE_IND_AST_VALN_FREQ_UNITCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQRevaluation Period for an Asset CMS_DTE_AST_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
PAST_VALUED_DATELast Date on which the Asset was Valued CMS_DTE_VALN_DATEDATS8CMS_DATE
START_DATEDate on which the First Valuation is Performed on the Asset CMS_DTE_START_DATEDATS8CMS_DATE
END_DATEDate on which the Last Valuation is Performed on the Asset CMS_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicator to specify if Asset has a Default Lending Rate CMS_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending Rate 1 CMS_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending Rate 2 CMS_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending Rate 3 CMS_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending Rate 4 CMS_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending Rate 5 CMS_DTE_LRTE_PCT5DEC10(6) CMS_PCT
LIQD_TYPLiquidation Type CMS_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
LIQD_DATEDate on which the Collateral was Liquidated CMS_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTReturns from the Liquidation of Collateral CMS_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation Value CMS_DTE_LIQD_CURRCUKY5TCURCWAERS
EXP_PRCD_AMNTExpected Proceed Amount CMS_DTE_LIQ_EXP_PRCD_AMOUNTCURR17(2) CMS_AMOUNT
EXP_PRCD_CURRCurrency: Expected Proceed CMS_DTE_LIQ_EXP_PRCD_CURRCUKY5TCURCWAERS
EXP_ACC_DATEExpected accrual date CMS_DTE_LIQ_EXP_ACCRUAL_DATEDATS8CMS_DATE
ACC_NUMBER_LIQAccount number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBERCHAR35BANKN35
BANK_CNTRY_LIQBank country key CMS_DTE_LIQ_BNK_CTRY_KYCHAR3T005LAND1
BANK_KEY_LIQBank Key CMS_DTE_LIQ_BNK_KEYCHAR15BANKKBNK
BANK_CTRLKEY_LIQBank Control Key BKONTCHAR2BKONT
UNIT_VERF_FREQIndicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNITCHAR2CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQStatement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIODNUMC4CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATELast Verification Date CMS_DTE_AST_VERF_DATEDATS8CMS_DATE
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16SYSUUID
AST_TYPAsset Type CMS_DTE_AST_TYPCHAR6Assigned to domainCMS_AST_TYPCMS_AST_TYPCMS_AST_TYP
PARENT_GUIDAsset Guid as a parent GUID for a sub-asset CMS_DTE_SAS_PAR_GUIDRAW16SYSUUID
NOM_VALUENominal Value of the Asset CMS_DTE_AST_NOMINAL_VALUECURR17(2) CMS_AMOUNT
NOM_VALUE_CURRCurrency of Nominal value CMS_DTE_AST_NOMINAL_VALUE_CURRCUKY5TCURCWAERS
AST_VALUEFinal Asset Value CMS_DTE_AST_VALUECURR17(2) CMS_AMOUNT
AST_VALUE_CURRCurrency of the Final Asset Value CMS_DTE_AST_VALUE_CURRCUKY5TCURCWAERS
QUANTITYQuantity CMS_DTE_QTYQUAN13(3) CMS_QTY
UNIT_OF_MEASUREUnit of Measure of Quantity CMS_DTE_UNITUNIT3T006CUNITMEINS
REC_ATAsset Value Recording Timestamp CMS_DTE_REC_ATDEC15TZNTSTMPS
PUR_PRICEPurchase Price of the Asset CMS_DTE_AST_PURCHASE_PRICECURR17(2) CMS_AMOUNT
PUR_PRICE_CURRCurrency of Purchase Price CMS_DTE_AST_PUR_PRICE_CURRCUKY5TCURCWAERS
PUR_DATEDate of Purchase CMS_DTE_AST_PUR_PRICE_DATEDATS8CMS_DATE
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4Assigned to domainCMS_BANKAREACMS_BANKAREA
ORG_UNIT1Organizational Unit 1 CMS_DTE_ORG_UNIT1CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2 CMS_DTE_ORG_UNIT2CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3 CMS_DTE_ORG_UNIT3CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4 CMS_DTE_ORG_UNIT4CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5 CMS_DTE_ORG_UNIT5CHAR10Assigned to domainCMS_ORG_UNIT

Key field Non-key field



How do I retrieve data from SAP structure CMS_STR_LIF_INS_DATA_SET using ABAP code?

As CMS_STR_LIF_INS_DATA_SET is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMS_STR_LIF_INS_DATA_SET as there is no data to select.

How to access SAP table CMS_STR_LIF_INS_DATA_SET

Within an ECC or HANA version of SAP you can also view further information about CMS_STR_LIF_INS_DATA_SET and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).