REUSE status
Integration of Google Sheets into ABAP List Viewer
Important note before starting your project setup/configuration
We are happy to announce that Google Cloud and SAP have expanded their partnership to enable a native integration between Google Workspace and SAP S/4HANA. Our customers now have the possibility to export data from all important UI Tables to Google Sheets as well as a table import from Google Sheets to the Upload General Journal Entries application. This initial set of features is included in SAP S/4HANA Cloud 2208 and S/4HANA 2022, leveraging an SAP Business Technology Platform service (additional license required: SAP Document Management Service, integration option).
Please feel free to check out our public documentation and set-up guide as well as our blog posts:
- Seamless integration between SAP S/4HANA & Google Workspace
- SAP’s UI Technologies enabling Google Workspace
Project Description
This project comprises an archive containing sample source code for the integration of Google Sheets into the ABAP List Viewer (ALV) component. Thus, this sample code helps you to implement and configure the export of ALV grid data from SAP GUI directly to Google Drive and display exported data snapshots automatically in Google Sheets.
Minimum Requirements
- This functionality is only available for certain SAP NetWeaver support packages, see note 2592115.
- After installation of the corresponding Support Package, it is mandatory to implement note 2624404 (ALV GUI: BAdI Export Integration Corrections).
Download and Installation
Proceed as follows to make best use of the sample code:
- Clone the repository or use the abapGit client to import the sources into your SAP system.
- Setup the Google API Endpoint (see chapter 2.2 in Export of ALV Grid Data to Google Sheets )
- Create a Service Provider Type for Google (see chapter 2.3.1 Export of ALV Grid Data to Google Sheets)
- Create an OAuth 2.0 Client Profile (see chapter 2.3.6 Export of ALV Grid Data to Google Sheets)
- Configure the Access to Google APIs (see chapter 2.4 Export of ALV Grid Data to Google Sheets)
- Check the Connection (see chapter 2.5. Export of ALV Grid Data to Google Sheets)
- ALV ABAP administration (see chapter 3.2 Export of ALV Grid Data to Google Sheets)
Configuration Guide
See the full documentation Export of ALV Grid Data to Google Sheets available in the SAP Community.
Limitations
- The redirect URL called by Google requires a public top level domain server.
- There is no way to use an Enterprise account or logon to Google Drive via SSO – every end user needs a regular Google account.
Known Issues
None.
How to obtain support
No SAP standard support provided: Consult SAP note 2896606 for details.
You can ask your questions concerning this functionality in the SAP Community. Please, use ABAP Development as primary tag and choose alv as additional user tag.
You find an overview of all ALV questions under: https://answers.sap.com/topics/alv.html.
Contribution
An SAP Code Sample such as this is open software but is not quite a typical full-blown open source project. If you come across a problem, we’d encourage you to check the project’s issue tracker and to file a new issue if needed. If you are especially passionate about something you’d like to improve, you are welcome to fork the repository and submit improvements or changes as a pull request.
License
Copyright (c) 2021 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.
Note that the sample code includes calls to the Google Drive APIs which calls are licensed under the Creative Commons Attribution 3.0 License (https://creativecommons.org/licenses/by/3.0/) in accordance with Google's Developer Site Policies (https://developers.google.com/terms/site-policies). Furthermore, the use of the Google Drive service is subject to applicable agreements with Google Inc.