SAP ABAP Table ICSITEMRE (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	TRANSP	Transparent table
Transparent table	ICSITEMRE	Table Relationship Diagram
Short Description	Damaged Real Estate

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ACTIVE	☑	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
3	CLAIM	☑	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
4	DAMAGEDOBJ	☑	ICL_DAMOBJRE	ICL_DAMOBJ	NUMC	4	0	Damaged real estate	ICLDAMOBJ
5	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
6	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
7	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
8	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
9	.INCLUDE	☐				0	0	Attributes of ICLITEMRE
10	RESTATEN	☐	ICL_RESTATEN	TEXT20	CHAR	20	0	Description of Real Estate
11	REMATERIAL	☐	ICL_REMATERIAL	ICL_REMATERIAL	CHAR	2	0	Real Estate Primary Building Material	TICL304
12	ADDRESS	☐	ICL_READDRESS	AD_ADDRNUM	CHAR	10	0	Address (CAM) of Building	ADRC
13	DATEADDR	☐	ICL_ADDRESSCH	DATE	DATS	8	0	Date on which Address Changed (Move)
14	CONSTYEAR	☐	ICL_RESTATE02	BU_YEAR	NUMC	4	0	Construction Year (Year Completed) of Real Estate
15	LOSSTYPE	☐	ICL_ITEMAULT	ICL_ITEMAULT	CHAR	1	0	Scope of Loss	TICL101
16	XVENDOR	☐	ICL_ITEMAU05	XFELD	CHAR	1	0	Flag: Willing to Use Preferred Vendor?
17	RB_FCHANGE	☐	ICL_RB_FCHANGE	BOOLE	CHAR	1	0	Radio button for formal change of insured obj. to dam.obj.
18	RB_NADDR	☐	ICL_RB_NEW	BOOLE	CHAR	1	0	Button: Damaged Object Has New/Other Address to Insd Object
19	XTOTDAMAGE	☐	ICL_ITEMAU11	XFELD	CHAR	1	0	Flag: Total Loss
20	.INCLUDE	☐				0	0	Attributes of ICLITEMRE - Salvage
21	XOWNERRET	☐	ICL_SALVOWNRET	XFELD	CHAR	1	0	Flag: Retained by Owner?
22	EVALDATE	☐	ICL_SALVEVALDT	ICL_SALVEVALDT	DATS	8	0	Evaluation Date for Salvage
23	DETERMDATE	☐	ICL_SALVDETRDT	ICL_SALVDETRDT	DATS	8	0	Date: Damaged Objected Determined as Salvage
24	ESTACV	☐	ICL_SALVESTACV	ICL_RESAMOUNT	CURR	15	2	Salvage: Average Salvage Potential
25	SALVVALUE	☐	ICL_SALVVALUE	ICL_RESAMOUNT	CURR	15	2	Salvage Value as Amount of Money
26	CURR	☐	ICL_ACVCURR	WAERS	CUKY	5	0	Currency of Actual Cash Value	TCURC
27	HISTRATE	☐	ICL_HISTRATEI	ICL_PERCENT	DEC	5	2	History Rate in Percent
28	ASSIGNDATE	☐	ICL_ASSIGNDT	ICL_ASSIGNDT	DATS	8	0	Salvage: Date Assigned to Salvage Company
29	RETRVDATE	☐	ICL_RETRVDT	ICL_RETRVDT	DATS	8	0	Salvage: Arrival Date at Salvage Yard
30	SETTLEDATE	☐	ICL_SETTLEMENTDT	ICL_SETTLEMENTDT	DATS	8	0	Salvage: Settlement Date
31	SOLDDATE	☐	ICL_SALVSOLDD	DATE	DATS	8	0	Date Salvage Item Sold
32	TITLERECV	☐	ICL_TITLTOINS	ICL_TITLTOINS	DATS	8	0	Date on Which Insurer Received Title
33	NOTE	☐	ICL_SALVAGE_NOTE	TEXT50	CHAR	50	0	Note on Salvage
34	SEL_LOCATION	☐	ICL_INSPLOC	ICL_INSPLOC	CHAR	1	0	Location of Damaged Object

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in