SAP ABAP Table ICLSC_SEARCH_SCR (Benefits Catalog Search: Line Structure for Search API)

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	ICLSC_SEARCH_SCR	Table Relationship Diagram
Short Description	Benefits Catalog Search: Line Structure for Search API

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

Foreign Keys

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

History

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