CMS_INS

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Insurance Application Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_INS (
    MANDT,             -- Client [MANDT]
    INS_GUID,          -- Ins. GUID [CMS_DTE_INS_GUID]
    INS_CATEGORY,      -- Object Category [CMS_DTE_OMS_OBJ_CAT]
    INS_TYP,           -- Insurance Type [CMS_DTE_INS_TYPE]
    INS_ID,            -- Insurance ID [CMS_DTE_INS_ID]
    INS_DESC,          -- Description [CMS_DTE_INS_DESC]
    INSUR_TAX_DB,      -- Ins. tax deb bk [CMS_DTE_INS_TAX_DB]
    SETLMNT_TYPE,      -- Settlement type [CMS_DTE_INS_SETLMNT_TYPE]
    INSUR_SUM,         -- Insurance Sum [CMS_DTE_INS_SUM]
    INSUR_CURR,        -- Currency [CMS_DTE_INS_CURR]
    PRM_RT,            -- Premium % [CMS_DTE_INS_PRM_RT]
    INSUR_PREMIUM,     -- Ins. Premium [CMS_DTE_INS_PRM]
    INSUR_PRM_CURR,    -- Currency [CMS_DTE_INS_CURR]
    INSUR_TAX_RT,      -- Ins. tax rate [CMS_DTE_INS_TAX_RT]
    INSUR_TAX_AMT,     -- Ins. tax amount [CMS_DTE_INS_TAX_AMT]
    INSUR_TAX_CURR,    -- Currency [CMS_DTE_INS_TAX_CURR]
    SCOPE_INS_COVER,   -- not used [CMS_DTE_INS_COVER]
    EXT_ITM_NO,        -- Ext. item no [CMS_DTE_OMS_EXT_ITM_NO]
    EXT_REFERENCE,     -- Ext Ref Number [CMS_DTE_OMS_REF_ID]
    INS_COMP,          -- Insurance Company [CMS_DTE_INS_COMP]
    FOP,               -- Frq. of payment [CMS_DTE_INS_FOP]
    FREQ_UNIT,         -- Units of time [CMS_DTE_INS_FREQ_UNIT]
    INS_CODE,          -- Insurance Code [CMS_DTE_INS_CODE]
    ORIG_COUNTRY,      -- Orig.CtryRegion [CMS_DTE_INS_ORIG_COUNTRY]
    ORIG_REGION,       -- Origin Region [CMS_DTE_INS_ORIG_REGION]
    AUTO_CANCEL_DT,    -- Autocancel Date [CMS_DTE_INS_AUTO_CANCEL_DT]
    PRM_TYPE,          -- PremiumType [CMS_DTE_INS_PRM_TYPE]
    PRM_VALID_FROM,    -- Premium From [CMS_DTE_INS_PRM_VALID_FROM_DT]
    PAYMNT_METHOD,     -- Payment Method [CMS_DTE_INS_PAYMENT_METHOD]
    PAYMNT_INFO,       -- Pay Handle [CMS_DTE_INS_PAY_INFO]
    LAST_PAYMENT_DT,   -- Last Payment Dt [CMS_DTE_INS_LAST_PAYMENT_DT]
    NXT_PAYMENT_DT,    -- Next Payment Dt [CMS_DTE_INS_NXT_PAYMENT_DT]
    STATEMENT_DT,      -- Statement Dt [CMS_DTE_INS_STATEMENT_DT]
    REBATE_METHOD,     -- RebateMethod ID [CMS_DTE_INS_REBATE_METHOD_ID]
    PORTFOLIO,         -- Portfolio [CMS_DTE_INS_PORTFOLIO]
    MAX_AGE_LIMIT,     -- Max. Age in Yrs [CMS_DTE_INS_MAX_AGE_LIMIT]
    MAX_COVER_AMT,     -- MaxCoverage Amt [CMS_DTE_INS_MAX_COVER_AMT]
    MIN_COVER_AMT,     -- MinCoverage Amt [CMS_DTE_INS_MIN_COVER_AMT]
    IND_INSURED_EVNT,  -- Insured Event [CMS_DTE_IND_INSURED_EVENT]
    INSURED_EVENT_DT,  -- InsuredEvent Dt [CMS_DTE_INSURED_EVENT_DT]
    IND_FORCE_PLACED,  -- Force Placement [CMS_DTE_INS_IND_FORCE_PLACE]
    IND_TAX_DEDUCT,    -- Tax deductible [CMS_DTE_INS_IND_TAX_DEDUCT]
    INACTIVE_REASON,   -- Reason Inactive [CMS_DTE_INS_INACTIVE_REASON]
    POLICY_STATUS,     -- Policy Status [CMS_DTE_INS_POLICY_STATUS]
    INS_STRT_DAT,      -- Ins. start date [CMS_DTE_INS_STRT_DAT]
    INSUR_EXPY_DAT,    -- Expiry date [CMS_DTE_INS_EXPY_DAT]
    REQD_INSUR_CVR,    -- Reqd ins. cover [CMS_DTE_INS_REQD_CVR]
    REQD_INSUR_CURR,   -- Currency [CMS_DTE_INS_CURR]
    INSURER_NAM,       -- Insurer [CMS_DTE_INS_INSUR_NAM]
    INSURER_INF,       -- remarks [CMS_DTE_INS_INSUR_INF]
    COVER_MKT,         -- Cover Market [CMS_DTE_INS_COVER_MKT]
    SHARE_CVR_MKT,     -- Share [CMS_DTE_INS_SH_CVR_MKT]
    SH_CVR_MKT_CUR,    -- Currency [CMS_DTE_INS_SH_CVR_MKT_CUR]
    CONTACT_FIRM,      -- Agent [CMS_DTE_INS_CON_FRM]
    CONTACT_PARTNER,   -- Contact partner [CMS_DTE_INS_CON_PRT]
    TARRIF,            -- Tariff [CMS_DTE_INS_TARRIF]
    CALC_BASIS,        -- cal. basis [CMS_DTE_CMS_INS_CALC_BASIS]
    INT_CALC_METH,     -- Intrst cal mthd [CMS_DTE_INS_INT_CAL_MTD]
    CONTRACT_STRT_DT,  -- Contract begin [CMS_DTE_INS_CNTRT_STRT_DT]
    CONTRACT_END_DT,   -- Contract end [CMS_DTE_INS_CNTRT_END_DT]
    CONTRACT_CON_DT,   -- Conclusion on [CMS_DTE_INS_CNTRT_CON_DT]
    INSUR_STATUS,      -- InsuranceStatus [CMS_DTE_INS_STATUS]
    INSUR_STATUS_DT,   -- Ins status date [CMS_DTE_INS_STATUS_DT]
    SUM_ONE_TM_CON,    -- Sum of one time [CMS_DTE_INS_SUM_ONE_TM_CON]
    ONE_TM_CON_CKY,    -- Currency [CMS_DTE_INS_ONE_TM_CON_CKY]
    DYNAMICS,          -- Dynamics [CMS_DTE_INS_DYNAMICS]
    PER_DYNAMICS,      -- Dynamics % [CMS_DTE_INS_PER_DYNAMICS]
    TERMIN_PRD,        -- Termin. period [CMS_DTE_INS_TERMIN_PRD]
    TERM_PRD_UNIT,     -- Termin. period [CMS_DTE_INS_TERM_PRD_UNIT]
    RECALL_PRD,        -- Recall period [CMS_DTE_INS_RECALL_PRD]
    RECALL_PRD_UNIT,   -- Un. of rec. prd [CMS_DTE_INS_RECALL_PRD_UNIT]
    INS_SUM_SRVL,      -- Surv. benefit [CMS_DTE_INS_SUM_IN_SURVIVAL]
    INS_SUM_SRVL_CKY,  -- Currency [CMS_DTE_INS_SUM_IN_SURVIVL_CKY]
    INS_SUM_DTH,       -- Death benefit [CMS_DTE_INS_SUM_IN_DEATH]
    INS_SUM_DTH_CKY,   -- Currency [CMS_DTE_INS_SUM_IN_DEATH_CKY]
    INS_BENF_EXP,      -- Expiry benefit [CMS_DTE_INS_PROB_BENF]
    INS_BENF_EXP_CKY,  -- Currency [CMS_DTE_INS_PROB_BENF_CKY]
    DT_PROB_BEN_EXP,   -- Date of benefit [CMS_DTE_INS_DT_PRO_BEN_EXP]
    ADMIN_ORG_UNIT,    -- AdminOrg [CMS_DTE_ADMINORG]
    BANKAREA,          -- Bankarea [CMS_DTE_BANKAREA]
    CREATED_BY,        -- Created by [CMS_DTE_USER]
    CREATED_AT,        -- Created At [CMS_DTE_CREATED_AT]
    CHANGED_BY,        -- Last Changed by [CMS_DTE_LAST_CHNG_USER]
    CHANGED_AT,        -- Changed At [CMS_DTE_CHANGED_AT]
    SOURCEOFENTRY,     -- Source Of Entry [CMS_DTE_SOURCE_OF_ENTRY]
    BUPR_ID,           -- Bus. Process ID [CMS_DTE_BUPR_ID]
    BUPR_TYPE_CODE,    -- BusProcess Code [CMS_DTE_BUPR_TYP_CODE]
    PRIMARY KEY (MANDT, INS_GUID)
);