TICL003

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.

-- Version der Internen Fallart
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TICL003 (
    CLIENT,            -- Client [mandt]
    CLTYPE,            -- Claim Type [icl_cltype]
    GENERAT,           -- Generation [icl_cltypeg]
    VERSION,           -- Clm Type Versn [icl_cltypev]
    CURR,              -- Currency [icl_cltype06]
    COMPLEX,           -- Std Complexity [icl_cltype01]
    DEFLTPOST,         -- CD Doc: Std Data [icl_defltpost]
    GFUNCTION,         -- DeactvFnct [icl_gfunction]
    CDSPEC_CLAIM,      -- CA SmplTemplate [icl_cdspec_claim]
    XDUBLCHECK,        -- Duplicate Check [icl_xdublcheck]
    LOSDATDEV,         -- Days Deviation [icl_lossdatdev]
    XNOPREMCHK,        -- No Premium Check [icl_xnopremchk]
    XPREMINCCI,        -- Ignore PaidPrem [icl_xpremincci]
    MAXOSPRMA,         -- Outstndng Prem. [icl_ospremamt]
    MAXOSPRMD,         -- Tolerance Days [icl_maxdaysprmos]
    POLBTOLH,          -- Tol.Incptn (H) [icl_perbtolh]
    POLETOLH,          -- Tol. End (Hr) [icl_peretolh]
    COVBTOLH,          -- Tol. Start (Hr) [icl_covbtolh]
    COVETOLH,          -- Tol. End (Hr) [icl_covetolh]
    DEDUCAMTTOL,       -- OutstDeductible [icl_deducamttol]
    DEDUCPERTOL,       -- Outst.Deduct.% [icl_deducpertol]
    STATCLAIMVR,       -- ClmStatus ValRq [icl_statclaimvr]
    STATSUBCLVR,       -- SubclmStatus VR [icl_statsubclvr]
    STATPAYVR,         -- PaytStat VR [icl_statpayvr]
    STATLITHVR,        -- LitigStatVR [icl_statlithvr]
    STATLITIVR,        -- LitigLvlStat VR [icl_statlitivr]
    STATNEG,           -- Neg.Stat.VR [icl_statneg_d_pe]
    NOCLXSUBCL,        -- SubC:XClaimMade [icl_noclxsubcl]
    NOCLNSUBCL,        -- XSubCl:XClmMade [icl_noclnsubcl]
    XREOPENNOCLM,      -- Reopen XClmMade [icl_xreopennoclm]
    INVOICE_GET_PROC,  -- Determ.of Inv.Itms fr.AppvItm [iclh_invoice_get_process]
    PROCESS,           -- Process [icl_process]
    CCTYPE,            -- Clm Bundle Type [icl_cceventcat_invoice]
    INVTYPE_REQ,       -- Receivable [icl_invtype_req]
    SCHEDCAT,          -- SchdPaytCat [icl_schedule_cat]
    DATELOSSCHK,       -- Date of Loss [icl_datelosschk]
    POLNEWIMP,         -- Contract Imported [icl_polnewimp]
    POLNUMCHK,         -- Permttd ContrNo [icl_polnumchk]
    REQFLDCHECK,       -- Req.Field Check [icl_reqfldcheck]
    CLAI_ATTRIB,       -- No.of Claimants [icl_clai_attrib]
    RCOVERCHECK,       -- RenewCovAsgnChk [icl_rcovercheck]
    COVERREJR,         -- Coverage Rejection [icl_coverrejr]
    CLAIMACLOSE,       -- Leave Open [icl_xno_claim_auto_close]
    XF4PRODCOVTYPES,   -- F4: CovrgeTypes [icl_xf4prodcovtypes]
    SPLIT_REQUIRED,    -- Split? [icl_split_required]
    XCCALC_SUPP_PS,    -- Compens.Calcltn [icl_xccalc_supp_ps]
    ROLE,              -- ParticipantRole [icl_role_crea]
    INIT_SEND_DAYS,    -- Days to Initial Send [icl_invstg_init_send_days_d_pe]
    INIT_SEND_EXPR,    -- Initial Send Expr. [icl_invstg_init_send_expr_d_pe]
    DFLT_SRCH_MNTH,    -- Def. Search Period [icl_invstg_dflt_srch_mnth_d_pe]
    RE_SRCH_MNTHS,     -- Re-Search (Mths) [icl_invstg_re_srch_mnths_d_pe]
    RE_SRCH_EXPR,      -- Re-Search Expressn [icl_invstg_re_srch_expr_d_pe]
    PRIMARY KEY (CLIENT, CLTYPE, GENERAT, VERSION)
);