SAP ICSNOTE Note Table data and field list

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

The ICSNOTE table consists of various fields, each holding specific information or linking keys about Note data available in SAP. These include ACTIVE (Table entry is active (A) or in suspense (S)), CLAIM (Number of Claim), OBJYR (Year of Note), OBJNO (Note Number)... 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. .

ICSNOTE 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 ICSNOTE 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 ICSNOTE 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
CLIENT	Client	MANDT	CLNT	3	T000		MANDT
ACTIVE	Table entry is active (A) or in suspense (S)	ICL_ACTIVE	CHAR	1			ICL_ACTIVE
CLAIM	Number of Claim	ICL_CLAIM	CHAR	17	ICLCLAIM	ALPHA	ICL_CLAIM	ICL_CLAIM	ICL_CLAIMNO_COL
OBJYR	Year of Note	ICL_SOOBJYR	CHAR	2			SO_OBJ_YR
OBJNO	Note Number	ICL_SOOBJNO	CHAR	12	SOOD		SO_OBJ_NO
CHANGETIME	Changed: Date + Time	ICL_CHANGEUTC1	DEC	15		TSTAM	ICL_TIMESTAMP
CHANGEDBY	Changed By	ICL_CHANGEDBY	CHAR	12	USR02		XUBNAME
DELETED	Database Line Status (Original, Changed, Deleted)	ICL_RECSTATUS	CHAR	1			ICL_RECSTATUS
SUBCLAIM	Subclaim	ICL_SUBCL	CHAR	3	ICLSUBCL		ICL_SUBCL	ICL_SUBCLAIM
NOTETYPE	Topic of Claim Note	ICL_NOTETYPE	CHAR	2	TICL090		ICL_NOTETYPE
COMCAT	Category of Communication	ICL_COMCAT	CHAR	1			ICL_COMCAT
COMTYPE	Communication Type Key	ICL_COMTYPE	CHAR	1	TICL091		ICL_COMTYPE
XTELFLAG	Outbound Telephone Note	ICL_TELFLAG	CHAR	1			XFELD
CHONAM	Changed by	SO_CHO_NAM	CHAR	12			USERNAME
COMTIME	Start of Communication: UTC Time	ICL_COMTIMES	CHAR	14			TIMESTAMP
COMSTATUS	Status of Communication	ICL_COMSTATUS	CHAR	1			ICL_COMSTATUS
COMTIMEE	UTC Time Stamp: End Time of Communication	ICL_COMTIMEE	CHAR	14			TIMESTAMP
NOTECALLER	Caller	ICL_NOTECALLER	CHAR	12	Assigned to domain		XUBNAME
COMDATE	Communication Date	ICL_COMDATE	DATS	8			DATE
RESUBMISSION	Date on Which a Note Is Resubmitted	ICL_RESUBMISSION	DATS	8			DATE
AUTHGRP	Authorization Group for Displaying/Changing a Note	ICL_AUTHGRP_NOTE	CHAR	4	Assigned to domain		ICL_AUTHGRP		ICL_AUTHGRP
PRIO	Priority of a Note	ICL_PRIO	NUMC	1			SWD_PRIORI
VALIDSTATUS	Status Key (Validity) of a Note	ICL_VALIDSTATUS	CHAR	1			ICL_VALIDSTATUS
ASSIGN_GUID	UUID of Entry to be Linked	ICL_ASSIGN_GUID	CHAR	32			SYSUUID_C

Key field

Non-key field

< ICSLOSSDET - Claim Facts Text ICSPART - Participant in Claim >

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

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

SELECT SINGLE *
FROM ICSNOTE
INTO CORRESPONDING FIELDS OF WA_ICSNOTE
WHERE...

How to access SAP table ICSNOTE

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

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