All Projects → SAP-samples → abap-alv-google-upload-sheet

SAP-samples / abap-alv-google-upload-sheet

Licence: Apache-2.0 License
Sample demonstrating export of ALV Grid data from SAP GUI directly to Google Drive and display exported data snapshots automatically in Google Sheets.

Programming Languages

ABAP
45 projects

Projects that are alternatives of or similar to abap-alv-google-upload-sheet

abap-exercises-codejam
Material for CodeJams on SAP Business Technology Platform, ABAP Environment and ABAP RESTful Application Programming Model.
Stars: ✭ 25 (+4.17%)
Mutual labels:  sample, abap, sample-code
teched2021-developer-keynote
SAP TechEd 2021 Developer Keynote: Improving Developers' Lives.
Stars: ✭ 23 (-4.17%)
Mutual labels:  sample, abap, sample-code
abap-platform-jak
The JSON ABAP Konverter
Stars: ✭ 16 (-33.33%)
Mutual labels:  sample, abap, sample-code
cloud-abap-rap
This repository contains several examples how to develop with the ABAP RESTful Application Programming Model (RAP) in SAP BTP, ABAP environment.
Stars: ✭ 98 (+308.33%)
Mutual labels:  sample, abap, sample-code
abap-odata-smoke-test
This ABAP Report performs simple smoke tests for activated ODATA services, providing basic automated testing for your ODATA endpoints.
Stars: ✭ 13 (-45.83%)
Mutual labels:  sample, abap, sample-code
cloud-cap-risk-management
The SAP Risk Management example applications show how to deploy a CAP (SAP Cloud Application Programming model) application to Cloud Foundry and Kyma.
Stars: ✭ 36 (+50%)
Mutual labels:  sample, sample-code
fiori-elements-feature-showcase
Sample application that demonstrates and documents a broad variety of features of SAP Fiori elements for OData V4. Developers can play around with the new features and learn how to implement them.
Stars: ✭ 76 (+216.67%)
Mutual labels:  sample, sample-code
ui5-service-worker-sample
ui5-service-worker-sample demonstrates how the Service Worker API, available in modern web browsers, could be used in a UI5 app to realize different caching strategies.
Stars: ✭ 16 (-33.33%)
Mutual labels:  sample, sample-code
cloud-espm-cloud-native
Enterprise Sales and Procurement Model (ESPM) Cloud Native is a project that showcases how an application can be made resilient by implementing resilience design patterns. This application is developed using Spring Boot framework and can be deployed locally as well as on SAP BTP, Cloud Foundry environment.
Stars: ✭ 29 (+20.83%)
Mutual labels:  sample, sample-code
hcp-portal-service-samples
Code samples of site and page templates, applications, widgets, shell plugins and more, intended to be used as references for development of custom content for SAP HANA Cloud Platform portal service sites.
Stars: ✭ 29 (+20.83%)
Mutual labels:  sample, sample-code
cloud-platform-iot-starterkit
This repository provides information and code for working with SAP Cloud Platform Internet of Things. It enables users to get an end-to-end IoT solution with either real hardware or simulators up and running fast and start their own extensions and usage based on this.
Stars: ✭ 276 (+1050%)
Mutual labels:  sample, sample-code
devtoberfest-2021
The home of Devtoberfest 2021 - an open celebration of what makes us developers - coding and collaboration!
Stars: ✭ 212 (+783.33%)
Mutual labels:  sample, sample-code
hana-ml-samples
This project provides code examples for SAP HANA Predictive and Machine Learning scenarios and is educational content. It covers simple Predictive Analysis Library SQL examples as well as complete SAP HANA design-time “ML scenario”-application content or HANA-ML Python Notebook examples.
Stars: ✭ 67 (+179.17%)
Mutual labels:  sample, sample-code
cloud-cap-multitenancy
SAP Cloud Application Programming Model (CAP) sample code project with multitenancy using service manager-created SAP HANA containers for tenant data isolation.
Stars: ✭ 33 (+37.5%)
Mutual labels:  sample, sample-code
xf-application-mocks
Contains lightweight substitutes for SAP applications to ease the development and testing of extension and integration scenarios. In conjunction with SAP Business Technology Platform, kyma runtime, the efficient implementation of application extensions is supported without the need for real SAP applications being accessible during development.
Stars: ✭ 21 (-12.5%)
Mutual labels:  sample, sample-code
cap-sflight
Using SAP Cloud Application Programming Model and SAP Fiori elements to build a simple travel management app, both with Node.js and Java.
Stars: ✭ 65 (+170.83%)
Mutual labels:  sample, sample-code
cloud-sdk-ios-samples
SAP Cloud Platform SDK for iOS sample apps demonstrating various components and features of the SDK in the context of bigger apps.
Stars: ✭ 20 (-16.67%)
Mutual labels:  sample, sample-code
hana-developer-cli-tool-example
Learn how to build a developer-centric SAP HANA command line tool, particularly designed to be used when performing SAP HANA development in non-SAP tooling (for example from VS Code).
Stars: ✭ 73 (+204.17%)
Mutual labels:  sample, sample-code
ui5-webcomponents-sample-react
UI5 Web Components Sample TODO application built with React.
Stars: ✭ 47 (+95.83%)
Mutual labels:  sample, sample-code
db2-samples
Db2 application code, configuration samples, and other examples
Stars: ✭ 56 (+133.33%)
Mutual labels:  sample, sample-code

REUSE status

Integration of Google Sheets into ABAP List Viewer

Descriptions

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:

  1. Clone the repository or use the abapGit client to import the sources into your SAP system.
  2. Setup the Google API Endpoint (see chapter 2.2 in Export of ALV Grid Data to Google Sheets )
  3. Create a Service Provider Type for Google (see chapter 2.3.1 Export of ALV Grid Data to Google Sheets)
  4. Create an OAuth 2.0 Client Profile (see chapter 2.3.6 Export of ALV Grid Data to Google Sheets)
  5. Configure the Access to Google APIs (see chapter 2.4 Export of ALV Grid Data to Google Sheets)
  6. Check the Connection (see chapter 2.5. Export of ALV Grid Data to Google Sheets)
  7. 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.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].