SAP ABAP Table ICL_REF_DET (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	INTTAB	Structure
Structure	ICL_REF_DET	Table Relationship Diagram
Short Description	Coverage Referral in Claim

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	Fields for Displaying Coverage Referrals
2	DETAIL_SELECT	☐	ICL_DETAIL_SELECT		CHAR	50	0	Details
3	.INCLUDE	☐				0	0	Coverage Referral in Claim
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
6	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
7	SUBCLAIM	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	ICLSUBCL
8	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	ICLITEM
9	REFNO	☐	ICL_REFNO	ICL_REFNO	NUMC	3	0	Coverage Referral Number	*
10	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
11	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
12	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
13	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
14	.INCLUDE	☐				0	0	Attributes of ICLREF
15	REFERRAL	☐	ICL_REFERRAL	ICL_REFERRAL	CHAR	4	0	Coverage Referral	TICL079
16	TEXT	☐	ICL_REFT	ICL_TEXT	CHAR	70	0	Name of Coverage Referral
17	XMANUAL	☐	ICL_REFNO01	XFELD	CHAR	1	0	Flag: Coverage referral set manually?
18	SUBOBJCAT	☐	ICL_RSUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Object Category of Triggering Sub-Óbject	TICL013
19	SUBOBJECT	☐	ICL_RSUBOBJECT	ICL_SUBOBJECT	CHAR	16	0	Triggering Sub-Object
20	REJREAS	☐	ICL_REJREAS	ICL_REJREAS	CHAR	2	0	Reason for Overruling Coverage Referral	TICL080
21	REJCOM	☐	ICL_REJREASC	TEXT50	CHAR	50	0	Reason for Overruling Coverage Referral
22	REFERRALN	☐	ICL_REFERRALN	TEXT60	CHAR	60	0	Name for coverage referral
23	REJREASN	☐	ICL_REJREASN	TEXT60	CHAR	60	0	Name for Coverage Referral Overruling Reason
24	LIGHT	☐	ICL_REFLSTATUS	ICL_REFLSTATUS	CHAR	1	0	Status of a Coverage Referral
25	STATUS	☐	ICL_REFLSTAT_ICON	ICON_L2	CHAR	4	0	Status of a Coverage Referral as an Icon
26	STATUSN	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
27	SUBCLDESCRIP	☐	ICL_SUBCLDESCRIP	TEXT20	CHAR	20	0	Name of Claim/Subclaim
28	SUBOBJCATN	☐	ICL_SUBOBJCATN	TEXT25	CHAR	25	0	Name of Claim Subobject Category
29	COLOR	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_REF_DET	CHANGEDBY	USR02	BNAME
2	ICL_REF_DET	CLAIM	ICLCLAIM	CLAIM
3	ICL_REF_DET	CLIENT	T000	MANDT
4	ICL_REF_DET	ITEM	ICLITEM	ITEM
5	ICL_REF_DET	REFERRAL	TICL079	REFERRAL
6	ICL_REF_DET	REJREAS	TICL080	REJREAS
7	ICL_REF_DET	SUBCLAIM	ICLSUBCL	SUBCLAIM
8	ICL_REF_DET	SUBOBJCAT	TICL013	SUBOBJCAT

History

Last changed by/on	SAP	20130529
SAP Release Created in