SAP ABAP View V_ICLSERVCAT (FS-CM: DB Read View for 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

View Type	D	Database View
Database View	V_ICLSERVCAT
Short Description	FS-CM: DB Read View for Benefits/Services/Fees Catalogs
Root table	ICLSERVCAT	FS-CM: Benefits/Services/Fees Catalogs

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ICLSERVCAT	ICLSERVCAT
2	ICLSERVCATT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ICLSERVCAT	CLIENT	JL	EQ				0	0
2	ICLSERVCATT	CLIENT	JR	EQ			AND	0	0
3	ICLSERVCAT	SCPOSID_INT	JL	EQ				0	0
4	ICLSERVCATT	SCPOSID_INT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ICLSERVCAT	CLIENT		☐	MANDT	☐	Client
2	SCPOSID_INT	ICLSERVCAT	SCPOSID_INT		☐	ICL_SERVCAT_POSID_INT	☐	Internal ID of Benefits Catalog Item
3	ACTIVE	ICLSERVCAT	ACTIVE		☐	ICL_ACTIVE2	☐	Status
4	CHANGEDBY	ICLSERVCAT	CHANGEDBY		☐	ICL_CHANGEBY	☐	Version Created By (= Object Changed By)
5	CHANGETIME	ICLSERVCAT	CHANGETIME		☐	ICL_CHANGEUTC	☐	Version Created: UTC Date+Time
6	INACTIVETIME	ICLSERVCAT	INACTIVETIME		☐	ICL_INACTIUTC	☐	Version Deactivated: UTC Date+Time
7	EFFFROMTIME	ICLSERVCAT	EFFFROMTIME		☐	ICL_EFFROMUTC	☐	Version Valid From: UTC Date+Time
8	EFFTOTIME	ICLSERVCAT	EFFTOTIME		☐	ICL_EFFETOUTC	☐	Version Valid to: UTC-Date+Time
9	TERMTIME	ICLSERVCAT	TERMTIME		☐	ICL_TERMINUTC	☐	Valid-To Date Set: UTC Date+Time
10	DELETED	ICLSERVCAT	DELETED		☐	ICL_XDELETE	☐	Flag: Deletion Entry?
11	OSYSID	ICLSERVCAT	OSYSID		☐	ICL_OSYSID	☐	Original System of Version
12	OMANDT	ICLSERVCAT	OMANDT		☐	ICL_OMANDT	☐	Client in Original System
13	SCPOSID_PREV	ICLSERVCAT	SCPOSID_PREV		☐	ICL_SERVCAT_POSID_INT	☐	Internal ID of Benefits Catalog Item
14	SERVCATID	ICLSERVCAT	SERVCATID		☐	ICL_SERVCATID	☐	ID of a Benefits, Services and Fees Catalog
15	SCPOSID_EXT	ICLSERVCAT	SCPOSID_EXT		☐	ICL_SERVCAT_POSID	☐	ID of a Benefits Catalog Item
16	SCPOSID_AMNTFROM	ICLSERVCAT	SCPOSID_AMNTFROM		☐	ICL_SERVCAT_POSID_AMOUNT_FROM	☐	Lower Interval Limit of a Benefits Catalog Item
17	SCPOSID_AMNTTO	ICLSERVCAT	SCPOSID_AMNTTO		☐	ICL_SERVCAT_POSID_AMOUNT_TO	☐	Upper Interval Limit of a Benefits Catalog Item
18	SCPOS_CURR	ICLSERVCAT	SCPOS_CURR		☐	ICL_SERVCAT_POS_CURR	☐	Currency of Benefits/Services/Fees Catalog
19	SCPOS_PARENT	ICLSERVCAT	SCPOS_PARENT		☐	ICL_SERVCAT_POSID_INT	☐	Internal ID of Benefits Catalog Item
20	SCPOS_TYPE	ICLSERVCAT	SCPOS_TYPE		☐	ICL_SERVCAT_POS_TYPE	☐	Type of Benefits Catalog Item
21	SCPOS_XSEL	ICLSERVCAT	SCPOS_XSEL		☐	ICL_SERVCAT_POS_SELECTABLE	☐	Entry Lock for Benefits Catalog Item
22	BENTYPE	ICLSERVCAT	BENTYPE		☐	ICL_BENTYPE	☐	Benefit Type
23	BENTYPE_EXP	ICLSERVCAT	BENTYPE_EXP		☐	BRF_EXPRESSION	☐	BRF: Expression
24	SCPOS_XREIMBURSE	ICLSERVCAT	SCPOS_XREIMBURSE		☐	ICL_SERVCAT_POS_REIMBURSABLE	☐	Reimbursability of a Benefits Catalog Item
25	SCPOS_XAPPROVAL	ICLSERVCAT	SCPOS_XAPPROVAL		☐	ICL_SERVCAT_POS_APPROVAL	☐	Approval Requirement of a Benef/Serv/Fees Catalog Item
26	LANGU	ICLSERVCATT	LANGU		☐	LANGU	☐	Language Key
27	SCPOSN	ICLSERVCATT	SCPOSN		☐	ICL_SERVCAT_POS_SHORTNAME	☐	Short Text of a Benefits Catalog Item
28	SCPOSLN	ICLSERVCATT	SCPOSLN		☐	ICL_SERVCAT_POS_NAME	☐	Long Text of Benefits Catalog Item
29	SEASCPOSN	ICLSERVCATT	SEASCPOSN		☐	ICL_SERVCAT_POS_SEASHORTNAME	☐	Short Text for Search of a Benefits Catalog Item
30	SEASCPOSLN	ICLSERVCATT	SEASCPOSLN		☐	ICL_SERVCAT_POS_SEANAME	☐	Long Text for Search for Benefits Catalog Item
31	SCPOS_QUANTITY	ICLSERVCAT	SCPOS_QUANTITY		☐	ICL_SERVCAT_POS_QUANTITY	☐	Evaluation Quantity of Benefits Catalog Item
32	SCPOS_QUANUNIT	ICLSERVCAT	SCPOS_QUANUNIT		☐	ICL_SERVCAT_POS_QUANUNIT	☐	Unit of Benefits Catalog Item
33	SC_VARIANT	ICLSERVCAT	SC_VARIANT		☐	ICL_SERVCAT_VARIANT	☐	Variant of a Benefits/Services/Fee Catalog
34	SCPOS_VALPERUNIT	ICLSERVCAT	SCPOS_VALPERUNIT		☐	ICL_SERVCAT_POS_VALPERUNIT	☐	Value per Unit of Benefits Catalog Item

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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