Incremental Load

[shahanazhussain]

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

[matt]

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-...

You should also look at change documents and database logging.