SAP ABAP Table ICL_BW_NEG (Extract Structure for Negotiation)
Hierarchy
INSURANCE (Software Component) SAP Insurance
   FS-CM (Application Component) Claims Management
     ICL_EXTRACT (Package) FS-CM: Claims Management: Data Extracts
Basic Data
Table Category INTTAB    Structure 
Structure ICL_BW_NEG   Table Relationship Diagram
Short Description Extract Structure for Negotiation    
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   Negotiation  
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 NEGID ICL_NEGID_D_PE SYSUUID_C CHAR 32   0   Negotiation ID  
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 for Negotiation  
11 SUBOBJECT ICL_SUBOBJECT ICL_SUBOBJECT CHAR 16   0   Claim Subobject  
12 NEGTYPE ICL_NEGTYPE_D_PE ICL_NEGTYPE_PE CHAR 1   0   Key of Negotiation Type *
13 NEGDESCR ICL_NEGDESCR_D_PE TEXT60 CHAR 60   0   Description of Negotiation  
14 NEGNAME ICL_NEGNAME_D_PE ICL_NEGNAME_PE CHAR 10   0   Unique Technical Name of Negotiation  
15 RANGEFR ICL_RANGEFR_D_PE ICL_ITAMTS CURR 15   2   Lower Limit of Target Settlement Range  
16 RANGETO ICL_RANGETO_D_PE ICL_ITAMTS CURR 15   2   Upper Limit of Target Settlement Range  
17 CURRENCY ICL_NEGCURR_D_PE WAERS CUKY 5   0   Currency Used in Negotiation TCURC
18 SETTLMNTAMOUNT ICL_SETTLMNTAMOUNT_D_PE ICL_ITAMTS CURR 15   2   Final Settlement Amount  
19 SETTLMNTFORM ICL_SETTLMNTFORM_D_PE ICL_SETTLMNTFORM_PE CHAR 2   0   Key of Type of Settlement *
20 SETTLMNTDATE ICL_SETTLMNTDATE_D_PE DATS DATS 8   0   Final Settlement Date  
21 SETTLMNTDESC ICL_SETTLMNTDESCR_D_PE TEXT60 CHAR 60   0   Comment on Final Settlement  
22 NEGFORM ICL_NEGFORM_D_PE ICL_NEGFORM_PE CHAR 2   0   Key of Form of Negotiation ICL_CNEGFRM
23 CONTACTMODE ICL_COMTYPE ICL_COMTYPE CHAR 1   0   Key of Communication Type TICL091
24 VPARTNER ICL_NEGVPARTNER_D_PE ICL_NEGVPARTNER_PE CHAR 2   0   Key of Negotiation Partner *
25 .INCLUDE       0   0   Negotiation: Status  
26 CANCELLED ICL_NEG_CANCELLED XFELD CHAR 1   0   Status "Cancelled"  
27 FINISHED ICL_NEG_FINISHED_D_PE XFELD CHAR 1   0   Status "Closed"  
28 REOPENED ICL_NEG_REOPENED_D_PE XFELD CHAR 1   0   Status "Reopened"  
29 CLAIMTYPE ICL_CLTYPE ICL_CLTYPE CHAR 4   0   Internal Claim Type TICL011
30 DATELOSS ICL_LOSSDATE DATE DATS 8   0   Date of Loss/Claim  
31 PLINEOFBUS ICL_LINEOFBUS ICL_LINEOFBUS CHAR 3   0   Insurance Line of Business *
32 COMPANYCODE BUKRS BUKRS CHAR 4   0   Company Code *
33 UPDMOD RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ICL_BW_NEG CHANGEDBY USR02 BNAME    
2 ICL_BW_NEG CLAIM ICLCLAIM CLAIM    
3 ICL_BW_NEG CLAIMTYPE TICL011 CLTYPE    
4 ICL_BW_NEG CLIENT T000 MANDT    
5 ICL_BW_NEG CONTACTMODE TICL091 COMTYPE REF 1 CN
6 ICL_BW_NEG CURRENCY TCURC WAERS REF 1 CN
7 ICL_BW_NEG NEGFORM ICL_CNEGFRM NEGFORM REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 600