SAP ABAP Table ICSREF (Coverage Referral in Claim)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_CDC (Package) FS-CM: Data Capture

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSREF	Table Relationship Diagram
Short Description	Coverage Referral in Claim

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	ACTIVE	☑	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
3	CLAIM	☑	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
4	SUBCLAIM	☑	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	*
5	ITEM	☑	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
6	REFNO	☑	ICL_REFNO	ICL_REFNO	NUMC	3	0	Coverage Referral Number	*
7	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
8	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
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 ICLREF
12	REFERRAL	☐	ICL_REFERRAL	ICL_REFERRAL	CHAR	4	0	Coverage Referral	TICL079
13	TEXT	☐	ICL_REFT	ICL_TEXT	CHAR	70	0	Name of Coverage Referral
14	XMANUAL	☐	ICL_REFNO01	XFELD	CHAR	1	0	Flag: Coverage referral set manually?
15	SUBOBJCAT	☐	ICL_RSUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Object Category of Triggering Sub-Óbject	TICL013
16	SUBOBJECT	☐	ICL_RSUBOBJECT	ICL_SUBOBJECT	CHAR	16	0	Triggering Sub-Object
17	REJREAS	☐	ICL_REJREAS	ICL_REJREAS	CHAR	2	0	Reason for Overruling Coverage Referral	TICL080
18	REJCOM	☐	ICL_REJREASC	TEXT50	CHAR	50	0	Reason for Overruling Coverage Referral

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSREF	CHANGEDBY	USR02	BNAME
2	ICSREF	CLAIM	ICLCLAIM	CLAIM
3	ICSREF	CLIENT	T000	MANDT
4	ICSREF	REFERRAL	TICL079	REFERRAL
5	ICSREF	REJREAS	TICL080	REJREAS
6	ICSREF	SUBOBJCAT	TICL013	SUBOBJCAT

History

Last changed by/on	SAP	20130529
SAP Release Created in