Offer/Demand

DataSource Transactional Data: 0ISCM_NEGIT_01

This DataSource enables extraction of the data fields of the application table for the offers/demands in negotiation (ICL_NEGIT).

In addition, the following data is transferred to the BI system:

Internal claim type
Claim date
Insurance line of business
Company code

Technical Data

Application Component	Claims Management (0IS_IS_CM)
Available as of Release	ERP2005
Shipment	SAP BI 7.0
Content Versions	SAP NW 2004s BI Content Add-On 3
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Delta Update

This extractor can be used to perform both full updates and individual delta updates, providing that a delta initialization has taken place. Method AIMD is used as delta procedure, meaning that only new or changed data records are transferred to the BW system by way of the delta queue as “After Image”. You can also set the delete flag to delete existing data records in the BW system. To enable the delta update, include the UPDMOD field in the extract structure. This field specifies the update mode, meaning whether an “After Image” or “Delete Image" is involved.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`CLIENT`	Client	`ICL_NEGIT`	`CLIENT`
`ACTIVE`	Table entry is active (A) or in suspense (S)	`ICL_NEGIT`	`ACTIVE`
`CLAIM`	Number of the claim	`ICL_NEGIT`	`CLAIM`
`NEGITID`	ID of offer or demand	`ICL_NEGIT`	`NEGITID`
`CHANGETIME`	Changed: UTC date and time	`ICL_NEGIT`	`CHANGETIME`
`CHANGEDBY`	Changed by	`ICL_NEGIT`	`CHANGEDBY`
`DELETED`	Status of database entry (original, changed, deleted)	`ICL_NEGIT`	`DELETED`
`SUBOBJECT`	Claim subobject	`ICL_NEGIT`	`SUBOBJECT`
`NEGID`	ID of negotiation	`ICL_NEGIT`	`NEGID`
`NEGITNUM`	Unique number of the offer or demand	`ICL_NEGIT`	`NEGITNUM`
`DEMOFFDATE`	Date on which the demand or offer was created	`ICL_NEGIT`	`DEMOFFDATE`
`DEMOFFTYPE`	Type of offer or demand	`ICL_NEGIT`	`DEMOFFTYPE`
`DEMOFFAMNT`	Amount of demand or offer	`ICL_NEGIT`	`DEMOFFAMNT`
`CURRENCY`	Currency used in the negotiation	`ICL_NEGIT`	`CURRENCY`
`DEMOFFMODE`	Communication type	`ICL_NEGIT`	`DEMOFFMODE`
`VPARTNER`	Key of negotiation partner	`ICL_NEGIT`	`VPARTNER`
`CANCELLED`	Status “Reversed”	`ICL_NEGIT`	`CANCELLED`
`DEMOFFDESCR`	Comment on offer/demand	`ICL_NEGIT`	`DEMOFFDESCR`
`CLAIMTYPE`	Internal claim type	`ICLCLAIM`	`CLAIMTYPE`
`DATELOSS`	Claim date	`ICLCLAIM`	`DATELOSS`
`PLINEOFBUS`	Insurance line of business	`TICL321`	`PLINEOFBUS`
`COMPANYCODE`	Company code	`TICL321`	`COMPANYCODE`
`UPMOD`	BW delta procedure: Record mode		`UPMOD`