Skip to content
NextLytics
Megamenü_2023_Über-uns

Shaping Business Intelligence

Whether clever add-on products for SAP BI, development of meaningful dashboards or implementation of AI-based applications - we shape the future of Business Intelligence together with you. 

Megamenü_2023_Über-uns_1

About us

As a partner with deep process know-how, knowledge of the latest SAP technologies as well as high social competence and many years of project experience, we shape the future of Business Intelligence in your company too.

Megamenü_2023_Methodik

Our Methodology

The mixture of classic waterfall model and agile methodology guarantees our projects a high level of efficiency and satisfaction on both sides. Learn more about our project approach.

Products
Megamenü_2023_NextTables

NextTables

Edit data in SAP BW out of the box: NextTables makes editing tables easier, faster and more intuitive, whether you use SAP BW on HANA, SAP S/4HANA or SAP BW 4/HANA.

Megamenü_2023_Connector

NextLytics Connectors

The increasing automation of processes requires the connectivity of IT systems. NextLytics Connectors allow you to connect your SAP ecosystem with various open-source technologies.

IT-Services
Megamenü_2023_Data-Science

Data Science & Engineering

Ready for the future? As a strong partner, we will support you in the design, implementation and optimization of your AI application.

Megamenü_2023_Planning

SAP Planning

We design new planning applications using SAP BPC Embedded, IP or SAC Planning which create added value for your company.

Megamenü_2023_Dashboarding

Dashboarding

We help you with our expertise to create meaningful dashboards based on Tableau, Power BI, SAP Analytics Cloud or SAP Lumira. 

Megamenü_2023_Data-Warehouse-1

SAP Data Warehouse

Are you planning a migration to SAP HANA? We show you the challenges and which advantages a migration provides.

Business Analytics
Megamenü_2023_Procurement

Procurement Analytics

Transparent and valid figures are important, especially in companies with a decentralized structure. SAP Procurement Analytics allows you to evaluate SAP ERP data in SAP BI.

Megamenü_2023_Reporting

SAP HR Reporting & Analytics

With our standard model for reporting from SAP HCM with SAP BW, you accelerate business activities and make data from various systems available centrally and validly.

Megamenü_2023_Dataquality

Data Quality Management

In times of Big Data and IoT, maintaining high data quality is of the utmost importance. With our Data Quality Management (DQM) solution, you always keep the overview.

Career
Megamenü_2023_Karriere-2b

Working at NextLytics

If you would like to work with pleasure and don't want to miss out on your professional and personal development, we are the right choice for you!

Megamenü_2023_Karriere-1

Senior

Time for a change? Take your next professional step and work with us to shape innovation and growth in an exciting business environment!

Megamenü_2023_Karriere-5

Junior

Enough of grey theory - time to get to know the colourful reality! Start your working life with us and enjoy your work with interesting projects.

Megamenü_2023_Karriere-4-1

Students

You don't just want to study theory, but also want to experience it in practice? Check out theory and practice with us and experience where the differences are made.

Megamenü_2023_Karriere-3

Jobs

You can find all open vacancies here. Look around and submit your application - we look forward to it! If there is no matching position, please send us your unsolicited application.

Blog
Sign up now for our monthly newsletter!
Sign up for newsletter
 

Use Google API and ABAP to enrich SAP data with geoinfos

Nowadays, geodata play an increasingly important role. If you want to exploit the full potential of your data, you have to put them into a spatial context. In this article I will show you how to use the Google API to enrich data with geo information in SAP with ABAP.

Enriching your data with geo-information opens up many new application possibilities. For example, you can create dashboards with geo-information and make cartographic evaluations. In doing so, you can recognize important connections at a glance and thus gain new insights that cannot be easily derived from tables.

You can also use geodata in machine learning, for example to cluster your customers by location. Furthermore, geo points serve as a basis for calculating distances, which can also be an important criterion. In addition, you can also create personalized marketing campaigns based on geospatial information.

In this article, you'll learn how to use the Google Maps API to retrieve geo-information, such as latitude and longitude, based on address data. This allows you to create a consolidated database of geodata for all applications. The central availability of geo-information reduces the required data entry effort. In addition, double processing is avoided.

So how does it work in practice? First of all, it should be noted that the Google Maps API is subject to payment. To use it, you need a billing account and at least one enabled Google Maps Platform API or SDK. The API key can be requested in the Google Cloud Platform Console. You must provide an API key with each Maps JavaScript API request.

For example:

https://maps.googleapis.com/maps/api/geocode/json?address=kepellenstrasse37 hofheim&key=YOURAPIKEY

The result is returned in JSON format and could look like this:

Google Maps API result

Google also recognizes minor spelling mistakes (e.g. kepellenstr. vs. Kapellenstr.) and corrects them automatically.


 SAP BW, HANA Native and Data Warehouse Cloud - Download the comparison

New call-to-action


This query can also be executed in ABAP directly from a SAP system such as a Business Warehouse (SAP BW). To do this, we must first create an HTTP client:

cl_http_client=>create(
EXPORTING
host = 'maps.googleapis.com' " Logical destination (is specified when the function is called)
service = '443' " Port number
proxy_host = '' " Logical destination (is specified when the function is called)
proxy_service = '' " Port number
scheme = '2' "HTTPS = 2 ; HTTP = 1
ssl_id = 'ANONYM' " SSL Identity
sap_username = '' " R/3-System, User login name
sap_client = '' " R/3-System, Client number from login
IMPORTING
client = DATA(lo_client) " HTTP Client Abstraction
EXCEPTIONS
argument_not_found = 1 " Connection parameter (host or service) not available
plugin_not_active = 2 " HTTP/HTTPS-Communikation is not available
internal_error = 3 " Internal error (e.g. name too large)
OTHERS = 4
) .

Afterwards, the requested address and the API key is passed to this client:

l_uri = '/maps/api/geocode/json?address=' && cl_http_utility=>escape_url(
                                                   unescaped = i_address ) &&'&key=' && l_api_key. 

The result is a JSON string:

JSON String

Finally, it is necessary to convert the JSON string and provide the results in ABAP format:

/ui2/cl_json=>deserialize( EXPORTING json = l_body pretty_name = /ui2/cl_json=>pretty_mode-camel_case CHANGING data = ls_root ).

The functionality of the JSON Converter is explained in the SCN Wiki.

Deserialized JSON

You can then easily write the data from ABAP to BW using the new ADSO APIs. You can also use process chains to plan loading processes.

Would you like to learn more about how you can connect other applications to SAP? Please do not hesitate to contact us.

Learn more about SAP BW

avatar

Sebastian

Sebastian Uhlig has been consulting companies in various industries on SAP BI solutions at national and international level since 2001 and covers the range from requirements analysis to the implementation of complex solutions. He has experience in leading project teams and is the architect of the product NextTables. He enjoys mountain biking and watching American football games.

Got a question about this blog?
Ask Sebastian

Blog - NextLytics AG 

Welcome to our blog. In this section we regularly report on news and background information on topics such as SAP Business Intelligence (BI), SAP Dashboarding with Lumira Designer or SAP Analytics Cloud, Machine Learning with SAP BW, Data Science and Planning with SAP Business Planning and Consolidation (BPC), SAP Integrated Planning (IP) and SAC Planning and much more.

Subscribe to our newsletter

Related Posts

Recent Posts