To download from SAP to Excel:

o download from SAP to Excel:

* Many SAP reports have direct download function to EXCEL.
* SAP Query and SAP QuickViewer are excellent tools for Downloading (BvdR AO).
* Transaction SE16N allows you to access any sap table and download result to Excel
* SAP RFC functions can be called directly from Excel / VBA.

Use transaction BAPI in SAP to find your business object and study the function.

If you know the SAP table the RFC RFC_READ_TABLE offers a SQL query of the table

Trouble is .. you can not use joins here. you have to put the join in as a query in the SAP database and use the query in RFC_READ_TABLE

To upload data from Excel into SAP:

* Some of the Business functions (BAPI's / RFC unctions) offer data upload
* The general tool in SAP for data upload is the Batch input / call transactons

In the batch input file you specify screen by screen and field by field the input to SAP. SAP has a recorder to create the sample file. Just run trans SHDB and within this trans you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.

Did I say it was easy ? No , not really , but it's a set of very powerful tools there if you take your time to study them. Our company would not manage without them.

To download from SAP to Excel:

o download from SAP to Excel:

* Many SAP reports have direct download function to EXCEL.
* SAP Query and SAP QuickViewer are excellent tools for Downloading (BvdR AO).
* Transaction SE16N allows you to access any sap table and download result to Excel
* SAP RFC functions can be called directly from Excel / VBA.

Use transaction BAPI in SAP to find your business object and study the function.

If you know the SAP table the RFC RFC_READ_TABLE offers a SQL query of the table

Trouble is .. you can not use joins here. you have to put the join in as a query in the SAP database and use the query in RFC_READ_TABLE

To upload data from Excel into SAP:

* Some of the Business functions (BAPI's / RFC unctions) offer data upload
* The general tool in SAP for data upload is the Batch input / call transactons

In the batch input file you specify screen by screen and field by field the input to SAP. SAP has a recorder to create the sample file. Just run trans SHDB and within this trans you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.

Did I say it was easy ? No , not really , but it's a set of very powerful tools there if you take your time to study them. Our company would not manage without them.