SAP ABAP Table ICLSERVCAT (FS-CM: Benefits/Services/Fees Catalogs)

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	TRANSP	Transparent table
Transparent table	ICLSERVCAT	Table Relationship Diagram
Short Description	FS-CM: Benefits/Services/Fees Catalogs

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	SCPOSID_INT	☑	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
3	.INCLUDE	☐				0	0	FS-CM: Attributes for Version of Benefits/Serv/Fee Catalogs
4	ACTIVE	☐	ICL_ACTIVE2	ICL_ACTIVE2	CHAR	1	0	Status
5	CHANGEDBY	☐	ICL_CHANGEBY	XUBNAME	CHAR	12	0	Version Created By (= Object Changed By)	USR02
6	CHANGETIME	☐	ICL_CHANGEUTC	ICL_TIMESTAMP	DEC	15	0	Version Created: UTC Date+Time
7	INACTIVETIME	☐	ICL_INACTIUTC	ICL_TIMESTAMP	DEC	15	0	Version Deactivated: UTC Date+Time
8	EFFFROMTIME	☐	ICL_EFFROMUTC	ICL_TIMESTAMP	DEC	15	0	Version Valid From: UTC Date+Time
9	EFFTOTIME	☐	ICL_EFFETOUTC	ICL_TIMESTAMP	DEC	15	0	Version Valid to: UTC-Date+Time
10	TERMTIME	☐	ICL_TERMINUTC	ICL_TIMESTAMP	DEC	15	0	Valid-To Date Set: UTC Date+Time
11	DELETED	☐	ICL_XDELETE	XFELD	CHAR	1	0	Flag: Deletion Entry?
12	OSYSID	☐	ICL_OSYSID	SYCHAR08	CHAR	8	0	Original System of Version
13	OMANDT	☐	ICL_OMANDT	MANDT	CLNT	3	0	Client in Original System	*
14	SCPOSID_PREV	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
15	.INCLUDE	☐				0	0	FS-CM: External Key Attrib. of Benef/Serv/Fee Ctlg Item
16	SERVCATID	☐	ICL_SERVCATID	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	TICL401
17	SC_VARIANT	☐	ICL_SERVCAT_VARIANT	ICL_SERVCAT_VARIANT	CHAR	4	0	Variant of a Benefits/Services/Fee Catalog	TICL402
18	SCPOSID_EXT	☐	ICL_SERVCAT_POSID	ICL_SERVCAT_POSID	CHAR	20	0	ID of a Benefits Catalog Item
19	SCPOSID_AMNTFROM	☐	ICL_SERVCAT_POSID_AMOUNT_FROM	ICL_AMOUNT	CURR	15	2	Lower Interval Limit of a Benefits Catalog Item
20	SCPOSID_AMNTTO	☐	ICL_SERVCAT_POSID_AMOUNT_TO	ICL_AMOUNT	CURR	15	2	Upper Interval Limit of a Benefits Catalog Item
21	.INCLUDE	☐				0	0	FS-CM: General Attributes of Benef/Service/Fee Catalog Item
22	SCPOS_CURR	☐	ICL_SERVCAT_POS_CURR	WAERS	CUKY	5	0	Currency of Benefits/Services/Fees Catalog	TCURC
23	SCPOS_PARENT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
24	SCPOS_TYPE	☐	ICL_SERVCAT_POS_TYPE	ICL_SERVCAT_POS_TYPE	CHAR	4	0	Type of Benefits Catalog Item	TICL404
25	SCPOS_XSEL	☐	ICL_SERVCAT_POS_SELECTABLE	XFELD	CHAR	1	0	Entry Lock for Benefits Catalog Item
26	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL055
27	BENTYPE_EXP	☐	BRF_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF: Expression	*
28	SCPOS_QUANTITY	☐	ICL_SERVCAT_POS_QUANTITY	ICL_SERVCAT_POS_QUANTITY	QUAN	10	3	Evaluation Quantity of Benefits Catalog Item
29	SCPOS_QUANTITYTO	☐	ICL_SERVCAT_POS_QUANTITY_TO	ICL_SERVCAT_POS_QUANTITY	QUAN	10	3	Evaluation Quantity of Catalog Item (Upper Limit)
30	SCPOS_QUANUNIT	☐	ICL_SERVCAT_POS_QUANUNIT	MEINS	UNIT	3	0	Unit of Benefits Catalog Item	T006
31	SCPOS_VALPERUNIT	☐	ICL_SERVCAT_POS_VALPERUNIT	ICL_SERVCAT_POS_VALPERUNIT	DEC	20	12	Value per Unit of Benefits Catalog Item
32	SCPOS_XREIMBURSE	☐	ICL_SERVCAT_POS_REIMBURSABLE	ICL_SERVCAT_POS_REIMBURSABLE	CHAR	1	0	Reimbursability of a Benefits Catalog Item
33	SCPOS_XAPPROVAL	☐	ICL_SERVCAT_POS_APPROVAL	XFELD	CHAR	1	0	Approval Requirement of a Benef/Serv/Fees Catalog Item
34	.INCLUDE	☐				0	0	Relative Amount
35	RV	☐	ICL_SERVCAT_RV_D_PE		QUAN	10	0	Relative Value
36	RVU	☐	ICL_SERVCAT_RVU_D_PE	MEINS	UNIT	3	0	Unit of Measure of Relative Value	T006
37	.INCLUDE	☐				0	0	Hospital Data
38	AVLENGTH	☐	ICL_SERVCAT_AVLENG_D_PE	ICL_SERVCAT_RESIDENCETIME_D_PE	DEC	5	2	Average Length of Stay in Days
39	DEDUCTION	☐	ICL_SERVCAT_DEDUCTION_D_PE	ICL_SERVCAT_RESIDENCETIME_D_PE	DEC	5	2	First Day of Markdown
40	SURCHARGE	☐	ICL_SERVCAT_SURCHARGE_D_PE	ICL_SERVCAT_RESIDENCETIME_D_PE	DEC	5	2	First Day of Markup
41	LOCALIZATION	☐	ICL_SERVCATAL_LOCAL_D_PE	ICL_SERVCATAL_LOCAL_D_PE	CHAR	1	0	Indicator 'Localization Possible'
42	CATAID	☐	ICL_CATAID_MDC_D_PE	ICL_CATAID	CHAR	4	0	Catalog for Major Diagnostic Categories (MDCs)	TICL350
43	DIAGID	☐	ICL_MDCPOSID_D_PE	ICL_DIAGID	CHAR	10	0	Code of an MDC Item	TICL351

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLSERVCAT	BENTYPE	TICL055	BENTYPE		1	CN
2	ICLSERVCAT	CATAID	TICL350	CATAID	KEY	1	CN
3	ICLSERVCAT	CHANGEDBY	USR02	BNAME		1	CN
4	ICLSERVCAT	CLIENT	T000	MANDT	KEY	1	CN
5	ICLSERVCAT	DIAGID	TICL351	DIAGID	KEY	1	CN
6	ICLSERVCAT	RVU	T006	MSEHI		1	CN
7	ICLSERVCAT	SCPOS_CURR	TCURC	WAERS		1	CN
8	ICLSERVCAT	SCPOS_QUANUNIT	T006	MSEHI		1	CN
9	ICLSERVCAT	SCPOS_TYPE	TICL404	SCPOS_TYPE		1	CN
10	ICLSERVCAT	SC_VARIANT	TICL402	SC_VARIANT
11	ICLSERVCAT	SERVCATID	TICL401	SERVCATID

History

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