Super Cool New CloudSimple Feature

When we talk to people about CloudSimple’s capabilities, there are two common reactions: “Wow, that’s really cool!” “Could ...

Contact us

When we talk to people about CloudSimple’s capabilities, there are two common reactions:

  • “Wow, that’s really cool!”
  • “Could it do [CRAZY_HARD_THING]?”

A lot of times, the answer to [CRAZY_HARD_THING] is “yes, it can do that – let me show you”. Realistically, however, there are times when the answer is “no, it can’t do that at the moment”.

As a developer, whenever my code can’t do [CRAZY_HARD_THING] I take it as a personal challenge. Accordingly, last week I set aside Friday to engage my elite rock star ninja hacker programming skills to see if I could unravel one of these challenges.

The problem: get CloudSimple to output the results of standard SAP GUI ALV reports. As it is, CloudSimple can read and interpret delivered SAP Gateway services, as well as customer developed Gateway services. But what if you already have a bunch of ALV reports developed and simply want to put their results into Google Sheets?

The solution: a Gateway service that can dynamically call programs and extract their results into a generic container. On the CloudSimple side, this presents itself as a service with two filters (program name and variant) that outputs the results of the program/variant. As a double bonus, it also outputs field descriptors for the ALV columns – so your data retains some meaning after it is transported from the SAP backend.

Here’s what it looks like.

I set up a simple ALV report in my SAP system, outputting some basic information on material inventory. The selection screen, with my variant:

Quick look at the SAP GUI ALV result:

Here are the CloudSimple filters necessary to duplicate this:

And finally, the CloudSimple screen with the results fully in place. Note that the top row contains the generic field names from the Gateway service, the second row contains field names from the actual ALV report, and the third row is the actual data output by the ALV report.

And that, dear readers, is how it works. So, among all the other cool stuff that you can do in CloudSimple, add this: call existing ABAP ALV reports and export their data right to Google Sheets!

In the meantime, I’m going to take a nap to recover from my elite rock star ninja hacker programming session.

Paul J. Modderman

Paul J. Modderman

Paul Modderman loves creating things and sharing them. He has spoken at SAP TechEd, multiple ASUG regional events, ASUG Fall Focus, Google DevFest MN, Google ISV Days, and several webinars and SAP community gatherings. Paul's writing has been featured in SAP Professional Journal, on the SAPinsider blog, and the popular Mindset blog. He believes clear communication is just as important as code, but also has serious developer chops. His tech career has spanned web applications with technologies like .NET, Java, Python, and React to SAP soutions in ABAP, OData and SAPUI5. His work integrating Google, Fiori, and Android was featured at SAP SAPPHIRE. Paul was principal technical architect on Mindset's certified solutions CloudSimple and Analytics for BW. He's an SAP Developer Hero, honored in 2017. Paul is the author of two books: Mindset Perspectives: SAP Development Tips, Tricks, and Projects, and SAPUI5 and SAP Fiori: The Psychology of UX Design. His passion for innovative application architecture and tech evangelism shines through in everything he does.

Let’s make your SAP better, together.

  • This field is for validation purposes and should be left unchanged.