abap2gsheet
An ABAP framework that wraps the Google Sheets API behind ABAP calls for on-premise SAP S/4HANA, authenticating through SAP's standard OAuth 2.0 client.
Calling the Google Sheets API from ABAP needs an OAuth 2.0 client and its authorizations in place before any request succeeds. The framework wraps that API behind ABAP calls and authenticates through SAP's standard OAuth 2.0 client, so it carries that client's prerequisites: AS ABAP 7.40 SP08 with note 2043775 applied, S_OA2C_ADM with activities 01, 02 and 03 for the administrator who creates the client configuration, and S_OA2C_USE with PROFILE Z_GOOGLE_SHEETS and ACTVT 16 for the end users. The maintainers target SAP S/4HANA 1809 and above, on-premise only, and point at chapter 2.2 of SAP's Export of ALV Grid Data to Google Sheets for setting up the Google API endpoint.
Facts
Where it sits
Who is behind it
In the atlas: maintains 1, contributes to 1@techedgegroup-sapmaintainerMNicolai77Contributes to this
In the atlas: contributes to 1@MNicolai771 contributor
Before choosing this
Signals
ActivityQuietNo published releases; repository quiet for 81 months
It publishes no releases, and its repository has been quiet for at least 24 full months. This may be normal for stable software; check whether its current state still fits your use.
What it declares
Every artifact
- Type
- Package
- Origin
- Independently maintained
As a package
- Where it runs
- Inside its host
- Distributed through
- does not say
Connections
Calling an external HTTP API from application code
Download
README
quoted from techedgegroup-sap/abap2gsheet under Apache-2.0, readabap2gsheet
ABAP framework that abstract the Google Sheets API
For more information on this please refer to the SCN BLOG
Pre-requirements
We are targeting to support ABAP2GSheet on SAP S/4HANA 1809 and above (obviously only on-premise).
Since we count on the SAP standard authentication method to Google API (SAP oauth2 client), we have at least the same prerequisites that are:
- SAP oauth2 client is only available for SAP NetWeaver starting from AS ABAP 7.40 SP08 (Note 2043775 must be applied).
- As a prerequisite the system administrator needs authorizations to create OAuth 2.0 Client Configurations. Make sure that the system administrator has the authorization S_OA2C_ADM with at least the activities 01, 02 and 03 in the AS ABAP system.
- Make sure that the end users who should be allowed to use the new OAuth 2.0 Client have the required authorizations assigned. During execution of OAuth 2.0 flows there is a check of the authorization object “S_OA2C_USE”. This authorization object has two fields “PROFILE” and “ACTVT”.
- Set the authorization field values as follows: S_OA2C_USE PROFILE = Z_GOOGLE_SHEETS ACTVT = 16
Setup the Google API Endpoint (see chapter 2.2 in Export of ALV Grid Data to Google Sheets )
Others providing
Compare all 10 on the HTTP clients page →- abapify/fetch-cloudabapify/fetch-cloudA plugin for the abapify/fetch polyfill that supplies its BAdI implementation for ABAP Cloud, where cl_http_client cannot be used directly; the polyfill is installed first.independent, abapCloud-compatible plugin for the abapify Fetch API polyfillfrom ABAP
- abapify/fetch-legacyabapify/fetch-legacyA legacy-release implementation of the Fetch API interface for outbound HTTP calls from ABAP, plugging into abapify/fetch so the calling code needs no refactoring when it moves to the cloud.independent, abapLegacy-release Fetch API implementation for outbound HTTP in ABAPfrom ABAP
- abapify/fetchabapify/fetchA Fetch API-style polyfill for ABAP: one facade over request, response and destination, with the release-specific HTTP client of cloud or classic systems supplied by a plugin like Cloud fetch.independent, abapFetch API-style HTTP polyfill for cloud and classic ABAPfrom ABAP
- ABAPFireABAPFireAn ABAP client library for Firebase's Realtime Database REST API, with email-and-password authentication and methods to read, set, update, push and remove data at a path.independent, abapABAP client for Firebase's Realtime Database REST APIfrom ABAP
- B-Tocs ABAP SDKB-Tocs ABAP SDKAn ABAP package that carries the outbound web service call for an SAP ABAP server, with the utility and security classes it needs under it and one plugin per integration on top.independent, abapWeb service client and connector layer for calling out of ABAPfrom ABAP
- abap-soql-queryabap-soql-queryAn ABAP report that runs Salesforce SOQL queries against standard or custom objects through a connected app, shows the rows in an ALV grid and exports them to CSV or Excel.independent, abapABAP report that runs Salesforce SOQL queries and exports resultsfrom ABAP
- abap2gappsabap2gappsAn ABAP API for Google Apps integration, with a program, ZGAPPS_UPLOAD, that uploads a chosen file from the SAP system to Google Docs through a consumer registered for OAuth 2.0.independent, abapABAP API for Google Apps, with upload to Google Docsfrom ABAP
- ABAP SDK for AzureABAP SDK for AzureABAP objects and classes for sending SAP business process data to Azure services such as Event Hub, Service Bus, Key Vault, Blob and Azure OpenAI, without depending on a middleware product.partner, abapABAP classes for calling Azure services from SAP processesfrom ABAP
- cross-http-clientcross-http-clientAn ABAP HTTP client intended to work across classic on-premise ABAP and ABAP Cloud, using CL_HTTP_CLIENT on the one and CL_HTTP_DESTINATION_PROVIDER on the other.community org, abapHTTP client for classic on-premise ABAP and ABAP Cloudfrom ABAP
Details
Sources
Sources are graph entities: the same page may back several entries, and an unreachable source flags every row that rests on it.
Compatibility and provenance
abaplint
Flavors
“We are targeting to support ABAP2GSheet on SAP S/4HANA 1809 and above (obviously only on-premise).” — techedgegroup-sap/abap2gsheet — README, Pre-requirements
Contributors
History in the atlas
- First seen.
For your agent
- Ref
artifact:techedgegroup-sap-abap2gsheet- JSON
- /artifacts/techedgegroup-sap-abap2gsheet.json
- MCP
- Connecting an agent