Wenn der Standard nicht ausreicht: Mit diesem Buch lernen Sie, IDocs selbstständig zu programmieren und zu erweitern. Die Autorin beschreibt Customizing-Techniken, die Erweiterung der Standardbausteine und komplette Eigenentwicklungen. Ob Rückmeldungen von Statuswerten, E-Mail-Workflows oder Serialisierung – für alle Aufgaben finden Sie Anleitungen und Tipps aus der Programmierpraxis. Neu in dieser Auflage: Überwachung und Fehlerbehandlung mit dem SAP Application Interface Framework.
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 |