SAP ABAP Table ICL_CLSRCHFLDS (Search Terms for Business Partner Search)

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_CLSRCHFLDS	Table Relationship Diagram
Short Description	Search Terms for Business Partner Search

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	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
2	EXCLAIMNO	☐	ICL_CLAIMNO	ICL_CLAIMNO	CHAR	20	0	External Number
3	EXCLAIMNOCAT	☐	ICL_CLAIMNOCAT	ICL_CLAIMNOCAT	CHAR	1	0	External Number Category
4	POLICY	☐	ICL_POLICY	ICL_POLICY	CHAR	17	0	Contract Number
5	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
6	OWNER	☐	ICL_CLAIMOWNER	ICL_CLAIMOWNER	CHAR	12	0	ID of Claim Handler
7	PLATENO	☐	ICL_LICENSE	CHAR12	CHAR	12	0	License Plate Number
8	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
9	DATELOSS_LOW	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
10	DATELOSS_HIGH	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
11	LOSSREPCOMPA	☐	ICL_LOSSREPCOMPA	DATE	DATS	8	0	Date Claim Reported to Insurance Company
12	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
13	PARTNERDESCRIP	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
14	MC_NAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
15	MC_NAME2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
16	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
17	MC_CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
18	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
19	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
20	TELNR_CALL	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
21	LOSSTYPE	☐	ICL_LOSSTYPE	ICL_LOSSTYPE	CHAR	4	0	Incident Type of a Claim	TICL060
22	VIN	☐	ICL_VIN	CHAR17	CHAR	17	0	Vehicle Identification Number
23	ROLE	☐	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	TICL301
24	STATUS	☐	ICL_CLSTATUS	ICL_STATUS	CHAR	2	0	Status of Claim	TICL140
25	POLH	☐	ICL_POLH	BU_PARTNER	CHAR	10	0	Insured	*
26	POLHNAME	☐	ICL_POLHNAME	CHAR50	CHAR	50	0	Short Description of Policyholder
27	CLAIMANT	☐	ICL_CLAIMANT	BU_PARTNER	CHAR	10	0	Claimant	*
28	CLAIMANTN	☐	ICL_CLAIMANTN	CHAR50	CHAR	50	0	Short Description of Claimant
29	POLPRODN	☐	ICL_POLPRODN	TEXT30	CHAR	30	0	Name of Policy Product
30	SUBCLTYPEN	☐	ICL_SUBCLTYPEN	TEXT25	CHAR	25	0	Subclaim Type Name
31	ACTIVITY	☐	ICL_ACTIVITY_CLSEARCH		CHAR	80	0	Task(s) in Claim
32	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
33	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
34	SSN	☐	ICL_SSN	BPTAXNUM	CHAR	20	0	Social Insurance Number
35	TIN	☐	ICL_TIN	BPTAXNUM	CHAR	20	0	Tax Number
36	STATUSN	☐	ICL_STATUSN	TEXT25	CHAR	25	0	Status Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_CLSRCHFLDS	CREATEDBY	USR02	BNAME
2	ICL_CLSRCHFLDS	LOSSTYPE	TICL060	LOSSTYPE
3	ICL_CLSRCHFLDS	ROLE	TICL301	ROLE
4	ICL_CLSRCHFLDS	STATUS	TICL140	STATUS

History

Last changed by/on	SAP	20110901
SAP Release Created in