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
⤷ 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 |