Exporting Functions and Business Objects to Excel 

Use

You can download the data of a business object, a whole application hierarchy, a function, or a function group to an Excel spreadsheet.

You can download data from an R/3 system you are logged into or from a local repository file.

Prerequisites

Connect to the R/3 system or open the local repository file you wish to download data from.

Procedure

  1. Select the data you wish to download.
  2. Choose View à View Selected Item in MS Excel.

Result

SAP Assistant opens an Excel spreadsheet and downloads the selected business object, application hierarchy, function, or function group details. You can now save the spreadsheet and perform any other Excel operation on the data in it.

Note that you cannot download a single BAPI. If you select a BAPI, the data for the business objects and its other BAPIs is downloaded.