Showing results for 
Search instead for 
Did you mean: 

Table Comparison for deltas on Large Tables

Former Member
0 Kudos


We are planning on using BODS to join BKPF(header) and BSEG(line item) tables in HANA and send the data across to SQL Server for reporting. We plan to use BODS Table Comparison transform with the ABAP Dataflow (RFC method) for delta management. The concern I have is that initially the HANA server will be a fresh installation and so limited number of records will be used in the Table Comparison transform. As time passes, the number of records in BSEG will grow and the Table Transform might become too resource intensive for the BODS server and network. Any expert advise on how to manage this scenario would be sincerely appreciated.




Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

You should distinguish between source CDC and target CDC (Change Data Capture).

1/. Source CDC: Make sure you only select those records from the source tables that are new or have been modified since the last run. The logic for the BSEG table is in delta data loading for bseg table | SCN.

2/. Target CDC: in order to guarantee consistency at the target level, use a Table_Comparison transform. Performance implications can be found in .

Former Member
0 Kudos

Thank you for the help, Dirk. Have a good day.

Answers (1)

Answers (1)

0 Kudos

Hi @dirk.venken

Your blogs on delta are very helpful.

We are stuck on figuring out ways to identify delta records for table BSEG_ADD.

Could you provide your inputs / guidance on the same.

Best regards