Incremental Load

shahanazhussain — Mon, 06 Aug 2018 08:13:09 GMT

Dear Experts,

We have a custom application in our ECC system. This is used to extract data into different file formats, from underlying database tables. For initial full load it is working. Now that we need to capture the incremental/delta load.

I would like to know is there any option to capture the database changes(insert, update and delete) in ECC without affecting the system performance. That is, any specific transaction or table I could refer to.

PS: Tables without a date field also need to be considered.

Thanks in advance,

Shahanaz

Re: Incremental Load

matt — Mon, 06 Aug 2018 11:44:12 GMT

BW has generic delta extractors - you could adopt a similar approach. Here's an example: https://blogs.sap.com/2013/11/07/generic-delta-extraction-using-function-module-along-with-currency-conversion-in-source-system/

You should also look at change documents and database logging.

topic Re: Incremental Load in Application Development and Automation Discussions

Incremental Load

Re: Incremental Load