1. Home
  2. Resources
  3. SAP Tables
  4. ICLCLAIM - Claim

SAP Table ICLCLAIM

Claim

ICLCLAIM (Claim) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ICLCLAIM to other SAP tables.

ICLCLAIM table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
ACTIVE Table entry is active (A) or in suspense (S) ICL_ACTIVE CHAR 1 0
A Table Entry Is Active
S Table Entry Is in Suspense
CLAIM Number of Claim ICL_CLAIM CHAR 17 0
CHANGETIME Changed: Date + Time ICL_CHANGEUTC1 DEC 15 0
CHANGEDBY Changed By ICL_CHANGEDBY USR02 CHAR 12 0
DELETED Database Line Status (Original, Changed, Deleted) ICL_RECSTATUS CHAR 1 0
O Original
C Changed
X Deleted
CREATEDBY Created By ICL_CREATEDBY USR02 CHAR 12 0
CREATETIME Created: Date + Time ICL_CREATEUTC DEC 15 0
ACHANGEDBY Whole Claim Last Changed By ICL_ACHANGEDBY USR02 CHAR 12 0
ACHANGETIME Whole Claim Last Changed At ICL_ACHANGETIME DEC 15 0
EXCLAIMNOCAT External Number Category ICL_CLAIMNOCAT CHAR 1 0
D Data medium number
NULL Ext. Claim No.
EXCLAIMNO External Number ICL_CLAIMNO CHAR 23 0
STATUS Status of Claim ICL_CLSTATUS TICL140 CHAR 2 0
STATUSCHG Time of Last Status Change ICL_STATUSCHG DEC 15 0
STHANDLER "Claim Handling" Process Active ICL_STHANDLER CHAR 1 0
X Yes
NULL No
STNOCLAIM No Claim Made ICL_STNOCLAIM CHAR 1 0
X Yes
NULL No
STCLOSED "Close (Sub)Claim" Process Executed ICL_STCLOSED CHAR 1 0
X Yes
NULL No
STATREASON Reason for Changing the Status ICL_FORMSET TICL047 CHAR 2 0
LOSSTYPE Incident Type of a Claim ICL_LOSSTYPE TICL062 CHAR 4 0
CLAIMTYPE Internal Claim Type ICL_CLTYPE TICL011 CHAR 4 0
CLTYPEG Generation of Internal Claim Type ICL_CLTYPEG TICL011 NUMC 5 0
CLTYPEV Internal Claim Type Version ICL_CLTYPEV TICL003 NUMC 5 0
LOSSEVENT Cumulative Event ICL_LOSSEVENT ICLCCEVENT CHAR 17 0
POLPROD Policy Product ICL_POLPROD TICL320 CHAR 6 0
GENERAT Policy Product Generation ICL_GENERAT TICL320 NUMC 5 0
VERSION Policy Product Version ICL_POLPRODV TICL321 NUMC 5 0
LRENEWAL Last Renewal of Contract Before Claim Date/Time ICL_LRENEWAL DEC 15 0
POLICY Contract Number ICL_POLICY CHAR 17 0
LOSSCAUSE Cause of Loss/Claim ICL_LOSSCAUSE TICL009 CHAR 3 0
PERIL Peril ICL_PERIL CHAR 4 0
DATELOSS Date of Loss/Claim ICL_LOSSDATE DATS 8 0
TIMELOSS Time of Claim/Loss ICL_LOSSTIME TIMS 6 0
LTIMEZONE Time Zone of Claim/Loss Event ICL_LTIMEZONE TTZZ CHAR 6 0
XDATEESTIM Date Is Estimate ICL_XLOSSDATE CHAR 1 0
X Yes
NULL No
DATECHANGER Reason for Changing Claim Date ICL_DATECHANGER TICL029 CHAR 2 0
LOSSREPCOMPA Date Claim Reported to Insurance Company ICL_LOSSREPCOMPA DATS 8 0
LOSSREPAGENT Date on Which Claim Was Reported to Agent ICL_LOSSREPAGENT DATS 8 0
LOSSADDRESS Loss Location ICL_LOSSADDRESS ADRC CHAR 10 0
XAUTHREP Claim/Loss Reported to Authority ICL_XAUTHREP CHAR 1 0
X Yes
NULL No
XSENSITIVE Sensitive Claim? ICL_CLAIMSENS CHAR 1 0
X Yes
NULL No
COMPLEX Complexity of Claim/Subclaim ICL_COMPLEX TICL027 CHAR 1 0
JURISCOUNTRY Jurisdiction Country ICL_JURICOUNTRY T005 CHAR 3 0
JURISREGION Jurisdiction Region ICL_JURISREGION T005S CHAR 3 0
ASSIGN_STATE Assignment Status of a Claim Subobject ICL_ASSIGN_STATE CHAR 2 0
NULL Undefined: Should Not Appear in Operative System
UU Group and Claim Handler Not Assigned
AU Group Assigned Automatically, Claim Handler Not Assigned
MU Group Assigned Manually, Claim Handler Not Assigned
XU Group Incorrect, Claim Handler Not Assigned
UA Group Not Assigned, Claim Handler Assigned Automatically
AA Groupe and Claim Handler Assigned Automatically
MA Group Assigned Manually, Claim Hdler Assigned Automatically
XA Group Incorrect, Claim Handler Assigned Automatically
UM Group Not Assigned, Claim Handler Assigned Manually
AM Group Assigned Automatically, Claim Handler Assgnd Manually
MM Group and Claim Handler Assigned Manually
XM Group Incorrect, Claim Handler Assigned Manually
UX Group Not Assigned, Claim Handler Assigned Incorrectly
AX Group Assigned Automatically, Claim Hdler Assigned Incorrect
MX Group Assigned Manually, Claim Hdler Assigned Incorrectly
XX Group and Claim Handler Assigned Incorrectly
OWNERTYPE Object Type of Claim Handler ICL_OWNERTYPE T778O CHAR 2 0
OWNER ID of Claim Handler ICL_CLAIMOWNER CHAR 12 0
OWNERTYPE_GRP Object Type of Claim Handler Group ICL_OWNERTYPE2 CHAR 2 0
OWNER_GRP Claim Handler Group ICL_CLAIMOWNER2 CHAR 12 0
XCUMUL Claim Assigned to an Aggregate ICL_XCUMUL CHAR 1 0
X Yes
NULL No
VIEWFAULT Fault of Policyholder from Point of View of Insurer ICL_VIEWFAULTI TICL081 CHAR 1 0
VIEWFAULTPH Party at Fault from Point of View of Policyholder ICL_VIEWFAULTPH TICL081 CHAR 1 0
TPNO Third Party Count (NOT USED) ICL_TPNO NUMC 2 0
XTPKNOWN Flag: Third Party Known? ICL_TPKNOWN CHAR 1 0
X Yes
NULL No
COVERED Indication of Compensability ICL_COVERED CHAR 1 0
X Yes
N No
AUTHCLM Authorization Group for Claims (VIP) ICL_AUTHCLM TICL113 CHAR 4 0
XCLAIMB Entry in ICLCLAIMB Exists ICL_XCLAIMB CHAR 1 0
X Yes
NULL No
XNONOTIF Processing Not Possible in Notification Mode ICL_XNONOTIF CHAR 1 0
X Yes
NULL No
XRESERVE At Least One Reserve Exists in Claim ICL_XRESERVE CHAR 1 0
X Yes
NULL No
BENTREE Benefit Type Tree ICL_BENTREE CHAR 8 0
BENTREEG Generation of Benefit Type Tree ICL_BENTREEG NUMC 5 0
BENTREEV Version of Benefit Type Tree ICL_BENTREEV NUMC 5 0
WF_EXEC_TIME Execution Time Workflow ICL_WF_EXECUTION_TIME DEC 15 0
WF_STATUS Workflow Status ICL_WF_STATUS NUMC 1 0
1 Workflow Not Started
2 Workflow Started
3 Workflow Completed
4 Workflow Started Again
XDUMMYCLAIM Flag: Dummy Claim ICL_XDUMMYCLAIM CHAR 1 0
X Yes
NULL No
VERCHNGUTC Time for Reading Version ICL_VERCHNGUTC DEC 15 0
OPENDATE Opened On ICL_OPENDATE DATS 8 0
XWITHOUT_PRODUCT Use of Scenario Without Product Customizing ICL_XWITHOUTPRODUCT_D CHAR 1 0
X TRUE
NULL FALSE
MAX_ITEMNR Current Highest Claim Item Number ICL_SCLITEM_NR_MAX CHAR 4 0
ASSIGN_GUID UUID of Entry to be Linked ICL_ASSIGN_GUID CHAR 32 0
SIF_STATUS Status of Second Injury Fund ICL_SIF_STATUS_D CHAR 1 0
NULL Not Assigned
P Potential SIF Claim
F Filed with SIF (Pending Acceptance)
A Accepted
R Accepted (Refund Only)
X Rejected
W Accepted (Direct Payment in Full by SIF)
INVSTG_STATUS Claim Investigation Match Status ICL_INVSTG_MATCH_STATUS_D_PE CHAR 1 0
NULL Not Sent for Investigation
I Initial Send Performed
E Initial Send Failed
M Match Found
EFFECTIVE_DT Contract Validity Date ICL_EFFECTIVE_DT_D DATS 8 0
LOSSREP_DT Date on Request for Insurance Benefit ICL_LOSSREP_DT_D DATS 8 0
LUMPSUMOPTION Option Exercised ICL_LUMPSUMOPTION_D CHAR 1 0
STATPENSION Type of Statutory Pension ICL_STATPENSION_D CHAR 3 0
WITHDRAWAM Requested Total Withdrawal Amount ICL_WITHDRAWAM_D CURR 15 2
WITHDRAWCURR Currency of Withdrawal Amount ICL_WITHDRAWCURR_D CUKY 5 0
WITHDRAWSEQ Withdrawal Sequence ICL_WITHDRAWSEQ_D CHAR 3 0
ALTERNATEBEN Display Alternative Benefit Values ICL_ALTERNATEBEN_D CHAR 1 0
GENERATENOTIF Make Special Risk Notification ICL_GENERATENOTIF_D CHAR 1 0
NOTIFREASON Reason for Special Risk Notification ICL_NOTIFREASON_D CHAR 3 0
AUTFOLLOWUP Automatic Resubmission ICL_AUTFOLLOWUP_D CHAR 1 0
X Automatic Resubmission
NULL No Automatic Resubmission
FOLLOWUP_DT Date of Automatic Resubmission ICL_FOLLOWUP_DT_D DATS 8 0
PROCESSING_DT Processing On ICL_PROCESSING_DT_D DATS 8 0
STATUSOBJID Object number J_OBJNR CHAR 22 0
DUNNLEVEL Dunning Status ICL_DUNNLEVEL_D CHAR 2 0
CLEARDATE Premium Paid Up To ICL_CLEARDATE_D DATS 8 0
PREMBALANAM Premium Balance ICL_PREMBALANAM_D CURR 15 2
PREMBALANAMCURR Currency of Premium Payment ICL_PREMBALANAMCURR_D CUKY 5 0
WITHDRAWTYPE Withdrawal Type ICL_WITHDRAWTYPE_D CHAR 3 0
REACT_DT Date of Occupational Disability/Perm.Incap.to Wk Reactivatn ICL_REACT_DT_D DATS 8 0
GENNOTIFTIME Special Risk Message Submitted On ICL_GENERATENOTIFTIME_D DEC 15 0
BEN_CALC_FAIL Time of Last Incorrect Benefit Calculation ICL_BEN_CALC_FAIL_D DEC 15 0
POLSYSTEM Technical Key of Policy System ICL_POLSYSTEM_D CHAR 8 0
ARCHIVE_STATUS Archiving Status TYP_ARCHIVE_STATUS CHAR 1 0
NULL No Analysis Made
1 Not Archivable
2 Archivable
3 Can be deleted
4 Archived
5 Cannot be Deleted
ARCHIVE_FLUD Resubmission Date TYP_ARCHIVE_FLUD DATS 8 0
REJECTION Rejection Reason TYP_REJECTION CHAR 2 0

ICLCLAIM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ICLCLAIM ACHANGEDBY ICLCLAIM ACHANGEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICLCLAIM ACHANGEDBY ICLCLAIM CLIENT USR02 Logon Data (Kernel-Side Use) MANDT
ICLCLAIM AUTHCLM ICLCLAIM AUTHCLM TICL113 Authorization Groups Claims (VIP) AUTHCLM
ICLCLAIM AUTHCLM SYST MANDT TICL113 Authorization Groups Claims (VIP) CLIENT
ICLCLAIM CHANGEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
ICLCLAIM CHANGEDBY ICLCLAIM CHANGEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICLCLAIM CLAIMTYPE ICLCLAIM CLIENT TICL011 Generation of Internal Claim Type CLIENT
ICLCLAIM CLAIMTYPE ICLCLAIM CLAIMTYPE TICL011 Generation of Internal Claim Type CLTYPE
ICLCLAIM CLAIMTYPE * TICL011 Generation of Internal Claim Type VERSION
ICLCLAIM CLIENT ICLCLAIM CLIENT T000 Clients MANDT
ICLCLAIM CLTYPEG ICLCLAIM CLAIMTYPE TICL011 Generation of Internal Claim Type CLTYPE
ICLCLAIM CLTYPEG ICLCLAIM CLTYPEG TICL011 Generation of Internal Claim Type VERSION
ICLCLAIM CLTYPEG ICLCLAIM CLIENT TICL011 Generation of Internal Claim Type CLIENT
ICLCLAIM CLTYPEV ICLCLAIM CLTYPEV TICL003 Internal Claim Type Version VERSION
ICLCLAIM CLTYPEV ICLCLAIM CLIENT TICL003 Internal Claim Type Version CLIENT
ICLCLAIM CLTYPEV ICLCLAIM CLAIMTYPE TICL003 Internal Claim Type Version CLTYPE
ICLCLAIM CLTYPEV ICLCLAIM CLTYPEG TICL003 Internal Claim Type Version GENERAT
ICLCLAIM COMPLEX * TICL027 Internal Claim Type: Permitted Subclaim Complexity SUBCLTYPE
ICLCLAIM COMPLEX ICLCLAIM COMPLEX TICL027 Internal Claim Type: Permitted Subclaim Complexity COMPLEX
ICLCLAIM COMPLEX ICLCLAIM CLIENT TICL027 Internal Claim Type: Permitted Subclaim Complexity CLIENT
ICLCLAIM COMPLEX ICLCLAIM CLAIMTYPE TICL027 Internal Claim Type: Permitted Subclaim Complexity CLTYPE
ICLCLAIM COMPLEX ICLCLAIM CLTYPEG TICL027 Internal Claim Type: Permitted Subclaim Complexity GENERAT
ICLCLAIM COMPLEX ICLCLAIM CLTYPEV TICL027 Internal Claim Type: Permitted Subclaim Complexity VERSION
ICLCLAIM CREATEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
ICLCLAIM CREATEDBY ICLCLAIM CREATEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICLCLAIM DATECHANGER ICLCLAIM CLIENT TICL029 Reason for Changing Claim Date CLIENT
ICLCLAIM DATECHANGER ICLCLAIM DATECHANGER TICL029 Reason for Changing Claim Date DATECHANGER
ICLCLAIM GENERAT ICLCLAIM GENERAT TICL320 Policy Product Generation VERSION
ICLCLAIM GENERAT ICLCLAIM CLIENT TICL320 Policy Product Generation CLIENT
ICLCLAIM GENERAT ICLCLAIM POLPROD TICL320 Policy Product Generation POLPROD
ICLCLAIM JURISCOUNTRY ICLCLAIM CLIENT T005 Countries MANDT
ICLCLAIM JURISCOUNTRY ICLCLAIM JURISCOUNTRY T005 Countries LAND1
ICLCLAIM JURISREGION ICLCLAIM JURISREGION T005S Taxes: Region (Province) Key BLAND
ICLCLAIM JURISREGION ICLCLAIM CLIENT T005S Taxes: Region (Province) Key MANDT
ICLCLAIM JURISREGION ICLCLAIM JURISCOUNTRY T005S Taxes: Region (Province) Key LAND1
ICLCLAIM LOSSADDRESS * ADRC Addresses (Business Address Services) DATE_FROM
ICLCLAIM LOSSADDRESS * ADRC Addresses (Business Address Services) NATION
ICLCLAIM LOSSADDRESS ICLCLAIM CLIENT ADRC Addresses (Business Address Services) CLIENT
ICLCLAIM LOSSADDRESS ICLCLAIM LOSSADDRESS ADRC Addresses (Business Address Services) ADDRNUMBER
ICLCLAIM LOSSCAUSE ICLCLAIM LOSSCAUSE TICL009 Internal Claim Type: Permitted Cause of Claim LOSSCAUSE
ICLCLAIM LOSSCAUSE ICLCLAIM CLIENT TICL009 Internal Claim Type: Permitted Cause of Claim CLIENT
ICLCLAIM LOSSCAUSE ICLCLAIM CLAIMTYPE TICL009 Internal Claim Type: Permitted Cause of Claim CLTYPE
ICLCLAIM LOSSCAUSE ICLCLAIM CLTYPEG TICL009 Internal Claim Type: Permitted Cause of Claim GENERAT
ICLCLAIM LOSSCAUSE ICLCLAIM CLTYPEV TICL009 Internal Claim Type: Permitted Cause of Claim VERSION
ICLCLAIM LOSSEVENT ICLCLAIM CLIENT ICLCCEVENT Claim Bundle CLIENT
ICLCLAIM LOSSEVENT 'A' ICLCCEVENT Claim Bundle ACTIVE
ICLCLAIM LOSSEVENT ICLCLAIM LOSSEVENT ICLCCEVENT Claim Bundle CCEVENT
ICLCLAIM LOSSTYPE ICLCLAIM CLIENT TICL062 Policy Product - Internal Claim Type - Determination CLIENT
ICLCLAIM LOSSTYPE * TICL062 Policy Product - Internal Claim Type - Determination POLPROD
ICLCLAIM LOSSTYPE * TICL062 Policy Product - Internal Claim Type - Determination GENERAT
ICLCLAIM LOSSTYPE * TICL062 Policy Product - Internal Claim Type - Determination VERSION
ICLCLAIM LOSSTYPE ICLCLAIM LOSSTYPE TICL062 Policy Product - Internal Claim Type - Determination LOSSTYPE
ICLCLAIM LTIMEZONE ICLCLAIM CLIENT TTZZ Time zones CLIENT
ICLCLAIM LTIMEZONE ICLCLAIM LTIMEZONE TTZZ Time zones TZONE
ICLCLAIM OWNERTYPE ICLCLAIM CLIENT T778O Object Types MANDT
ICLCLAIM OWNERTYPE ICLCLAIM OWNERTYPE T778O Object Types OTYPE
ICLCLAIM POLPROD ICLCLAIM CLIENT TICL320 Policy Product Generation CLIENT
ICLCLAIM POLPROD ICLCLAIM POLPROD TICL320 Policy Product Generation POLPROD
ICLCLAIM POLPROD * TICL320 Policy Product Generation VERSION
ICLCLAIM STATREASON ICLCLAIM STATREASON TICL047 Internal Claim Type: Permitted Claim Closure Reason FORMOFSET
ICLCLAIM STATREASON ICLCLAIM CLAIMTYPE TICL047 Internal Claim Type: Permitted Claim Closure Reason CLTYPE
ICLCLAIM STATREASON ICLCLAIM CLTYPEG TICL047 Internal Claim Type: Permitted Claim Closure Reason GENERAT
ICLCLAIM STATREASON ICLCLAIM CLTYPEV TICL047 Internal Claim Type: Permitted Claim Closure Reason VERSION
ICLCLAIM STATREASON ' ' TICL047 Internal Claim Type: Permitted Claim Closure Reason SUBCLTYPE
ICLCLAIM STATREASON ICLCLAIM STATUS TICL047 Internal Claim Type: Permitted Claim Closure Reason STATUS
ICLCLAIM STATREASON ICLCLAIM CLIENT TICL047 Internal Claim Type: Permitted Claim Closure Reason CLIENT
ICLCLAIM STATUS SYST MANDT TICL140 Claim Status / Subclaim Status CLIENT
ICLCLAIM STATUS ICLCLAIM STATUS TICL140 Claim Status / Subclaim Status STATUS
ICLCLAIM VERSION ICLCLAIM GENERAT TICL321 Policy Product Version GENERAT
ICLCLAIM VERSION ICLCLAIM VERSION TICL321 Policy Product Version VERSION
ICLCLAIM VERSION ICLCLAIM CLIENT TICL321 Policy Product Version CLIENT
ICLCLAIM VERSION ICLCLAIM POLPROD TICL321 Policy Product Version POLPROD
ICLCLAIM VIEWFAULT ICLCLAIM CLIENT TICL081 Fault CLIENT
ICLCLAIM VIEWFAULT ICLCLAIM VIEWFAULT TICL081 Fault VIEWFAULT
ICLCLAIM VIEWFAULTPH ICLCLAIM CLIENT TICL081 Fault CLIENT
ICLCLAIM VIEWFAULTPH ICLCLAIM VIEWFAULTPH TICL081 Fault VIEWFAULT