SAP ABAP Table ICL_DIAGINV_S_AL (Accident: Previous Illnesses and Disabilities)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_DIAGINV_S_AL	Table Relationship Diagram
Short Description	Accident: Previous Illnesses and Disabilities

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
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	.INCLUDE	☐				0	0	Accident: Grid Structure for Disability
5	.INCLUDE	☐				0	0	ICLH_GRID: Include Structure for Header Data
6	DETAIL_SELECT	☐	ICL_DETAIL_SELECT		CHAR	50	0	Details
7	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
8	CT	☐	LVC_T_STYL		TTYP	0	0
9	SUBCLAIM	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	*
10	PROCUREMENT	☐	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping	*
11	.INCLUDE	☐				0	0	ICLH_GRID: Include Structure for Benef/Services/Fees Catalog
12	.INCLUDE	☐				0	0	ICLH_LVC_INCL_SERVCAT: Include for Benefits/Serv/Fee Catlg
13	SERVCATID	☐	ICL_SERVCATID	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	*
14	SERVCATIDLN	☐	ICL_SERVCATNAME	TEXT30	CHAR	30	0	Name of Benefits/Services/Fee Catalog
15	SCPOSID	☐	ICL_SERVCAT_POSID	ICL_SERVCAT_POSID	CHAR	20	0	ID of a Benefits Catalog Item
16	SCPOSLN	☐	ICL_SERVCAT_POS_NAME	TEXT100	CHAR	100	0	Long Text of Benefits Catalog Item
17	SCPOSID_INT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
18	FACTOR	☐	ICLH_DISMEMBERMENT_TAX	ICL_PERCENT	DEC	5	2	Degree of Disability acc. to Dismemberment Schedule
19	ACVPERCENT	☐	ICLH_DISABILITY	ICL_PERCENT	DEC	5	2	Functional Impairment of a Body Part
20	DISCOUNTPERCENT	☐	ICLH_OLD_DISABILITY	ICL_PERCENT	DEC	5	2	Previous Impairment of a Body Part
21	EVQUANTITY	☐	ICL_EVQUANTITY	ICL_LIMAMT	QUAN	10	3	Claim Item: Number (Days, Visits, Area) for Evaluation
22	EVQUANUNIT	☐	ICL_EVQUANUNIT	MEINS	UNIT	3	0	Claim Item: Unit of Measurement	*
23	ITEM_DESC	☐	ICL_DPDESC	TEXT40	CHAR	40	0	Claim Item Description
24	SUBOBJCAT	☐	ICL_SUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Claim Subobject Category	*
25	SUBOBJECT	☐	ICL_SUBOBJECTD	ICL_SUBOBJECTD	CHAR	3	0	Damaged Objects Occurrence Subobject
26	DIAGNO	☐	ICL_DIAGNO	ICL_DIAGNO	CHAR	3	0	Sequence Number of Diagnosis Within A Case
27	DIAGINVTYPE	☐	ICL_DIAGINV_TYPE_D	ICL_DIAGINV	CHAR	1	0	Type of Data Record (Previous Illness or Disability)
28	DESC_TEXT	☐	ICL_DIAGINV_DESC_D		CHAR	240	0	Information on Accident
29	ITEMCAT	☐	ICL_ITEMCAT	ICL_ITEMCAT	CHAR	2	0	Claim Item Category	TICL139
30	ITEMTYPE	☐	ICL_ITEMTYPE	ICL_IOBTYPE	CHAR	3	0	Claim Item Object Type	TICL164
31	DATEFROM	☐	ICL_DATEFROM	DATS	DATS	8	0	Start Date of Period
32	TIMEFROM	☐	ICL_TIMEFROM	ICL_TIMEFROM	TIMS	6	0	Start Time of Claim Item Group
33	DATETO	☐	ICL_DATETO	DATS	DATS	8	0	End Date of Period
34	TIMETO	☐	ICL_TIMETO	ICL_TIMETO	TIMS	6	0	End Time of Claim Item Group
35	.INCLUDE	☐				0	0	Claim Items - Value-Added Tax Fields
36	GROSNET	☐	ICL_GROSNET	XFELD	CHAR	1	0	Flag: Amount Is Net Amount
37	TXCOD	☐	ICL_TXCOD	MWSKZ	CHAR	2	0	Tax Code	*
38	.INCLUDE	☐				0	0	FS-CM: General Attributes of Benef/Service/Fee Catalog Item
39	SCPOS_CURR	☐	ICL_SERVCAT_POS_CURR	WAERS	CUKY	5	0	Currency of Benefits/Services/Fees Catalog	TCURC
40	SCPOS_PARENT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
41	SCPOS_TYPE	☐	ICL_SERVCAT_POS_TYPE	ICL_SERVCAT_POS_TYPE	CHAR	4	0	Type of Benefits Catalog Item	TICL404
42	SCPOS_XSEL	☐	ICL_SERVCAT_POS_SELECTABLE	XFELD	CHAR	1	0	Entry Lock for Benefits Catalog Item
43	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL055
44	BENTYPE_EXP	☐	BRF_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF: Expression	*
45	SCPOS_QUANTITY	☐	ICL_SERVCAT_POS_QUANTITY	ICL_SERVCAT_POS_QUANTITY	QUAN	10	3	Evaluation Quantity of Benefits Catalog Item
46	SCPOS_QUANTITYTO	☐	ICL_SERVCAT_POS_QUANTITY_TO	ICL_SERVCAT_POS_QUANTITY	QUAN	10	3	Evaluation Quantity of Catalog Item (Upper Limit)
47	SCPOS_QUANUNIT	☐	ICL_SERVCAT_POS_QUANUNIT	MEINS	UNIT	3	0	Unit of Benefits Catalog Item	T006
48	SCPOS_VALPERUNIT	☐	ICL_SERVCAT_POS_VALPERUNIT	ICL_SERVCAT_POS_VALPERUNIT	DEC	20	12	Value per Unit of Benefits Catalog Item
49	SCPOS_XREIMBURSE	☐	ICL_SERVCAT_POS_REIMBURSABLE	ICL_SERVCAT_POS_REIMBURSABLE	CHAR	1	0	Reimbursability of a Benefits Catalog Item
50	SCPOS_XAPPROVAL	☐	ICL_SERVCAT_POS_APPROVAL	XFELD	CHAR	1	0	Approval Requirement of a Benef/Serv/Fees Catalog Item
51	.INCLUDE	☐				0	0	Attributes of ICLDIAGNOSIS
52	CATAID1	☐	ICL_CATAID	ICL_CATAID	CHAR	4	0	Catalog Code	TICL350
53	DIAGID1	☐	ICL_PRIMDIAGID	ICL_DIAGID	CHAR	10	0	Primary Diagnosis	TICL351
54	CATAID2	☐	ICL_CATAID	ICL_CATAID	CHAR	4	0	Catalog Code	TICL350
55	DIAGID2	☐	ICL_SECDIAGID	ICL_DIAGID	CHAR	10	0	Secondary Diagnosis	TICL351
56	DIAGNOPARENT	☐	ICL_DIAGNO_OLD_D	ICL_DIAGNO_OLD	NUMC	3	0	Diagnosis Number (Numerical) - Obsolete
57	DESCRIPTION	☐	ICL_DESCRIPTION	TEXT50	CHAR	50	0	Diagnosis Description
58	ENDDATE	☐	ICL_ENDDATE	DATUM	DATS	8	0	End Date
59	DIAGSRCCAT	☐	ICL_PDOCCAT	ICL_PDOCCAT	CHAR	2	0	Claim Item Grouping Category	TICL138
60	DIAGSRCID	☐	ICL_DIAGSRCID	ICL_DIAGSRCID	CHAR	20	0	Diagnosis Source ID	*
61	DIAGTYPE	☐	ICL_DIAGTYPE	ICL_DIAGTYPE	CHAR	2	0	Diagnosis Type	TICL360
62	LOCALIZATION	☐	ICL_LOCALIZATION	ICL_LOCALIZATION	CHAR	1	0	Side Localization of a Diagnosis	TICL352
63	SEVERITYCODE	☐	ICL_SEVERITYCODE	ICL_SEVERITYCODE	CHAR	1	0	Severity of Diagnosis	TICL354
64	MORPHOLOGY	☐	ICL_MORPHOLOGY	ICL_MORPHOLOGY	CHAR	7	0	Morphology	TICL356
65	EXCORIATION	☐	ICL_EXCORIATION	ICL_EXCORIATION	CHAR	5	0	Excoriation	TICL358
66	GUARANTEE	☐	ICL_GUARANTEE	ICL_GUARANTEE	CHAR	1	0	Diagnostic Certainty	TICL363
67	DEPARTMENT	☐	ICL_DEPARTMENT	ICL_DEPARTMENT	CHAR	4	0	Department (Key)	TICL364
68	DIAGORDER	☐	ICL_DIAGORDER		NUMC	3	0	Sequence of Diagnoses
69	LOCALIZATION2	☐	ICL_LOCALIZATION2	ICL_LOCALIZATION	CHAR	1	0	Localization 2	TICL352
70	USED4CALC	☐	ICL_USED4CALC		CHAR	1	0	Used for Grouping
71	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_DIAGINV_S_AL	BENTYPE	TICL055	BENTYPE
2	ICL_DIAGINV_S_AL	CATAID1	TICL350	CATAID	KEY	1	CN
3	ICL_DIAGINV_S_AL	CATAID2	TICL350	CATAID	KEY	1	CN
4	ICL_DIAGINV_S_AL	CLAIM	ICLCLAIM	CLAIM
5	ICL_DIAGINV_S_AL	DEPARTMENT	TICL364	DEPARTMENT	KEY	1	CN
6	ICL_DIAGINV_S_AL	DIAGID1	TICL351	DIAGID	KEY	1	CN
7	ICL_DIAGINV_S_AL	DIAGID2	TICL351	DIAGID	KEY	1	CN
8	ICL_DIAGINV_S_AL	DIAGSRCCAT	TICL138	PDOCCAT	KEY	1	CN
9	ICL_DIAGINV_S_AL	DIAGTYPE	TICL360	DIAGTYPE	KEY	1	CN
10	ICL_DIAGINV_S_AL	EXCORIATION	TICL358	EXCORIATION	KEY	1	CN
11	ICL_DIAGINV_S_AL	GUARANTEE	TICL363	GUARANTEE	KEY	1	CN
12	ICL_DIAGINV_S_AL	ITEMCAT	TICL139	ITEMCAT	KEY	1	CN
13	ICL_DIAGINV_S_AL	ITEMTYPE	TICL164	ITEMTYPE
14	ICL_DIAGINV_S_AL	LOCALIZATION	TICL352	LOCALIZATION	KEY	1	CN
15	ICL_DIAGINV_S_AL	LOCALIZATION2	TICL352	LOCALIZATION	KEY	1	CN
16	ICL_DIAGINV_S_AL	MORPHOLOGY	TICL356	MORPHOLOGY	KEY	1	CN
17	ICL_DIAGINV_S_AL	SCPOS_CURR	TCURC	WAERS		1	CN
18	ICL_DIAGINV_S_AL	SCPOS_QUANUNIT	T006	MSEHI		1	CN
19	ICL_DIAGINV_S_AL	SCPOS_TYPE	TICL404	SCPOS_TYPE		1	CN
20	ICL_DIAGINV_S_AL	SEVERITYCODE	TICL354	SEVERITY	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600