- Home
- SAP automation
- SAP reporting
SAP reporting runs on CDS views in S/4HANA and on HANA views in Business One for HANA
Each SAP ERP reports its own way. S/4HANA reads live data through CDS views and shows it in Fiori apps; in S/4HANA Cloud Public Edition, SAP Analytics Cloud runs underneath. SAP Business One, version for SAP HANA, reports from views in its HANA database, through the Query Generator, Crystal Reports and an Excel add-in.
S/4HANA reports read live data, with no copy
S/4HANA reports on the same tables your team posts to. SAP Learning calls this embedded analytics: operational reporting on live transaction data. In the past, data was copied from the transaction system into a separate analytics system. S/4HANA copies no data.
The layer in between is the virtual data model. It is built from CDS views, which are SAP’s views over the raw tables. SAP ships thousands of them, so finding the right one takes time. SAP says embedded analytics serves the day-to-day work of a business. It does not focus on strategic analytics.
SAP names three kinds of report users in S/4HANA:
- The IT user builds CDS views, new apps and planning functions.
- The key user builds queries, reports, KPIs, dashboards and tiles, and helps others find them.
- The end user reads the data and acts on it.
Which S/4HANA app answers which reporting need
SAP Learning names one Fiori app for each step, most of them in its S/4HANA Cloud Public Edition course. Fiori is SAP’s set of standard apps, all with one design.
Scroll the table sideways to see every column.
| You want to | The app SAP names | What SAP says |
|---|---|---|
| Find a data view | View Browser | Lists every CDS view, SAP’s and your own |
| Change or build a view | Custom CDS Views | Can also generate an OData API, so outside apps can read the fields |
| Run a query | Query Browser | Runs it in the Web Dynpro Grid tool |
| Build a query | Custom Analytical Queries | Copies a query, or builds one from scratch |
| Make KPIs, reports and stories | Manage KPIs and Reports | Copy SAP’s items first. Only items on released views can be copied |
| Look at data with no model | Data Analyzer | Runs on SAP Analytics Cloud |
| See financial statements | Balance Sheet/Income Statement (Multidimensional) | Drills to line items, and exports to Excel or PDF |
| Start a sales rep’s day | My Sales Overview | Shows open quotations and incoming orders by month |
Review booklets are the newer form of multidimensional reports, with a more modern look than the old Web Dynpro apps.
Four rules shape any build:
- In S/4HANA Cloud, CDS views are built with graphical tools only.
- On-premise S/4HANA also allows code. ABAP Development Tools for Eclipse create a CDS view from database tables.
- No Fiori tool makes a CDS view from scratch. The Fiori tools always start from an existing view.
- In S/4HANA Cloud Public Edition, custom views, queries, KPIs and reports are built in the development tenant first. Then they move to test and production.
Analytical queries also work outside Fiori. SAP names SAP Analytics Cloud and SAP BusinessObjects as tools that can use them.
Classic list reports such as ME2L still run
Not every S/4HANA report is a new Fiori app. Buyers still use list displays to watch open purchase orders. SAP’s purchasing course names two:
- ME2M lists purchasing documents by material.
- ME2L lists them by vendor.
Enter the WE101 selection parameter and limit the delivery dates to the period you want to check. Both have Fiori apps: Display Purchasing Documents by Material, and by Supplier. So a buyer who learned the old codes and one who only knows Fiori can run the same list. Our page on SAP purchase orders covers the buying side.
SAC runs under S/4HANA Cloud Public Edition’s reports
In S/4HANA Cloud Public Edition, SAP Analytics Cloud (SAC) is the engine under the embedded reports. It runs through a live connection. No second login. Customers cannot log into that copy directly, and use it through Fiori apps.
SAC is also its own SAP product. SAP says it connects natively to SAP Datasphere and SAP S/4HANA. SAP Learning says it runs as software as a service. SAP hosts and updates it in its own data centers. Where your data goes depends on your database:
- SAP HANA on premise. SAC reads company data through a reverse proxy. The data stays in the company.
- Other databases. Data is copied to the cloud and leaves your network.
In S/4HANA Cloud Public Edition, stories that combine data from other SAP cloud products, such as SuccessFactors, need an Enterprise license to SAC.
For finance, SAP delivers a Digital Boardroom. It shows this year and last year, with finance KPIs grouped under growth, profitability and liquidity.
Business One on SAP HANA reports from a semantic layer
SAP Business One, version for SAP HANA, reports from a semantic layer: views in its HANA database. A view hides the underlying tables and the joins, SAP Learning says. Business One also runs on Microsoft SQL Server. SAP’s Service Layer guide says the semantic layer views are for the SAP HANA version only.
On the HANA version, you read the views in several ways:
- SQL. The Query Generator and Crystal Reports both read the views with SQL queries.
- Excel. The Excel Report and Interactive Analysis add-in builds reports and analyses on the views.
- Cockpit widgets. Pervasive dashboards, KPIs and advanced dashboards sit in each user’s cockpit.
- The Analytical Portal. It publishes reports in a web browser. Users can schedule a report and send it by email.
Five rules from SAP Learning shape that setup:
- The company database must first be set up in the Business One Analytics Administration Console.
- Every user needs a Business One license fit for the data they read, plus rights to the semantic layer.
- Crystal dashboards need a separate Crystal Designer license. They are built outside Business One and imported.
- Crystal reports reach the portal only after import as .rpt files, through the Report and Layout Manager.
- The portal runs in Edge, Chrome, Firefox and Safari. Internet Explorer is not supported.
A pervasive dashboard can show between 5 and 300 top values. It can also run a strategy type on the chart: ABC Analysis, K-means Clustering, or Forecast, which works only on charts with date dimensions.
AI in SAP reporting today
SAP’s reporting AI differs by product.
- Business One. Feature package 2608 added AI-written SQL to the Web client’s User-Defined Queries app. You describe the data in plain words and the AI drafts the query. SAP says the actual records are never sent. The audit log records your prompts, the AI’s answers and usage data. SAP’s setup steps begin with a pay-as-you-go SAP BTP account. The same AI cannot read Business One data.
- SAP Analytics Cloud. SAP says Joule can automate reporting there. Users can ask questions in natural language and get answers from governed data.
- S/4HANA Cloud Public Edition. Embedded machine learning uses SAP HANA libraries such as the APL and the PAL. SAP Learning says the APL is for business analysts and the PAL is for data scientists. The side-by-side route on SAP’s Business AI Platform needs a separate license.
A reporting agent reads SAP through the doors SAP documents
A custom agent fits when the question starts outside SAP, in an email or a chat, and the answer needs SAP data.
- In S/4HANA, a custom CDS view can generate an OData API. An agent can read just the fields that view exposes.
- In Business One for SAP HANA, the Service Layer exposes the semantic layer views as OData, under their own root URL,
/b1s/v1/sml.svc. Those are the same reporting views described above. - In Business One on SQL Server, from 10.0 PL02 the Service Layer exposes your custom SQL views over OData instead.
- SQL queries. SAP’s guide added SQL Query support to the Service Layer in its version of 28 October 2020.
The Service Layer does not offer the DI API’s RecordSet object. SAP’s guide calls exposed views the alternative. For how an agent signs in to each product, see SAP AI agents. For links between SAP and other systems, see SAP integration.
Our team’s SAP go-lives
Our team has taken three SAP products live: Business One, S/4HANA and ECC. Our team can also run an SAP implementation end to end.
Our team’s data and module work
On the data side, our team has worked on AWS, Azure, Google Cloud and private servers.
Our team has also delivered small ERP modules, each built for one business problem. The first call is free.
Questions
How to pull a report on SAP?
It depends on which SAP you run. In S/4HANA, open the Fiori app for the area, or run an analytical query in the Query Browser app. Classic list reports, such as ME2L for purchase orders by vendor, still work. In Business One, version for SAP HANA, use the Query Generator, a Crystal report or the Excel Report add-in, or open the Analytical Portal in a browser.
What is ME2L used for in SAP?
ME2L lists purchasing documents by vendor. SAP's purchasing course pairs it with ME2M, which lists them by material. Buyers use both to watch open purchase orders: enter the WE101 selection parameter and limit the delivery dates to the period you want. In S/4HANA the Fiori app for ME2L is called Display Purchasing Documents by Supplier.
Can we build our own reports in S/4HANA Cloud Public Edition?
Yes, with graphical tools. Copy an SAP KPI, report or story first, since SAP-delivered ones cannot be edited directly, and only those built on released CDS views or queries can be copied. You build in the development tenant, then move the work to test and production. A brand-new CDS view from database tables needs ABAP Development Tools for Eclipse, a route SAP gives for on-premise S/4HANA.
Do we need SAP Analytics Cloud for S/4HANA reports?
Not for the reports inside S/4HANA Cloud Public Edition. There, SAP Analytics Cloud already runs underneath through a live connection, and you reach it through Fiori apps. Stories that pull data from other SAP cloud products need an Enterprise license to SAC. A separate SAC can also read on-premise S/4HANA on SAP HANA, through a reverse proxy, with the data staying in the company.
Does SAP Business One have AI for reports?
Yes, for writing queries. Feature package 2608 lets a Web client user describe the data in plain words, and AI drafts the SQL in the User-Defined Queries app. SAP says the actual records are never sent to the model. SAP's setup steps begin with a pay-as-you-go SAP BTP account. The AI cannot read Business One data itself.
What does Crystal Reports do in SAP Business One?
On Business One for SAP HANA, it reads the semantic layer views with SQL and lays the results out as reports. Reports are imported into Business One as .rpt files through the Report and Layout Manager. The Analytical Portal then runs them in a browser, on a schedule if you like, and emails them. Crystal dashboards need a separate Crystal Designer license.
What are the 7 stages of a SAP implementation project?
SAP's own method, SAP Activate, has six phases, not seven. SAP says Activate gives road maps and checkpoints across those six phases. SAP Learning adds that the core of the delivery happens between the Prepare and Deploy phases, which it calls the four core phases.
Sources
Every source behind a figure or a vendor fact on this page, with the day we read it.
- SAP Learning, Using SAP S/4HANA reporting optionsRead 19 Nov 2026
- SAP Learning, Describing embedded analytics (S/4HANA Cloud Public Edition)Read 19 Nov 2026
- SAP Learning, Modeling tools of S/4HANA embedded analyticsRead 19 Nov 2026
- SAP Learning, Describing S/4HANA embedded analyticsRead 19 Nov 2026
- SAP Learning, Analytical features of S/4HANA SalesRead 19 Nov 2026
- SAP Learning, Monitoring purchase orders (S/4HANA)Read 19 Nov 2026
- SAP, SAP Analytics CloudRead 19 Nov 2026
- SAP Learning, SAP HANA analytics in SAP Business OneRead 19 Nov 2026
- SAP Help, What's New in Business One 10.0 FP 2608, Web clientRead 18 Nov 2026
- SAP Help, AI in the Business One Web clientRead 18 Nov 2026
- SAP Help, Working with the Business One Service Layer (PDF)Read 18 Nov 2026
- CadenceWorks, SAP AI agentsRead 19 Nov 2026
- SAP, SAP Activate methodologyRead 18 Nov 2026
- SAP Learning, The SAP Activate methodology structureRead 19 Nov 2026
Talk through your SAP reports on a first call
Tell us which SAP product and release you run, and the report your team rebuilds by hand each week. The first call is free.