SAP ABAP Table ICL_PROCEDURES_S_AL (Data on Procedures (incl. Benefits Catalog Data and Texts))

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_PROCEDURES_S_AL	Table Relationship Diagram
Short Description	Data on Procedures (incl. Benefits Catalog Data and Texts)

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	Data on Procedures
2	.INCLUDE	☐				0	0	Procedures
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
5	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
6	PROCEDURE_GUID	☐	ICL_PROCEDUREGUID	SYSUUID_C	CHAR	32	0	Universal Unique Identifier of a Procedure
7	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
8	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
9	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
10	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
11	.INCLUDE	☐				0	0	Attributes of ICLPROCEDURES
12	.INCLUDE	☐				0	0	FS-CM: Benefits/Services/Fees Catalogs in ICLITEM
13	SCPOSID_INT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
14	SERVCAT	☐	ICL_SERVCATID_PROCEDURES	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	*
15	SCPOSID_EXT	☐	ICL_SERVCAT_POSID	ICL_SERVCAT_POSID	CHAR	20	0	ID of a Benefits Catalog Item
16	PROCEDURE_NO	☐	ICL_PROCEDURENO		NUMC	3	0	Sequence Number of a Procedure
17	PATIENT	☐	ICLH_PROCED_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of Person Treated	*
18	PRIMPROCED	☐	ICL_PRIMPROCEDURE	ICL_PRIMPROCEDURE_D_PE	CHAR	1	0	Primary Procedure
19	PROCEDTIME	☐	ICL_PROCEDURE_TIME	ICL_TIMESTAMP	DEC	15	0	Time Performed
20	LOCALIZATION	☐	ICL_LOCALIZATION	ICL_LOCALIZATION	CHAR	1	0	Side Localization of a Diagnosis	TICL352
21	DEPARTMENT	☐	ICL_DEPARTMENT	ICL_DEPARTMENT	CHAR	4	0	Department (Key)	*
22	USED4CALC	☐	ICL_USED4CALC		CHAR	1	0	Used for Grouping

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_PROCEDURES_S_AL	CHANGEDBY	USR02	BNAME
2	ICL_PROCEDURES_S_AL	CLIENT	T000	MANDT
3	ICL_PROCEDURES_S_AL	LOCALIZATION	TICL352	LOCALIZATION

History

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