SAP ABAP Table ICL_ICLNOTE_S (Structure for Database Table ICLNOTE)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_ICLNOTE_S	Table Relationship Diagram
Short Description	Structure for Database Table ICLNOTE

Delivery and Maintenance

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

History

Last changed by/on	SAP	20130529
SAP Release Created in