ICLSUBCL SAP (Subclaim) Table details
Dictionary Type: Table
Description: Subclaim
Description: Subclaim
Table field list including key, data, relationships and ABAP select examples
ICLSUBCL is a standard SAP Table which is used to store Subclaim data and is available within R/3 SAP systems depending on the version and release level.
The ICLSUBCL table consists of various fields, each holding specific information or linking keys about Subclaim data available in SAP. These include ACTIVE (Table entry is active (A) or in suspense (S)), CLAIM (Number of Claim), SUBCLAIM (Subclaim), CHANGETIME (Changed: Date + Time).. 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 ICLSUBCL 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 | ICLCLAIM | ALPHA | ICL_CLAIM | ICL_CLAIM | ICL_CLAIMNO_COL |
SUBCLAIM | Subclaim | ICL_SUBCL | CHAR | 3 | ICL_SUBCL | ICL_SUBCLAIM | |||
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 | |||
STATUS | Status of Subclaim | ICL_SUBCL10 | 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 | ||||
STINVALID | Subclaim Invalid | ICL_STINVALID | CHAR | 1 | XFELD | ||||
STREJECT | Claim/Subclaim Rejected | ICL_STREJECT | CHAR | 1 | XFELD | ||||
STATREASON | Reason for Changing the Status | ICL_FORMSET | CHAR | 2 | TICL047 | ICL_FORMSET | |||
XCOMPLETE | Flag: Claim Item List (Presumably) Complete | ICL_SUBCL08 | CHAR | 1 | XFELD | ||||
SUBCLTYPE | Subclaim Type | ICL_SUBCLTYPE | CHAR | 4 | TICL004 | ICL_SUBCLTYPE | |||
XSALVAGE | Flag: Salvage? | ICL_SUBCL01 | CHAR | 1 | ICL_SUBCL01 | ||||
XOTHERINSURE | Flag: Other Insurance? | ICL_SUBCL02 | CHAR | 1 | XFELD | ||||
XSUBRO | Subrogation/Recovery Status | ICL_SUBCL03 | CHAR | 1 | ICL_SUBCL03 | ||||
SUBRO_POTENTIAL | Subrogation/Recovery Potential of a Subclaim (Check Status) | ICL_SUBRO_POTENTIAL_D | CHAR | 1 | ICL_SUBRO_POTENTIAL | ||||
XLITIGATION | Flag: Litigation? | ICL_SUBCL04 | CHAR | 1 | XFELD | ||||
XNEGOTIATION | Flag: Negotiation? | ICL_SUBCL05 | CHAR | 1 | XFELD | ||||
XFRAUD | Flag: Potential Fraud? | ICL_SUBCL06 | CHAR | 1 | XFELD | ||||
COVERAGE | Coverage | ICL_POLM | CHAR | 4 | ICLPOLM | ICL_POLM | |||
COVPOLVNR | Version Number of Coverage Contract | ICL_POLMVNR | NUMC | 2 | ICLPOLM | ICL_POLVCNTR | |||
XCOVCONFIRMED | Indication of Compensability | ICL_COVERED | CHAR | 1 | ICL_COVERED | ||||
ASSIGN_STATE | Assignment Status of a Claim Subobject | ICL_ASSIGN_STATE | CHAR | 2 | ICL_ASSIGN_STATE | ||||
HANDLERTYPE | Object Category of Subclaim Handler | ICL_HANDLERTYPE | CHAR | 2 | T778O | OTYPE | |||
CLAIMHANDLER | Claim Handler for Subclaim | ICL_SUBCLCH | CHAR | 12 | USR02 | XUBNAME | |||
HANDLERTYPE_GRP | Object Category of Subclaim Handler Group | ICL_HANDLERTYPE2 | CHAR | 2 | Assigned to domain | OTYPE | |||
CLAIMHANDLER_GRP | Claim Handler Group for Subclaims | ICL_SUBCLCH2 | CHAR | 12 | Assigned to domain | XUBNAME | |||
COMPLEX | Complexity of Claim/Subclaim | ICL_COMPLEX | CHAR | 1 | TICL027 | ICL_COMPLEX | |||
SUBCLAIMDESC | Name of Claim/Subclaim | ICL_SUBCLDESCRIP | CHAR | 20 | TEXT20 | ||||
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 | ||||
ASSIGN_GUID | UUID of Entry to be Linked | ICL_ASSIGN_GUID | CHAR | 32 | SYSUUID_C | ||||
MAX_ITEMNR | Current Highest Claim Item Number | ICL_SCLITEM_NR_MAX | CHAR | 4 | Assigned to domain | ICL_SCLITEM | |||
OVERRULEREASON | Overruling Reason | ICL_OVERRULEREASON_D | CHAR | 3 | ICL_OVERRULEREASON | ||||
BENSTART_DT | Start of Benefit | ICL_BENSTART_DT_D | DATS | 8 | DATS | ||||
BENEND_DT | End of Benefit | ICL_BENEND_DT_D | DATS | 8 | DATS | ||||
COMPENSABILITY | Compensability | ICL_COMPENSABILITY_D | CHAR | 1 | ICL_COMPENSABILITY | ||||
BENCALC_NUM | Sequence Number of Benefit Calculation | ICL_BENCALC_NUM_D | CHAR | 20 | ICL_BENCALC_NUM | ||||
INSUREDOBJ | Insured Object Number | ICL_INSOBJ | NUMC | 4 | Assigned to domain | ICL_INSOBJ |
Key field | Non-key field |
How do I retrieve data from SAP table ICLSUBCL using ABAP code
The following ABAP code Example will allow you to do a basic selection on ICLSUBCL to SELECT all data from the tableDATA: WA_ICLSUBCL TYPE ICLSUBCL.
SELECT SINGLE *
FROM ICLSUBCL
INTO CORRESPONDING FIELDS OF WA_ICLSUBCL
WHERE...
How to access SAP table ICLSUBCL
Within an ECC or HANA version of SAP you can also view further information about ICLSUBCL 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