1. SAP Tutorial
  2. Financial Services

ICLDRGITEM SAP table for – DRG Item

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

SAP ICLDRGITEM table

Table ICLDRGITEM technical data

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

SAP ICLDRGITEM 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 ICLDRGITEM 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
  • ITEM : Claim Item
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .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 ICLDRGITEM
  • .INCLUDE : Claim Item – Fields for Coverage Check
  • COVTYPE : Coverage Type
    Its data type is CHAR (Character String) with field length 10
  • BENTYPE : Benefit Type
    Its data type is CHAR (Character String) with field length 10
  • RCOVTYPE : Benefit Coverage Type
    Its data type is CHAR (Character String) with field length 10
  • XWAITPERIOD : Probationary Periods Ignored
    Its data type is CHAR (Character String) with field length 1
  • COVERAGE : Coverage
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : FS-CM: Benefits/Services/Fees Catalogs in ICLITEM
  • SCPOSID_INT : Internal ID of Benefits Catalog Item
    Its data type is CHAR (Character String) with field length 32
  • SERVCAT : Catalog of Diagnosis Related Group (DRG)
    Its data type is CHAR (Character String) with field length 10
  • SCPOSID_EXT : Item in Catalog of Diagnosis Related Group (DRG)
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Claim Items – Status Fields
  • STATUS : Status of Claim Item
    Its data type is CHAR (Character String) with field length 2
  • REJREASON : Claim Item Rejection Reason
    Its data type is CHAR (Character String) with field length 2
  • MODIFIED : Modified
    Its data type is CHAR (Character String) with field length 1
  • PROCURED : Ordered
    Its data type is CHAR (Character String) with field length 1
  • CALCULATED : Calculated
    Its data type is CHAR (Character String) with field length 1
  • CATAID : Catalog of Major Diagnostic Category (MDC)
    Its data type is CHAR (Character String) with field length 4
  • DIAGID : Catalog Item of Major Diagnostic Category (MDC)
    Its data type is CHAR (Character String) with field length 10
  • SEVERITY_CODE : Severity of Diagnosis Related Group (DRG)
    Its data type is CHAR (Character String) with field length 1
  • NOTE : Note for Diagnosis Related Groups
    Its data type is CHAR (Character String) with field length 80
  • REMUN_TYPE_AM : Remuneration Category
    Its data type is CHAR (Character String) with field length 4
  • AMOUNT : DRG Amount
    Its data type is CURR (Currency Field) with field length 15
  • REMUN_TYPE_ADDAM : Remuneration Category
    Its data type is CHAR (Character String) with field length 4
  • ADDITIONALAMOUNT : Additional DRG Amount
    Its data type is CURR (Currency Field) with field length 15
  • CURR : Currency of Evaluated Amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • AMOUNTDAYS : Number of Days for DRG Calculation (Markdown/Markup)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ITEM_REF : Claim Item
    Its data type is CHAR (Character String) with field length 4
  • PROCUREMENT : ID of Claim Item Grouping
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Mechanical Ventilation Duration
  • EVQUANTITY : Duration of Mechanical Ventilation
    Its data type is QUAN (Quantity field) with field length 10
  • EVQUANUNIT : Unit of Mechanical Ventilation Duration
    Its data type is UNIT (Unit key for a Quantity field) with field length 3

    • ICLDRGITEM related tables

    • TICL354T : Texts for Severity
    • TICL356T : Texts for Morphology
    • ICLPROCEDURES : Procedures
    • TICL157T : HI: Text for Recovery/Subrogation Indicator
    • TICL332 : Usage of Claim Item
    • ICLCAREREP2 : Data on Caregiver
    • ICSDIAGNOSIS : Diagnoses
    • TICL367T : Texts for Planning (Dental Treatment)
    • TICL052_2 : Assignment Text Module to Category
    • TICL364T : Texts for Departments
    • TICL195 : Control of Copy Function Codes
    • TICL157 : HI: Recovery/Subro Indicator
    • TICL363 : Diagnostic Certainty
    • TICL155T : Text Table for Further Specification of Reason for Creating
    • TICL367 : Planning: Dental Treatment
    • TICL197 : Navigation Tree Note Dependent on PDOCCAT
    • TICL193 : BDT Handling Modules of FCODE
    • TICL333T : Tax Calculation in Invoice Items
    • TICL362 : Diagnosis Group
    • TICL355 : Diagnosis: Permitted Severity

    ICLDRGITEM related transaction codes under SAP package ICL_HEALTH

    • S_KK4_08000503 : IMG Activity: SIMG_ICL_TICL367
    • S_KK4_08000505 : IMG Activity: SIMG_ICL_TICL369
    • ICLDIAGIMPORT : Import Diagnoses
    • S_KK4_08000487 : IMG Activity: SIMG_ICL_TICL364
    • ICL_REPREIMB : Call ICLH_REPREIMB_GENERATE
    • ICLINVNOT01 : Single Entry of Invoice
    • S_KK4_08000502 : IMG Activity: SIMG_ICL_TICL366
    • S_KK4_08000423 : IMG Activity:
    • ICLINVSG01 : Invoice Mass Entry
    • S_KK4_08000426 : IMG Activity:
    • S_KK4_08000486 : IMG Activity: SIMG_ICL_TICL363
    • S_KK4_08000421 : IMG Activity:
    • S_KK4_08000422 : IMG Activity:
    • S_KK4_08000416 : IMG Activity:
    • S_KK4_08000417 : IMG Activity:
    • S_KK4_08000424 : IMG Activity:
    • S_KK4_08000418 : IMG Activity:
    • S_KK4_08000415 : IMG Activity:
    • S_KK4_08000420 : IMG Activity:
    • S_KK4_08000419 : IMG Activity:

    Related References

    Related Tutorials

    ICSDRGITEM SAP table for – DRG Item

    ICSDRGITEM table in SAP FS (Claims Management in FS) module. This table is used for storing data of DRG Item....

    ICL_CDRGSEV SAP table for – Severity (for DRG)

    ICL_CDRGSEV table in SAP FS (Claims Management in FS) module. This table is used for storing data of Severity (for...

    ICLITEM SAP table for – Claim Item

    ICLITEM table in SAP FS (Claims Management in FS) module. This table is used for storing data of Claim Item....

    ICSSALVI SAP table for – Salvage Item

    ICSSALVI table in SAP FS (Claims Management in FS) module. This table is used for storing data of Salvage Item....

    ICSITEM SAP table for – Claim Item

    ICSITEM table in SAP FS (Claims Management in FS) module. This table is used for storing data of Claim Item....

    ICLITEMSV SAP table for – Salvage Item Evaluation

    ICLITEMSV table in SAP FS (Claims Management in FS) module. This table is used for storing data of Salvage Item...

    ICLSALVI SAP table for – Salvage Item

    ICLSALVI table in SAP FS (Claims Management in FS) module. This table is used for storing data of Salvage Item....

    «
    »