ICSPAY SAP table for – Payment

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

SAP ICSPAY table

Table ICSPAY technical data

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

SAP ICSPAY 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 ICSPAY 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
  • 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 ICLPAY
  • .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
  • APPROVEDBY : Checked By
    Its data type is CHAR (Character String) with field length 12
  • APPROVEDTIME : Date Checked (UTC Date+Time)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TRANSFERTIME : Transfer Date (UTC Date+Time)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • DOCUMENTREF : Reference for Payment Document Created in Subledger
    Its data type is CHAR (Character String) with field length 14
  • POSTDATE : Posting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DOCDATE : Document Date of Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DUEDATE : Due Date for Net Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XALREADYPAID : Payment Already Made
    Its data type is CHAR (Character String) with field length 1
  • PAYCAT : Record Type of Payment
    Its data type is CHAR (Character String) with field length 1
  • PAYTYPE : Payment Type (Final Payment, Payment After Closure of Claim)
    Its data type is CHAR (Character String) with field length 1
  • SUBSAL : Subrogation/Salvage
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • XPAYEE : Additional Payee (ICLPAYEE)
    Its data type is CHAR (Character String) with field length 1
  • ADDRNUMBER : Address Number for Checks
    Its data type is CHAR (Character String) with field length 10
  • CRECADDR : Address Number for Checks
    Its data type is CHAR (Character String) with field length 10
  • BKID : Bank Details ID
    Its data type is CHAR (Character String) with field length 4
  • CURR : Claim Payment Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXCHRATE : Exchange Rate of Payment Currency into Policy Currency
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • STATUS : Internal Payment Status (Database Status)
    Its data type is CHAR (Character String) with field length 2
  • METHOD : Payment Method
    Its data type is CHAR (Character String) with field length 1
  • CHECKNUMBER : Check Number for Manual Check Payments
    Its data type is CHAR (Character String) with field length 13
  • NOTE : Payment Note
    Its data type is CHAR (Character String) with field length 50
  • INVOICEREF : External Invoice Number
    Its data type is CHAR (Character String) with field length 20
  • REFCLAIM : Claim Number (Reassignment Reference)
    Its data type is CHAR (Character String) with field length 17
  • REFSUBCLAIM : Subclaim (Reassignment Reference)
    Its data type is CHAR (Character String) with field length 3
  • REFPAYMENT : Claim Payment (Reassignment Reference)
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • AMTDONE : Amount Paid or Received
    Its data type is CURR (Currency Field) with field length 15
  • LIABRATE : Negotiated Liability Rate in Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • AMTNEG : Amount Negotiated
    Its data type is CURR (Currency Field) with field length 15
  • SUBROSTATUS : Legal Status of Subrogation
    Its data type is CHAR (Character String) with field length 1
  • TAXROLE : Tax Role of Claim Payment Recipient
    Its data type is CHAR (Character String) with field length 4
  • TAX_RPT : Flag for Reportable Payments
    Its data type is CHAR (Character String) with field length 1
  • XTAXRPTCT : Code for Withholding Tax in Statutory Reporting Category
    Its data type is CHAR (Character String) with field length 1
  • MTAXRPTCT : Withholding Tax Code for Statutory Reporting
    Its data type is CHAR (Character String) with field length 2
  • OVRD_TAXRPTCT : Manual Withholding Tax Code
    Its data type is CHAR (Character String) with field length 1
  • FUNDSRECDT : Salvage: Funds Received
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XSALVESTEND : End Estimation of Salvage Value
    Its data type is CHAR (Character String) with field length 1
  • OWNERTYPE_GRP : Responsible Organization Category
    Its data type is CHAR (Character String) with field length 2
  • OWNER_GRP : Responsible Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • REASONREJ : Rejection Reasons for Payments and Reserves
    Its data type is CHAR (Character String) with field length 2
  • REFEXTSDOC : Referenced Statistical Payment Entry
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • MOS : Method of Settlement
    Its data type is CHAR (Character String) with field length 3
  • CL_PAYFREQPLAN : Payment Frequency of Scheduled Payment
    Its data type is CHAR (Character String) with field length 2
  • PMTTO : End Date of a Scheduled Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PMTFR : Start Date of a Scheduled Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SCHEDTYPE : Type of Scheduled Payment
    Its data type is CHAR (Character String) with field length 2
  • NROFINVREQ : Mininum Number of Inbound Invoices
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DAMAGEDOBJ : Damaged Object
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • MIGRATION : Indicator for Migrated Payments
    Its data type is CHAR (Character String) with field length 1
  • REQEVALCAT : Determination Category of Receivable Amount
    Its data type is CHAR (Character String) with field length 1
  • ASSIGN_GUID : UUID of Entry to be Linked
    Its data type is CHAR (Character String) with field length 32
  • PAYOUT_SCENARIO : Repetitive Payment Scenario
    Its data type is CHAR (Character String) with field length 1