ICLCCEVENT SAP (Claim Bundle) Table details
Dictionary Type: Table
Description: Claim Bundle
Description: Claim Bundle
Table field list including key, data, relationships and ABAP select examples
ICLCCEVENT is a standard SAP Table which is used to store Claim Bundle data and is available within R/3 SAP systems depending on the version and release level.
The ICLCCEVENT table consists of various fields, each holding specific information or linking keys about Claim Bundle data available in SAP. These include ACTIVE (Table entry is active (A) or in suspense (S)), CCEVENT (Claim Bundle), CHANGETIME (Changed: Date + Time), CHANGEDBY (Changed By).. 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 ICLCCEVENT 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 | ||||
CCEVENT | Claim Bundle | ICL_CCEVENT | CHAR | 17 | ALPHA | ICL_CCEVENT | ICLEVT | ||
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 | |||
CCTYPE | Claim Bundle Type | ICL_CCEVENTCAT | CHAR | 2 | TICL001 | ICL_CCEVENTCAT | ICL_CCEVENTCAT | ||
SUBTYPE | Subtype of Claim Bundle Type | ICL_CCEVENTTY | CHAR | 2 | TICL002 | ICL_CCEVENTTY | |||
CURR | Currency of Claim Bundle Reserve | ICL_CCEVENTCUR | CUKY | 5 | TCURC | WAERS | |||
LIMIT | Claim Bundle Compensation Reserve | ICL_CCEVENTLIM | CURR | 17(2) | ICL_TOAMT | ||||
LIMITE | Claim Bundle Expenses Reserve | ICL_CCEVENTLIME | CURR | 17(2) | |||||
CODE | External Name for Claim Bundle | ICL_CCEVENTCODE | CHAR | 20 | CHAR20 | ||||
NAME | Name of Claim Bundle | ICL_CCEVENTNAME | CHAR | 20 | TEXT20 | ||||
RANGEFROM | Event Period: Date From | ICL_CCEVENTFROM | DATS | 8 | DATE | ICL_CCEVENTFROM | |||
RANGETO | Event Period: Date To | ICL_CCEVENTTO | DATS | 8 | DATE | ||||
HOTLINE | Coordinator phone number | ICL_CCEVENTTEL | CHAR | 30 | CHAR30 | ||||
LOCATYPE | Define Location via Region '1', Postal Code '2', Address '3' | ICL_CCEVENTLOCA | NUMC | 1 | ICL_LOCTYPE | ||||
STATUS | Status of Claim Bundle | ICLE_BUNDLE_STATUS_D | CHAR | 2 | TICL140 | ICL_STATUS | |||
BUNDLECAUSE | Reason for Creation of Claim Bundle | ICL_BUNDLECAUSE | CHAR | 3 | TICL012 | ICL_BUNDLECAUSE | |||
OWNER | Claim Bundle Handler | ICL_BUNDLEOWNER | CHAR | 12 | USR02 | XUBNAME | |||
INVOICEREF_BULK | External Collective Invoice Number | ICL_INVOICEREF_BULK | CHAR | 16 | CHAR16 | ||||
EXTERNALREF_BULK | External Reference to Collective Invoice | ICL_EXTERNALREF_BULK | CHAR | 20 | ICL_EXTERNALREF_BULK | ||||
ISSUEDATE | Collective Invoice Date | ICL_ISSUEDATE_INVBULK | DATS | 8 | DATS | ||||
AMOUNT_TOTAL | Net Total Amount of Collective Invoice (acc. to Coll.Inv.) | ICL_AMOUNT_BULKINV_TOTAL | CURR | 15(2) | ICL_AMOUNT | ||||
PAYMENTLEVEL | Payment Level of a Collective Invoice | ICL_PAYMENTLEVEL | NUMC | 1 | ICL_PAYMENTLEVEL | ||||
DATASOURCE | Data Origin | ICL_DATASOURCE | CHAR | 2 | TICL136 | ICL_DATASOURCE | |||
RECEIVEDATE | Date Received | ICL_RECEIVEDATE | DATS | 8 | DATS | ||||
CLMINPROCESS | Dependent Claim Exists with Status 'In Process' | ICL_CLMSTATUS_INPROCESS | CHAR | 1 | XFELD | ||||
RELEASED | Status 'Released' | ICL_STATUS_RELEASED | CHAR | 1 | XFELD | ||||
CANCEL | Status 'Cancelled' | ICL_STATUS_CANCEL | CHAR | 1 | XFELD | ||||
INPROCESS | Status 'In Process' | ICL_STATUS_INPROCESS | CHAR | 1 | XFELD | ||||
CLMINPROC_CNTR | Counter for Number of Open Claims | ICL_CLMSTATUS_INPROCESS_CNTR | INT4 | 10 | ICL_CLMSTATUS_INPROCESS_CNTR | ||||
STHANDLER | 'Bundle Processing' Process Is Active | ICLE_STHANDLER | CHAR | 1 | XFELD | ||||
WF_STATUS | Workflow Status | ICL_WF_STATUS | NUMC | 1 | ICL_WF_STATUS | ||||
CCSBRBNDL | Number of Collective Subrogation/Recovery | ICL_CCSBRBNDL | CHAR | 17 | ICLCCEVENT | ALPHA | ICL_CCEVENT | ||
CCSBRTYPE | Subrogation Claim Type in Subrogation | ICL_CCSBRTYPE | CHAR | 2 | TICL177 | ICL_CCSBRTYPE | |||
CHREASONSBR | Change Reason for Status of Collective Subrogation/Recovery | ICL_CHREASONSBR | CHAR | 2 | TICL175 | ICL_CHREASONSBR | |||
BILLINGDATE | Next Billing Date | ICL_BILLINGDATE | DATS | 8 | DATE | ||||
RESUBDATE | Date of Resubmission | ICL_RESUBDATE | DATS | 8 | DATE | ||||
SBRNOTIFDATE | Date on Which Subrogation Claim Was Reported | ICL_SBRNOTIFDATE | DATS | 8 | DATE | ||||
ACHANGEDBY | Whole Claim Last Changed By | ICL_ACHANGEDBY | CHAR | 12 | Assigned to domain | XUBNAME | |||
ACHANGETIME | Whole Claim Last Changed At | ICL_ACHANGETIME | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
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 |
Key field | Non-key field |
How do I retrieve data from SAP table ICLCCEVENT using ABAP code
The following ABAP code Example will allow you to do a basic selection on ICLCCEVENT to SELECT all data from the tableDATA: WA_ICLCCEVENT TYPE ICLCCEVENT.
SELECT SINGLE *
FROM ICLCCEVENT
INTO CORRESPONDING FIELDS OF WA_ICLCCEVENT
WHERE...
How to access SAP table ICLCCEVENT
Within an ECC or HANA version of SAP you can also view further information about ICLCCEVENT 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