cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to get Delta records from generic DataSource

Former Member
0 Kudos

How can i create Delta for a heneric DataSource?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi iSeeemy

In RSO2 transaction , click "Generic Delta" and a new window will open.

Here you have to choose any field from your DS which is increases monotonously. It can be TImestamp, CalenderDay or Pointer.

THis is needed by the system to check which records have been added since last extraction ( characterised by the criteria you have choosen).

I would suggest you to create delta on the basis of any time stamp field in the data source.

Cheers

Pradeep

former_member182516
Active Contributor
0 Kudos

Hi,

IN Tcode rso2; select your data source: edit, choose generic delta button, give the delta specific field,and followed by

any one of delta options UTC time stamp or date or time or numeric pointer field, use safety intervals either upper or lower, save the data source,replicate the structure.

Delta mechanisms : Calday,TimeStamp,Numeric Pointer

We can go for any of these depending on the requirement.

Generally We go for Calday when we want to load the Delta daily or weekly.

Numeric Pointer :If we have a suitable requirement.(Eg: When we don't want to change the existing records and we have a field which holds Unique and Increasing value)

TimeStamp: If we have to do delta more than once in a day.

Safety Interval Upper Limit of Delta Selection

This field is used by DataSources that determine their delta generically using a repetitively-increasing field in the extract structure.

The field contains the discrepancy between the current maximum when the delta or delta init extraction took place and the data that has actually been read.

Safety Interval Lower Limit

This field contains the value taken from the highest value of the previous delta extraction to determine the lowest value of the time stamp for the next delta extraction.

also download Generic Delta doc

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

Regards

KP

Edited by: prashanthk on Jul 9, 2010 8:05 AM

former_member188011
Active Contributor
0 Kudos

Hi iSeemey:

Please refer to this paper.

"How tou2026 Create Generic Delta"

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

Regards,

Francisco Milán.