SAP ABAP Table ICSNOTE (Note)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_CDC (Package) FS-CM: Data Capture

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSNOTE	Table Relationship Diagram
Short Description	Note

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ACTIVE	☑	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
3	CLAIM	☑	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
4	OBJYR	☑	ICL_SOOBJYR	SO_OBJ_YR	CHAR	2	0	Year of Note
5	OBJNO	☑	ICL_SOOBJNO	SO_OBJ_NO	CHAR	12	0	Note Number	SOOD
6	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
7	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
8	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
9	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
10	.INCLUDE	☐				0	0	Attributes of ICLNOTE
11	SUBCLAIM	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	ICLSUBCL
12	NOTETYPE	☐	ICL_NOTETYPE	ICL_NOTETYPE	CHAR	2	0	Topic of Claim Note	TICL090
13	COMCAT	☐	ICL_COMCAT	ICL_COMCAT	CHAR	1	0	Category of Communication
14	COMTYPE	☐	ICL_COMTYPE	ICL_COMTYPE	CHAR	1	0	Key of Communication Type	TICL091
15	XTELFLAG	☐	ICL_TELFLAG	XFELD	CHAR	1	0	Outbound Telephone Note
16	CHONAM	☐	SO_CHO_NAM	USERNAME	CHAR	12	0	Changed by
17	COMTIME	☐	ICL_COMTIMES	TIMESTAMP	CHAR	14	0	Start of Communication: UTC Time
18	COMSTATUS	☐	ICL_COMSTATUS	ICL_COMSTATUS	CHAR	1	0	Status of Communication
19	COMTIMEE	☐	ICL_COMTIMEE	TIMESTAMP	CHAR	14	0	UTC Time Stamp: End Time of Communication
20	NOTECALLER	☐	ICL_NOTECALLER	XUBNAME	CHAR	12	0	Caller	*
21	COMDATE	☐	ICL_COMDATE	DATE	DATS	8	0	Communication Date
22	RESUBMISSION	☐	ICL_RESUBMISSION	DATE	DATS	8	0	Date on Which a Note Is Resubmitted
23	AUTHGRP	☐	ICL_AUTHGRP_NOTE	ICL_AUTHGRP	CHAR	4	0	Authorization Group for Displaying/Changing a Note	*
24	PRIO	☐	ICL_PRIO	SWD_PRIORI	NUMC	1	0	Priority of a Note
25	VALIDSTATUS	☐	ICL_VALIDSTATUS	ICL_VALIDSTATUS	CHAR	1	0	Status Key (Validity) of a Note
26	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSNOTE	CHANGEDBY	USR02	BNAME
2	ICSNOTE	CLAIM	ICLCLAIM	CLAIM
3	ICSNOTE	CLIENT	T000	MANDT
4	ICSNOTE	COMTYPE	TICL091	COMTYPE
5	ICSNOTE	NOTETYPE	TICL090	NOTETYPE
6	ICSNOTE	OBJNO	SOOD	OBJNO
7	ICSNOTE	SUBCLAIM	ICLSUBCL	SUBCLAIM

History

Last changed by/on	SAP	20130529
SAP Release Created in