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.

-- Internal Claim Type Version
-- 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]
    ACTIVE,            -- Status [ICL_ACTIVE2]
    CHANGEDBY,         -- Changed by [ICL_CHANGEBY]
    CHANGETIME,        -- Created [ICL_CHANGEUTC]
    INACTIVETIME,      -- Deactivated [ICL_INACTIUTC]
    EFFFROMTIME,       -- Valid From [ICL_EFFROMUTC]
    EFFTOTIME,         -- Valid To [ICL_EFFETOUTC]
    TERMTIME,          -- Scheduled [ICL_TERMINUTC]
    DELETED,           -- Deletion entry [ICL_XDELETE]
    OVERSION,          -- Orig. version [ICL_CLTYPEVO]
    OSYSID,            -- Original System [ICL_OSYSID]
    OMANDT,            -- Original Client [ICL_OMANDT]
    BVERSION,          -- Basis Version [ICL_CLTYPEVB]
    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)
);