SAP ABAP Table ICL_WCOMP_ICLW40_ALV (Workers Comp - View ICLW40 ALV Grid)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_WCOMP (Package) Workers Compensation

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_WCOMP_ICLW40_ALV	Table Relationship Diagram
Short Description	Workers Comp - View ICLW40 ALV Grid

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	Workers Comp - Header Data
2	.INCLUDE	☐				0	0	Workers Comp - Header Data
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
5	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
6	SUBCLAIM	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	*
7	WCMPH_SEQNUM	☐	ICL_WCMP_SEQNUM	SYSUUID_C	CHAR	32	0	Sequence Number of Header Data
8	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
9	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
10	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
11	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
12	.INCLUDE	☐				0	0	Workers Compensation - Header Structure
13	.INCLUDE	☐				0	0	Workers Compensation - Benefits Catalag (Ext.Catalog Item)
14	COUNTRY	☐	ICL_JURICOUNTRY	LAND1	CHAR	3	0	Jurisdiction Country	T005
15	REGION	☐	ICL_JURISREGION	REGIO	CHAR	3	0	Jurisdiction Region	T005S
16	DISABILITY_CLASS	☐	ICL_DISABILITY_CLASS	ICL_DISABILITY_CLASS	CHAR	2	0	Disability Class	TICL460
17	AWW	☐	ICL_EMP_PREINJURY_AWW	ICL_RESAMOUNT	CURR	15	2	Pre-Injury Average Weekly Wage
18	POST_AWW	☐	ICL_EMP_POSTINJURY_AWW	ICL_RESAMOUNT	CURR	15	2	Average Weekly Wage After Injury
19	LOSSDATE	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
20	STARTDATE	☐	ICL_WCMP_STARTDATE	ICL_WCMP_DATE	DATS	8	0	Last Day Worked
21	EXPENDDATE	☐	ICL_WCMP_EXPENDDATE	ICL_WCMP_DATE	DATS	8	0	Expected Date of Return to Work (YYYYMMDD)
22	ENDDATE	☐	ICL_EMP_INITIALRTW	ICL_INITIALRTW	DATS	8	0	Initial Return to Work Date
23	MMI_DATE	☐	ICL_EMP_MMI_DATE	ICL_MMI_DATE	DATS	8	0	Date of Maximum Medical Improvement
24	NUM_EXEMPT	☐	ICL_EMP_NUMOFENTEXEMPTIONS	NUM2	NUMC	2	0	Employee Number of Entitled Exemptions
25	NUMOFWHDEXEMPTIO	☐	ICL_EMP_NUMOFWHDEXEMPTIONS	NUM2	NUMC	2	0	Employee Number of Withholding Exemptions
26	CURRENCY	☐	ICL_CURRENCY	WAERS	CUKY	5	0	Currency	*
27	SERVCAT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
28	NUM_DEPENDANTS	☐	ICL_EMP_NUMOFDEPENDENTS	NUM2	NUMC	2	0	Employee Number of Dependents
29	MARITAL_STATUS	☐	ICL_WCMP_MARITALSTATUS	ICL_WCMP_MARST	CHAR	1	0	Marital Status
30	BENEFIT_OFFSET	☐	ICL_WCMP_OFFSET	ICL_ITAMTS	CURR	15	2	Amount Offset
31	PAID_FOR_DOI	☐	ICL_WCMP_PAID_FOR_DOI	XFELD	CHAR	1	0	Paid for Day of Injury
32	PROCUREMENT	☐	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping	*
33	COLOR	☐	ICL_COLOR	CHAR10	CHAR	10	0	Color
34	DETAIL_SELECT	☐	ICL_DETAIL_SELECT		CHAR	50	0	Details

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_WCOMP_ICLW40_ALV	CHANGEDBY	USR02	BNAME
2	ICL_WCOMP_ICLW40_ALV	COUNTRY	T005	LAND1
3	ICL_WCOMP_ICLW40_ALV	DISABILITY_CLASS	TICL460	DISABILITY_CLASS
4	ICL_WCOMP_ICLW40_ALV	REGION	T005S	BLAND

History

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