Das Standardwerk zum Änderungs- und Transportmanagement in der 4. Auflage! In diesem Buch finden Sie alle Informationen, die Sie zum Planen, Implementieren und Warten von Systemlandschaften benötigen. Sie lernen die Grundlagen und die Bedienung aller relevanten Werkzeuge und erhalten detaillierte Anleitungen zur Änderungs- und Transportverwaltung. Diese Neuauflage berücksichtigt Neuerungen in den Bereichen SAP NetWeaver AS Java und Development Infrastructure, CTS+, SAP Solution Manager und Enhancement Packages. Bringen Sie ihr Wissen auf den neuesten Stand!
Bei amazon.de ansehen →The table CMS_INS (Insurance Application Table) is a standard table in SAP ERP. It belongs to the package CMS_OMS_RIG.
Table | CMS_INS |
Short Text | Insurance Application Table |
Package | CMS_OMS_RIG |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
INS_GUID | ✔ | Insurance GUID | CMS_DTE_INS_GUID | RAW | 16 | |
INS_CATEGORY | Object Category | CMS_DTE_OMS_OBJ_CAT | CHAR | 6 | * | |
INS_TYP | Insurance Type | CMS_DTE_INS_TYPE | CHAR | 6 | * | |
INS_ID | Insurance ID | CMS_DTE_INS_ID | CHAR | 40 | ||
INS_DESC | Insurance Description | CMS_DTE_INS_DESC | CHAR | 30 | ||
INSUR_TAX_DB | Insurance tax to the debit of the bank | CMS_DTE_INS_TAX_DB | CHAR | 1 | ||
SETLMNT_TYPE | Type of settlement | CMS_DTE_INS_SETLMNT_TYPE | CHAR | 6 | TCMS_ATT_ID_TY | |
INSUR_SUM | Insurance Sum | CMS_DTE_INS_SUM | CURR | 17 | ||
INSUR_CURR | Insurance Currency | CMS_DTE_INS_CURR | CUKY | 5 | TCURC | |
PRM_RT | Premium Rate | CMS_DTE_INS_PRM_RT | DEC | 10 | ||
INSUR_PREMIUM | Insurance Premium | CMS_DTE_INS_PRM | CURR | 17 | ||
INSUR_PRM_CURR | Insurance Currency | CMS_DTE_INS_CURR | CUKY | 5 | TCURC | |
INSUR_TAX_RT | Insurance tax rate (in %) | CMS_DTE_INS_TAX_RT | DEC | 10 | ||
INSUR_TAX_AMT | Insurance tax amount | CMS_DTE_INS_TAX_AMT | CURR | 17 | ||
INSUR_TAX_CURR | Tax Currency | CMS_DTE_INS_TAX_CURR | CUKY | 5 | TCURC | |
SCOPE_INS_COVER | not used -> package has to be changed CMS_OMS_INS | CMS_DTE_INS_COVER | CHAR | 6 | ||
EXT_ITM_NO | Ext. Item no / Number for identification of the objects | CMS_DTE_OMS_EXT_ITM_NO | CHAR | 40 | ||
EXT_REFERENCE | Reference number for the legacy system | CMS_DTE_OMS_REF_ID | CHAR | 32 | ||
FOP | Frequency of Payment | CMS_DTE_INS_FOP | NUMC | 4 | ||
FREQ_UNIT | Indicator: Units of time for revaluation | CMS_DTE_INS_FREQ_UNIT | CHAR | 2 | ||
INS_CODE | Insurance Product Code | CMS_DTE_INS_CODE | CHAR | 6 | ||
ORIG_COUNTRY | Country where Insurance was purchased | CMS_DTE_INS_ORIG_COUNTRY | CHAR | 3 | T005 | |
ORIG_REGION | Region where Insurance was purchased | CMS_DTE_INS_ORIG_REGION | CHAR | 3 | T005S | |
AUTO_CANCEL_DT | Auto Cancellation Date for an Insurance Policy | CMS_DTE_INS_AUTO_CANCEL_DT | DATS | 8 | ||
PRM_TYPE | Type of Premium | CMS_DTE_INS_PRM_TYPE | CHAR | 2 | ||
PRM_VALID_FROM | Date from when specified Premium is valid | CMS_DTE_INS_PRM_VALID_FROM_DT | DATS | 8 | ||
PAYMNT_METHOD | Payment method for premiums | CMS_DTE_INS_PAYMENT_METHOD | CHAR | 2 | ||
PAYMNT_INFO | Payment Info for an insurance policy | CMS_DTE_INS_PAY_INFO | CHAR | 30 | ||
LAST_PAYMENT_DT | Date when last premium payment was made | CMS_DTE_INS_LAST_PAYMENT_DT | DATS | 8 | ||
NXT_PAYMENT_DT | Next Payment Date when insurance premium is due | CMS_DTE_INS_NXT_PAYMENT_DT | DATS | 8 | ||
STATEMENT_DT | Date when statements for Policy was made | CMS_DTE_INS_STATEMENT_DT | DATS | 8 | ||
REBATE_METHOD | Identifier for the rebate method used to calculate refunds | CMS_DTE_INS_REBATE_METHOD_ID | CHAR | 6 | TCMS_INS_REB | |
PORTFOLIO | Insurance Portfolio | CMS_DTE_INS_PORTFOLIO | CHAR | 6 | TCMS_INS_PORT | |
MAX_AGE_LIMIT | Maximum age limit for Policy Validity | CMS_DTE_INS_MAX_AGE_LIMIT | INT1 | 3 | ||
MAX_COVER_AMT | Maximum Coverage Amount | CMS_DTE_INS_MAX_COVER_AMT | CURR | 17 | ||
MIN_COVER_AMT | Minimum Coverage Amount | CMS_DTE_INS_MIN_COVER_AMT | CURR | 17 | ||
IND_INSURED_EVNT | Boolean indicator that insured event occured (X = Occured) | CMS_DTE_IND_INSURED_EVENT | CHAR | 1 | ||
INSURED_EVENT_DT | Date when Insured Event Occured | CMS_DTE_INSURED_EVENT_DT | DATS | 8 | ||
IND_FORCE_PLACED | Is Insurance Force Placed? (Default = No) | CMS_DTE_INS_IND_FORCE_PLACE | CHAR | 2 | ||
IND_TAX_DEDUCT | Indicator that Insurance Policy is Tax Deductible | CMS_DTE_INS_IND_TAX_DEDUCT | CHAR | 2 | ||
INACTIVE_REASON | Reason for inactivating insurance policy | CMS_DTE_INS_INACTIVE_REASON | CHAR | 2 | TCMS_INS_SRSN | |
POLICY_STATUS | Insurance Policy Status | CMS_DTE_INS_POLICY_STATUS | CHAR | 2 | ||
INS_STRT_DAT | Start date of insurance | CMS_DTE_INS_STRT_DAT | DATS | 8 | ||
INSUR_EXPY_DAT | Date of expiry of insurance | CMS_DTE_INS_EXPY_DAT | DATS | 8 | ||
REQD_INSUR_CVR | Required insurance cover | CMS_DTE_INS_REQD_CVR | CURR | 17 | ||
REQD_INSUR_CURR | Insurance Currency | CMS_DTE_INS_CURR | CUKY | 5 | TCURC | |
INSURER_NAM | Name of the insurer | CMS_DTE_INS_INSUR_NAM | CHAR | 30 | ||
INSURER_INF | Remarks on insurer | CMS_DTE_INS_INSUR_INF | CHAR | 30 | ||
COVER_MKT | Cover Market | CMS_DTE_INS_COVER_MKT | CHAR | 3 | * | |
SHARE_CVR_MKT | Share of cover market | CMS_DTE_INS_SH_CVR_MKT | CURR | 17 | ||
SH_CVR_MKT_CUR | Currency for Share of Cover Market | CMS_DTE_INS_SH_CVR_MKT_CUR | CUKY | 5 | * | |
CONTACT_FIRM | Contact firm | CMS_DTE_INS_CON_FRM | CHAR | 30 | ||
CONTACT_PARTNER | Contact partner | CMS_DTE_INS_CON_PRT | CHAR | 30 | ||
TARRIF | Insurance tariff | CMS_DTE_INS_TARRIF | CHAR | 30 | ||
CONTRACT_STRT_DT | Contract begin date | CMS_DTE_INS_CNTRT_STRT_DT | DATS | 8 | ||
CONTRACT_END_DT | Contract end date | CMS_DTE_INS_CNTRT_END_DT | DATS | 8 | ||
CONTRACT_CON_DT | Date of conclusion of contract | CMS_DTE_INS_CNTRT_CON_DT | DATS | 8 | ||
INSUR_STATUS | Status of insurance | CMS_DTE_INS_STATUS | CHAR | 6 | TCMS_ATT_ID_TY | |
INSUR_STATUS_DT | Status date of insurance | CMS_DTE_INS_STATUS_DT | DATS | 8 | ||
SUM_ONE_TM_CON | Sum of one time contribution | CMS_DTE_INS_SUM_ONE_TM_CON | CURR | 17 | ||
ONE_TM_CON_CKY | Currency | CMS_DTE_INS_ONE_TM_CON_CKY | CUKY | 5 | TCURC | |
DYNAMICS | Dynamics | CMS_DTE_INS_DYNAMICS | CHAR | 1 | ||
PER_DYNAMICS | Percentage of the dynamics | CMS_DTE_INS_PER_DYNAMICS | DEC | 10 | ||
TERMIN_PRD | Termination period | CMS_DTE_INS_TERMIN_PRD | NUMC | 4 | ||
TERM_PRD_UNIT | Indicator: Units of termination period | CMS_DTE_INS_TERM_PRD_UNIT | CHAR | 2 | ||
RECALL_PRD | Recall period | CMS_DTE_INS_RECALL_PRD | NUMC | 4 | ||
RECALL_PRD_UNIT | Indicator: Units of Recall Period | CMS_DTE_INS_RECALL_PRD_UNIT | CHAR | 2 | ||
INS_SUM_SRVL | Insurance sum incase of survival | CMS_DTE_INS_SUM_IN_SURVIVAL | CURR | 17 | ||
INS_SUM_SRVL_CKY | Insurance survival Currency | CMS_DTE_INS_SUM_IN_SURVIVL_CKY | CUKY | 5 | TCURC | |
INS_SUM_DTH | Insurance sum in case of death | CMS_DTE_INS_SUM_IN_DEATH | CURR | 17 | ||
INS_SUM_DTH_CKY | Death benefit currency | CMS_DTE_INS_SUM_IN_DEATH_CKY | CUKY | 5 | TCURC | |
INS_BENF_EXP | Probable benefit on expiry | CMS_DTE_INS_PROB_BENF | CURR | 17 | ||
INS_BENF_EXP_CKY | Currency for probable benefit on expiry | CMS_DTE_INS_PROB_BENF_CKY | CUKY | 5 | TCURC | |
DT_PROB_BEN_EXP | Date of probable benefit on expiry | CMS_DTE_INS_DT_PRO_BEN_EXP | DATS | 8 | ||
ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | CHAR | 12 | ||
BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | CHAR | 4 | * | |
CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR | 12 | ||
CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC | 15 | ||
CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR | 12 | ||
CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC | 15 | ||
SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR | 32 |