Best way to copy data from Excel to SAP

[kwyang]

Hi all,

I would like to ask what're the best MACRO options out there to automate data into SAP system.
The primary focus is to copy a bunch of data (from excel) into SAP Vendor Master Data (XK01) automatically.
Based on my limited knowledge, these are the only options I'm aware of:

1. SAP LSMW (I find it lacking as there're a lot of fields that can't be recorded)
2. SAP GUI Scripting/VBA (Limited access to users, so it might not be the best option)

Would appreciate if anyone can provide an alternative options thanks.

 

[kwyang]

Problem has been solved. Thanks