SAP ABAP Table ICL_SCWCOMP_ALV (Workers Compensation Rule Overview - ALV)

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_SCWCOMP_ALV	Table Relationship Diagram
Short Description	Workers Compensation Rule Overview - ALV

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	SCPOSID_INT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
2	SERVCATID	☐	ICL_SERVCATID	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	*
3	SC_VARIANT	☐	ICL_SERVCAT_VARIANT	ICL_SERVCAT_VARIANT	CHAR	4	0	Variant of a Benefits/Services/Fee Catalog	*
4	DISABILITY_CLASS	☐	ICL_DISABILITY_CLASS	ICL_DISABILITY_CLASS	CHAR	2	0	Disability Class	TICL460
5	DISABILITY_CLASS_TEXT	☐	ICL_DISABILITY_CLASST	ICL_TXT50	CHAR	50	0	Name of Disability Class
6	COUNTRY	☐	ICL_JURICOUNTRY	LAND1	CHAR	3	0	Jurisdiction Country	*
7	REGION	☐	ICL_JURISREGION	REGIO	CHAR	3	0	Jurisdiction Region	*
8	REGION_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
9	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
10	.INCLUDE	☐				0	0	FS-CM: Attributes for Version of Benefits/Serv/Fee Catalogs
11	ACTIVE	☐	ICL_ACTIVE2	ICL_ACTIVE2	CHAR	1	0	Status
12	CHANGEDBY	☐	ICL_CHANGEBY	XUBNAME	CHAR	12	0	Version Created By (= Object Changed By)	USR02
13	CHANGETIME	☐	ICL_CHANGEUTC	ICL_TIMESTAMP	DEC	15	0	Version Created: UTC Date+Time
14	INACTIVETIME	☐	ICL_INACTIUTC	ICL_TIMESTAMP	DEC	15	0	Version Deactivated: UTC Date+Time
15	EFFFROMTIME	☐	ICL_EFFROMUTC	ICL_TIMESTAMP	DEC	15	0	Version Valid From: UTC Date+Time
16	EFFTOTIME	☐	ICL_EFFETOUTC	ICL_TIMESTAMP	DEC	15	0	Version Valid to: UTC-Date+Time
17	TERMTIME	☐	ICL_TERMINUTC	ICL_TIMESTAMP	DEC	15	0	Valid-To Date Set: UTC Date+Time
18	DELETED	☐	ICL_XDELETE	XFELD	CHAR	1	0	Flag: Deletion Entry?
19	OSYSID	☐	ICL_OSYSID	SYCHAR08	CHAR	8	0	Original System of Version
20	OMANDT	☐	ICL_OMANDT	MANDT	CLNT	3	0	Client in Original System	*
21	SCPOSID_PREV	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
22	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	*
23	.INCLUDE	☐				0	0	Workers Comp - Benefits Catalog
24	SAWW	☐	ICL_SAWW_AMT	ICL_RESAMOUNT	CURR	15	2	State Average Weekly Wage (AWW)
25	BENEFIT_RULE	☐	ICL_BEN_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Benefit	*
26	MAX_BEN	☐	ICL_MAX_AMT	ICL_RESAMOUNT	CURR	15	2	Maximum Amount
27	MAX_RULE	☐	ICL_MAX_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Maximum Weekly Benefit	*
28	MIN_BEN	☐	ICL_MIN_AMT	ICL_RESAMOUNT	CURR	15	2	Minimum Amount
29	MIN_RULE	☐	ICL_MIN_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Minimum Weekly Benefit	*
30	WAITING_PERIOD	☐	ICL_WAITINGPRD	NUMC4	NUMC	4	0	Waiting Period
31	RETRO_PERIOD	☐	ICL_RETROPRD	NUMC4	NUMC	4	0	Retroactive Period
32	MAX_PERIOD	☐	ICL_MAXPRD		NUMC	4	0	Maximum Benefit Period in Weeks
33	MAX_TOTAL	☐	ICL_MAX_PYMNT	ICL_RESAMOUNT	CURR	15	2	Maximum Payment Amount
34	FORMULA	☐	ICL_WC_FORM	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Overall Benefit	*
35	.INCLUDE	☐				0	0	Workers Compensation - Benefits Catalog Death
36	SPOUSE_CHILD_BEN	☐	ICL_SPS_CHLD_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Spouse and Child Rule	*
37	SPOUSE_ONLY_BEN	☐	ICL_SPS_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Spouse Rule	*
38	ONE_CHILD_BEN	☐	ICL_CHLD_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Child Rule	*
39	MAX_SPSECHLD_AMT	☐	ICL_SPSECHLD_AMT	ICL_RESAMOUNT	CURR	15	2	Maximum Weekly Amount for Spouse and Child
40	MAX_SPSEONLY_AMT	☐	ICL_SPSEONLY_AMT	ICL_RESAMOUNT	CURR	15	2	Maximum Weekly Amount for Spouse
41	MIN_SPSEONLY_AMT	☐	ICL_SPSE_MIN_AMT	ICL_RESAMOUNT	CURR	15	2	Minimum Amount for Spouse
42	AMOUNT_LIMIT_SC	☐	ICL_MAX_AMT_SC	ICL_RESAMOUNT	CURR	15	2	Amount Limit for Spouse Plus Child in Total
43	AMOUNT_LIMIT_SO	☐	ICL_MAX_AMT_SO	ICL_RESAMOUNT	CURR	15	2	Amount Limit for Spouse
44	TIME_LIMIT	☐	ICL_MAXPRD		NUMC	4	0	Maximum Benefit Period in Weeks
45	BURIAL_AMOUNT	☐	ICL_BURIAL_AMT	ICL_RESAMOUNT	CURR	15	2	Workers Compensation: Burial Amount
46	CHILD_MAX_AGE	☐	ICL_CHILD_MAX_AGE		NUMC	4	0	Maximum Age of Child
47	STDNT_MAX_AGE	☐	ICL_STDNT_MAX_AGE		NUMC	4	0	Maximum Age for Student
48	TRANSPORTN_MAX	☐	ICL_TRNSPT_MAX	ICL_RESAMOUNT	CURR	15	2	Maximum Amount for Transport
49	LUMP_SUM	☐	ICL_LUMP_SUM	ICL_RESAMOUNT	CURR	15	2	Lump Sum
50	FORMULA_DTH	☐	ICL_WC_FORM	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Overall Benefit	*
51	.INCLUDE	☐				0	0	Workers Compensation - Benefits Catalog Injuries
52	TOTAL_SCHED	☐	ICL_WCMP_OVERALL_SCHED	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Determining Total Weeks	TBRF150
53	SCH_SERVCATID	☐	ICL_WCMP_SCH_SERVCATID	ICL_SERVCATID	CHAR	10	0	Scheduled Benefits Catalog for Injuries	TICL401
54	SCH_SC_VARIANT	☐	ICL_WCMP_SCH_SERVCAT_VARIANT	ICL_SERVCAT_VARIANT	CHAR	4	0	Scheduled Benefits Catalog Variant for Injuries	TICL402

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_SCWCOMP_ALV	CHANGEDBY	USR02	BNAME		1	CN
2	ICL_SCWCOMP_ALV	DISABILITY_CLASS	TICL460	DISABILITY_CLASS
3	ICL_SCWCOMP_ALV	SCH_SC_VARIANT	TICL402	SC_VARIANT
4	ICL_SCWCOMP_ALV	SCH_SERVCATID	TICL401	SERVCATID
5	ICL_SCWCOMP_ALV	TOTAL_SCHED	TBRF150	EXPRESSION

History

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