Sunday, July 31, 2016

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.

Excel SAP Interface macro RFC READ TABLE Input

Excel SAP Interface macro RFC READ TABLE definition SE11

Excel SAP Interface macro RFC READ TABLE retrieved records result




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

Posted by at
Labels: , , , , , , , , , , , , , ,

1 comment:

  1. armapeNovember 22, 2016 at 8:09 PM

    Thanks for sharing your work. Can your program be used to extract information from any table shown when using any SAP transacion? For example the table shown by transaction CS03 which displays the bill of materials of corporate part numbers (assemblies).

    ReplyDelete

Subscribe to: Post Comments (Atom)