Create an OWL Excel Export

Overview

Object Work Lists (OWL) generated for custom business objects allow you to export the OWL data to a Microsoft Excel file. The file is based on a standard template, which you cannot change. However, you can format the generated spreadsheet as required.

Prerequisites

  • You have opened your solution containing an active custom business object.

  • You have created a floorplan scenario with navigation.

Procedure

  1. Log on to the SAP cloud solution and select   Application and User Management   Business Users .

  2. Select you user and select   Edit   Access Rights .

  3. In the Work Center and View Assignment view, select the work center you have created and assign it to your user. Click Save and Close.

  4. Log off from the SAP cloud solution. Log on again and navigate to the work center you have assigned to your user.

    The work center you have created is displayed. It contains an Export button.

  5. Click New and create several instances of your business object. .

  6. Complete the fields and select Save and then Close to get to the entry screen again.

  7. On the OWL, click Go to view the data records you have created.

  8. Click   Export   To Microsoft Excel .

Result

Microsoft Excel opens. The data records are displayed on a spreadsheet. You can save the data as it is or format it to suit your requirements.

See Also

Example: Export OWL Data to Excel