ICSACTIVITY SAP table for – Activity in the Claim

Here we would like to draw your attention to ICSACTIVITY 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). ICSACTIVITY is a SAP standard transp table used for storing Activity in the Claim related data in SAP. It comes under the package ICL_CDC.

SAP ICSACTIVITY table

Table ICSACTIVITY technical data

TableICSACTIVITY
Data storingActivity in the Claim
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_CDC
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSACTIVITY 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 ICSACTIVITY 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
  • CLAIM : Number of Claim
    Its a key field. Its data type is CHAR (Character String) with field length 17
  • SUBCLAIM : Subclaim
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ACTNUMBER : Sequence Number of Activity
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • 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 : Attributes of ICLACTIVITY
  • .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
  • ACTIVITY : Activity Management: Task
    Its data type is CHAR (Character String) with field length 6
  • XMANUAL : Activity Set Manually
    Its data type is CHAR (Character String) with field length 1
  • TEXT : Task Name
    Its data type is CHAR (Character String) with field length 128
  • DUETIME : Due Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • XDONE : Task Completed
    Its data type is CHAR (Character String) with field length 1
  • ACT_STATUS : Activity Management: Status of a Task
    Its data type is CHAR (Character String) with field length 1
  • NAVIGATE : Navigation Target
    Its data type is CHAR (Character String) with field length 4
  • SUBOBJCAT : Claim Subobject Category
    Its data type is CHAR (Character String) with field length 2
  • SUBOBJECT : ID of Claim Subobject for Navigation
    Its data type is CHAR (Character String) with field length 16
  • ACT_ASSIGN_STATE : Assignment Status of a Claim Subobject
    Its data type is CHAR (Character String) with field length 2
  • ACT_HANDLERTYPE : Object Category of Subclaim Handler
    Its data type is CHAR (Character String) with field length 2
  • ACT_HANDLER : Claim Handler for Task
    Its data type is CHAR (Character String) with field length 12
  • ACT_HNDLRTP_GRP : Object Category of Subclaim Handler Group
    Its data type is CHAR (Character String) with field length 2
  • ACT_HANDLER_GRP : Claim Handler Group for Task
    Its data type is CHAR (Character String) with field length 12
  • PRIORITY : (Do Not Use For Timebeing) Priority of Task
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SUBACTIVITYUSED : Activity Used to Process the Task
    Its data type is CHAR (Character String) with field length 6
  • RESUBM_TIME : Resubmission of a Task
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ACT_GRP_CAT : Activity Management: Task Type
    Its data type is CHAR (Character String) with field length 2
  • EXPRESSION_ORIG : Expression Responsible for Anomaly (Control Predicate)
    Its data type is CHAR (Character String) with field length 20
  • DUEDATE_TIME1 : Date/Time for First Submission in Workplace
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • DUEDATE_TIME2 : Date/Time for Latest Start of Task
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • DUEDATE_TIME3 : Date/Time for Latest End of Task
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • MAN_OTYPE : Manual Task: Claim Handler Category
    Its data type is CHAR (Character String) with field length 2
  • MAN_ACTORID : Proposed Handler for This Manual Task
    Its data type is CHAR (Character String) with field length 12
  • PRIORITY_WF : Activity Management: Priority of Task – Workflow
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 4
  • CCTYPE : Claim Bundle Type
    Its data type is CHAR (Character String) with field length 2
  • TASK_CCEVENT : Claim Bundle: Task/Log Entry
    Its data type is CHAR (Character String) with field length 6
  • XSYSTEM_ACTIVITY : Activity Is System Activity
    Its data type is CHAR (Character String) with field length 1
  • MANUAL_TASK_ONLY : Purely Manual Task
    Its data type is CHAR (Character String) with field length 1
  • MANUAL_CHARACTER : Task Has Manual Character
    Its data type is CHAR (Character String) with field length 1
  • WF_RELEVANT : Activity Management: Relevant for Workflow
    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
  • REF_OBJCAT : Claims Management Object Category
    Its data type is CHAR (Character String) with field length 2
  • REF_OBJECT : Claims Management Object
    Its data type is CHAR (Character String) with field length 17
  • REFTASK_SUBCLAIM : Subclaim of Reference Task
    Its data type is CHAR (Character String) with field length 3
  • REFTASK_ACTNO : Sequence Number of Reference Task
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFTASK_CATEGORY : Category of Reference Task
    Its data type is CHAR (Character String) with field length 2
  • PARENT_SUBCLAIM : Higher-Level Claim Subobject – Subclaim
    Its data type is CHAR (Character String) with field length 3
  • PARENT_SUBOBJCAT : Higher-Level Claim Subobject – Subobject Category
    Its data type is CHAR (Character String) with field length 2
  • PARENT_SUBOBJECT : Higher-Level Claim Subobject – Subobject
    Its data type is CHAR (Character String) with field length 16
  • WI_ID : Work item ID
    Its data type is NUMC (Character String with Digits Only) with field length 12