Delta process with external database

[Former Member]

SAP Help documentation says :

"You cannot use the delta update method with DB Connect. In this case, a delta request is possible using the selections (time stamp, for example)".

So please share your experiences about this issue. What methods are you using for delta upload ? Only time stamp ? If master or transactional data changes in external db system how you recognize this in delta process ? etc

thanks,

Yiðit

[edwin_harpino]

hi Yiðit,

we use a date field in db connect datasource to recognize the delta process, any data changes in source system will update this date field, in infopackage selection we 'filter' data by this date field, there is option 'yesterday', or can use routine and fill with sy-datum (current date).

there is one doc in www.expertonline.com (we didn't use this), take a look

http://www.bwexpertonline.com/downloads/DBConnectMakingDELTAABAPCode.doc

hope this helps.

[Former Member]

What is the time stamp mean for external database table or view. We can't modify external system source codes. So how can i get the time stamp in data selection tab of the packet?