How to use 2 date field as delta control in generic extractor.

[Former Member]

Hi colleagues:

I have developed a generic extractor to extract logistic data: Purchase Orders and Invoice. In order to do that, I have defined a view joining EKBE, EKKO, EKPO, EKET tables on R/3. By this approach, the delta mechanism is supposed to be controlled by the EKBE-BUDAT field and also by the EKPO-AEDAT field. Both fields are available on the view used to create the Datasource. However, the Datasource creation allows us to define just one field as delta control.

I have a few questions regarding to this scenario:

<b>1 - Is it possible to define 2 fields as delta control field on Generic Datasource?</b>

<b>2 - How about creating two similar Datasouces, one having AEDAT as delta control, the other having BUDAT as delta control, and then connect those Datasources to an unique Infosource on the bw side?</b>

Best regards

Waldemar

[Former Member · Accepted solution]

Did you check the business content extractors???

[Former Member · Accepted solution]

Hi Waldemar,

Create a generic extractor using a function module (FM) of Infoset to get your data out.

If you use a FM, you will have to set up one field as a delta to let your FM know that you are doing a delta extract. Let me know if you need a code sample of this.

Cheers! Bill

[Former Member · Accepted solution]

Bill,

Can u send me code sample for this FM at ckalyan@gmail.com. I am working on generic extraction right now.So this will be helpful.

Cheers,

Kalyan

[Former Member]

Hi Waldemar,

You can keep one delta field in the GDE and try to implement Delta logic in the Customerexit for extractors including second delta field too...

[Former Member]

hi,

1 - as far as I know it is not possible to define 2 fields

2 - this workaround is used often in cases like yours.

Just remember about order of extracting: first you extract new documents then changed

Regards,

Andrzej