SAP ICSPROCURE Claim Item Groupings Table data and field list

ICSPROCURE is a standard SAP Table which is used to store Claim Item Groupings data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ICSPROCURE table consists of various fields, each holding specific information or linking keys about Claim Item Groupings data available in SAP. These include ACTIVE (Table entry is active (A) or in suspense (S)), CLAIM (Number of Claim), SUBCLAIM (Subclaim of Payment), PROCUREMENT (ID of Claim Item Grouping)... 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. .

ICSPROCURE table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ICSPROCURE table 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 ICSPROCURE 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
ACTIVETable entry is active (A) or in suspense (S) ICL_ACTIVECHAR1ICL_ACTIVE
CLAIMNumber of Claim ICL_CLAIMCHAR17Assigned to domainALPHAICL_CLAIMICL_CLAIMICL_CLAIMNO_COL
SUBCLAIMSubclaim of Payment ICL_SUBCLPCHAR3Assigned to domainICL_SUBCL
PROCUREMENTID of Claim Item Grouping ICL_PROCUREMENTNUMC4Assigned to domainICL_PROCUREMENT
CHANGETIMEChanged: Date + Time ICL_CHANGEUTC1DEC15TSTAMICL_TIMESTAMP
CHANGEDBYChanged By ICL_CHANGEDBYCHAR12USR02XUBNAME
DELETEDDatabase Line Status (Original, Changed, Deleted) ICL_RECSTATUSCHAR1ICL_RECSTATUS
CREATEDBYCreated By ICL_CREATEDBYCHAR12USR02XUBNAME
CREATETIMECreated: Date + Time ICL_CREATEUTCDEC15TSTAMICL_TIMESTAMP
PDOCTYPEBenefit Type for Grouping of Lower Level Benefit Types ICL_PDOCTYPECHAR10Assigned to domainICL_BENTYPE
PDOCCATClaim Item Grouping Category ICL_PDOCCATCHAR2TICL138ICL_PDOCCAT
ISSUEDATEDate Created ICL_ISSUEDATE1DATS8DATS
RECEIVEDATEDate Received ICL_RECEIVEDATEDATS8DATS
DATEFROMStart Date of Period ICL_DATEFROMDATS8DATS
TIMEFROMStart Time of Claim Item Group ICL_TIMEFROMTIMS6ICL_TIMEFROM
DATETOEnd Date of Period ICL_DATETODATS8DATS
TIMETOEnd Time of Claim Item Group ICL_TIMETOTIMS6ICL_TIMETO
ISSUEDATE_PRESCRDate Prescription Created Acc. to Invoice ICL_ISSUEDATE_PRESCRDATS8DATSICL_ISSUEDATE_PRESCR
ACQUISITIONDATEDate Entered ICL_ACQUISITIONDATEDATS8DATS
AMOUNT1General Amount Field ICL_AMOUNT1CURR15(2) ICL_AMOUNT
CURRENCYCurrency ICL_CURRENCYCUKY5TCURCWAERS
EXTERNALREFExternal Reference of Claim Item Grouping ICL_EXTERNALREFCHAR20ICL_EXTERNALREF
EXTDOCUMENTExternal Document Number ICL_EXTDOCUMENTCHAR16ICL_EXTDOCUMENT
EXTCASENOHospital-Internal ID ICLH_EXTCASENOCHAR23ICLH_EXTCASENO
EXTFILENOHI: External Data Set Identification ICLH_EXTFILENOCHAR20ICLH_EXTFILENO
PROC_REFReference to Claim Item Grouping ICL_PROC_REFNUMC4Assigned to domainICL_PROCUREMENT
DISCOUNTAMOUNTDiscount on Invoice Amount ICL_DISCOUNTAMOUNTCURR15(2) ICL_AMOUNT
DISCOUNTPERCENTDiscount on Total Invoice Amount in Percent ICL_DISCOUNTPERCENTDEC5(2) ICL_PERCENT
ACCIDENTAccident or Other Reason for Possible Recovery ICL_ACCIDENTCHAR2TICL158ICL_ACCIDENT
SUBROGATIONIndication Whether Recovery Claim Might Be Involved ICL_SUBROGATIONCHAR2TICL157ICL_SUBROGATION
DUEDATEDue Date ICL_DUEDATEDATS8DATE
DUEDATE_ORIGOrigin of Due Date ICL_DUEDATE_ORIGDATS8DATE
STATUSStatus of a Claim Item Grouping ICL_PROCSTATUSCHAR2Assigned to domainICL_STATUS
STATREASONReason for Changing the Status ICL_FORMSETCHAR2TICL018ICL_FORMSET
OWNCONTRIBCopayment ICL_OWNCONTRIBNUMC3NUMC03
REASONReason for Creating a Claim Item Grouping ICL_REASONCHAR3TICL152ICL_REASON
CAUSESpecification of Reason for Creating Claim Item Grouping ICLH_CAUSECHAR2Assigned to domainICLH_CAUSE
PDOCCATTYPEType of Claim Item Grouping Category ICL_PDOCCATTYPECHAR3TICL153ICL_PDOCCATTYPE
SUBCL_ORIGOriginal Subclaim Multiple Prescription/Curr.Subclm Appraisl ICL_SUBCL_ORIGCHAR3Assigned to domainICL_SUBCL
PROC_ORIGOriginal Claim Item Grouping of Multiple Prescription ICL_PROC_ORIGNUMC4Assigned to domainICL_PROCUREMENT
DATASOURCEData Origin ICL_DATASOURCECHAR2TICL136ICL_DATASOURCE
SETORDERDATESet Order Date ICL_SETORDERDATEDATS8DATS
COMPLETIONDATECompletion Date ICL_COMPLETIONDATEDATS8DATS
FEEFee ICLH_FEECURR15(2) ICL_AMOUNT
MATLABCOSTMaterial and Laboratory Costs ICLH_MATLABCOSTCURR15(2) ICL_AMOUNT
MATLABCOSTINTwill be deleted. ICLH_MATLABCOSTINTCURR15(2) ICL_AMOUNT
ADDCOSTOther Costs ICLH_ADDCOSTCURR15(2) ICL_AMOUNT
VALPERUNITValue per Unit of Benefits Catalog Item ICL_SERVCAT_POS_VALPERUNITDEC20(12) ICL_SERVCAT_POS_VALPERUNIT
SUBSIDYPERCENTSubsidy in Percent (%) ICLH_SUBSIDYPERCENTDEC5(2) ICL_PERCENT
SUBSIDYAMOUNTSubsidy Amount ICLH_SUBSIDYAMOUNTCURR15(2) ICL_AMOUNT
SENTUTCSent: Date and Time ICL_SENTUTCDEC15TSTAMICL_TIMESTAMP
SENT_BY_DMESent via External Interface (Not Yet Used) ICL_SENT_BY_DMECHAR1XFELD
RECEIPT_BY_DMEReceipt via External Interface ICL_RECEIPT_BY_DMECHAR1XFELD
CANCELStatus 'Cancelled' ICL_STATUS_CANCELCHAR1XFELD
REJECTEDStatus 'Rejected' ICL_STATUS_REJECTEDCHAR1XFELD
INSUSPENSEStatus 'Pending' ICL_STATUS_INSUSPENSECHAR1XFELD
INPROCESSStatus 'In Process' ICL_STATUS_INPROCESSCHAR1XFELD
RELEASEDStatus 'Released' ICL_STATUS_RELEASEDCHAR1XFELD
XFINISHEDComplete/Approved/Finished ICL_XFINISHEDCHAR1XFELD
ORDEREDStatus 'Commissioned' ICL_STATUS_ORDEREDCHAR1XFELD
TRANSFERREDStatus 'Reassigned' ICL_STATUS_TRANSFERREDCHAR1XFELD
TOBEAPPROVEDStatus 'To Be Approved' ICL_STATUS_TOBEAPPROVEDCHAR1XFELD
XCLINICCARDFlag: Clinic Card ICLH_CLINIC_CARDCHAR1ICLH_CLINIC_CARD
PAYFREQPLANPayment Frequency of a Repetitive Payment ICL_PAYFREQPLAN_REPCHAR2TVS010BPKEY_VK
ASSIGN_GUIDUUID of Entry to be Linked ICL_ASSIGN_GUIDCHAR32SYSUUID_C
XREQUESTIndicator: Receivable ICL_XREQUESTCHAR1XFELD
COMPPER_DATEFROMComparision Period From ICL_COMPPER_DATEFROM_D_PEDATS8ICL_COMPPER_PE
COMPPER_DATETOComparison Period To ICL_COMPPER_DATETO_D_PEDATS8ICL_COMPPER_PE
PAYOUT_SCENARIORepetitive Payment Scenario ICL_PAYOUT_SCENARIO_DCHAR1ICL_PAYOUT_SCENARIO
REASONREJRejection Reasons for Payments and Reserves ICL_REASONREJCHAR2Assigned to domainICL_REASONREJ
METHODPayment Method ICL_PAYMENT01CHAR1Assigned to domainPYMET_KKPAYMENTMETHOD
ADDRNUMBERAddress Number for Checks ICL_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUM
BKIDBank Details ID ICL_BKIDCHAR4CHAR4

Key field Non-key field



How do I retrieve data from SAP table ICSPROCURE using ABAP code

The following ABAP code Example will allow you to do a basic selection on ICSPROCURE to SELECT all data from the table
DATA: WA_ICSPROCURE TYPE ICSPROCURE.

SELECT SINGLE *
FROM ICSPROCURE
INTO CORRESPONDING FIELDS OF WA_ICSPROCURE
WHERE...

How to access SAP table ICSPROCURE

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

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