SAP ABAP Table ICSPOLOWA (Insured Watercraft)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_POLICY (Package) Policy Snapshot and Interface to Policy

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSPOLOWA	Table Relationship Diagram
Short Description	Insured Watercraft

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_CLAIM1	ICL_CLAIM	CHAR	17	0	Policy Snapshot for Claim	ICLPOL
4	POLVNR	☑	ICL_POLVCNTR	ICL_POLVCNTR	NUMC	2	0	Counter of Contract Version	ICLPOL
5	INSUREDOBJ	☑	ICL_IWACRAFT	ICL_INSOBJ	NUMC	4	0	Insured watercraft	ICLPOLO
6	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
7	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
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 ICLPOLOWA
11	NAME	☐	ICL_WACRAFT12	TEXT20	CHAR	20	0	Name of Boat
12	MFRHULLNO	☐	ICL_WACRAFT14	TEXT10	CHAR	10	0	Hull manufacturer number
13	HULLMATERIAL	☐	ICL_WATHULL	ICL_WATHULL	CHAR	2	0	Watercraft hull material	TICL305
14	WATCRAMAKE	☐	ICL_WACRAFT03	ICL_IOBMA	CHAR	4	0	Make of watercraft	ICLPROPMA
15	WATCRAMODEL	☐	ICL_WACRAFT01	ICL_IOBMODEL	CHAR	4	0	Model of watercraft	ICLPROPMO
16	WATCRANO	☐	ICL_WACRAFT13	TEXT10	CHAR	10	0	Watercraft serial number
17	CONSTYEAR	☐	ICL_WACRAFT10	BU_YEAR	NUMC	4	0	Year of construction of watercraft
18	LENGTHUNIT	☐	ICL_WACRAFT06	MEINS	UNIT	3	0	Unit for length, width, and depth of watercraft	T006
19	LENGTH	☐	ICL_WACRAFT07	ICL_WACRAFT07	QUAN	6	0	Length of watercraft
20	WIDTH	☐	ICL_WACRAFT08	ICL_WACRAFT07	QUAN	6	0	Width of watercraft
21	DEPTH	☐	ICL_WACRAFT09	ICL_WACRAFT07	QUAN	6	0	Depth of watercraft
22	ENGINEMAKE	☐	ICL_WACRAFT04	ICL_IOBMA	CHAR	4	0	Make of engine	ICLPROPMA
23	ENGINEMODEL	☐	ICL_WACRAFT02	ICL_IOBMODEL	CHAR	4	0	Model of engine	ICLPROPMO
24	ENGINEYEAR	☐	ICL_WACRAFT11	BU_YEAR	NUMC	4	0	Year of construction of engine
25	POWERUNIT	☐	ICL_WACRAFT05	MEINS	UNIT	3	0	Unit for power of engine	T006
26	POWER	☐	ICL_WACRAFT15	ICL_WACRAFT15	QUAN	6	0	Power of Engine

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSPOLOWA	CHANGEDBY	USR02	BNAME
2	ICSPOLOWA	CLAIM	ICLPOL	CLAIM
3	ICSPOLOWA	CLIENT	T000	MANDT
4	ICSPOLOWA	ENGINEMAKE	ICLPROPMA	PROPMAKE
5	ICSPOLOWA	ENGINEMODEL	ICLPROPMO	PROPMODEL
6	ICSPOLOWA	HULLMATERIAL	TICL305	HULLMATERIAL
7	ICSPOLOWA	INSUREDOBJ	ICLPOLO	INSUREDOBJ
8	ICSPOLOWA	LENGTHUNIT	T006	MSEHI
9	ICSPOLOWA	POLVNR	ICLPOL	POLVNR
10	ICSPOLOWA	POWERUNIT	T006	MSEHI
11	ICSPOLOWA	WATCRAMAKE	ICLPROPMA	PROPMAKE
12	ICSPOLOWA	WATCRAMODEL	ICLPROPMO	PROPMODEL

History

Last changed by/on	SAP	20110901
SAP Release Created in