SAP ABAP Table ICL_NEG (Negotiation)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_NEGOTIATION_PE (Package) Claims: Negotiation: Persistency Layer

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICL_NEG	Table Relationship Diagram
Short Description	Negotiation

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	NEGID	☑	ICL_NEGID_D_PE	SYSUUID_C	CHAR	32	0	Negotiation ID
5	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
6	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
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 for Negotiation
10	SUBOBJECT	☐	ICL_SUBOBJECT	ICL_SUBOBJECT	CHAR	16	0	Claim Subobject
11	NEGTYPE	☐	ICL_NEGTYPE_D_PE	ICL_NEGTYPE_PE	CHAR	1	0	Key of Negotiation Type	*
12	NEGDESCR	☐	ICL_NEGDESCR_D_PE	TEXT60	CHAR	60	0	Description of Negotiation
13	NEGNAME	☐	ICL_NEGNAME_D_PE	ICL_NEGNAME_PE	CHAR	10	0	Unique Technical Name of Negotiation
14	RANGEFR	☐	ICL_RANGEFR_D_PE	ICL_ITAMTS	CURR	15	2	Lower Limit of Target Settlement Range
15	RANGETO	☐	ICL_RANGETO_D_PE	ICL_ITAMTS	CURR	15	2	Upper Limit of Target Settlement Range
16	CURRENCY	☐	ICL_NEGCURR_D_PE	WAERS	CUKY	5	0	Currency Used in Negotiation	TCURC
17	SETTLMNTAMOUNT	☐	ICL_SETTLMNTAMOUNT_D_PE	ICL_ITAMTS	CURR	15	2	Final Settlement Amount
18	SETTLMNTFORM	☐	ICL_SETTLMNTFORM_D_PE	ICL_SETTLMNTFORM_PE	CHAR	2	0	Key of Type of Settlement	*
19	SETTLMNTDATE	☐	ICL_SETTLMNTDATE_D_PE	DATS	DATS	8	0	Final Settlement Date
20	SETTLMNTDESC	☐	ICL_SETTLMNTDESCR_D_PE	TEXT60	CHAR	60	0	Comment on Final Settlement
21	NEGFORM	☐	ICL_NEGFORM_D_PE	ICL_NEGFORM_PE	CHAR	2	0	Key of Form of Negotiation	ICL_CNEGFRM
22	CONTACTMODE	☐	ICL_COMTYPE	ICL_COMTYPE	CHAR	1	0	Key of Communication Type	TICL091
23	VPARTNER	☐	ICL_NEGVPARTNER_D_PE	ICL_NEGVPARTNER_PE	CHAR	2	0	Key of Negotiation Partner	*
24	.INCLUDE	☐				0	0	Negotiation: Status
25	CANCELLED	☐	ICL_NEG_CANCELLED	XFELD	CHAR	1	0	Status "Cancelled"
26	FINISHED	☐	ICL_NEG_FINISHED_D_PE	XFELD	CHAR	1	0	Status "Closed"
27	REOPENED	☐	ICL_NEG_REOPENED_D_PE	XFELD	CHAR	1	0	Status "Reopened"

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_NEG	CHANGEDBY	USR02	BNAME
2	ICL_NEG	CLAIM	ICLCLAIM	CLAIM	KEY	1	CN
3	ICL_NEG	CLIENT	T000	MANDT	KEY	1	CN
4	ICL_NEG	CONTACTMODE	TICL091	COMTYPE	REF	1	CN
5	ICL_NEG	CURRENCY	TCURC	WAERS	REF	1	CN
6	ICL_NEG	NEGFORM	ICL_CNEGFRM	NEGFORM	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	600