ICSCLAIM SAP table for – Claim

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

SAP ICSCLAIM table

Table ICSCLAIM technical data

TableICSCLAIM
Data storingClaim
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_CDC
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSCLAIM 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 ICSCLAIM 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
  • 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 ICLCLAIM
  • .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
  • ACHANGEDBY : Whole Claim Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • ACHANGETIME : Whole Claim Last Changed At
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • EXCLAIMNOCAT : External Number Category
    Its data type is CHAR (Character String) with field length 1
  • EXCLAIMNO : External Number
    Its data type is CHAR (Character String) with field length 20
  • STATUS : Status of Claim
    Its data type is CHAR (Character String) with field length 2
  • STATUSCHG : Time of Last Status Change
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • STHANDLER : “Claim Handling” Process Active
    Its data type is CHAR (Character String) with field length 1
  • STNOCLAIM : No Claim Made
    Its data type is CHAR (Character String) with field length 1
  • STCLOSED : “Close (Sub)Claim” Process Executed
    Its data type is CHAR (Character String) with field length 1
  • STATREASON : Reason for Changing the Status
    Its data type is CHAR (Character String) with field length 2
  • LOSSTYPE : Incident Type of a Claim
    Its data type is CHAR (Character String) with field length 4
  • CLAIMTYPE : Internal Claim Type
    Its data type is CHAR (Character String) with field length 4
  • CLTYPEG : Generation of Internal Claim Type
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • CLTYPEV : Internal Claim Type Version
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • LOSSEVENT : Cumulative Event
    Its data type is CHAR (Character String) with field length 17
  • POLPROD : Policy Product
    Its data type is CHAR (Character String) with field length 6
  • GENERAT : Policy Product Generation
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • VERSION : Policy Product Version
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • LRENEWAL : Last Renewal of Contract Before Claim Date/Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • POLICY : Contract Number
    Its data type is CHAR (Character String) with field length 17
  • LOSSCAUSE : Cause of Loss/Claim
    Its data type is CHAR (Character String) with field length 3
  • PERIL : Peril
    Its data type is CHAR (Character String) with field length 4
  • DATELOSS : Date of Loss/Claim
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIMELOSS : Time of Claim/Loss
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LTIMEZONE : Time Zone of Claim/Loss Event
    Its data type is CHAR (Character String) with field length 6
  • XDATEESTIM : Date Is Estimate
    Its data type is CHAR (Character String) with field length 1
  • DATECHANGER : Reason for Changing Claim Date
    Its data type is CHAR (Character String) with field length 2
  • LOSSREPCOMPA : Date Claim Reported to Insurance Company
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LOSSREPAGENT : Date Claim Reported to Agent
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LOSSADDRESS : Loss Location
    Its data type is CHAR (Character String) with field length 10
  • XAUTHREP : Claim/Loss Reported to Authority
    Its data type is CHAR (Character String) with field length 1
  • XSENSITIVE : Sensitive Claim?
    Its data type is CHAR (Character String) with field length 1
  • COMPLEX : Complexity of Claim/Subclaim
    Its data type is CHAR (Character String) with field length 1
  • JURISCOUNTRY : Jurisdiction Country
    Its data type is CHAR (Character String) with field length 3
  • JURISREGION : Jurisdiction Region
    Its data type is CHAR (Character String) with field length 3
  • ASSIGN_STATE : Assignment Status of a Claim Subobject
    Its data type is CHAR (Character String) with field length 2
  • OWNERTYPE : Object Type of Claim Handler
    Its data type is CHAR (Character String) with field length 2
  • OWNER : ID of Claim Handler
    Its data type is CHAR (Character String) with field length 12
  • OWNERTYPE_GRP : Object Type of Claim Handler Group
    Its data type is CHAR (Character String) with field length 2
  • OWNER_GRP : Claim Handler Group
    Its data type is CHAR (Character String) with field length 12
  • XCUMUL : Claim Assigned to an Aggregate
    Its data type is CHAR (Character String) with field length 1
  • VIEWFAULT : Fault of Policyholder from Point of View of Insurer
    Its data type is CHAR (Character String) with field length 1
  • VIEWFAULTPH : Party at Fault from Point of View of Policyholder
    Its data type is CHAR (Character String) with field length 1
  • TPNO : Third Party Count (NOT USED)
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • XTPKNOWN : Flag: Third Party Known?
    Its data type is CHAR (Character String) with field length 1
  • COVERED : Indication of Compensability
    Its data type is CHAR (Character String) with field length 1
  • AUTHCLM : Authorization Group for Claims (VIP)
    Its data type is CHAR (Character String) with field length 4
  • XCLAIMB : Entry in ICLCLAIMB Exists
    Its data type is CHAR (Character String) with field length 1
  • XNONOTIF : Processing Not Possible in Notification Mode
    Its data type is CHAR (Character String) with field length 1
  • XRESERVE : At Least One Reserve Exists in Claim
    Its data type is CHAR (Character String) with field length 1
  • BENTREE : Benefit Type Tree
    Its data type is CHAR (Character String) with field length 8
  • BENTREEG : Generation of Benefit Type Tree
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • BENTREEV : Version of Benefit Type Tree
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • WF_EXEC_TIME : Execution Time Workflow
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • WF_STATUS : Workflow Status
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • XDUMMYCLAIM : Flag: Dummy Claim
    Its data type is CHAR (Character String) with field length 1
  • VERCHNGUTC : UTC Time of Change for Reading Version
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • OPENDATE : Opened On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XWITHOUT_PRODUCT : Indicator for Working Without Product Customizing
    Its data type is CHAR (Character String) with field length 1
  • MAX_ITEMNR : Current Highest Claim Item Number
    Its data type is CHAR (Character String) with field length 4
  • ASSIGN_GUID : UUID of Entry to be Linked
    Its data type is CHAR (Character String) with field length 32