ICL_CLAIM_FILE_LB_S_CLAIM SAP (Claim Header Data) Structure details
Description: Claim Header Data
Related tables to ICL_CLAIM_FILE_LB_S_CLAIM
Access table ICL_CLAIM_FILE_LB_S_CLAIM
Structure field list including key, data, relationships and ABAP select examples
ICL_CLAIM_FILE_LB_S_CLAIM 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 "Claim Header Data" 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_CLAIM_FILE_LB_S_CLAIM TYPE ICL_CLAIM_FILE_LB_S_CLAIM.
The ICL_CLAIM_FILE_LB_S_CLAIM table consists of various fields, each holding specific information or linking keys about Claim Header Data 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 (Deep)
SAP ICL_CLAIM_FILE_LB_S_CLAIM 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 |
WA_CLAIM | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | 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 | XUBNAME | ||||
DELETED | Database Line Status (Original, Changed, Deleted) | ICL_RECSTATUS | CHAR | 1 | ICL_RECSTATUS | ||||
CREATEDBY | Created By | ICL_CREATEDBY | CHAR | 12 | XUBNAME | ||||
CREATETIME | Created: Date + Time | ICL_CREATEUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
ACHANGEDBY | Whole Claim Last Changed By | ICL_ACHANGEDBY | CHAR | 12 | 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 | 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 | ICL_FORMSET | ||||
LOSSTYPE | Incident Type of a Claim | ICL_LOSSTYPE | CHAR | 4 | ICL_LOSSTYPE | ICL_LOSSTYPE | |||
CLAIMTYPE | Internal Claim Type | ICL_CLTYPE | CHAR | 4 | ICL_CLTYPE | ||||
CLTYPEG | Generation of Internal Claim Type | ICL_CLTYPEG | NUMC | 5 | ICL_CLTYPEG | ||||
CLTYPEV | Internal Claim Type Version | ICL_CLTYPEV | NUMC | 5 | ICL_CLTYPEV | ||||
LOSSEVENT | Cumulative Event | ICL_LOSSEVENT | CHAR | 17 | ALPHA | ICL_CCEVENT | |||
POLPROD | Policy Product | ICL_POLPROD | CHAR | 6 | ICL_POLPROD | ||||
GENERAT | Policy Product Generation | ICL_GENERAT | NUMC | 5 | ICL_GENERAT | ||||
VERSION | Policy Product Version | ICL_POLPRODV | NUMC | 5 | 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 | 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 | TZNZONE | ||||
XDATEESTIM | Date Is Estimate | ICL_XLOSSDATE | CHAR | 1 | XFELD | ||||
DATECHANGER | Reason for Changing Claim Date | ICL_DATECHANGER | CHAR | 2 | 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 | 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 | ICL_COMPLEX | ||||
JURISCOUNTRY | Jurisdiction Country | ICL_JURICOUNTRY | CHAR | 3 | LAND1 | ||||
JURISREGION | Jurisdiction Region | ICL_JURISREGION | CHAR | 3 | 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 | OTYPE | ||||
OWNER | ID of Claim Handler | ICL_CLAIMOWNER | CHAR | 12 | ICL_CLAIMOWNER | ||||
OWNERTYPE_GRP | Object Type of Claim Handler Group | ICL_OWNERTYPE2 | CHAR | 2 | 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 | ICL_VIEWFAULT | ||||
VIEWFAULTPH | Party at Fault from Point of View of Policyholder | ICL_VIEWFAULTPH | CHAR | 1 | 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 | 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 | ICL_BENTREE | ||||
BENTREEG | Generation of Benefit Type Tree | ICL_BENTREEG | NUMC | 5 | ICL_BENTREEG | ||||
BENTREEV | Version of Benefit Type Tree | ICL_BENTREEV | NUMC | 5 | 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 | 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 | 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 | WAERS | ||||
WITHDRAWSEQ | Withdrawal Sequence | ICL_WITHDRAWSEQ_D | CHAR | 3 | 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 | 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 | WAERS | ||||
WITHDRAWTYPE | Withdrawal Type | ICL_WITHDRAWTYPE_D | CHAR | 3 | 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 | ||||
T_NEWPOLICY | 0 | ||||||||
T_NEGITEM | 0 | ||||||||
T_CLMCURR | 0 | ||||||||
T_CLAIMNEW | 0 | ||||||||
T_NEGOTIATON | 0 | ||||||||
T_ARCHIVE | 0 | ||||||||
T_POLICY | 0 | ||||||||
T_SUBCLAIMS | 0 | ||||||||
T_ITEMS | 0 | ||||||||
T_NOTES | 0 | ||||||||
T_PAYMENTS | 0 | ||||||||
T_LOAN_HDR | 0 | ||||||||
T_DISAB | 0 | ||||||||
T_WAITPERIOD | 0 | ||||||||
T_TAX_HDR | 0 | ||||||||
T_BENSPL_HDR | 0 | ||||||||
T_BENPER_HDR | 0 | ||||||||
T_FUNDS_HDR | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure ICL_CLAIM_FILE_LB_S_CLAIM using ABAP code?
As ICL_CLAIM_FILE_LB_S_CLAIM 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_CLAIM_FILE_LB_S_CLAIM as there is no data to select.How to access SAP table ICL_CLAIM_FILE_LB_S_CLAIM
Within an ECC or HANA version of SAP you can also view further information about ICL_CLAIM_FILE_LB_S_CLAIM 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