ICLVISION SAP table for – Vision Findings

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

SAP ICLVISION table

Table ICLVISION technical data

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

SAP ICLVISION 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 ICLVISION 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
  • .INCLUDE : Shadow Tables Versioning: Include for Original Table
  • CHANGETIME : Changed: UTC Date+Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • 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