1. Home
  2. Resources
  3. SAP Tables
  4. ICLSUBCL - Subclaim

SAP Table ICLSUBCL

Subclaim

ICLSUBCL (Subclaim) 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 ICLSUBCL to other SAP tables.

ICLSUBCL 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 ICLCLAIM CHAR 17 0
SUBCLAIM Subclaim ICL_SUBCL CHAR 3 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
STATUS Status of Subclaim ICL_SUBCL10 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
STINVALID Subclaim Invalid ICL_STINVALID CHAR 1 0
X Yes
NULL No
STREJECT Claim/Subclaim Rejected ICL_STREJECT CHAR 1 0
X Yes
NULL No
STATREASON Reason for Changing the Status ICL_FORMSET TICL047 CHAR 2 0
XCOMPLETE Flag: Claim Item List (Presumably) Complete ICL_SUBCL08 CHAR 1 0
X Yes
NULL No
SUBCLTYPE Subclaim Type ICL_SUBCLTYPE TICL004 CHAR 4 0
XSALVAGE Flag: Salvage? ICL_SUBCL01 CHAR 1 0
NULL No Salvage Potential
1 Salvage Potential Identified
2 Open
3 Completed
XOTHERINSURE Flag: Other Insurance? ICL_SUBCL02 CHAR 1 0
X Yes
NULL No
XSUBRO Subrogation/Recovery Status ICL_SUBCL03 CHAR 1 0
NULL No Subrogation Potential
1 Subrogation Potential Identified
2 Open
3 Completed
SUBRO_POTENTIAL Subrogation/Recovery Potential of a Subclaim (Check Status) ICL_SUBRO_POTENTIAL_D CHAR 1 0
NULL Not Checked
1 Exists
2 Does Not Exist
3 Subrogation/Recovery Not Permitted
XLITIGATION Flag: Litigation? ICL_SUBCL04 CHAR 1 0
X Yes
NULL No
XNEGOTIATION Flag: Negotiation? ICL_SUBCL05 CHAR 1 0
X Yes
NULL No
XFRAUD Flag: Potential Fraud? ICL_SUBCL06 CHAR 1 0
X Yes
NULL No
COVERAGE Coverage ICL_POLM ICLPOLM CHAR 4 0
COVPOLVNR Version Number of Coverage Contract ICL_POLMVNR ICLPOLM NUMC 2 0
XCOVCONFIRMED Indication of Compensability ICL_COVERED CHAR 1 0
X Yes
N No
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
HANDLERTYPE Object Category of Subclaim Handler ICL_HANDLERTYPE T778O CHAR 2 0
CLAIMHANDLER Claim Handler for Subclaim ICL_SUBCLCH USR02 CHAR 12 0
HANDLERTYPE_GRP Object Category of Subclaim Handler Group ICL_HANDLERTYPE2 CHAR 2 0
CLAIMHANDLER_GRP Claim Handler Group for Subclaims ICL_SUBCLCH2 CHAR 12 0
COMPLEX Complexity of Claim/Subclaim ICL_COMPLEX TICL027 CHAR 1 0
SUBCLAIMDESC Name of Claim/Subclaim ICL_SUBCLDESCRIP CHAR 20 0
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
ASSIGN_GUID UUID of Entry to be Linked ICL_ASSIGN_GUID CHAR 32 0
MAX_ITEMNR Current Highest Claim Item Number ICL_SCLITEM_NR_MAX CHAR 4 0
OVERRULEREASON Overruling Reason ICL_OVERRULEREASON_D CHAR 3 0
BENSTART_DT Start of Benefit ICL_BENSTART_DT_D DATS 8 0
BENEND_DT End of Benefit ICL_BENEND_DT_D DATS 8 0
COMPENSABILITY Compensability ICL_COMPENSABILITY_D CHAR 1 0
0 Compensable
1 Not Relevant
2 Not Compensable
BENCALC_NUM Sequence Number of Benefit Calculation ICL_BENCALC_NUM_D CHAR 20 0
INSUREDOBJ Insured Object Number ICL_INSOBJ NUMC 4 0

ICLSUBCL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ICLSUBCL CHANGEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
ICLSUBCL CHANGEDBY ICLSUBCL CHANGEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICLSUBCL CLAIM ICLSUBCL CLIENT ICLCLAIM Claim CLIENT
ICLSUBCL CLAIM ICLSUBCL ACTIVE ICLCLAIM Claim ACTIVE
ICLSUBCL CLAIM ICLSUBCL CLAIM ICLCLAIM Claim CLAIM
ICLSUBCL CLAIMHANDLER ICLSUBCL CLIENT USR02 Logon Data (Kernel-Side Use) MANDT
ICLSUBCL CLAIMHANDLER ICLSUBCL CLAIMHANDLER USR02 Logon Data (Kernel-Side Use) BNAME
ICLSUBCL CLIENT ICLSUBCL CLIENT T000 Clients MANDT
ICLSUBCL COMPLEX * TICL027 Internal Claim Type: Permitted Subclaim Complexity CLTYPE
ICLSUBCL COMPLEX * TICL027 Internal Claim Type: Permitted Subclaim Complexity GENERAT
ICLSUBCL COMPLEX * TICL027 Internal Claim Type: Permitted Subclaim Complexity VERSION
ICLSUBCL COMPLEX ICLSUBCL SUBCLTYPE TICL027 Internal Claim Type: Permitted Subclaim Complexity SUBCLTYPE
ICLSUBCL COMPLEX ICLSUBCL COMPLEX TICL027 Internal Claim Type: Permitted Subclaim Complexity COMPLEX
ICLSUBCL COMPLEX ICLSUBCL CLIENT TICL027 Internal Claim Type: Permitted Subclaim Complexity CLIENT
ICLSUBCL COVERAGE ICLSUBCL CLIENT ICLPOLM Coverage in Policy Snapshot CLIENT
ICLSUBCL COVERAGE ICLSUBCL ACTIVE ICLPOLM Coverage in Policy Snapshot ACTIVE
ICLSUBCL COVERAGE ICLSUBCL CLAIM ICLPOLM Coverage in Policy Snapshot CLAIM
ICLSUBCL COVERAGE ICLSUBCL COVPOLVNR ICLPOLM Coverage in Policy Snapshot POLVNR
ICLSUBCL COVERAGE ICLSUBCL COVERAGE ICLPOLM Coverage in Policy Snapshot COVERAGE
ICLSUBCL COVPOLVNR ICLSUBCL CLIENT ICLPOLM Coverage in Policy Snapshot CLIENT
ICLSUBCL COVPOLVNR ICLSUBCL ACTIVE ICLPOLM Coverage in Policy Snapshot ACTIVE
ICLSUBCL COVPOLVNR ICLSUBCL CLAIM ICLPOLM Coverage in Policy Snapshot CLAIM
ICLSUBCL COVPOLVNR ICLSUBCL COVPOLVNR ICLPOLM Coverage in Policy Snapshot POLVNR
ICLSUBCL COVPOLVNR * ICLPOLM Coverage in Policy Snapshot COVERAGE
ICLSUBCL CREATEDBY SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
ICLSUBCL CREATEDBY ICLSUBCL CREATEDBY USR02 Logon Data (Kernel-Side Use) BNAME
ICLSUBCL HANDLERTYPE ICLSUBCL CLIENT T778O Object Types MANDT
ICLSUBCL HANDLERTYPE ICLSUBCL HANDLERTYPE T778O Object Types OTYPE
ICLSUBCL STATREASON ICLSUBCL CLIENT TICL047 Internal Claim Type: Permitted Claim Closure Reason CLIENT
ICLSUBCL STATREASON ICLSUBCL STATREASON TICL047 Internal Claim Type: Permitted Claim Closure Reason FORMOFSET
ICLSUBCL STATREASON * TICL047 Internal Claim Type: Permitted Claim Closure Reason CLTYPE
ICLSUBCL STATREASON * TICL047 Internal Claim Type: Permitted Claim Closure Reason GENERAT
ICLSUBCL STATREASON * TICL047 Internal Claim Type: Permitted Claim Closure Reason VERSION
ICLSUBCL STATREASON ICLSUBCL SUBCLTYPE TICL047 Internal Claim Type: Permitted Claim Closure Reason SUBCLTYPE
ICLSUBCL STATREASON ICLSUBCL STATUS TICL047 Internal Claim Type: Permitted Claim Closure Reason STATUS
ICLSUBCL STATUS SYST MANDT TICL140 Claim Status / Subclaim Status CLIENT
ICLSUBCL STATUS ICLSUBCL STATUS TICL140 Claim Status / Subclaim Status STATUS
ICLSUBCL SUBCLTYPE ICLSUBCL CLIENT TICL004 Subclaim Type CLIENT
ICLSUBCL SUBCLTYPE ICLSUBCL SUBCLTYPE TICL004 Subclaim Type SUBCLTYPE