ICLCLAIM SAP (Claim) Table details

Dictionary Type: Table
Description: Claim




ABAP Code to SELECT data from ICLCLAIM
Related tables to ICLCLAIM
Access table ICLCLAIM




Table field list including key, data, relationships and ABAP select examples

ICLCLAIM is a standard SAP Table which is used to store Claim data and is available within R/3 SAP systems depending on the version and release level.

The ICLCLAIM table consists of various fields, each holding specific information or linking keys about Claim data available in SAP. These include ACTIVE (Table entry is active (A) or in suspense (S)), CLAIM (Number of Claim), CHANGETIME (Changed: Date + Time), CHANGEDBY (Changed By).. 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. .

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 ICLCLAIM table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
ACTIVETable entry is active (A) or in suspense (S) ICL_ACTIVECHAR1ICL_ACTIVE
CLAIMNumber of Claim ICL_CLAIMCHAR17ALPHAICL_CLAIMICL_CLAIMICL_CLAIMNO_COL
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
ACHANGEDBYWhole Claim Last Changed By ICL_ACHANGEDBYCHAR12USR02XUBNAME
ACHANGETIMEWhole Claim Last Changed At ICL_ACHANGETIMEDEC15TSTAMICL_TIMESTAMP
EXCLAIMNOCATExternal Number Category ICL_CLAIMNOCATCHAR1ICL_CLAIMNOCATICL_CLAIMNOCAT
EXCLAIMNOExternal Number ICL_CLAIMNOCHAR23ICL_CLAIMNOICL_CLAIMNO
STATUSStatus of Claim ICL_CLSTATUSCHAR2TICL140ICL_STATUS
STATUSCHGTime of Last Status Change ICL_STATUSCHGDEC15TSTAMICL_TIMESTAMP
STHANDLER'Claim Handling' Process Active ICL_STHANDLERCHAR1XFELD
STNOCLAIMNo Claim Made ICL_STNOCLAIMCHAR1XFELD
STCLOSED'Close (Sub)Claim' Process Executed ICL_STCLOSEDCHAR1XFELD
STATREASONReason for Changing the Status ICL_FORMSETCHAR2TICL047ICL_FORMSET
LOSSTYPEIncident Type of a Claim ICL_LOSSTYPECHAR4TICL062ICL_LOSSTYPEICL_LOSSTYPE
CLAIMTYPEInternal Claim Type ICL_CLTYPECHAR4TICL011ICL_CLTYPE
CLTYPEGGeneration of Internal Claim Type ICL_CLTYPEGNUMC5TICL011ICL_CLTYPEG
CLTYPEVInternal Claim Type Version ICL_CLTYPEVNUMC5TICL003ICL_CLTYPEV
LOSSEVENTCumulative Event ICL_LOSSEVENTCHAR17ICLCCEVENTALPHAICL_CCEVENT
POLPRODPolicy Product ICL_POLPRODCHAR6TICL320ICL_POLPROD
GENERATPolicy Product Generation ICL_GENERATNUMC5TICL320ICL_GENERAT
VERSIONPolicy Product Version ICL_POLPRODVNUMC5TICL321ICL_CUST_VERSION
LRENEWALLast Renewal of Contract Before Claim Date/Time ICL_LRENEWALDEC15TSTAMICL_TIMESTAMP
POLICYContract Number ICL_POLICYCHAR17ALPHAICL_POLICYICL_POLICY
LOSSCAUSECause of Loss/Claim ICL_LOSSCAUSECHAR3TICL009ICL_LOSSCAUSE
PERILPeril ICL_PERILCHAR4Assigned to domainICL_PERIL
DATELOSSDate of Loss/Claim ICL_LOSSDATEDATS8DATEICL_LOSSDATE
TIMELOSSTime of Claim/Loss ICL_LOSSTIMETIMS6TIMEICL_LOSSTIME
LTIMEZONETime Zone of Claim/Loss Event ICL_LTIMEZONECHAR6TTZZTZNZONE
XDATEESTIMDate Is Estimate ICL_XLOSSDATECHAR1XFELD
DATECHANGERReason for Changing Claim Date ICL_DATECHANGERCHAR2TICL029ICL_DATECHANGER
LOSSREPCOMPADate Claim Reported to Insurance Company ICL_LOSSREPCOMPADATS8DATE
LOSSREPAGENTDate on Which Claim Was Reported to Agent ICL_LOSSREPAGENTDATS8DATE
LOSSADDRESSLoss Location ICL_LOSSADDRESSCHAR10ADRCALPHAAD_ADDRNUM
XAUTHREPClaim/Loss Reported to Authority ICL_XAUTHREPCHAR1XFELD
XSENSITIVESensitive Claim? ICL_CLAIMSENSCHAR1XFELD
COMPLEXComplexity of Claim/Subclaim ICL_COMPLEXCHAR1TICL027ICL_COMPLEX
JURISCOUNTRYJurisdiction Country ICL_JURICOUNTRYCHAR3T005LAND1
JURISREGIONJurisdiction Region ICL_JURISREGIONCHAR3T005SREGIO
ASSIGN_STATEAssignment Status of a Claim Subobject ICL_ASSIGN_STATECHAR2ICL_ASSIGN_STATE
OWNERTYPEObject Type of Claim Handler ICL_OWNERTYPECHAR2T778OOTYPE
OWNERID of Claim Handler ICL_CLAIMOWNERCHAR12ICL_CLAIMOWNER
OWNERTYPE_GRPObject Type of Claim Handler Group ICL_OWNERTYPE2CHAR2Assigned to domainOTYPE
OWNER_GRPClaim Handler Group ICL_CLAIMOWNER2CHAR12ICL_CLAIMOWNER
XCUMULClaim Assigned to an Aggregate ICL_XCUMULCHAR1XFELD
VIEWFAULTFault of Policyholder from Point of View of Insurer ICL_VIEWFAULTICHAR1TICL081ICL_VIEWFAULT
VIEWFAULTPHParty at Fault from Point of View of Policyholder ICL_VIEWFAULTPHCHAR1TICL081ICL_VIEWFAULT
TPNOThird Party Count (NOT USED) ICL_TPNONUMC2NUMC2
XTPKNOWNFlag: Third Party Known? ICL_TPKNOWNCHAR1XFELD
COVEREDIndication of Compensability ICL_COVEREDCHAR1ICL_COVERED
AUTHCLMAuthorization Group for Claims (VIP) ICL_AUTHCLMCHAR4TICL113ICL_AUTHCLM
XCLAIMBEntry in ICLCLAIMB Exists ICL_XCLAIMBCHAR1XFELD
XNONOTIFProcessing Not Possible in Notification Mode ICL_XNONOTIFCHAR1XFELD
XRESERVEAt Least One Reserve Exists in Claim ICL_XRESERVECHAR1XFELD
BENTREEBenefit Type Tree ICL_BENTREECHAR8Assigned to domainICL_BENTREE
BENTREEGGeneration of Benefit Type Tree ICL_BENTREEGNUMC5Assigned to domainICL_BENTREEG
BENTREEVVersion of Benefit Type Tree ICL_BENTREEVNUMC5Assigned to domainICL_BENTREEV
WF_EXEC_TIMEExecution Time Workflow ICL_WF_EXECUTION_TIMEDEC15TSTAMICL_TIMESTAMP
WF_STATUSWorkflow Status ICL_WF_STATUSNUMC1ICL_WF_STATUS
XDUMMYCLAIMFlag: Dummy Claim ICL_XDUMMYCLAIMCHAR1XFELD
VERCHNGUTCTime for Reading Version ICL_VERCHNGUTCDEC15TSTAMICL_TIMESTAMP
OPENDATEOpened On ICL_OPENDATEDATS8DATE
XWITHOUT_PRODUCTUse of Scenario Without Product Customizing ICL_XWITHOUTPRODUCT_DCHAR1BOOLE
MAX_ITEMNRCurrent Highest Claim Item Number ICL_SCLITEM_NR_MAXCHAR4Assigned to domainICL_SCLITEM
ASSIGN_GUIDUUID of Entry to be Linked ICL_ASSIGN_GUIDCHAR32SYSUUID_C
SIF_STATUSStatus of Second Injury Fund ICL_SIF_STATUS_DCHAR1ICL_SIF_STATUS
INVSTG_STATUSClaim Investigation Match Status ICL_INVSTG_MATCH_STATUS_D_PECHAR1ICL_INVSTG_MATCH_STATUS
EFFECTIVE_DTContract Validity Date ICL_EFFECTIVE_DT_DDATS8DATS
LOSSREP_DTDate on Request for Insurance Benefit ICL_LOSSREP_DT_DDATS8DATS
LUMPSUMOPTIONOption Exercised ICL_LUMPSUMOPTION_DCHAR1ICL_LUMPSUMOPTION
STATPENSIONType of Statutory Pension ICL_STATPENSION_DCHAR3Assigned to domainICL_STATPENSION
WITHDRAWAMRequested Total Withdrawal Amount ICL_WITHDRAWAM_DCURR15(2) ICL_AMOUNT
WITHDRAWCURRCurrency of Withdrawal Amount ICL_WITHDRAWCURR_DCUKY5Assigned to domainWAERS
WITHDRAWSEQWithdrawal Sequence ICL_WITHDRAWSEQ_DCHAR3Assigned to domainICL_WITHDRAWSEQ
ALTERNATEBENDisplay Alternative Benefit Values ICL_ALTERNATEBEN_DCHAR1ICL_ALTERNATEBEN
GENERATENOTIFMake Special Risk Notification ICL_GENERATENOTIF_DCHAR1ICL_GENERATENOTIF
NOTIFREASONReason for Special Risk Notification ICL_NOTIFREASON_DCHAR3ICL_NOTIFREASON
AUTFOLLOWUPAutomatic Resubmission ICL_AUTFOLLOWUP_DCHAR1ICL_AUTFOLLOWUP
FOLLOWUP_DTDate of Automatic Resubmission ICL_FOLLOWUP_DT_DDATS8DATS
PROCESSING_DTProcessing On ICL_PROCESSING_DT_DDATS8DATS
STATUSOBJIDObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
DUNNLEVELDunning Status ICL_DUNNLEVEL_DCHAR2ICL_DUNNLEVEL
CLEARDATEPremium Paid Up To ICL_CLEARDATE_DDATS8DATS
PREMBALANAMPremium Balance ICL_PREMBALANAM_DCURR15(2) ICL_AMOUNT
PREMBALANAMCURRCurrency of Premium Payment ICL_PREMBALANAMCURR_DCUKY5Assigned to domainWAERS
WITHDRAWTYPEWithdrawal Type ICL_WITHDRAWTYPE_DCHAR3Assigned to domainICL_WITHDRAWTYPE
REACT_DTDate of Occupational Disability/Perm.Incap.to Wk Reactivatn ICL_REACT_DT_DDATS8DATS
GENNOTIFTIMESpecial Risk Message Submitted On ICL_GENERATENOTIFTIME_DDEC15ICL_GENERATENOTIFTIME
BEN_CALC_FAILTime of Last Incorrect Benefit Calculation ICL_BEN_CALC_FAIL_DDEC15TSTAMICL_TIMESTAMP
POLSYSTEMTechnical Key of Policy System ICL_POLSYSTEM_DCHAR8SYCHAR08
ARCHIVE_STATUSArchiving Status TYP_ARCHIVE_STATUSCHAR1TYP_ARCHIVE_STATUS
ARCHIVE_FLUDResubmission Date TYP_ARCHIVE_FLUDDATS8DATS
REJECTIONRejection Reason TYP_REJECTIONCHAR2AREN_REJECTIONS_COLLECTIVE

Key field Non-key field



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

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

SELECT SINGLE *
FROM ICLCLAIM
INTO CORRESPONDING FIELDS OF WA_ICLCLAIM
WHERE...

How to access SAP table ICLCLAIM

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!