Did you create Generic Extractor on KONA (Rebate Agreement) & Delta Setup ?

[Former Member]

Hi all,

Did you create the Generic Extractor after creating the view on KONA table ? How did you setup the Generic Delta, PLEASE ?

I have created a view on KONA (Rebate Agreement) & KONH (Conditions Header) tables and I want to create the Generic Extractor. Should I create the Generic Extractors for Transaction Data & Text, PLEASE?

How to setup the Generic Delta, PLEASE ???

Thanks,

Venkat.

[Former Member]

Hi,

in your case, it is not possible to create a generic delta with one extractor only. This is only possible with a function module, because you have a creation and a change date in your table. The change date (aedat) is only updated after changes, the creation date (erdat) only once the row was created. So you have two options.

1st: create 2 datasources, lets say zbw_kona_created, use your view as extractor and set the field erdat as generic delta field and zbw_kona_changed and use the view as well but set the field aedat as generic delta field.

2nd: create a fm, set erdat or aedat (it doesn't matter for a fm) as generic delta field

and do a select ..... where aedat >= <generic delta date> or erdat >= <generic delta date>).

Both options has to be posted to a ods first, with all infoobjects in overwrite mode.

kind regards

Siggi