csv file to rfc scenario..process multiple rows of csv

[Former Member]

Hi Experts,

I have been trying a few tings but has nt worked so far.. this is my scenario..

There is a csv file with say 100 rows, even if one column is erroneous the interface halts and there r no updates in the z table..

I have used 1:n multi mapping ....any idea how i can proceed to satisfy the above scenario?

[Former Member · Accepted solution]

Hi Teja,

You can use the proxy (if it is the SAP system) then at the end of the proxy code we can use the commit statement. If any field is not updated correctly then it shouldn't commit. If all the records are updated then it performs the commit option.

Regards

Ramesh

[Former Member]

Hi,

This i feel to take care from the RFC side as the rfc functions looks like handling using transaction mechanisms..

which will commit only after successfully operations of all or rollback if anything in between fails...

by the way is the problem of record is with source data type itself or with in the PI ...?

or one thing you need to look is to execute the RFC for each record..which is not a performance efficient and not a good solution when you can pass all the records in a single call

HTH

Rajesh