ICSPROCURE SAP table for – Claim Item Groupings

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

SAP ICSPROCURE table

Table ICSPROCURE technical data

TableICSPROCURE
Data storingClaim Item Groupings
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_CDC
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSPROCURE 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 ICSPROCURE 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 of Payment
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PROCUREMENT : ID of Claim Item Grouping
    Its a key field. Its data type is NUMC (Character String with Digits Only) 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 : Claim Item Grouping
  • .INCLUDE : Organizational Include (Short Version)
  • CREATEDBY : Created By
    Its data type is CHAR (Character String) with field length 12
  • CREATETIME : Created: UTC Date+Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • PDOCTYPE : Benefit Type for Grouping of Lower Level Benefit Types
    Its data type is CHAR (Character String) with field length 10
  • PDOCCAT : Claim Item Grouping Category
    Its data type is CHAR (Character String) with field length 2
  • ISSUEDATE : Date Created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECEIVEDATE : Date Received
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATEFROM : Start Date of Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIMEFROM : Start Time of Claim Item Group
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATETO : End Date of Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TIMETO : End Time of Claim Item Group
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ISSUEDATE_PRESCR : Date Prescription Created Acc. to Invoice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACQUISITIONDATE : Date Entered
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AMOUNT1 : General Amount Field
    Its data type is CURR (Currency Field) with field length 15
  • CURRENCY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLUDE : External Numbers for Claim Item Groupings
  • EXTERNALREF : External Reference of Claim Item Grouping
    Its data type is CHAR (Character String) with field length 20
  • EXTDOCUMENT : External Document Number
    Its data type is CHAR (Character String) with field length 16
  • EXTCASENO : Hospital-Internal ID
    Its data type is CHAR (Character String) with field length 15
  • EXTFILENO : HI: External Data Set Identification
    Its data type is CHAR (Character String) with field length 20
  • PROC_REF : ID of Claim Item Grouping
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DISCOUNTAMOUNT : Discount on Invoice Amount
    Its data type is CURR (Currency Field) with field length 15
  • DISCOUNTPERCENT : Discount on Total Invoice Amount in Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • .INCLUDE : Accident or Subro/Recovery Indicator
  • ACCIDENT : Accident or Other Reason for Possible Recovery
    Its data type is CHAR (Character String) with field length 2
  • SUBROGATION : Indication Whether Recovery Claim Might Be Involved
    Its data type is CHAR (Character String) with field length 2
  • DUEDATE : Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DUEDATE_ORIG : Origin of Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STATUS : Status of a Claim Item Grouping
    Its data type is CHAR (Character String) with field length 2
  • STATREASON : Reason for Changing the Status
    Its data type is CHAR (Character String) with field length 2
  • OWNCONTRIB : Copayment
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REASON : Reason for Creating a Claim Item Grouping
    Its data type is CHAR (Character String) with field length 3
  • CAUSE : Specification of Reason for Creating Claim Item Grouping
    Its data type is CHAR (Character String) with field length 2
  • PDOCCATTYPE : Type of Claim Item Grouping Category
    Its data type is CHAR (Character String) with field length 3
  • SUBCL_ORIG : Original Subclaim Multiple Prescription/Curr.Subclm Appraisl
    Its data type is CHAR (Character String) with field length 3
  • PROC_ORIG : Original Claim Item Grouping of Multiple Prescription
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DATASOURCE : Data Origin
    Its data type is CHAR (Character String) with field length 2
  • SETORDERDATE : Set Order Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • COMPLETIONDATE : Completion Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Claim Item Grouping: Dental-Specific Fields
  • FEE : Fee
    Its data type is CURR (Currency Field) with field length 15
  • MATLABCOST : Material and Laboratory Costs
    Its data type is CURR (Currency Field) with field length 15
  • MATLABCOSTINT : will be deleted.
    Its data type is CURR (Currency Field) with field length 15
  • ADDCOST : Other Costs
    Its data type is CURR (Currency Field) with field length 15
  • VALPERUNIT : Value per Unit of Benefits Catalog Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 20
  • SUBSIDYPERCENT : Subsidy in Percent (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SUBSIDYAMOUNT : Subsidy Amount
    Its data type is CURR (Currency Field) with field length 15
  • SENTUTC : Sent: UTC Date and Time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SENT_BY_DME : Sent via External Interface (Not Yet Used)
    Its data type is CHAR (Character String) with field length 1
  • RECEIPT_BY_DME : Receipt via External Interface
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Status for Procurement
  • CANCEL : Status “Cancelled”
    Its data type is CHAR (Character String) with field length 1
  • REJECTED : Status “Rejected”
    Its data type is CHAR (Character String) with field length 1
  • INSUSPENSE : Status “Pending”
    Its data type is CHAR (Character String) with field length 1
  • INPROCESS : Status “In Process”
    Its data type is CHAR (Character String) with field length 1
  • RELEASED : Status “Released”
    Its data type is CHAR (Character String) with field length 1
  • XFINISHED : Complete/Approved/Finished
    Its data type is CHAR (Character String) with field length 1
  • ORDERED : Status “Commissioned”
    Its data type is CHAR (Character String) with field length 1
  • TRANSFERRED : Status “Reassigned”
    Its data type is CHAR (Character String) with field length 1
  • XCLINICCARD : Flag: Clinic Card
    Its data type is CHAR (Character String) with field length 1
  • PAYFREQPLAN : Payment Frequency of a Repetitive Payment
    Its data type is CHAR (Character String) with field length 2
  • ASSIGN_GUID : UUID of Entry to be Linked
    Its data type is CHAR (Character String) with field length 32
  • XREQUEST : Indicator: Receivable
    Its data type is CHAR (Character String) with field length 1
  • COMPPER_DATEFROM : Comparison Period From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • COMPPER_DATETO : Comparison Period To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PAYOUT_SCENARIO : Repetitive Payment Scenario
    Its data type is CHAR (Character String) with field length 1