ICSDIAGNOSIS SAP table for – Diagnoses

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

SAP ICSDIAGNOSIS table

Table ICSDIAGNOSIS technical data

TableICSDIAGNOSIS
Data storingDiagnoses
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_HEALTH
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSDIAGNOSIS 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 ICSDIAGNOSIS 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
  • PATIENT : Injured Person
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • SUBOBJCAT : Claim Subobject Category
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SUBOBJECT : Damaged Objects Occurrence Subobject
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • DIAGNO : Sequence Number of Diagnosis Within A Case
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • 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 ICLDIAGNOSIS
  • CATAID1 : Catalog Code
    Its data type is CHAR (Character String) with field length 4
  • DIAGID1 : Primary Diagnosis
    Its data type is CHAR (Character String) with field length 10
  • CATAID2 : Catalog Code
    Its data type is CHAR (Character String) with field length 4
  • DIAGID2 : Secondary Diagnosis
    Its data type is CHAR (Character String) with field length 10
  • DIAGNOPARENT : Diagnosis Number (Numerical) – Obsolete
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DESCRIPTION : Diagnosis Description
    Its data type is CHAR (Character String) with field length 50
  • ENDDATE : End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DIAGSRCCAT : Claim Item Grouping Category
    Its data type is CHAR (Character String) with field length 2
  • DIAGSRCID : Diagnosis Source ID
    Its data type is CHAR (Character String) with field length 20
  • DIAGTYPE : Diagnosis Type
    Its data type is CHAR (Character String) with field length 2
  • LOCALIZATION : Side Localization of a Diagnosis
    Its data type is CHAR (Character String) with field length 1
  • SEVERITYCODE : Severity of Diagnosis
    Its data type is CHAR (Character String) with field length 1
  • MORPHOLOGY : Morphology
    Its data type is CHAR (Character String) with field length 7
  • EXCORIATION : Excoriation
    Its data type is CHAR (Character String) with field length 5
  • GUARANTEE : Diagnostic Certainty
    Its data type is CHAR (Character String) with field length 1
  • DEPARTMENT : Department (Key)
    Its data type is CHAR (Character String) with field length 4
  • DIAGORDER : Sequence of Diagnoses
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • LOCALIZATION2 : Localization 2
    Its data type is CHAR (Character String) with field length 1
  • USED4CALC : Used for Grouping
    Its data type is CHAR (Character String) with field length 1
  • ASSIGN_GUID : UUID of Entry to be Linked
    Its data type is CHAR (Character String) with field length 32