Providing Enterprise Data Simply via SAP BSP - Data Retrieval in XML

Overview

In the last few lessons, we talked about the BSP application itself, the data retrieval in JSON, and how to handle URL parameters. Today, I want to give some help to the developers, who want to retrieve their data simply in XML. To achieve this, we are going to perform a few modifications only.

Today lessons

How to retrieve data in XML format

Providing Enterprise Data Simply via SAP BSP - Handling URL Parameters

Overview

In the previous posts, we built a very simple BSP application that we used to retrieve a simple, hard-coded JSON. Then we went ahead, and we replaced this hard-coded JSON in code using a simple SELECT statement, and a JSON transformation.

Today, we move on and talk about how to pass parameters to our web service in order to pass a filtered data back to the client. We are going to solve these requirements using Page Attributes.

Today lessons

How to pass parameters to the service

Providing Enterprise Data Simply via SAP BSP - Data Retrieval in JSON

Overview

In the previous post, we built a very simple BSP application that we used to retrieve a simple, hard-coded JSON. Today, we go ahead, and talk about how we can produce this hard-coded JSON in code. In order to do this, I'm going to introduce you the Event Handlers in Pages with Flow Logic.

Today lessons

What are the available Event Handlers
How to produce JSON in ABAP 7.4

Providing Enterprise Data Simply via SAP BSP - First Steps

Overview

Today, I want to share a very handy approach with you about building simple web services in SAP. It's a lightweight alternative to the SOAP web services. I mostly try to avoid building SOAP web services, since they provide very thick interfaces, always need to regenerate the proxies and so on, so it can be a nightmare in complex cases (at least for me). I usually prefer building RESTful web services using the SAP Netweaver Gateway, but what if I don't have it?

To demonstrate the approach, we are going to build a simple web service that uses JSON format and deals with flight schedules.

Today lesson

How to build a simple one-page BSP Application in SAP

Simple XML Processing in ABAP Part V. – Processing XML Attributes

In the previous post, we finished our framework program that is able to call our previously constructed Simple Transformation to parse the content of the XML into SAP database table, ZCUSTOMER.

Today, I want to share you another challenging use case for processing XML documents, namely how to process XML attributes in the XML document using Simple Transformation. It may sound a bit difficult, but we will see that SAP makes our job really easy. We can perform all mentioned operation below via the source code editor or the visual editor. As you got familiar with the visual editor in the previous posts, now I am going to demonstrate the steps in the source code editor (Note: it doesn't matter which IDE you use, it has the same effect).

Simple XML Processing in ABAP Part IV. – Create Framework Program to Process XML Files

Main responsibilities

We did a great job with the Simple Transformations, so from now on we are ready to call it from the framework program. To make it simpler, first I am going to introduce the main responsibilities of the framework program: first let's upload the content of the XML file, then parse this content into an SAP internal format, and at last insert the parsed data into the database. I like to write transparent codes, so we are going to use subroutines to separate these different responsibilities, and keep our code readable. We are going to construct three subroutines, namely UPLOAD_XML, PARSE_XML, and INSERT_INTO_DATABASE.

Simple XML Processing in ABAP Part III. – Create Simple Transformation to Parse XML Content

Create the Simple Transformation

As we are ready with creating ABAP Dictionary objects, let’s move on, and open the transaction, called STRANS to create the Simple Transformation that will parse the content of the XML document into the internal format of the SAP. In the Transformation Editor, first let’s give a name to our transformation like ZCUSTOMER_ST, and hit the Create button.

Simple XML Processing in ABAP Part I. – Overview

Introduction to XML

Today, it is very common business request to exchange data between different external systems. It can be a problem that those systems usually store their data in incompatible formats. To make this exchange process much easier, it’s usual to use a plain text format such as XML. XML provides a standardized format, so a result those systems can communicate with each other in only one specified language, what everybody easily understands.

Since the XML is a well-known markup language, most of the programming languages are capable to process XML files and provide various tools to transform their content to an internal format of the given system. If you want to learn more about XML, visit the website: www.w3schools.com.