Google and SAP partnered to allow customers to connect core SAP software designed for running all mission-critical processes in the cloud with the collaborative capabilities of Google Docs and Google Sheets to innovate how work gets done across the enterprise.
Google Workspace enables teams of all sizes to connect, create and collaborate – to drive innovation from any device and any location. Specifically, Google Docs and Google Sheets, integrated with SAP S/4HANA Cloud, will enable new business capabilities, use cases and opportunities for collaborative tasks. See details in this Press Release.
What are the new capabilities?
SAP data from all important UI tables can be exported to Google Workspace which allows customers to connect core SAP software operations in the cloud or on-premise with Google Sheets. A ‘File Browser’ dialog is available and offers the user a possibility to browse Google Drive and decide on the preferred location for the table export. In general, Google’s “My Drive”, “Shared drives” and “Shared with me” are supported.
Web Dynpro ABAP export-as dialog
Web Dynpro ABAP file browser dialog
After exporting, the data is displayed in Google Sheets and the user can use all Google Sheets capabilities to continue the work with the SAP data including collaborative tasks e.g. sharing it with others.
Exported data in Google Sheets
End to end demo of SAPUI5 table data export
How to use Google Workspace in SAP S/4HANA Cloud and On Premise?
In tables showing application data use the export button to launch this capability. SAP’s UI technologies support this integration starting from:
- SAPUI5: SmartTable: SAPUI5 version 1.102
- SAP Fiori elements: SAPUI5 version 1.102
- Web Dynpro ABAP List Viewer (WD ABAP ALV): SAP_UI 7.57
- Floorplan Manager: List ATS UIBB, Tree ATS UIBB and Analytics Component (based on Web Dynpro Data Grid): SAP_UI 7.57
- SAP List Viewer (ALV Grid) running in SAP GUI for HTML, SAP GUI for Windows and SAP GUI for JAVA: SAP_BASIS 7.57
- ABAP List running in SAP GUI for HTML, SAP GUI for Windows and SAP GUI for JAVA: SAP_BASIS 7.57
- WebClient UI: S4FND 107
(“File browser” isn’t available yet, the exported file is stored into “My Drive” folder)
These capabilities are available in SAP S/4HANA Cloud 2208 and SAP S/4HANA On Premise 2022, see the What’s New information.
The SAP Document Management Service on SAP Business Technology Platform is used as repository and to manage the document in Google Workspace. For more information on how to set up and configure your system, see Integrating with Google Workspace.
The Google Workspace integration offers an out-of-the box export of S/4HANA table data to Google Workspace via SAP Document Management Service.