ICSCCEVENT SAP table for – Shadow Table Claim Bundle

Here we would like to draw your attention to ICSCCEVENT table in SAP. As we know it is being mainly used with the SAP FS-CM (Claims Management in FS) component which is coming under FS module (Financial Services). ICSCCEVENT is a SAP standard transp table used for storing Shadow Table Claim Bundle related data in SAP. It comes under the package ICL_EVENT.

SAP ICSCCEVENT table

Table ICSCCEVENT technical data

TableICSCCEVENT
Data storingShadow Table Claim Bundle
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_EVENT
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSCCEVENT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ICSCCEVENT table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ACTIVE : Table entry is active (A) or in suspense (S)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • CCEVENT : Claim Bundle
    Its a key field. Its data type is CHAR (Character String) with field length 17
  • CHANGETIME : Changed: UTC Date+Time
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : Shadow Tables Versioning: Include for Shade Table
  • CHANGEDBY : Changed By
    Its data type is CHAR (Character String) with field length 12
  • DELETED : Database Line Status (Original, Changed, Deleted)
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Claim Bundle
  • .INCLUDE : Organizational Include (Short Version)
  • CREATEDBY : Created By
    Its data type is CHAR (Character String) with field length 12
  • CREATETIME : Created: UTC Date+Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CCTYPE : Claim Bundle Type
    Its data type is CHAR (Character String) with field length 2
  • SUBTYPE : Subtype of Claim Bundle Type
    Its data type is CHAR (Character String) with field length 2
  • CURR : Currency of Claim Bundle Reserve
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • LIMIT : Claim Bundle Compensation Reserve
    Its data type is CURR (Currency Field) with field length 17
  • LIMITE : Claim Bundle Expenses Reserve
    Its data type is CURR (Currency Field) with field length 17
  • CODE : External Name for Claim Bundle
    Its data type is CHAR (Character String) with field length 12
  • NAME : Name of Claim Bundle
    Its data type is CHAR (Character String) with field length 20
  • RANGEFROM : Event Period: Date From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RANGETO : Event Period: Date To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HOTLINE : Coordinator phone number
    Its data type is CHAR (Character String) with field length 30
  • LOCATYPE : Define Location via Region ‘1’, Postal Code ‘2’, Address ‘3’
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • STATUS : Status of Claim Bundle
    Its data type is CHAR (Character String) with field length 2
  • BUNDLECAUSE : Reason for Creation of Claim Bundle
    Its data type is CHAR (Character String) with field length 3
  • OWNER : Claim Bundle Handler
    Its data type is CHAR (Character String) with field length 12
  • INVOICEREF_BULK : External Collective Invoice Number
    Its data type is CHAR (Character String) with field length 16
  • EXTERNALREF_BULK : External Collective Reference
    Its data type is CHAR (Character String) with field length 20
  • ISSUEDATE : Collective Invoice Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AMOUNT_TOTAL : Net Total Amount of Collective Invoice (acc. to Coll.Inv.)
    Its data type is CURR (Currency Field) with field length 15
  • PAYMENTLEVEL : Payment Level of a Collective Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DATASOURCE : Data Origin
    Its data type is CHAR (Character String) with field length 2
  • RECEIVEDATE : Date Received
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLMINPROCESS : Dependent Claim Exists with Status “In Process”
    Its data type is CHAR (Character String) with field length 1
  • RELEASED : Status “Released”
    Its data type is CHAR (Character String) with field length 1
  • CANCEL : Status “Cancelled”
    Its data type is CHAR (Character String) with field length 1
  • INPROCESS : Status “In Process”
    Its data type is CHAR (Character String) with field length 1
  • CLMINPROC_CNTR : Counter for Number of Open Claims
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • STHANDLER : “Bundle Processing” Process Is Active
    Its data type is CHAR (Character String) with field length 1
  • WF_STATUS : Workflow Status
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • .INCLUDE : Collective Subrogation: Special Attributes
  • CCSBRBNDL : Number of Collective Subrogation/Recovery
    Its data type is CHAR (Character String) with field length 17
  • CCSBRTYPE : Subrogation Claim Type in Subrogation
    Its data type is CHAR (Character String) with field length 2
  • CHREASONSBR : Change Reason for Status of Collective Subrogation/Recovery
    Its data type is CHAR (Character String) with field length 2
  • BILLINGDATE : Next Billing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RESUBDATE : Date of Resubmission
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SBRNOTIFDATE : Date on Which Subrogation Claim Was Reported
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8