SAP ABAP Table ICL_BW_REFERRAL (Extract Structure for Coverage Referrals)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_BW_REFERRAL	Table Relationship Diagram
Short Description	Extract Structure for Coverage Referrals

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	Coverage Referral in Claim
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
4	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
5	SUBCLAIM	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	ICLSUBCL
6	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	ICLITEM
7	REFNO	☐	ICL_REFNO	ICL_REFNO	NUMC	3	0	Coverage Referral Number	*
8	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
9	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
10	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
11	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
12	.INCLUDE	☐				0	0	Attributes of ICLREF
13	REFERRAL	☐	ICL_REFERRAL	ICL_REFERRAL	CHAR	4	0	Coverage Referral	TICL079
14	TEXT	☐	ICL_REFT	ICL_TEXT	CHAR	70	0	Name of Coverage Referral
15	XMANUAL	☐	ICL_REFNO01	XFELD	CHAR	1	0	Flag: Coverage referral set manually?
16	SUBOBJCAT	☐	ICL_RSUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Object Category of Triggering Sub-Óbject	TICL013
17	SUBOBJECT	☐	ICL_RSUBOBJECT	ICL_SUBOBJECT	CHAR	16	0	Triggering Sub-Object
18	REJREAS	☐	ICL_REJREAS	ICL_REJREAS	CHAR	2	0	Reason for Overruling Coverage Referral	TICL080
19	REJCOM	☐	ICL_REJREASC	TEXT50	CHAR	50	0	Reason for Overruling Coverage Referral
20	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	TICL011
21	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
22	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*
23	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
24	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	464