I need some help in finding a solution to this challenging problem, I have to update some info in SAP from an excel file. The file has different columns which needs to be entered in different fields in the SAP GUI (Marked the headers of these fields in green background), except for few columns which needs to be updated in a table (Marked the headers of these fields with red background).
Another important thing to notice here is that the no of rows for each vendors differ like for the first vendor has 4 rows (stretches from row - 2:5).
Also for the excel sheet snip which i have shared has 5 vendors and so the SAP entry will be made in 5 iterations ( in first iteration the first vendor details will be entered and so on). I have marked all the vendors in 5 different colors to show that at a time in the SAP GUI only one vendor details will be entered.
Attaching these snips for reference -