Data From Excel to SAP

[teoszczak]

Hi,

I spent few hours for reading all posts about that but I still can't understand how it works. Is someone here who will be able to write a VBA code for simple thing. connect this two things:
I have 1 material, XXX. I would like to change the description for it in SAP.
I have recorded Script in SAP. Simple change by MM02 transaction, entering number, change description, save.

How to make script which will take all numbers from first column and make changes on these materials using Material description from second column?
From excel=>SAP

 

[obiron]

I know very little about SAP but when you are moving data between systems you generally have three options.

1) Generate an extract file from Excel which is then collected and imported by SAP. SAP will not care where the orignal data came from or how it was generated. The file will have to be in a defined format (probably one of CSV, Fixed length, XML or EDI)

2) Make a connection to the SAP database from Excel and run an SQL statement to 'inject' the data into the database. This requires passwords and permissions and is regarded as the riskiest option because it makes it difficult to protect the SAP database from badly formed / malicious SQL

3) Make a connection from SAP to Excel and use Excel as a datasource. This normally requires certain security policies to be implemented (e.g. OPENROWSOURCE to be activated as part of the Surface Area Configuration in MSSQL) and can only be done by system admins.

There are 3rd party tools available to help the integration between SAP and EXCEL. I know SAP does have certain security priveleges that will allow only particular users/user groups to run scripts.