SAP ABAP Table ICL_CORR_OI_DATA (Usable Data in Desktop Office Application)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_OI (Package) FS-CM: Office Integration for Claim (Correspondence w. OI)

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_CORR_OI_DATA	Table Relationship Diagram
Short Description	Usable Data in Desktop Office Application

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	Usable Recipient Data in Desktop Application
2	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	PARTN_CAT	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
4	PARTN_GRP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
5	SEARCHTERM1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
6	SEARCHTERM2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
7	FIRSTNAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
8	LASTNAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
9	NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
10	NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
11	NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
12	NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
13	NAMEGROUP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
14	NAMEGROUP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
15	XNAME	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
16	SALUTATION	☐	ICL_SALUTATION	CHAR80	CHAR	80	0	Complete Letter Salutation
17	LINE0	☐	LINES	LINES	CHAR	80	0	Address line
18	LINE1	☐	LINES	LINES	CHAR	80	0	Address line
19	LINE2	☐	LINES	LINES	CHAR	80	0	Address line
20	LINE3	☐	LINES	LINES	CHAR	80	0	Address line
21	LINE4	☐	LINES	LINES	CHAR	80	0	Address line
22	LINE5	☐	LINES	LINES	CHAR	80	0	Address line
23	LINE6	☐	LINES	LINES	CHAR	80	0	Address line
24	LINE7	☐	LINES	LINES	CHAR	80	0	Address line
25	LINE8	☐	LINES	LINES	CHAR	80	0	Address line
26	LINE9	☐	LINES	LINES	CHAR	80	0	Address line
27	ADDRCATE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
28	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
29	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
30	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
31	TEL_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
32	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
33	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
34	TEL_NUMBER_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
35	FAX_COUNTRY	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
36	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
37	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
38	FAX_NUMBER_LONG	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
39	ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
40	APPL	☐	BP_APPL	BP_APPL	CHAR	4	0	Application Category	*
41	ADDRTYPE	☐	BU_ADRKIND	BU_ADRKIND	CHAR	10	0	Address Type	*
42	XADDRESS	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
43	.INCLUDE	☐				0	0	Claim
44	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
45	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
46	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
47	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
48	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
49	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
50	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
51	.INCLUDE	☐				0	0	Attributes of ICLCLAIM
52	.INCLUDE	☐				0	0	Organizational Include (Short Version)
53	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
54	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
55	ACHANGEDBY	☐	ICL_ACHANGEDBY	XUBNAME	CHAR	12	0	Whole Claim Last Changed By	USR02
56	ACHANGETIME	☐	ICL_ACHANGETIME	ICL_TIMESTAMP	DEC	15	0	Whole Claim Last Changed At
57	EXCLAIMNOCAT	☐	ICL_CLAIMNOCAT	ICL_CLAIMNOCAT	CHAR	1	0	External Number Category
58	EXCLAIMNO	☐	ICL_CLAIMNO	ICL_CLAIMNO	CHAR	20	0	External Number
59	STATUS	☐	ICL_CLSTATUS	ICL_STATUS	CHAR	2	0	Status of Claim	TICL140
60	STATUSCHG	☐	ICL_STATUSCHG	ICL_TIMESTAMP	DEC	15	0	Time of Last Status Change
61	STHANDLER	☐	ICL_STHANDLER	XFELD	CHAR	1	0	"Claim Handling" Process Active
62	STNOCLAIM	☐	ICL_STNOCLAIM	XFELD	CHAR	1	0	No Claim Made
63	STCLOSED	☐	ICL_STCLOSED	XFELD	CHAR	1	0	"Close (Sub)Claim" Process Executed
64	STATREASON	☐	ICL_FORMSET	ICL_FORMSET	CHAR	2	0	Reason for Changing the Status	TICL047
65	LOSSTYPE	☐	ICL_LOSSTYPE	ICL_LOSSTYPE	CHAR	4	0	Incident Type of a Claim	TICL062
66	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	TICL011
67	CLTYPEG	☐	ICL_CLTYPEG	ICL_CLTYPEG	NUMC	5	0	Generation of Internal Claim Type	TICL011
68	CLTYPEV	☐	ICL_CLTYPEV	ICL_CLTYPEV	NUMC	5	0	Internal Claim Type Version	TICL003
69	LOSSEVENT	☐	ICL_LOSSEVENT	ICL_CCEVENT	CHAR	17	0	Cumulative Event	ICLCCEVENT
70	POLPROD	☐	ICL_POLPROD	ICL_POLPROD	CHAR	6	0	Policy Product	TICL320
71	GENERAT	☐	ICL_GENERAT	ICL_GENERAT	NUMC	5	0	Policy Product Generation	TICL320
72	VERSION	☐	ICL_POLPRODV	ICL_CUST_VERSION	NUMC	5	0	Policy Product Version	TICL321
73	LRENEWAL	☐	ICL_LRENEWAL	ICL_TIMESTAMP	DEC	15	0	Last Renewal of Contract Before Claim Date/Time
74	POLICY	☐	ICL_POLICY	ICL_POLICY	CHAR	17	0	Contract Number
75	LOSSCAUSE	☐	ICL_LOSSCAUSE	ICL_LOSSCAUSE	CHAR	3	0	Cause of Loss/Claim	TICL009
76	PERIL	☐	ICL_PERIL	ICL_PERIL	CHAR	4	0	Peril
77	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
78	TIMELOSS	☐	ICL_LOSSTIME	TIME	TIMS	6	0	Time of Claim/Loss
79	LTIMEZONE	☐	ICL_LTIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Claim/Loss Event	TTZZ
80	XDATEESTIM	☐	ICL_XLOSSDATE	XFELD	CHAR	1	0	Date Is Estimate
81	DATECHANGER	☐	ICL_DATECHANGER	ICL_DATECHANGER	CHAR	2	0	Reason for Changing Claim Date	TICL029
82	LOSSREPCOMPA	☐	ICL_LOSSREPCOMPA	DATE	DATS	8	0	Date Claim Reported to Insurance Company
83	LOSSREPAGENT	☐	ICL_LOSSREPAGENT	DATE	DATS	8	0	Date Claim Reported to Agent
84	LOSSADDRESS	☐	ICL_LOSSADDRESS	AD_ADDRNUM	CHAR	10	0	Loss Location	ADRC
85	XAUTHREP	☐	ICL_XAUTHREP	XFELD	CHAR	1	0	Claim/Loss Reported to Authority
86	XSENSITIVE	☐	ICL_CLAIMSENS	XFELD	CHAR	1	0	Sensitive Claim?
87	COMPLEX	☐	ICL_COMPLEX	ICL_COMPLEX	CHAR	1	0	Complexity of Claim/Subclaim	TICL027
88	JURISCOUNTRY	☐	ICL_JURICOUNTRY	LAND1	CHAR	3	0	Jurisdiction Country	T005
89	JURISREGION	☐	ICL_JURISREGION	REGIO	CHAR	3	0	Jurisdiction Region	T005S
90	ASSIGN_STATE	☐	ICL_ASSIGN_STATE	ICL_ASSIGN_STATE	CHAR	2	0	Assignment Status of a Claim Subobject
91	OWNERTYPE	☐	ICL_OWNERTYPE	OTYPE	CHAR	2	0	Object Type of Claim Handler	T778O
92	OWNER	☐	ICL_CLAIMOWNER	ICL_CLAIMOWNER	CHAR	12	0	ID of Claim Handler
93	OWNERTYPE_GRP	☐	ICL_OWNERTYPE2	OTYPE	CHAR	2	0	Object Type of Claim Handler Group	*
94	OWNER_GRP	☐	ICL_CLAIMOWNER2	ICL_CLAIMOWNER	CHAR	12	0	Claim Handler Group
95	XCUMUL	☐	ICL_XCUMUL	XFELD	CHAR	1	0	Claim Assigned to an Aggregate
96	VIEWFAULT	☐	ICL_VIEWFAULTI	ICL_VIEWFAULT	CHAR	1	0	Fault of Policyholder from Point of View of Insurer	TICL081
97	VIEWFAULTPH	☐	ICL_VIEWFAULTPH	ICL_VIEWFAULT	CHAR	1	0	Party at Fault from Point of View of Policyholder	TICL081
98	TPNO	☐	ICL_TPNO	NUMC2	NUMC	2	0	Third Party Count (NOT USED)
99	XTPKNOWN	☐	ICL_TPKNOWN	XFELD	CHAR	1	0	Flag: Third Party Known?
100	COVERED	☐	ICL_COVERED	ICL_COVERED	CHAR	1	0	Indication of Compensability
101	AUTHCLM	☐	ICL_AUTHCLM	ICL_AUTHCLM	CHAR	4	0	Authorization Group for Claims (VIP)	TICL113
102	XCLAIMB	☐	ICL_XCLAIMB	XFELD	CHAR	1	0	Entry in ICLCLAIMB Exists
103	XNONOTIF	☐	ICL_XNONOTIF	XFELD	CHAR	1	0	Processing Not Possible in Notification Mode
104	XRESERVE	☐	ICL_XRESERVE	XFELD	CHAR	1	0	At Least One Reserve Exists in Claim
105	BENTREE	☐	ICL_BENTREE	ICL_BENTREE	CHAR	8	0	Benefit Type Tree	*
106	BENTREEG	☐	ICL_BENTREEG	ICL_BENTREEG	NUMC	5	0	Generation of Benefit Type Tree	*
107	BENTREEV	☐	ICL_BENTREEV	ICL_BENTREEV	NUMC	5	0	Version of Benefit Type Tree	*
108	WF_EXEC_TIME	☐	ICL_WF_EXECUTION_TIME	ICL_TIMESTAMP	DEC	15	0	Execution Time Workflow
109	WF_STATUS	☐	ICL_WF_STATUS	ICL_WF_STATUS	NUMC	1	0	Workflow Status
110	XDUMMYCLAIM	☐	ICL_XDUMMYCLAIM	XFELD	CHAR	1	0	Flag: Dummy Claim
111	VERCHNGUTC	☐	ICL_VERCHNGUTC	ICL_TIMESTAMP	DEC	15	0	UTC Time of Change for Reading Version
112	OPENDATE	☐	ICL_OPENDATE	DATE	DATS	8	0	Opened On
113	XWITHOUT_PRODUCT	☐	ICL_XWITHOUTPRODUCT_D	BOOLE	CHAR	1	0	Indicator for Working Without Product Customizing
114	MAX_ITEMNR	☐	ICL_SCLITEM_NR_MAX	ICL_SCLITEM	CHAR	4	0	Current Highest Claim Item Number	*
115	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
116	.INCLUDE	☐				0	0	Structure for Screen Fields in CDC
117	CLAIMDISP	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
118	POLH	☐	ICL_POLH	BU_PARTNER	CHAR	10	0	Insured	*
119	POLHNAME	☐	ICL_POLHNAME	CHAR50	CHAR	50	0	Short Description of Policyholder
120	LOSSTYPEN	☐	ICL_LOSSTYPEN	TEXT30	CHAR	30	0	Name of Incident Type
121	CLINEOFBUS	☐	ICL_CLINEOFBUS	ICL_CLINEOFBUS	CHAR	3	0	Claim Line of Business	TICL077
122	CLINEOFBUSN	☐	ICL_CLINEOFBUSN	TEXT30	CHAR	30	0	Name of Claim Line of Business
123	LOSSCAUSEN	☐	ICL_LOSSCAUSEN	TEXT60	CHAR	60	0	Name for Cause of Claim/Loss
124	EVENTN	☐	ICL_CCEVENTNAME	TEXT20	CHAR	20	0	Name of Claim Bundle
125	CLAIMHN	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
126	COMPLEXN	☐	ICL_COMPLEXN	TEXT15	CHAR	15	0	(Sub)Claim Complexity Name
127	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*
128	PLINEOFBUSN	☐	ICL_LINEOFBUSN	TEXT30	CHAR	30	0	Name of Insurance Line of Business
129	POLPRODN	☐	ICL_POLPRODN	TEXT30	CHAR	30	0	Name of Policy Product
130	CREATENAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
131	VIEWFAULTN	☐	ICL_VIEWFAULTN	TEXT30	CHAR	30	0	Name of Fault
132	JURISCOUNTRYN	☐	LANDX	TEXT15	CHAR	15	0	Country Name
133	JURISREGIONN	☐	BEZEI20	TEXT20	CHAR	20	0	Description
134	CREATEDATE	☐	ICL_OPENDATE	DATE	DATS	8	0	Opened On
135	CREATETIMES	☐	ICL_CREATETIME	TIME	TIMS	6	0	Created At
136	CHANGENAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
137	CHANGEDATE	☐	ICL_CHANGEDATE	DATE	DATS	8	0	Changed On
138	CHANGETIMES	☐	ICL_CHANGETIME	TIME	TIMS	6	0	Changed at
139	ACHANGENAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
140	ACHANGEDATE	☐	ICL_CHANGEDATE	DATE	DATS	8	0	Changed On
141	ACHANGETIMES	☐	ICL_CHANGETIME	TIME	TIMS	6	0	Changed at
142	LRENEWALD	☐	ICL_LRENEWALD	DATE	DATS	8	0	Last Renewal of Contract Before Claim/Loss Event
143	LRENEWALT	☐	ICL_LRENEWALT	TIME	TIMS	6	0	Last Renewal of Contract Before Claim/Loss Event
144	NOTEPERMIT	☐	ICL_NOTEPERMIT	ICL_NOTEPERMIT	CHAR	1	0	Permitted Processing Type of Notes
145	STATUSCHGD	☐	ICL_STATUSCHGD	DATE	DATS	8	0	Date of Last Status Change
146	STATUSCHGT	☐	ICL_STATUSCHGT	TIME	TIMS	6	0	Time of Last Status Change
147	TEXT	☐	CHAR255	CHAR255	CHAR	255	0	Char255

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_CORR_OI_DATA	ACHANGEDBY	USR02	BNAME
2	ICL_CORR_OI_DATA	AUTHCLM	TICL113	AUTHCLM	REF	1	CN
3	ICL_CORR_OI_DATA	CHANGEDBY	USR02	BNAME
4	ICL_CORR_OI_DATA	CLAIMTYPE	TICL011	CLTYPE
5	ICL_CORR_OI_DATA	CLIENT	T000	MANDT
6	ICL_CORR_OI_DATA	CLINEOFBUS	TICL077	CLINEOFBUS
7	ICL_CORR_OI_DATA	CLTYPEG	TICL011	VERSION
8	ICL_CORR_OI_DATA	CLTYPEV	TICL003	VERSION
9	ICL_CORR_OI_DATA	COMPLEX	TICL027	COMPLEX
10	ICL_CORR_OI_DATA	CREATEDBY	USR02	BNAME
11	ICL_CORR_OI_DATA	DATECHANGER	TICL029	DATECHANGER
12	ICL_CORR_OI_DATA	GENERAT	TICL320	VERSION
13	ICL_CORR_OI_DATA	JURISCOUNTRY	T005	LAND1
14	ICL_CORR_OI_DATA	JURISREGION	T005S	BLAND
15	ICL_CORR_OI_DATA	LOSSADDRESS	ADRC	ADDRNUMBER
16	ICL_CORR_OI_DATA	LOSSCAUSE	TICL009	LOSSCAUSE
17	ICL_CORR_OI_DATA	LOSSEVENT	ICLCCEVENT	CCEVENT
18	ICL_CORR_OI_DATA	LOSSTYPE	TICL062	LOSSTYPE
19	ICL_CORR_OI_DATA	LTIMEZONE	TTZZ	TZONE
20	ICL_CORR_OI_DATA	OWNERTYPE	T778O	OTYPE
21	ICL_CORR_OI_DATA	POLPROD	TICL320	POLPROD
22	ICL_CORR_OI_DATA	STATREASON	TICL047	FORMOFSET
23	ICL_CORR_OI_DATA	STATUS	TICL140	STATUS
24	ICL_CORR_OI_DATA	VERSION	TICL321	VERSION
25	ICL_CORR_OI_DATA	VIEWFAULT	TICL081	VIEWFAULT
26	ICL_CORR_OI_DATA	VIEWFAULTPH	TICL081	VIEWFAULT

History

Last changed by/on	SAP	20140121
SAP Release Created in	473