Data cancellation / roll back

[Former Member]

Hi,

We have a scenario wherein SAP PI posts certain number say 10 Material Master Data to SAP from external system, so during process if first five materials out of 10 are posted and error appears for sixth material, then is it possible to cancel all previous 5 postings also.

Please suggest

Thanks in advance.

[former_member307485]

Hi,

Probable solutions :

1.create an abap proxy that will receive all of your data (all rows).Then call BAPI one by one and check the return table at the end loop at return table and if it's all successfull

then commit work it not rollback work

2. Or instead of updating the table one by one..

You can create a temporary internal table inside you proecdure and after all the entries are transferred to that internal table you can update your database table using that..

Then you can use statement like "commit" and "rollback" which can be used in your stored procedure.

XI/PI cannot do it on it's own there always must be some functions

on application system side that support this (even with 7.1)

Regards,

Divya

[Former Member]

Divya,

Thanks that was very helpful.....that will definitely work if you are pushing data to SAP which is independant of each other.

But in our case, I will further explain our situation...

in our scenario we have to create 10 materials say A1,A2 .... A10 , and 2 Boms say A9 and A10

A9 BOM contains items A1,A2..A6

and A10 BOM contains items A7,A8,A9

Now when i trigger upload say 10 materials are created, then BOM for A9 is also created

but if while creating BOM for A10 some error happens, so in that scenario requirement is all 10 materials and BOM for A9 which was created should be rolled back/removed from system.

Please suggest

Thanks in advance

[Former Member]

Hi

Normally SAP RFC handles in Batch for insertion kindly check it is possible at RFC level

rgds

sini