Logo GroupMEE

SAP Excel

SAP EXCEL PLUGIN

Work in SAP as if it were EXCEL. Create programs in an easier way.

Using the SAP connection with MS Excel, users download data from the SAP application to Microsoft Office desktop applications, including Excel.

With SAP-MS Excel connectivity, end users can interact with SAP transactions directly within their Excel spreadsheet.

Despite the large sums of money in SAP, most business users remain dissatisfied with it because SAP data is not easily accessible in their favorite desktop productivity tools: Microsoft Excel. Since Microsoft Office applications are not connected to SAP, users are forced to:

  1. Use error-prone cut, copy, and paste to fill their Excel spreadsheets.
  2. Manually update data from Excel spreadsheets to business applications.

BENEFITS OF SAP DATA TO MICROSOFT OFFICE APPLICATIONS

The SAP-MS Excel connectivity extends SAP data to Microsoft Excel through an information delivery server based on SOA and Microsoft Office add-ins, and provides the following benefits:

  1. It eliminates the data collection mechanism based on cut and paste from SAP to Microsoft Excel.
  2. It allows users to obtain real-time data from SAP within Excel with a single Refresh click.
  3. It allows users to update SAP from Excel.
  4. It prevents any data integrity issues with copying and reduces compliance problems.

WHO BENEFITS

  1. Production and logistics managers who want to create Excel reports from the latest SAP data.
  2. Analysts who want to combine SAP data and other enterprise data warehouses for budgeting purposes.
 

Example: 

EXCEL FILE SCENARIOS

  1. Create an MS Excel file for user input.
  2. Create a user interface in an Excel sheet to enter data for the customer master and output cells.
  3. Apply ABAP code to establish the connection with SAP.
  4. Read the input data for the customer master from the Excel file sheet.
  5. Obtain data from SAP using the SAP connection code.
  6. Display the output within the Excel sheet itself.

SAP SCENARIOS

  1. Create a function module in ABAP that is «Remote Enabled». Create the IMPORT, EXPORT, and TABLES parameters according to the requirements of MS Excel.
  2. Write logic to display the customer master details based on the input from the Excel file.
  3. Activate the function module.
Logo SAP Partner