SAP ABAP Table ICL_BW_SUBCLAIM (Extract Structure for Subclaim Data)

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_SUBCLAIM	Table Relationship Diagram
Short Description	Extract Structure for Subclaim Data

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	Subclaim
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	*
6	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
7	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
8	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
9	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
10	.INCLUDE	☐				0	0	Attributes of ICLSUBCL
11	.INCLUDE	☐				0	0	Organizational Include (Short Version)
12	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
13	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
14	STATUS	☐	ICL_SUBCL10	ICL_STATUS	CHAR	2	0	Status of Subclaim	TICL140
15	STATUSCHG	☐	ICL_STATUSCHG	ICL_TIMESTAMP	DEC	15	0	Time of Last Status Change
16	STHANDLER	☐	ICL_STHANDLER	XFELD	CHAR	1	0	"Claim Handling" Process Active
17	STNOCLAIM	☐	ICL_STNOCLAIM	XFELD	CHAR	1	0	No Claim Made
18	STCLOSED	☐	ICL_STCLOSED	XFELD	CHAR	1	0	"Close (Sub)Claim" Process Executed
19	STINVALID	☐	ICL_STINVALID	XFELD	CHAR	1	0	Subclaim Invalid
20	STREJECT	☐	ICL_STREJECT	XFELD	CHAR	1	0	Claim/Subclaim Rejected
21	STATREASON	☐	ICL_FORMSET	ICL_FORMSET	CHAR	2	0	Reason for Changing the Status	TICL047
22	XCOMPLETE	☐	ICL_SUBCL08	XFELD	CHAR	1	0	Flag: Claim Item List (Presumably) Complete
23	SUBCLTYPE	☐	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	TICL004
24	XSALVAGE	☐	ICL_SUBCL01	ICL_SUBCL01	CHAR	1	0	Flag: Salvage?
25	XOTHERINSURE	☐	ICL_SUBCL02	XFELD	CHAR	1	0	Flag: Other Insurance?
26	XSUBRO	☐	ICL_SUBCL03	ICL_SUBCL03	CHAR	1	0	Subrogation/Recovery Status
27	SUBRO_POTENTIAL	☐	ICL_SUBRO_POTENTIAL_D	ICL_SUBRO_POTENTIAL	CHAR	1	0	Subrogation/Recovery Potential of a Subclaim (Check Status)
28	XLITIGATION	☐	ICL_SUBCL04	XFELD	CHAR	1	0	Flag: Litigation?
29	XNEGOTIATION	☐	ICL_SUBCL05	XFELD	CHAR	1	0	Flag: Negotiation?
30	XFRAUD	☐	ICL_SUBCL06	XFELD	CHAR	1	0	Flag: Potential Fraud?
31	COVERAGE	☐	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	ICLPOLM
32	COVPOLVNR	☐	ICL_POLMVNR	ICL_POLVCNTR	NUMC	2	0	Version Number of Coverage Contract	ICLPOLM
33	XCOVCONFIRMED	☐	ICL_COVERED	ICL_COVERED	CHAR	1	0	Indication of Compensability
34	ASSIGN_STATE	☐	ICL_ASSIGN_STATE	ICL_ASSIGN_STATE	CHAR	2	0	Assignment Status of a Claim Subobject
35	HANDLERTYPE	☐	ICL_HANDLERTYPE	OTYPE	CHAR	2	0	Object Category of Subclaim Handler	T778O
36	CLAIMHANDLER	☐	ICL_SUBCLCH	XUBNAME	CHAR	12	0	Claim Handler for Subclaim	USR02
37	HANDLERTYPE_GRP	☐	ICL_HANDLERTYPE2	OTYPE	CHAR	2	0	Object Category of Subclaim Handler Group	*
38	CLAIMHANDLER_GRP	☐	ICL_SUBCLCH2	XUBNAME	CHAR	12	0	Claim Handler Group for Subclaims	*
39	COMPLEX	☐	ICL_COMPLEX	ICL_COMPLEX	CHAR	1	0	Complexity of Claim/Subclaim	TICL027
40	SUBCLAIMDESC	☐	ICL_SUBCLDESCRIP	TEXT20	CHAR	20	0	Name of Claim/Subclaim
41	BENTREE	☐	ICL_BENTREE	ICL_BENTREE	CHAR	8	0	Benefit Type Tree	*
42	BENTREEG	☐	ICL_BENTREEG	ICL_BENTREEG	NUMC	5	0	Generation of Benefit Type Tree	*
43	BENTREEV	☐	ICL_BENTREEV	ICL_BENTREEV	NUMC	5	0	Version of Benefit Type Tree	*
44	WF_EXEC_TIME	☐	ICL_WF_EXECUTION_TIME	ICL_TIMESTAMP	DEC	15	0	Execution Time Workflow
45	WF_STATUS	☐	ICL_WF_STATUS	ICL_WF_STATUS	NUMC	1	0	Workflow Status
46	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
47	MAX_ITEMNR	☐	ICL_SCLITEM_NR_MAX	ICL_SCLITEM	CHAR	4	0	Current Highest Claim Item Number	*
48	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	TICL011
49	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
50	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*
51	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
52	CLAIMANT	☐	ICL_CLAIMANT	BU_PARTNER	CHAR	10	0	Claimant	*
53	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_SUBCLAIM	CHANGEDBY	USR02	BNAME
2	ICL_BW_SUBCLAIM	CLAIM	ICLCLAIM	CLAIM
3	ICL_BW_SUBCLAIM	CLAIMHANDLER	USR02	BNAME
4	ICL_BW_SUBCLAIM	CLAIMTYPE	TICL011	CLTYPE
5	ICL_BW_SUBCLAIM	CLIENT	T000	MANDT
6	ICL_BW_SUBCLAIM	COMPLEX	TICL027	COMPLEX
7	ICL_BW_SUBCLAIM	COVERAGE	ICLPOLM	COVERAGE
8	ICL_BW_SUBCLAIM	COVPOLVNR	ICLPOLM	POLVNR
9	ICL_BW_SUBCLAIM	CREATEDBY	USR02	BNAME
10	ICL_BW_SUBCLAIM	HANDLERTYPE	T778O	OTYPE	REF	C	CN
11	ICL_BW_SUBCLAIM	STATREASON	TICL047	FORMOFSET
12	ICL_BW_SUBCLAIM	STATUS	TICL140	STATUS
13	ICL_BW_SUBCLAIM	SUBCLTYPE	TICL004	SUBCLTYPE

History

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