SAP ABAP Table ICL_ITEMRE (Extended ICLITEMRE (Damaged Real Estate))

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_ITEMRE	Table Relationship Diagram
Short Description	Extended ICLITEMRE (Damaged Real Estate)

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	Damaged Real Estate
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	DAMAGEDOBJ	☐	ICL_DAMOBJRE	ICL_DAMOBJ	NUMC	4	0	Damaged real estate	ICLDAMOBJ
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 ICLITEMRE
11	RESTATEN	☐	ICL_RESTATEN	TEXT20	CHAR	20	0	Description of Real Estate
12	REMATERIAL	☐	ICL_REMATERIAL	ICL_REMATERIAL	CHAR	2	0	Real Estate Primary Building Material	TICL304
13	ADDRESS	☐	ICL_READDRESS	AD_ADDRNUM	CHAR	10	0	Address (CAM) of Building	ADRC
14	DATEADDR	☐	ICL_ADDRESSCH	DATE	DATS	8	0	Date on which Address Changed (Move)
15	CONSTYEAR	☐	ICL_RESTATE02	BU_YEAR	NUMC	4	0	Construction Year (Year Completed) of Real Estate
16	LOSSTYPE	☐	ICL_ITEMAULT	ICL_ITEMAULT	CHAR	1	0	Scope of Loss	TICL101
17	XVENDOR	☐	ICL_ITEMAU05	XFELD	CHAR	1	0	Flag: Willing to Use Preferred Vendor?
18	RB_FCHANGE	☐	ICL_RB_FCHANGE	BOOLE	CHAR	1	0	Radio button for formal change of insured obj. to dam.obj.
19	RB_NADDR	☐	ICL_RB_NEW	BOOLE	CHAR	1	0	Button: Damaged Object Has New/Other Address to Insd Object
20	XTOTDAMAGE	☐	ICL_ITEMAU11	XFELD	CHAR	1	0	Flag: Total Loss
21	.INCLUDE	☐				0	0	Attributes of ICLITEMRE - Salvage
22	XOWNERRET	☐	ICL_SALVOWNRET	XFELD	CHAR	1	0	Flag: Retained by Owner?
23	EVALDATE	☐	ICL_SALVEVALDT	ICL_SALVEVALDT	DATS	8	0	Evaluation Date for Salvage
24	DETERMDATE	☐	ICL_SALVDETRDT	ICL_SALVDETRDT	DATS	8	0	Date: Damaged Objected Determined as Salvage
25	ESTACV	☐	ICL_SALVESTACV	ICL_RESAMOUNT	CURR	15	2	Salvage: Average Salvage Potential
26	SALVVALUE	☐	ICL_SALVVALUE	ICL_RESAMOUNT	CURR	15	2	Salvage Value as Amount of Money
27	CURR	☐	ICL_ACVCURR	WAERS	CUKY	5	0	Currency of Actual Cash Value	TCURC
28	HISTRATE	☐	ICL_HISTRATEI	ICL_PERCENT	DEC	5	2	History Rate in Percent
29	ASSIGNDATE	☐	ICL_ASSIGNDT	ICL_ASSIGNDT	DATS	8	0	Salvage: Date Assigned to Salvage Company
30	RETRVDATE	☐	ICL_RETRVDT	ICL_RETRVDT	DATS	8	0	Salvage: Arrival Date at Salvage Yard
31	SETTLEDATE	☐	ICL_SETTLEMENTDT	ICL_SETTLEMENTDT	DATS	8	0	Salvage: Settlement Date
32	SOLDDATE	☐	ICL_SALVSOLDD	DATE	DATS	8	0	Date Salvage Item Sold
33	TITLERECV	☐	ICL_TITLTOINS	ICL_TITLTOINS	DATS	8	0	Date on Which Insurer Received Title
34	NOTE	☐	ICL_SALVAGE_NOTE	TEXT50	CHAR	50	0	Note on Salvage
35	SEL_LOCATION	☐	ICL_INSPLOC	ICL_INSPLOC	CHAR	1	0	Location of Damaged Object
36	XSETINGM	☐	ICLITEM01	CHAR01	CHAR	1	0	Flag: Place Value of Object in Global Memory

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_ITEMRE	ADDRESS	ADRC	ADDRNUMBER
2	ICL_ITEMRE	CHANGEDBY	USR02	BNAME
3	ICL_ITEMRE	CLAIM	ICLCLAIM	CLAIM
4	ICL_ITEMRE	CLIENT	T000	MANDT
5	ICL_ITEMRE	CURR	TCURC	WAERS
6	ICL_ITEMRE	DAMAGEDOBJ	ICLDAMOBJ	DAMAGEDOBJ
7	ICL_ITEMRE	LOSSTYPE	TICL101	LOSSTYPE	KEY	1	CN
8	ICL_ITEMRE	REMATERIAL	TICL304	REMATERIAL

History

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