ICL_BW3_CLAIM_S SAP (Point-in-Time Extract Structure Claim) Structure details
Description: Point-in-Time Extract Structure Claim
Related tables to ICL_BW3_CLAIM_S
Access table ICL_BW3_CLAIM_S
Structure field list including key, data, relationships and ABAP select examples
ICL_BW3_CLAIM_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 "Point-in-Time Extract Structure Claim" 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_BW3_CLAIM_S TYPE ICL_BW3_CLAIM_S.
The ICL_BW3_CLAIM_S table consists of various fields, each holding specific information or linking keys about Point-in-Time Extract Structure Claim 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_BW3_CLAIM_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 | Assigned to domain | 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 | Assigned to domain | 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 | 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 | ||||
POLICYHOLDER | Policyholder | ICL_POLHOLDER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
PLINEOFBUS | Insurance Line of Business | ICL_LINEOFBUS | CHAR | 3 | Assigned to domain | ICL_LINEOFBUS | |||
COMPANYCODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
KEYDATE | Key Date for As-of-Point-in-Time Reporting | ICL_BW_KEYDATE | DATS | 8 | DATE | ||||
LO_TZONE | Local Time Zone for Conversion of Key Date | ICL_BW_LOZONE | CHAR | 6 | Assigned to domain | TZNZONE | SCSEAR_TZ | ||
INCEPTION | Inception of Contract | ICL_INCEPTION | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
EXPIRY | End Date and Time of Contract | ICL_EXPIRY | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
POLICY_PM | Number of Policy in FS-PM | ICL_PMI_POLEX | CHAR | 17 | ALPHA | ICL_POLICY | ICL_POLICY1_PM | ||
POLEX_PM | External Policy | ICL_POLEX_PM | CHAR | 17 | ALPHA | ICL_POLICY | |||
DISTCHAN | Insurance Distribution Channel | ICL_DISTCHAN | CHAR | 1 | Assigned to domain | ICL_DISTCHAN | |||
AGENT | Agent According to Policy Snapshot | ICL_POLAGENT | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
RBPOBJID | Object ID of Performer | ICL_RBPOBJID_D_PE | CHAR | 12 | HROBJID_12 | ||||
RBPOTYPE | Object Type of Performer | ICL_RBPOTYPE_D_PE | CHAR | 2 | Assigned to domain | OTYPE | ICL_RBPOTYPE_E | ||
UNITOBJID | Object ID of Performer | ICL_RBPOBJID_D_PE | CHAR | 12 | HROBJID_12 | ||||
UNITOTYPE | Object Type of Performer | ICL_RBPOTYPE_D_PE | CHAR | 2 | Assigned to domain | OTYPE | ICL_RBPOTYPE_E |
Key field | Non-key field |
How do I retrieve data from SAP structure ICL_BW3_CLAIM_S using ABAP code?
As ICL_BW3_CLAIM_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_BW3_CLAIM_S as there is no data to select.How to access SAP table ICL_BW3_CLAIM_S
Within an ECC or HANA version of SAP you can also view further information about ICL_BW3_CLAIM_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