1. SAP Tutorial
  2. Financial Services

ICSDRGITEM SAP table for – DRG Item

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

SAP ICSDRGITEM table

Table ICSDRGITEM technical data

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

SAP ICSDRGITEM 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 ICSDRGITEM 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
  • 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 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

    • ICSDRGITEM related tables

    • TICL158T : HI: Text for Accident Indicator
    • ICLCAREREP1 : Data on Care Request
    • TICL361 : Diagnosis Origin Category: Permitted Diagnosis Type
    • TICL352 : Diagnosis Localization
    • TICL157 : HI: Recovery/Subro Indicator
    • ICSDENTAL : Tooth Notation
    • TICL356T : Texts for Morphology
    • TICL357 : Permitted Morphology
    • TICL367 : Planning: Dental Treatment
    • TICL194 : Alternative Icons for Claim Item Grouping Grids
    • TICL356 : Morphology
    • TICL354 : Severity of Diagnosis
    • TICL195 : Control of Copy Function Codes
    • TICL360T : Texts for Diagnosis Type
    • TICL353 : Diagnosis: Permitted Localization
    • TICL354T : Texts for Severity
    • ICSPROCEDURES : Procedures
    • TICL366T : Texts for State of Teeth (Dental Diagnosis)
    • ICLDRGITEM : DRG Item
    • TICL358 : Excoriation Diagnosed

    ICSDRGITEM related transaction codes under SAP package ICL_HEALTH

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

    Related References

    Related Tutorials

    ICLDRGITEM SAP table for – DRG Item

    ICLDRGITEM 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...

    TICL358 SAP table for – Excoriation Diagnosed

    TICL358 table in SAP FS (Claims Management in FS) module. This table is used for storing data of Excoriation Diagnosed....

    TICL350 SAP table for – Name of Diagnosis Catalog

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

    TICL332T SAP table for – Text for Usage of Claim Item

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

    TICL367 SAP table for – Planning: Dental Treatment

    TICL367 table in SAP FS (Claims Management in FS) module. This table is used for storing data of Planning: Dental...

    TICL366T SAP table for – Texts for State of Teeth (Dental Diagnosis)

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

    «
    »