SAP ABAP Table ICL_SERVCAT_POSITION (FS-CM: All Data on Benefits/Services/Fees Catalog Item)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_SERVICE_CATALOG (Package) FS-CM: Benefits/Services/Fees Catalog

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_SERVCAT_POSITION	Table Relationship Diagram
Short Description	FS-CM: All Data on Benefits/Services/Fees Catalog Item

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	.INCLUDE	☐				0	0	FS-CM: Attributes for Version of Benefits/Serv/Fee Catalogs
3	ACTIVE	☐	ICL_ACTIVE2	ICL_ACTIVE2	CHAR	1	0	Status
4	CHANGEDBY	☐	ICL_CHANGEBY	XUBNAME	CHAR	12	0	Version Created By (= Object Changed By)	USR02
5	CHANGETIME	☐	ICL_CHANGEUTC	ICL_TIMESTAMP	DEC	15	0	Version Created: UTC Date+Time
6	INACTIVETIME	☐	ICL_INACTIUTC	ICL_TIMESTAMP	DEC	15	0	Version Deactivated: UTC Date+Time
7	EFFFROMTIME	☐	ICL_EFFROMUTC	ICL_TIMESTAMP	DEC	15	0	Version Valid From: UTC Date+Time
8	EFFTOTIME	☐	ICL_EFFETOUTC	ICL_TIMESTAMP	DEC	15	0	Version Valid to: UTC-Date+Time
9	TERMTIME	☐	ICL_TERMINUTC	ICL_TIMESTAMP	DEC	15	0	Valid-To Date Set: UTC Date+Time
10	DELETED	☐	ICL_XDELETE	XFELD	CHAR	1	0	Flag: Deletion Entry?
11	OSYSID	☐	ICL_OSYSID	SYCHAR08	CHAR	8	0	Original System of Version
12	OMANDT	☐	ICL_OMANDT	MANDT	CLNT	3	0	Client in Original System	*
13	SCPOSID_PREV	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
14	.INCLUDE	☐				0	0	FS-CM: External Key Attrib. of Benef/Serv/Fee Ctlg Item
15	SERVCATID	☐	ICL_SERVCATID	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	TICL401
16	SC_VARIANT	☐	ICL_SERVCAT_VARIANT	ICL_SERVCAT_VARIANT	CHAR	4	0	Variant of a Benefits/Services/Fee Catalog	TICL402
17	SCPOSID_EXT	☐	ICL_SERVCAT_POSID	ICL_SERVCAT_POSID	CHAR	20	0	ID of a Benefits Catalog Item
18	SCPOSID_AMNTFROM	☐	ICL_SERVCAT_POSID_AMOUNT_FROM	ICL_AMOUNT	CURR	15	2	Lower Interval Limit of a Benefits Catalog Item
19	SCPOSID_AMNTTO	☐	ICL_SERVCAT_POSID_AMOUNT_TO	ICL_AMOUNT	CURR	15	2	Upper Interval Limit of a Benefits Catalog Item
20	.INCLUDE	☐				0	0	FS-CM: General Attributes of Benef/Service/Fee Catalog Item
21	SCPOS_CURR	☐	ICL_SERVCAT_POS_CURR	WAERS	CUKY	5	0	Currency of Benefits/Services/Fees Catalog	TCURC
22	SCPOS_PARENT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
23	SCPOS_TYPE	☐	ICL_SERVCAT_POS_TYPE	ICL_SERVCAT_POS_TYPE	CHAR	4	0	Type of Benefits Catalog Item	TICL404
24	SCPOS_XSEL	☐	ICL_SERVCAT_POS_SELECTABLE	XFELD	CHAR	1	0	Entry Lock for Benefits Catalog Item
25	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL055
26	BENTYPE_EXP	☐	BRF_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF: Expression	*
27	SCPOS_QUANTITY	☐	ICL_SERVCAT_POS_QUANTITY	ICL_SERVCAT_POS_QUANTITY	QUAN	10	3	Evaluation Quantity of Benefits Catalog Item
28	SCPOS_QUANTITYTO	☐	ICL_SERVCAT_POS_QUANTITY_TO	ICL_SERVCAT_POS_QUANTITY	QUAN	10	3	Evaluation Quantity of Catalog Item (Upper Limit)
29	SCPOS_QUANUNIT	☐	ICL_SERVCAT_POS_QUANUNIT	MEINS	UNIT	3	0	Unit of Benefits Catalog Item	T006
30	SCPOS_VALPERUNIT	☐	ICL_SERVCAT_POS_VALPERUNIT	ICL_SERVCAT_POS_VALPERUNIT	DEC	20	12	Value per Unit of Benefits Catalog Item
31	SCPOS_XREIMBURSE	☐	ICL_SERVCAT_POS_REIMBURSABLE	ICL_SERVCAT_POS_REIMBURSABLE	CHAR	1	0	Reimbursability of a Benefits Catalog Item
32	SCPOS_XAPPROVAL	☐	ICL_SERVCAT_POS_APPROVAL	XFELD	CHAR	1	0	Approval Requirement of a Benef/Serv/Fees Catalog Item
33	.INCLUDE	☐				0	0	Workers Comp - Benefits Catalog
34	SAWW	☐	ICL_SAWW_AMT	ICL_RESAMOUNT	CURR	15	2	State Average Weekly Wage (AWW)
35	BENEFIT_RULE	☐	ICL_BEN_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Benefit	*
36	MAX_BEN	☐	ICL_MAX_AMT	ICL_RESAMOUNT	CURR	15	2	Maximum Amount
37	MAX_RULE	☐	ICL_MAX_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Maximum Weekly Benefit	*
38	MIN_BEN	☐	ICL_MIN_AMT	ICL_RESAMOUNT	CURR	15	2	Minimum Amount
39	MIN_RULE	☐	ICL_MIN_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Minimum Weekly Benefit	*
40	WAITING_PERIOD	☐	ICL_WAITINGPRD	NUMC4	NUMC	4	0	Waiting Period
41	RETRO_PERIOD	☐	ICL_RETROPRD	NUMC4	NUMC	4	0	Retroactive Period
42	MAX_PERIOD	☐	ICL_MAXPRD		NUMC	4	0	Maximum Benefit Period in Weeks
43	MAX_TOTAL	☐	ICL_MAX_PYMNT	ICL_RESAMOUNT	CURR	15	2	Maximum Payment Amount
44	FORMULA	☐	ICL_WC_FORM	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Overall Benefit	*
45	.INCLUDE	☐				0	0	Workers Compensation - Benefits Catalog Death
46	SPOUSE_CHILD_BEN	☐	ICL_SPS_CHLD_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Spouse and Child Rule	*
47	SPOUSE_ONLY_BEN	☐	ICL_SPS_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Spouse Rule	*
48	ONE_CHILD_BEN	☐	ICL_CHLD_RULE	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Child Rule	*
49	MAX_SPSECHLD_AMT	☐	ICL_SPSECHLD_AMT	ICL_RESAMOUNT	CURR	15	2	Maximum Weekly Amount for Spouse and Child
50	MAX_SPSEONLY_AMT	☐	ICL_SPSEONLY_AMT	ICL_RESAMOUNT	CURR	15	2	Maximum Weekly Amount for Spouse
51	MIN_SPSEONLY_AMT	☐	ICL_SPSE_MIN_AMT	ICL_RESAMOUNT	CURR	15	2	Minimum Amount for Spouse
52	AMOUNT_LIMIT_SC	☐	ICL_MAX_AMT_SC	ICL_RESAMOUNT	CURR	15	2	Amount Limit for Spouse Plus Child in Total
53	AMOUNT_LIMIT_SO	☐	ICL_MAX_AMT_SO	ICL_RESAMOUNT	CURR	15	2	Amount Limit for Spouse
54	TIME_LIMIT	☐	ICL_MAXPRD		NUMC	4	0	Maximum Benefit Period in Weeks
55	BURIAL_AMOUNT	☐	ICL_BURIAL_AMT	ICL_RESAMOUNT	CURR	15	2	Workers Compensation: Burial Amount
56	CHILD_MAX_AGE	☐	ICL_CHILD_MAX_AGE		NUMC	4	0	Maximum Age of Child
57	STDNT_MAX_AGE	☐	ICL_STDNT_MAX_AGE		NUMC	4	0	Maximum Age for Student
58	TRANSPORTN_MAX	☐	ICL_TRNSPT_MAX	ICL_RESAMOUNT	CURR	15	2	Maximum Amount for Transport
59	LUMP_SUM	☐	ICL_LUMP_SUM	ICL_RESAMOUNT	CURR	15	2	Lump Sum
60	FORMULA_DTH	☐	ICL_WC_FORM	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Deriving Overall Benefit	*
61	.INCLUDE	☐				0	0	Workers Compensation - Benefits Catalog Injuries
62	TOTAL_SCHED	☐	ICL_WCMP_OVERALL_SCHED	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Determining Total Weeks	TBRF150
63	SCH_SERVCATID	☐	ICL_WCMP_SCH_SERVCATID	ICL_SERVCATID	CHAR	10	0	Scheduled Benefits Catalog for Injuries	TICL401
64	SCH_SC_VARIANT	☐	ICL_WCMP_SCH_SERVCAT_VARIANT	ICL_SERVCAT_VARIANT	CHAR	4	0	Scheduled Benefits Catalog Variant for Injuries	TICL402
65	SERVCATIDSN	☐	ICL_SERVCATNAME_SHORT	TEXT10	CHAR	10	0	Short Name of a Benefits/Services/Fees Catalog
66	SERVCATIDLN	☐	ICL_SERVCATNAME	TEXT30	CHAR	30	0	Name of Benefits/Services/Fee Catalog
67	SCPOSN	☐	ICL_SERVCAT_POS_SHORTNAME	TEXT30	CHAR	30	0	Short Text of a Benefits Catalog Item
68	SCPOSLN	☐	ICL_SERVCAT_POS_NAME	TEXT100	CHAR	100	0	Long Text of Benefits Catalog Item
69	SCPOSXLN	☐	ICL_SERVCAT_POS_XLONG_TEXT	TEXT255	CHAR	255	0	Description of Benefits Catalog Item
70	SCPOSHINT_TEXT	☐	ICLSERVCATXLT_T		TTYP	0	0
71	SC_ATTRIBUTES	☐	ICL_SCATTRIB_DATA_TAB		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_SERVCAT_POSITION	BENTYPE	TICL055	BENTYPE		1	CN
2	ICL_SERVCAT_POSITION	CHANGEDBY	USR02	BNAME		1	CN
3	ICL_SERVCAT_POSITION	SCH_SC_VARIANT	TICL402	SC_VARIANT
4	ICL_SERVCAT_POSITION	SCH_SERVCATID	TICL401	SERVCATID
5	ICL_SERVCAT_POSITION	SCPOS_CURR	TCURC	WAERS		1	CN
6	ICL_SERVCAT_POSITION	SCPOS_QUANUNIT	T006	MSEHI		1	CN
7	ICL_SERVCAT_POSITION	SCPOS_TYPE	TICL404	SCPOS_TYPE		1	CN
8	ICL_SERVCAT_POSITION	SC_VARIANT	TICL402	SC_VARIANT
9	ICL_SERVCAT_POSITION	SERVCATID	TICL401	SERVCATID
10	ICL_SERVCAT_POSITION	TOTAL_SCHED	TBRF150	EXPRESSION

History

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