ICSPAYI SAP table for – Payment Item

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

SAP ICSPAYI table

Table ICSPAYI technical data

TableICSPAYI
Data storingPayment Item
ModuleFS
Sub ModuleFS-CM
SAP PackageICL_CF
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP ICSPAYI 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 ICSPAYI 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
  • PAYMENT : Number of Claim Payment
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • PAYMENTITEM : Claim Payment Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • 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 ICLPAYI
  • ITEMSUBCL : Subclaim to Which a Payment Item Is Assigned
    Its data type is CHAR (Character String) with field length 3
  • PAYITEMCAT : Claim Payment Item Category
    Its data type is CHAR (Character String) with field length 1
  • PAMPAID : Payment Amount
    Its data type is CURR (Currency Field) with field length 15
  • BENTYPE : Benefit Type
    Its data type is CHAR (Character String) with field length 10
  • COVTYPE : Coverage Type
    Its data type is CHAR (Character String) with field length 10
  • PYMTYPE : Tax Category
    Its data type is CHAR (Character String) with field length 4
  • PAYTYPEI : Payment Type (Final Payment, Payment After Closure of Claim)
    Its data type is CHAR (Character String) with field length 1
  • TREASONSET : Payment Reason Group
    Its data type is CHAR (Character String) with field length 2
  • TREASON : Payment Reason
    Its data type is CHAR (Character String) with field length 4
  • GROSS_NET : Tax Category of Amount (Gross/Net)
    Its data type is CHAR (Character String) with field length 1
  • TXCOD : Tax Code
    Its data type is CHAR (Character String) with field length 2
  • REQUESTED : Amount Requested
    Its data type is CURR (Currency Field) with field length 15
  • POSTDATEI : Posting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ITEM : Claim Item
    Its data type is CHAR (Character String) with field length 4
  • REFNO : External Reference Number
    Its data type is CHAR (Character String) with field length 15
  • PAYITY : Payment Item Type
    Its data type is CHAR (Character String) with field length 10
  • REPID : Coinsurance Key
    Its data type is CHAR (Character String) with field length 10
  • VALIDFROM : Payment Item: Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Payment Item: Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ASSIGN_GUID : UUID of Entry to be Linked
    Its data type is CHAR (Character String) with field length 32
  • CDDOCITEM : Item Number in Payment Plan Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REQUESTED_ORIG : Original Amount Requested
    Its data type is CURR (Currency Field) with field length 15