SAP ICS_PAY Attributes of ICLPAY Table data and field list

ICS_PAY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Attributes of ICLPAY" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ICS_PAY TYPE ICS_PAY.

The ICS_PAY table consists of various fields, each holding specific information or linking keys about Attributes of ICLPAY data available in SAP. These include CREATEDBY (Created By), CREATETIME (Created: Date + Time), APPROVEDBY (Checked By), APPROVEDTIME (Date Checked (Date+Time))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

ICS_PAY structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ICS_PAY structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ICS_PAY table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CREATEDBYCreated By ICL_CREATEDBYCHAR12USR02XUBNAME
CREATETIMECreated: Date + Time ICL_CREATEUTCDEC15TSTAMICL_TIMESTAMP
APPROVEDBYChecked By ICL_PAYMENT13CHAR12Assigned to domainXUBNAME
APPROVEDTIMEDate Checked (Date+Time) ICL_PAYMENT15UTCDEC15TSTAMICL_TIMESTAMP
TRANSFERTIMETransfer Date to Collections/Disbursements (Date+Time) ICL_PAYMENT17UTCDEC15TSTAMICL_TIMESTAMP
DOCUMENTREFReference for Payment Document Created in Subledger ICL_DOCUMENTREFCHAR14ICL_DOCUMENTREF
POSTDATEPosting Date ICL_POSTDATEDATS8DATE
DOCDATEDocument Date of Payment ICL_DOCDATEDATS8DATE
DUEDATEDue Date for Net Payment ICL_DUEDATENETDATS8DATE
XALREADYPAIDPayment Already Made ICL_ALREADYPAIDCHAR1CHAR1
PAYCATRecord Type of Payment ICL_PAYCATCHAR1ICL_PAYCAT
PAYTYPEPayment Type (Final Payment, Payment After Closure of Claim) ICL_PAYTYPECHAR1ICL_PAYTYPE
SUBSALSubrogation/Salvage ICL_SUBSALNUMC3ICL_SUBRO
XPAYEEAdditional Payee (ICLPAYEE) ICL_XPAYEECHAR1CHAR1
ADDRNUMBERAddress Number for Checks ICL_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUM
CRECADDRAddress Number for Checks ICL_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUM
BKIDBank Details ID ICL_BKIDCHAR4CHAR4
CURRClaim Payment Currency ICL_PAYMENTCURCUKY5TCURCWAERS
EXCHRATEExchange Rate of Payment Currency into Policy Currency ICL_PAYMENT18DEC9(5) EXCRTKURSF
STATUSInternal Payment Status (Database Status) ICL_PAYMENT12CHAR2ICL_PAYMENT12
METHODPayment Method ICL_PAYMENT01CHAR1Assigned to domainPYMET_KKPAYMENTMETHOD
CHECKNUMBERCheck Number for Manual Check Payments ICL_CHECKCHAR13ALPHAICL_CHECK
NOTEPayment Note ICL_PAYMENT04CHAR50TEXT50
INVOICEREFExternal Invoice Number ICL_INVOICEREFCHAR20CHAR20
REFCLAIMClaim Number (Reassignment Reference) ICL_CLAIM_REFPAYCHAR17Assigned to domainCLAIMICL_CLAIMICL_CLAIM
REFSUBCLAIMSubclaim (Reassignment Reference) ICL_SUBCL_REFPAYCHAR3Assigned to domainICL_SUBCLICL_SUBCLAIM
REFPAYMENTClaim Payment (Reassignment Reference) ICL_PAYMENT_REFPAYNUMC5Assigned to domainICL_PAYMENT
AMTDONEAmount Paid or Received ICL_AMOUNT_DONECURR15(2) ICL_ITAMTS
LIABRATENegotiated Liability Rate in Percent ICL_LIABRATE_NEGDEC5(2) ICL_PERCENT
AMTNEGAmount Negotiated ICL_AMOUNTNEGCURR15(2) ICL_ITAMTS
SUBROSTATUSLegal Status of Subrogation/Recovery ICL_SUBROSTATUSCHAR1ICL_SUBROSTATUS
TAXROLETax Role of Claim Payment Recipient ICL_TAXROLECHAR4Assigned to domainICL_TAXROLE
TAX_RPTFlag for Reportable Payments ICL_TAXRPTCHAR1XFELD
XTAXRPTCTCode for Withholding Tax in Statutory Reporting Category ICL_XTAXRPTCTCHAR1XFELD
MTAXRPTCTWithholding Tax Code for Statutory Reporting ICL_TAXRPTCTCHAR2Assigned to domainQSSKZ
OVRD_TAXRPTCTManual Withholding Tax Code ICL_OVRDTAXRPTCTCHAR1XFELD
FUNDSRECDTSalvage: Funds Received ICL_SALVFUNDRECDATS8ICL_SALVFUNDREC
XSALVESTENDEnd Estimation of Salvage Value ICL_XSALVESTENDCHAR1XFELD
OWNERTYPE_GRPResponsible Organization Category ICL_OWNERTYPE_GRP3CHAR2Assigned to domainOTYPE
OWNER_GRPResponsible Organizational Unit ICL_OWNER_GRP3CHAR12Assigned to domainXUBNAME
REASONREJRejection Reasons for Payments and Reserves ICL_REASONREJCHAR2TICL112ICL_REASONREJ
REFEXTSDOCReferenced Statistical Payment Entry ICL_REFEXTSDOCNUMC5Assigned to domainICL_PAYMENT
MOSMethod of Settlement ICL_MOSCHAR3Assigned to domainICL_MOS
CL_PAYFREQPLANPayment Frequency of Scheduled Payment ICL_PAYFREQPLANCHAR2TVS010BPKEY_VK
PMTTOEnd Date of a Scheduled Payment ICL_PMTTODATS8DATUM
PMTFRStart Date of a Scheduled Payment ICL_PMTFRDATS8DATUM
SCHEDTYPEType of Scheduled Payment ICL_SCHEDULE_TYPECHAR2TICL180ICL_SCHEDULE_TYPE
NROFINVREQMininum Number of Inbound Invoices ICL_INVOICES_REQUIREDNUMC2NUMC2
DAMAGEDOBJDamaged Object ICL_DAMOBJNUMC4Assigned to domainICL_DAMOBJ
MIGRATIONIndicator for Migrated Payments ICL_PAYMIGRATIONCHAR1CHAR1
REQEVALCATDetermination Category of Receivable Amount ICL_REQEVALCAT_D_PECHAR1ICL_REQEVALCAT_PE
ASSIGN_GUIDUUID of Entry to be Linked ICL_ASSIGN_GUIDCHAR32SYSUUID_C
PAYOUT_SCENARIORepetitive Payment Scenario ICL_PAYOUT_SCENARIO_DCHAR1ICL_PAYOUT_SCENARIO
SERV_FROMService Start Date ICL_SERVFRDATS8DATUM
SERV_TOService End Date ICL_SERVTODATS8DATUM
XREPPAYPayment Creation from Repetitive Payment Record ICL_XREPPAY_D_ALCHAR1XFELD
ALTPOSTTARGETAlternative Posting Target ICL_ALTPOSTTARGET_DCHAR50TEXT50
GROSS_NET_PAYMENTGross/Net payment indicator /GSINS/INSH_GROSS_NET_PAYMENTCHAR1/GSINS/INSH_GROSS_NET_PAYMENT
HCM_PAYMENT_STATEPayment Processing State Indicator on the HCM system /GSINS/INSH_HCM_PAYMENT_STATECHAR1/GSINS/INSH_HCM_PAYMENT_STATE

Key field Non-key field



How do I retrieve data from SAP structure ICS_PAY using ABAP code?

As ICS_PAY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ICS_PAY as there is no data to select.

How to access SAP table ICS_PAY

Within an ECC or HANA version of SAP you can also view further information about ICS_PAY and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).