ICSVISION SAP table for – Eyeglass Prescription

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

SAP ICSVISION table

Table ICSVISION technical data

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

SAP ICSVISION 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 ICSVISION 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
  • DOBJ : 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
  • DISTANCE : Vision (Near/Distance)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DIRECTION : Alignment (Left/Right)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • 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 ICLVISION
  • SRCCAT : Claim Item Grouping Category
    Its data type is CHAR (Character String) with field length 2
  • SRCID : Diagnosis Source ID
    Its data type is CHAR (Character String) with field length 20
  • VISIONAID : Vision Aid Exists
    Its data type is CHAR (Character String) with field length 1
  • SPHERE : Spheres
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • CYLINDER : Cylinder
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • AXIS : Axis
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ADDITION : Addition
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PRISM : Prism
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • BASE : Base
    Its data type is CHAR (Character String) with field length 5
  • VERTEXDIST : Vertex Distance
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3