---
title: An Overview of SAP GTS Reporting with SAP BW/4HANA
description: SAP BW/4HANA can work alongside SAP Global Trade Services (SAP GTS) in its reporting capabilities. Learn about some of the advantages of using both here!
image: https://blog.sap-press.com/hubfs/An%20Overview%20of%20SAP%20GTS%20Reporting%20with%20SAP%20BW4HANA.png
---

[![rheinwerk-sappress-logo-header-1](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://blog.sap-press.com/) [Blog](https://blog.sap-press.com)

- Books 
    - Get an overview of our books and courses on every relevant SAP topic. 
          - [Programming](https://sap-press.com/programming/)
          - [Administration](https://sap-press.com/administration/)
          - [BI](https://sap-press.com/business-intelligence/)
          - [Finance](https://sap-press.com/finance-controlling/)
          - [Logistics](https://sap-press.com/logistics/)
          - [HR](https://sap-press.com/human-resources/)
          - [CRM & Sales](https://sap-press.com/marketing-sales/)
          - [HANA](https://sap-press.com/hana/)
          - [Introductions](https://sap-press.com/introductions/)
          - [E-Bites](https://sap-press.com/e-bites/)
          - [Certification Guides](https://www.sap-press.com/certification-guides/)
          - [Rheinwerk Courses](https://www.sap-press.com/online-courses/)
- Book Subscription 
    - Get unlimited access to all SAP PRESS books! 
          - [SAP PRESS Subscription](https://sap-press.com/subscriptions/)

[Logistics](https://blog.sap-press.com/tag/logistics)

# An Overview of SAP GTS Reporting with SAP BW/4HANA

![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg)  by [SAP PRESS](https://blog.sap-press.com/author/sap-press)

SAP Business Warehouse for SAP HANA (SAP BW/4HANA) is the successor of SAP BW on SAP HANA. In comparison to SAP BW on SAP HANA, developments have started from a completely different codebase.

 

[SAP BW/4HANA](https://learning.sap-press.com/sap-data-management#SAP-BW4HANA) can be leveraged to harmonize and structure data from multiple  
sources and systems into data models. It can handle data from SAP and non-SAP feeder systems. Not all data that SAP BW/4HANA can leverage needs to be stored in the database. After the data is ready for consumption, SAP BW/4HANA allows for fast and dynamic reporting.

 

The general architecture of a data model is based on the Layered and Scalable Architecture ++ (LSA++) from SAP. This architecture prescribes a general way of working that consists of mandatory and optional layers. The goal is to have a flexible architecture that is both scalable and reusable to minimize the total cost of ownership (TCO). The figure below depicts this approach.

 

![Data Models](https://blog.sap-press.com/hs-fs/hubfs/09_042.jpg?width=876&height=663&name=09_042.jpg)

 

The Virtualization layer is the only mandatory layer, and, as the name states, it doesn’t persist any data in the database. It also allows access to all of the layers beneath it. The reason behind this is to maintain a flexible approach. All the data that is needed for analytical reporting is consumed through this Virtualization layer.

 

If anything were to happen to the underlying data model or if any of the other layers were to change or disappear, this would not impact reports built on top of the virtualization layer.

 

All other layers in the LSA++ architecture are optional. It’s important to note that optional doesn’t mean unnecessary; it means that any of these layers have their use and advantages in a data warehouse approach, but that you have the freedom on how to tackle each data model that has to be developed.

 

To use SAP GTS data for analytical reporting, you need to integrate SAP GTS with SAP BW/4HANA. The integration between SAP GTS and SAP BW/4HANA can be established as part of their standard functionality. First, set up a remote function call (RFC) connection between SAP BW/4HANA and SAP GTS. Then, enable the data transfer from SAP GTS to SAP BW/4HANA via Customizing by activating the data transfer to SAP BW/4HANA on the FTO, document type, and item category levels.

 

The following figure shows the integration between SAP GTS and SAP BW/4HANA. As previously mentioned, SAP BW/4HANA can leverage data from both SAP and non-SAP systems.

 

![Input and Output](https://blog.sap-press.com/hubfs/09_043.jpg)

The objects that enable data to be available for use in SAP BW/4HANA are called data sources. Data sources can make use of different technologies to extract data or virtualize data to SAP BW/4HANA. The following are the most common methods:

- Data extraction through views or function modules that have been created in the source SAP system and where the data will be persisted in SAP BW/4HANA
- [SAP HANA](https://learning.sap-press.com/sap-hana) views (i.e., all views from SAP HANA Live for SAP GTS)
- [CDS views](https://blog.sap-press.com/abap-sql-versus-cds-views-and-amdps-what-to-use#cds-views)

In this blog post, we focus on the first method: extracting from SAP GTS to SAP BW/4HANA. Currently, this is the most efficient way to leverage data maintained in SAP GTS.

 

**Note:** The other methods (i.e., SAP HANA views and CDS views) can also play an important role, but as the provided content for SAP GTS doesn’t suit all scenarios, data extraction to the data warehouse is still highly recommended. One advantage to keep in mind is that any SAP HANA views or CDS views (i.e., that you would use or create for operational reporting) can also be used to create a data source for your data warehouse.

 

At a high level, data extraction from SAP GTS to SAP BW/4HANA works as follows. First, the SAP BW/4HANA system fetches the changed (i.e., delta) information from the data sources on a regular basis and combines the data from multiple SAP GTS tables to transform them into a specific format. As many SAP GTS tables contain globally unique identifiers (GUIDs) as unique keys, it’s important to review that the extractors don’t forward this information to your SAP BW/4HANA system to minimize complexity and storage costs.

 

After the data extraction is finalized and available in SAP BW/4HANA, the data can be transformed and enhanced based on the needed requirements for the analytics reporting. After this activity is completed, master data and transactional data is accessible in SAP BW/4HANA and allows for multidimensional analyses from various business perspectives. For example, you can access consolidated data from different modules (i.e., SAP GTS, [SAP S/4HANA](https://learning.sap-press.com/sap-s4hana), etc.) via a single report.

 

The following sections cover more details on the extraction of data from SAP GTS.

 

## SAP GTS Queries

When you’re setting up SAP BW/4HANA to integrate with SAP GTS, there are 22 standard queries with corresponding dataflows and extractors, as listed in the table below. Queries contain key figures, which are numeric values or quantities (e.g., net price or quantity) used in the output reports as objects for analysis. Queries relate to actual reports and specify what data is leveraged.

 

![Standard Queries from SAP BW/4HANA for Integration with SAP GTS](https://blog.sap-press.com/hs-fs/hubfs/2505_Table_09_004%20Standard%20Queries%20from%20SAP%20BW4HANA%20for%20Integration%20with%20SAP%20GTS.png?width=3062&height=12661&name=2505_Table_09_004%20Standard%20Queries%20from%20SAP%20BW4HANA%20for%20Integration%20with%20SAP%20GTS.png)

**9**

## Reporting Options

The strength of the SAP BW/4HANA reports lies in their customizable nature. Analysts can continuously make modifications such as adding or removing variables and inserting metrics to analyze large sets of data. This allows users to make informed business decisions.

 

You can apply SAP BW/4HANA content in three ways:

- **Without modifications:** This option covers the basic reporting requirements—you activate the content and can use it as is.
- **With modifications:** This option entails changing delivered BI content by modifying the installed objects.
- **Using BI content as a template to build further customized reporting:** This is the most frequently used approach, in which you install the standard content and leverage the pieces that you need to comply with naming conventions, coding standards, and reporting requirements. 

## Advantages and Usage

SAP BW/4HANA offers several advantages for reporting:

- Users can make reports fit their business needs better by via customizations such as adding and removing variables and inserting filters. As such, valuable data may be filtered and extracted from large sets of transactional data.
- Data visualization through various frontend reporting tools (e.g., SAP Analysis for Microsoft Office, SAP Lumira, [SAP Analytics Cloud](https://learning.sap-press.com/bi/sap-analytics-cloud)) can help companies create insightful dashboards that showcase metrics tailored to different users.
- SAP BW/4HANA content contains a range of objects that simplify the implementation of an SAP BW/4HANA system and facilitate the development of an effective reporting system.
- When you use SAP BW/4HANA, you can combine data from various systems (i.e., SAP or non-SAP) into a single report. This removes the need to manually combine data from multiple systems into a spreadsheet because data from both SAP and non-SAP systems may be imported in SAP BW/4HANA.

## Learn SAP GTS in Our Upcoming Rheinwerk Course!

Navigate volatile global supply chains with SAP GTS, edition for SAP HANA! Learn its architecture and configuration and dive into customs, compliance, and preference management to cover your global operations.  Get access to course recordings by clicking the banner below.

 

[![blog_courses_32_gts_on_demand](https://blog.sap-press.com/hs-fs/hubfs/blog_courses_32_gts_on_demand.png?width=600&height=200&name=blog_courses_32_gts_on_demand.png)](https://www.sap-press.com/online-courses/sap-global-trade-services/)

 

*Editor’s note*: This post has been adapted from a section of the book *[Implementing SAP Global Trade Services](https://www.sap-press.com/implementing-sap-global-trade-services_5789/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2505_chapter9&utm_content=2505)* by Nick Moris, Pablo LeCour, and Li Yu.

## Recommendation

[![Implementing SAP Global Trade Services](https://blog.sap-press.com/hs-fs/hubfs/social-suggested-images/2505-1-1-1-1.jpg?width=170&name=2505-1-1-1-1.jpg)](https://www.sap-press.com/implementing-sap-global-trade-services_5789/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2505_chapter9&utm_content=2505)

**Implementing SAP Global Trade Services**

The new SAP GTS is here! Whether you’re performing a greenfield implementation or migrating from legacy SAP GTS, get the edition for SAP HANA up and running. Learn the ins and outs of the system, from activating SAP Fiori apps to customizing baseline settings and master data. See how to configure core processes, step by step: compliance management, customs management, and trade preference management. With details on reporting and migration, this is your all-in-one guide to global trade!

[Learn More](https://www.sap-press.com/implementing-sap-global-trade-services_5789/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2505_chapter9&utm_content=2505)

![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg)

**by [SAP PRESS](https://blog.sap-press.com/author/sap-press)**

SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP IBP, intelligent technologies, SAP Business Technology Platform, and more!

[Logistics](https://blog.sap-press.com/tag/logistics)

[![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.sap-press.com%2Fan-overview-of-sap-gts-reporting-with-sap-bw%2F4hana%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](https://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.sap-press.com%2Fan-overview-of-sap-gts-reporting-with-sap-bw%2F4hana%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.sap-press.com%2Fan-overview-of-sap-gts-reporting-with-sap-bw%2F4hana%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.sap-press.com%2Fan-overview-of-sap-gts-reporting-with-sap-bw%2F4hana%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check+out+https%3A%2F%2Fblog.sap-press.com%2Fan-overview-of-sap-gts-reporting-with-sap-bw%2F4hana%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.sap-press.com%2Fan-overview-of-sap-gts-reporting-with-sap-bw%2F4hana%3Futm_medium%3Dsocial%26utm_source%3Demail)

### Comments

### Latest Blog Posts

[![Plug-In Settings for GTS in SAP S/4HANA](https://blog.sap-press.com/hs-fs/hubfs/Plug-In%20Settings%20for%20GTS%20in%20SAP%20S4HANA.png?height=600&name=Plug-In%20Settings%20for%20GTS%20in%20SAP%20S4HANA.png)](https://blog.sap-press.com/plug-in-settings-for-gts-in-sap-s4hana)

[Logistics](https://blog.sap-press.com/tag/logistics)

## [Plug-In Settings for GTS in SAP S/4HANA](https://blog.sap-press.com/plug-in-settings-for-gts-in-sap-s4hana)

[Read More](https://blog.sap-press.com/plug-in-settings-for-gts-in-sap-s4hana)

[![Migrating from SAP WM to Embedded EWM in SAP S/4HANA](https://blog.sap-press.com/hs-fs/hubfs/Migrating%20from%20SAP%20WM%20to%20Embedded%20EWM%20in%20SAP%20S4HANA.png?height=600&name=Migrating%20from%20SAP%20WM%20to%20Embedded%20EWM%20in%20SAP%20S4HANA.png)](https://blog.sap-press.com/migrating-from-sap-wm-to-embedded-ewm-in-sap-s/4hana)

[Logistics](https://blog.sap-press.com/tag/logistics)

## [Migrating from SAP WM to Embedded EWM in SAP S/4HANA](https://blog.sap-press.com/migrating-from-sap-wm-to-embedded-ewm-in-sap-s/4hana)

[Read More](https://blog.sap-press.com/migrating-from-sap-wm-to-embedded-ewm-in-sap-s/4hana)

**Subscribe to our blog!**Get notified about future blog updates.

- <https://www.facebook.com/sappress>
- <https://twitter.com/sappress>
- <https://linkedin.com/company/sap-press>
- <https://www.instagram.com/sap_press/>
- <https://blog.sap-press.com/rss.xml>

### The official SAP PRESS Blog

As the world’s leading SAP publisher, SAP PRESS’ goal is to create resources that will help you accelerate your SAP journey. The SAP PRESS Blog is designed to provide helpful, actionable information on a variety of SAP topics, from SAP ERP to SAP S/4HANA. Explore ABAP, FICO, SAP HANA, and more!

### SAP Blog Topics

- [All Topics](https://blog.sap-press.com)
- [Logistics](https://blog.sap-press.com/tag/logistics)
- [Programming](https://blog.sap-press.com/tag/programming)
- [FICO](https://blog.sap-press.com/tag/fico)
- [Administration](https://blog.sap-press.com/tag/administration)
- [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence)
- [What Is?](https://blog.sap-press.com/tag/what-is)
- [Featured](https://blog.sap-press.com/tag/featured)
- [CRM & Sales](https://blog.sap-press.com/tag/crm-sales)
- [Video](https://blog.sap-press.com/tag/video)
- [Human Resources](https://blog.sap-press.com/tag/human-resources)

### Blog curated by

[![Rheinwerk Publishing & SAP PRESS Logo](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://sap-press.com) [Visit the SAP PRESS Store](https://sap-press.com)

### About

- [Home](https://sap-press.com/)
- [About Us](https://sap-press.com/the-publisher/)
- [Contact](mailto:info@rheinwerk-publishing.com)
- [Legal Notes](https://sap-press.com/legal-notes/)
- [Privacy Policy](https://sap-press.com/privacy/)
- [Terms of Use](https://sap-press.com/terms/)
- [Guest Posting](https://blog.sap-press.com/guest-posting)

© 2026 Rheinwerk Publishing, Inc. | Change Privacy Options

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "SAP PRESS",
    "url" : "https://blog.sap-press.com/author/sap-press"
  },
  "dateModified" : "2026-04-02T12:41:10.320Z",
  "datePublished" : "2019-11-18T13:15:00.000Z",
  "headline" : "An Overview of SAP GTS Reporting with SAP BW/4HANA",
  "image" : [ "https://blog.sap-press.com/hubfs/An%20Overview%20of%20SAP%20GTS%20Reporting%20with%20SAP%20BW4HANA.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.sap-press.com/an-overview-of-sap-gts-reporting-with-sap-bw/4hana",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.sap-press.com/hubfs/Logo-1.jpg"
    },
    "name" : "Rheinwerk Publishing, Inc."
  }
}
```