SAP ABAP Table ICL_DELTA_RES (Delta for Additional Fields Extract Structure ICL_BW_RESERVE)

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_DELTA_RES	Table Relationship Diagram
Short Description	Delta for Additional Fields Extract Structure ICL_BW_RESERVE

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	Single case reserve for subclaim
2	.INCLUDE	☐				0	0	Case Reserve
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
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	SUBCL	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	*
7	RESTYPE	☐	ICL_RESTYPE	ICL_RESTYPE	CHAR	2	0	Reserve Type	*
8	CURR	☐	ICL_RESCURR	WAERS	CUKY	5	0	Currency of Reserve (Transactn Crcy)	*
9	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
10	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
11	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
12	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
13	.INCLUDE	☐				0	0	Attributes of ICLRESERVE
14	GROSSRES	☐	ICL_RESERVEAM	ICL_ITAMTS	CURR	15	2	Expenditure per Reserve Type
15	METHOD	☐	ICL_RESMETHOD	ICL_RESMETHOD	CHAR	1	0	Reserving Method
16	XAPPROVED	☐	ICL_RESERVE06	XFELD	CHAR	1	0	Reserving/Reserve Change Approved?
17	APPROVEDBY	☐	ICL_RESERVEAB	XUBNAME	CHAR	12	0	Approved By	USR02
18	APPROVEDTIME	☐	ICL_RESERVE07	ICL_TIMESTAMP	DEC	15	0	Time Approved (UTC Time Stamp)
19	CHANGEREASON	☐	ICL_RESCHREASON	ICL_RESCHREASON	CHAR	2	0	Reserve Change Reason	TICL030
20	POSTDATE	☐	ICL_POSTDATE	DATE	DATS	8	0	Posting Date
21	RSAMTPERUNIT	☐	ICL_RSAMTPERUNIT	ICL_ITAMTPRO	CURR	8	2	Amount per Unit (Individual Price)
22	RSQUANTITY	☐	ICL_RSQUANTITY	ICL_LIMAMT	QUAN	10	3	Reserve: Number (Days, Persons, Cases) for Qty Evaluation
23	RSQUANUNIT	☐	ICL_RSQUANUNIT	MEINS	UNIT	3	0	Unit of Single Items for this Reserve	T006
24	RSPENDING	☐	ICL_RSPENDING	ICL_ITAMTS	CURR	15	2	Pending Reserve
25	RSREASON_REJ	☐	ICL_REASONREJ	ICL_REASONREJ	CHAR	2	0	Rejection Reasons for Payments and Reserves	TICL112
26	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
27	RESTYPE_MI	☐	ICL_RESTYPE	ICL_RESTYPE	CHAR	2	0	Reserve Type	*
28	.INCLUDE	☐				0	0	Reserves - GUI Fields Only (Derived from DB)
29	SUBCLTYPE	☐	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	*
30	SUBCLTYPE_NAME	☐	ICL_SUBCLTYPEN	TEXT25	CHAR	25	0	Subclaim Type Name
31	SUBCLTYPEDESC	☐	ICL_SUBCLDESCRIP	TEXT20	CHAR	20	0	Name of Claim/Subclaim
32	COVERAGE	☐	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	*
33	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	*
34	COVTYPE_NAME	☐	ICL_COVTYPEN	TEXT50	CHAR	50	0	Name of Coverage Type
35	BPARTNER	☐	ICL_CLAIMANT	BU_PARTNER	CHAR	10	0	Claimant	*
36	DESCRIP	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
37	RESTYPE_NAME	☐	ICL_RESTYPEN	TEXT20	CHAR	20	0	Reserve Type Name
38	RESCAT_NAME	☐	ICL_RESCATN	TEXT25	CHAR	25	0	Reserving Category Name
39	LOSSEXP_NAME	☐	ICL_LOSSEXPN	DDTEXT	CHAR	60	0	Flag: Loss/expenses description
40	CHANGEREASON_NAME	☐	ICL_RESCHREASONN	TEXT25	CHAR	25	0	Name of Claim Reserve Change Reason
41	METHOD_NAME	☐	ICL_RESMETHODN	DDTEXT	CHAR	60	0	Name of reserving method
42	XRECOVERY	☐	ICL_XRECOVERY	ICL_XRECOVERY	CHAR	1	0	Expectation Reserve
43	XINVISIBLE	☐	ICL_RESTYPE6	XFELD	CHAR	1	0	Flag: Reserve Not Visible to Clerk
44	CHANGEDATET	☐	ICL_RESERVE01	DATE	DATS	8	0	Change Date
45	CHANGETIMET	☐	ICL_RESERVE02	TIME	TIMS	6	0	Changed At
46	APPROVEDDATET	☐	ICL_RESERVE04	DATE	DATS	8	0	Approved On
47	APPROVEDTIMET	☐	ICL_RESERVE05	TIME	TIMS	6	0	Time Approved
48	RSQUANUNITN	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
49	XMULT_INS	☐	ICL_XMULT_INS_D	XFELD	CHAR	1	0	Reserve for Multiple Insurance
50	XOWN_GL	☐	ICL_MI_X_OWN_GL_RES		CHAR	1	0	Reserve Share to G/L
51	SEL	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
52	PAMPAID	☐	ICL_SCLITEMAP	ICL_ITAMTS	CURR	15	2	Payment Amount
53	NETRES	☐	ICL_RESERVENE	ICL_ITAMTS	CURR	15	2	Reserve (Remaining Reserve)
54	OLD_GROSSRES	☐	ICL_RESERVEAM	ICL_ITAMTS	CURR	15	2	Expenditure per Reserve Type
55	OLD_NETRES	☐	ICL_RESERVENE	ICL_ITAMTS	CURR	15	2	Reserve (Remaining Reserve)
56	AUTH_MODE	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
57	AUTH_DECISION	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
58	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
59	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*
60	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
61	ORGUNIT	☐	ICL_ORGUNIT	HR_SOBJID	NUMC	8	0	Organizational Unit	*
62	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_DELTA_RES	APPROVEDBY	USR02	BNAME
2	ICL_DELTA_RES	CHANGEDBY	USR02	BNAME
3	ICL_DELTA_RES	CHANGEREASON	TICL030	RESCHREASON
4	ICL_DELTA_RES	RSQUANUNIT	T006	MSEHI		1	CN
5	ICL_DELTA_RES	RSREASON_REJ	TICL112	REASONREJ	REF	1	CN

History

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