ICLCLAIM SAP (Claim) Table details
Dictionary Type: Table
Description: Claim
Description: Claim
Table field list including key, data, relationships and ABAP select examples
ICLCLAIM is a standard SAP Table which is used to store Claim data and is available within R/3 SAP systems depending on the version and release level.
The ICLCLAIM table consists of various fields, each holding specific information or linking keys about Claim data available in SAP. These include ACTIVE (Table entry is active (A) or in suspense (S)), CLAIM (Number of Claim), CHANGETIME (Changed: Date + Time), CHANGEDBY (Changed By).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ICLCLAIM table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ACTIVE | Table entry is active (A) or in suspense (S) | ICL_ACTIVE | CHAR | 1 | ICL_ACTIVE | ||||
CLAIM | Number of Claim | ICL_CLAIM | CHAR | 17 | ALPHA | ICL_CLAIM | ICL_CLAIM | ICL_CLAIMNO_COL | |
CHANGETIME | Changed: Date + Time | ICL_CHANGEUTC1 | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
CHANGEDBY | Changed By | ICL_CHANGEDBY | CHAR | 12 | USR02 | XUBNAME | |||
DELETED | Database Line Status (Original, Changed, Deleted) | ICL_RECSTATUS | CHAR | 1 | ICL_RECSTATUS | ||||
CREATEDBY | Created By | ICL_CREATEDBY | CHAR | 12 | USR02 | XUBNAME | |||
CREATETIME | Created: Date + Time | ICL_CREATEUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
ACHANGEDBY | Whole Claim Last Changed By | ICL_ACHANGEDBY | CHAR | 12 | USR02 | XUBNAME | |||
ACHANGETIME | Whole Claim Last Changed At | ICL_ACHANGETIME | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
EXCLAIMNOCAT | External Number Category | ICL_CLAIMNOCAT | CHAR | 1 | ICL_CLAIMNOCAT | ICL_CLAIMNOCAT | |||
EXCLAIMNO | External Number | ICL_CLAIMNO | CHAR | 23 | ICL_CLAIMNO | ICL_CLAIMNO | |||
STATUS | Status of Claim | ICL_CLSTATUS | CHAR | 2 | TICL140 | ICL_STATUS | |||
STATUSCHG | Time of Last Status Change | ICL_STATUSCHG | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
STHANDLER | 'Claim Handling' Process Active | ICL_STHANDLER | CHAR | 1 | XFELD | ||||
STNOCLAIM | No Claim Made | ICL_STNOCLAIM | CHAR | 1 | XFELD | ||||
STCLOSED | 'Close (Sub)Claim' Process Executed | ICL_STCLOSED | CHAR | 1 | XFELD | ||||
STATREASON | Reason for Changing the Status | ICL_FORMSET | CHAR | 2 | TICL047 | ICL_FORMSET | |||
LOSSTYPE | Incident Type of a Claim | ICL_LOSSTYPE | CHAR | 4 | TICL062 | ICL_LOSSTYPE | ICL_LOSSTYPE | ||
CLAIMTYPE | Internal Claim Type | ICL_CLTYPE | CHAR | 4 | TICL011 | ICL_CLTYPE | |||
CLTYPEG | Generation of Internal Claim Type | ICL_CLTYPEG | NUMC | 5 | TICL011 | ICL_CLTYPEG | |||
CLTYPEV | Internal Claim Type Version | ICL_CLTYPEV | NUMC | 5 | TICL003 | ICL_CLTYPEV | |||
LOSSEVENT | Cumulative Event | ICL_LOSSEVENT | CHAR | 17 | ICLCCEVENT | ALPHA | ICL_CCEVENT | ||
POLPROD | Policy Product | ICL_POLPROD | CHAR | 6 | TICL320 | ICL_POLPROD | |||
GENERAT | Policy Product Generation | ICL_GENERAT | NUMC | 5 | TICL320 | ICL_GENERAT | |||
VERSION | Policy Product Version | ICL_POLPRODV | NUMC | 5 | TICL321 | ICL_CUST_VERSION | |||
LRENEWAL | Last Renewal of Contract Before Claim Date/Time | ICL_LRENEWAL | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
POLICY | Contract Number | ICL_POLICY | CHAR | 17 | ALPHA | ICL_POLICY | ICL_POLICY | ||
LOSSCAUSE | Cause of Loss/Claim | ICL_LOSSCAUSE | CHAR | 3 | TICL009 | ICL_LOSSCAUSE | |||
PERIL | Peril | ICL_PERIL | CHAR | 4 | Assigned to domain | ICL_PERIL | |||
DATELOSS | Date of Loss/Claim | ICL_LOSSDATE | DATS | 8 | DATE | ICL_LOSSDATE | |||
TIMELOSS | Time of Claim/Loss | ICL_LOSSTIME | TIMS | 6 | TIME | ICL_LOSSTIME | |||
LTIMEZONE | Time Zone of Claim/Loss Event | ICL_LTIMEZONE | CHAR | 6 | TTZZ | TZNZONE | |||
XDATEESTIM | Date Is Estimate | ICL_XLOSSDATE | CHAR | 1 | XFELD | ||||
DATECHANGER | Reason for Changing Claim Date | ICL_DATECHANGER | CHAR | 2 | TICL029 | ICL_DATECHANGER | |||
LOSSREPCOMPA | Date Claim Reported to Insurance Company | ICL_LOSSREPCOMPA | DATS | 8 | DATE | ||||
LOSSREPAGENT | Date on Which Claim Was Reported to Agent | ICL_LOSSREPAGENT | DATS | 8 | DATE | ||||
LOSSADDRESS | Loss Location | ICL_LOSSADDRESS | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
XAUTHREP | Claim/Loss Reported to Authority | ICL_XAUTHREP | CHAR | 1 | XFELD | ||||
XSENSITIVE | Sensitive Claim? | ICL_CLAIMSENS | CHAR | 1 | XFELD | ||||
COMPLEX | Complexity of Claim/Subclaim | ICL_COMPLEX | CHAR | 1 | TICL027 | ICL_COMPLEX | |||
JURISCOUNTRY | Jurisdiction Country | ICL_JURICOUNTRY | CHAR | 3 | T005 | LAND1 | |||
JURISREGION | Jurisdiction Region | ICL_JURISREGION | CHAR | 3 | T005S | REGIO | |||
ASSIGN_STATE | Assignment Status of a Claim Subobject | ICL_ASSIGN_STATE | CHAR | 2 | ICL_ASSIGN_STATE | ||||
OWNERTYPE | Object Type of Claim Handler | ICL_OWNERTYPE | CHAR | 2 | T778O | OTYPE | |||
OWNER | ID of Claim Handler | ICL_CLAIMOWNER | CHAR | 12 | ICL_CLAIMOWNER | ||||
OWNERTYPE_GRP | Object Type of Claim Handler Group | ICL_OWNERTYPE2 | CHAR | 2 | Assigned to domain | OTYPE | |||
OWNER_GRP | Claim Handler Group | ICL_CLAIMOWNER2 | CHAR | 12 | ICL_CLAIMOWNER | ||||
XCUMUL | Claim Assigned to an Aggregate | ICL_XCUMUL | CHAR | 1 | XFELD | ||||
VIEWFAULT | Fault of Policyholder from Point of View of Insurer | ICL_VIEWFAULTI | CHAR | 1 | TICL081 | ICL_VIEWFAULT | |||
VIEWFAULTPH | Party at Fault from Point of View of Policyholder | ICL_VIEWFAULTPH | CHAR | 1 | TICL081 | ICL_VIEWFAULT | |||
TPNO | Third Party Count (NOT USED) | ICL_TPNO | NUMC | 2 | NUMC2 | ||||
XTPKNOWN | Flag: Third Party Known? | ICL_TPKNOWN | CHAR | 1 | XFELD | ||||
COVERED | Indication of Compensability | ICL_COVERED | CHAR | 1 | ICL_COVERED | ||||
AUTHCLM | Authorization Group for Claims (VIP) | ICL_AUTHCLM | CHAR | 4 | TICL113 | ICL_AUTHCLM | |||
XCLAIMB | Entry in ICLCLAIMB Exists | ICL_XCLAIMB | CHAR | 1 | XFELD | ||||
XNONOTIF | Processing Not Possible in Notification Mode | ICL_XNONOTIF | CHAR | 1 | XFELD | ||||
XRESERVE | At Least One Reserve Exists in Claim | ICL_XRESERVE | CHAR | 1 | XFELD | ||||
BENTREE | Benefit Type Tree | ICL_BENTREE | CHAR | 8 | Assigned to domain | ICL_BENTREE | |||
BENTREEG | Generation of Benefit Type Tree | ICL_BENTREEG | NUMC | 5 | Assigned to domain | ICL_BENTREEG | |||
BENTREEV | Version of Benefit Type Tree | ICL_BENTREEV | NUMC | 5 | Assigned to domain | ICL_BENTREEV | |||
WF_EXEC_TIME | Execution Time Workflow | ICL_WF_EXECUTION_TIME | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
WF_STATUS | Workflow Status | ICL_WF_STATUS | NUMC | 1 | ICL_WF_STATUS | ||||
XDUMMYCLAIM | Flag: Dummy Claim | ICL_XDUMMYCLAIM | CHAR | 1 | XFELD | ||||
VERCHNGUTC | Time for Reading Version | ICL_VERCHNGUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
OPENDATE | Opened On | ICL_OPENDATE | DATS | 8 | DATE | ||||
XWITHOUT_PRODUCT | Use of Scenario Without Product Customizing | ICL_XWITHOUTPRODUCT_D | CHAR | 1 | BOOLE | ||||
MAX_ITEMNR | Current Highest Claim Item Number | ICL_SCLITEM_NR_MAX | CHAR | 4 | Assigned to domain | ICL_SCLITEM | |||
ASSIGN_GUID | UUID of Entry to be Linked | ICL_ASSIGN_GUID | CHAR | 32 | SYSUUID_C | ||||
SIF_STATUS | Status of Second Injury Fund | ICL_SIF_STATUS_D | CHAR | 1 | ICL_SIF_STATUS | ||||
INVSTG_STATUS | Claim Investigation Match Status | ICL_INVSTG_MATCH_STATUS_D_PE | CHAR | 1 | ICL_INVSTG_MATCH_STATUS | ||||
EFFECTIVE_DT | Contract Validity Date | ICL_EFFECTIVE_DT_D | DATS | 8 | DATS | ||||
LOSSREP_DT | Date on Request for Insurance Benefit | ICL_LOSSREP_DT_D | DATS | 8 | DATS | ||||
LUMPSUMOPTION | Option Exercised | ICL_LUMPSUMOPTION_D | CHAR | 1 | ICL_LUMPSUMOPTION | ||||
STATPENSION | Type of Statutory Pension | ICL_STATPENSION_D | CHAR | 3 | Assigned to domain | ICL_STATPENSION | |||
WITHDRAWAM | Requested Total Withdrawal Amount | ICL_WITHDRAWAM_D | CURR | 15(2) | ICL_AMOUNT | ||||
WITHDRAWCURR | Currency of Withdrawal Amount | ICL_WITHDRAWCURR_D | CUKY | 5 | Assigned to domain | WAERS | |||
WITHDRAWSEQ | Withdrawal Sequence | ICL_WITHDRAWSEQ_D | CHAR | 3 | Assigned to domain | ICL_WITHDRAWSEQ | |||
ALTERNATEBEN | Display Alternative Benefit Values | ICL_ALTERNATEBEN_D | CHAR | 1 | ICL_ALTERNATEBEN | ||||
GENERATENOTIF | Make Special Risk Notification | ICL_GENERATENOTIF_D | CHAR | 1 | ICL_GENERATENOTIF | ||||
NOTIFREASON | Reason for Special Risk Notification | ICL_NOTIFREASON_D | CHAR | 3 | ICL_NOTIFREASON | ||||
AUTFOLLOWUP | Automatic Resubmission | ICL_AUTFOLLOWUP_D | CHAR | 1 | ICL_AUTFOLLOWUP | ||||
FOLLOWUP_DT | Date of Automatic Resubmission | ICL_FOLLOWUP_DT_D | DATS | 8 | DATS | ||||
PROCESSING_DT | Processing On | ICL_PROCESSING_DT_D | DATS | 8 | DATS | ||||
STATUSOBJID | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
DUNNLEVEL | Dunning Status | ICL_DUNNLEVEL_D | CHAR | 2 | ICL_DUNNLEVEL | ||||
CLEARDATE | Premium Paid Up To | ICL_CLEARDATE_D | DATS | 8 | DATS | ||||
PREMBALANAM | Premium Balance | ICL_PREMBALANAM_D | CURR | 15(2) | ICL_AMOUNT | ||||
PREMBALANAMCURR | Currency of Premium Payment | ICL_PREMBALANAMCURR_D | CUKY | 5 | Assigned to domain | WAERS | |||
WITHDRAWTYPE | Withdrawal Type | ICL_WITHDRAWTYPE_D | CHAR | 3 | Assigned to domain | ICL_WITHDRAWTYPE | |||
REACT_DT | Date of Occupational Disability/Perm.Incap.to Wk Reactivatn | ICL_REACT_DT_D | DATS | 8 | DATS | ||||
GENNOTIFTIME | Special Risk Message Submitted On | ICL_GENERATENOTIFTIME_D | DEC | 15 | ICL_GENERATENOTIFTIME | ||||
BEN_CALC_FAIL | Time of Last Incorrect Benefit Calculation | ICL_BEN_CALC_FAIL_D | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
POLSYSTEM | Technical Key of Policy System | ICL_POLSYSTEM_D | CHAR | 8 | SYCHAR08 | ||||
ARCHIVE_STATUS | Archiving Status | TYP_ARCHIVE_STATUS | CHAR | 1 | TYP_ARCHIVE_STATUS | ||||
ARCHIVE_FLUD | Resubmission Date | TYP_ARCHIVE_FLUD | DATS | 8 | DATS | ||||
REJECTION | Rejection Reason | TYP_REJECTION | CHAR | 2 | AREN_REJECTIONS_COLLECTIVE |
Key field | Non-key field |
How do I retrieve data from SAP table ICLCLAIM using ABAP code
The following ABAP code Example will allow you to do a basic selection on ICLCLAIM to SELECT all data from the tableDATA: WA_ICLCLAIM TYPE ICLCLAIM.
SELECT SINGLE *
FROM ICLCLAIM
INTO CORRESPONDING FIELDS OF WA_ICLCLAIM
WHERE...
How to access SAP table ICLCLAIM
Within an ECC or HANA version of SAP you can also view further information about ICLCLAIM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects