Generic Delta via Date field

[Former Member]

Hi Gurus,

Problem with generic delta (quite a topic in SDN already, but I found no complete response)

I have a custom table in the source system (CRM 5.0) and would like to load the table to BW (7.0).

I have created an extractor from the table and activated the generic delta on date field (last change date) which is in the table.

I have activated change document at the data type of the ‘last change date’

Now:

initial works fine

delta shows no records

In TX: RSO2 menu  DataSource  ALE Delta is disabled (I was unable to enable it)

In table: ROOSGEN I have no message type for the extractor

In TX: RSA7 I see no new entries in the delta

I found a very good how-to:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/10b68b99-022e-2a10-999d-c4dc9ec2...

But do I really have to code here anything?

I used an older how-to:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b062adbb...

Is there a way how can I activate the generic delta without to code? I really need just a primitive delta, no special intelligence.

Thanks in advance

Will reward any hint!

Martin

[raymond_giuseppi · Accepted solution]

Did you execute the initial load just before midnight, or did you use a safety window of at least one day.

In both case, you should wait ONE DAY before executing the Delta.

Regards

[Former Member · Accepted solution]

Hello Raymond,

Thank you for the prompt answer!

I have executed the delta in the same day as the initial.

I tried the upper limit as: ‘none’, ‘1’ and ‘2’.

Shall I wait one day? I will try, however I expected at least some records in the delta queue after I made changes to the table

Martin

[raymond_giuseppi · Accepted solution]

You will see nothing under RSA7 before you execute the Delta load, the day after the initial loading. And that don't depend on the security window. The only field you can see is the "last date extracted" value. Data are only available to "reload" a Delta after failure, once a delta has been processed.

Regards