I’m trying to find out how to post a excel / txt file in Sap with UiPath (As in a financial posting document). As far as I can see there are multiple options:
a. Run a transaction in Sap in which you have the ability to upload the excel or txt file, these transactions automatically fill the required tables in Sap, this is done by mapping the columns in the excel to the columns in in the Sap table(s).
b.Run the BAPI itself, by for example the Bapi pack, and fill the fields in the bapi with the fields in Excel. I don’t have experience with the Bapi pack. To me, this feels like the right way to go forward, since I’m using activities from UiPath. However, I am not sure if this is possible.
My questions are therefore the following:
- Which way is best? Or is there another option which is even better?
- When using the Bapi pack can you use columns in excel to fill the required tables in Sap?
- Does anyone have experience, if so, what was your approach?
Thank you in advance,