---
title: Test Table Export Using SAP UI5 Application
description: The purpose of this tutorial is to test your setup that was created in the previous tutorial series by exporting data from SAP S/4HANA Cloud, public edition to Google Sheets.
auto_validation: true
time: 10
tags: [ tutorial>beginner, topic>cloud; software-product>sap-business-technology-platform, software-product>sap-s-4hana; topic>Google Workspace; topic>SAPUI5, software-product>sap-document-management-service]
primary_tag: 	software-product>sap-s-4hana-cloud
author_name: Vikram Kulkarni
author_profile: https://github.com/Vikramkulkarni01
slug: btp-sdm-gwi-s4hana-export-testing
canonical_url: https://developers.sap.com/tutorials/btp-sdm-gwi-s4hana-export-testing
---
## Prerequisites

- You've an account in the Google Workspace.
- You've necessary privileges for SAP S/4HANA Cloud, public edition.

### You will learn

- How to export data from SAP UI (User Interface) tables.

---
[ACCORDION-BEGIN [Step 1: ](Access your application )]
Log on to your S/4HANA Cloud, public edition. Open the **Manage Journal Entries** or **Purchase Orders** or any other applications that is offering a table-based export.

  !![Accessing System](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/btp-sdm-gwi-s4hana-export-testing/LogOntoS4HANACloud.png)


[DONE]
[ACCORDION-END]

[ACCORDION-BEGIN [Step 2: ](Export table details)]
1. The user interface of an application that offers a table base export looks like this: You can use any such application which gives the option to export a table. *This tutorial uses the Purchase Orders application*.

    !![Table](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/btp-sdm-gwi-s4hana-export-testing/LogOntoS4HANACloud2.1.png)

2. Navigate to the drop-down menu (you'll have to figure out this option in your application). Click on **Export As**.

    !![Export](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/btp-sdm-gwi-s4hana-export-testing/ExportAs.png)

3. Check if the destination option is available, select **Cloud** and click on **Export To**.

    !![Destination to Export](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/btp-sdm-gwi-s4hana-export-testing/Destination_cloud.png)

4. Check if the entries in the file browser window are loaded (like folders and files are visible).

    !![ExportTo](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/btp-sdm-gwi-s4hana-export-testing/ExportTo.png)

5. Select a folder and click **Export**. If prompted enter the Google Workspace credentials of the user and then the exported data shall be visible in Google Sheets.

    !![ExcelSheet](https://raw.githubusercontent.com/sap-tutorials/btp-adai/main/tutorials/btp-sdm-gwi-s4hana-export-testing/JournalEntries_excel.png)

[DONE]
[ACCORDION-END]