ABAP Client proxy to JDBC (two tables update and deletion)
We have a source structure lpopulated via Proxy looks like:
Actual Package Number
From Proxy we are sending records in batches of say 500 records, if there are 5000 records pulled by report then proxy will be sending 500 records at a time. we say 500 records as 1 package, so total 10 packges will be received by XI during one report execution. After receiving first package(In source structure when Actual Package number is 1) in XI, XI has to first clear the data from table(Clearinf of sata can bve done based on timestamp from SAP data and Database table records time stamp value) and then post master data(B) to one of the table in SQL, Once XI received all the packages(10) then one log entry has to be done in separate log table,
We were planning like is there any way we can compare Total Packages and Actual Package number based on which we can do operations on Database table.
What will be the best practice to achieve this scenario?