Excel SAP tool

I need to analyze SAP data using Excel. One of the way to get the data into Excel is using RFC call to RFC_READ_TABLE. There are a few example on the net, however I could not find one suit my need. So here it is, Excel with VBA macro call ready to use.

About XITSAP1

This tool can retrieve content of SAP table directly using RFC call.

XITSAP1 is a tool to download records from any SAP tables.

Download

Get the file: XITSAP1_v01r_RFC_READ_TABLE.xls (zip)

Feature

• Download SAP tables directly into Excel
• User can specify any tables to retrieve
• User can specify which fields to retrieve (planned in future development)
• User can specify condition of records to select (planned in future development)

Usage example

1. Download and open the file
2. Fill in SAP System connection parameters
3. Specify SAP Table name
4. Click Get Definition
5. Specify which field and what condition to retrieve
6. Click Read Table