ICL_INACTIVE_CLAIMS_NOTIF_S SAP (Inactive Claims - Claim Handler Notification (ALV Layout)) Structure details
Description: Inactive Claims - Claim Handler Notification (ALV Layout)
Related tables to ICL_INACTIVE_CLAIMS_NOTIF_S
Access table ICL_INACTIVE_CLAIMS_NOTIF_S
Structure field list including key, data, relationships and ABAP select examples
ICL_INACTIVE_CLAIMS_NOTIF_S is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Inactive Claims - Claim Handler Notification (ALV Layout)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ICL_INACTIVE_CLAIMS_NOTIF_S TYPE ICL_INACTIVE_CLAIMS_NOTIF_S.
The ICL_INACTIVE_CLAIMS_NOTIF_S table consists of various fields, each holding specific information or linking keys about Inactive Claims - Claim Handler Notification (ALV Layout) data available in SAP. These include CLIENT (Client), ACTIVE (Table entry is active (A) or in suspense (S)), CLAIM (Number of Claim), 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ICL_INACTIVE_CLAIMS_NOTIF_S structure 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 | Assigned to domain | 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 | Assigned to domain | 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 | Assigned to domain | ICL_LOSSCAUSE | |||
PERIL | Peril | ICL_PERIL | CHAR | 4 | 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 | ||||
DAYSLASTUPD | Number of Days Since Last Change | ICL_DAYSLASTUPD | NUMC | 5 | NUM5 | ||||
STATUSN | Status Description | ICL_STATUSN | CHAR | 25 | TEXT25 | ||||
CLTYPEN | Internal Claim Type Name | ICL_CLTYPEN | CHAR | 30 | TEXT30 | ||||
LOSSCAUSEN | Name for Cause of Claim/Loss | ICL_LOSSCAUSEN | CHAR | 60 | TEXT60 | ||||
LOSSTYPEN | Name of Incident Type | ICL_LOSSTYPEN | CHAR | 30 | TEXT30 | ||||
OWNERN | Full Name of Person | AD_NAMTEXT | CHAR | 80 | TEXT80 | ||||
HOLDER | Policyholder | ICL_POLHOLDER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
HOLDERDESCR | Short name of business partner | BU_DESCRIP | CHAR | 50 | BU_TEXT50 | ||||
POLPRODN | Name of Policy Product | ICL_POLPRODN | CHAR | 30 | TEXT30 | ||||
PLINEOFBUS | Insurance Line of Business | ICL_LINEOFBUS | CHAR | 3 | Assigned to domain | ICL_LINEOFBUS | |||
PLINEOFBUSN | Name of Insurance Line of Business | ICL_LINEOFBUSN | CHAR | 30 | TEXT30 |
Key field | Non-key field |
How do I retrieve data from SAP structure ICL_INACTIVE_CLAIMS_NOTIF_S using ABAP code?
As ICL_INACTIVE_CLAIMS_NOTIF_S is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ICL_INACTIVE_CLAIMS_NOTIF_S as there is no data to select.How to access SAP table ICL_INACTIVE_CLAIMS_NOTIF_S
Within an ECC or HANA version of SAP you can also view further information about ICL_INACTIVE_CLAIMS_NOTIF_S 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