BI for
SAP

Power BI on top of SAP S/4HANA or ECC, with data replicated outside production and financial, tax and operational indicators in a single model.

Data extraction amico

BI FOR SAP S/4HANA AND ECC

From FI to SD, SAP data ready for analysis

The beAnalytic takes the data from SAP to an analytical model in Power BI, using table replication, CDS views or SAP Datasphere, depending on the company’s environment and licensing. Every business rule is documented, from the order to the accounting entry.

Signs that your SAP needs BI: the team exports reports to Excel every month, each group company closes the numbers its own way, tax analyses depend on ledgers and invoices extracted by hand and heavy queries compete for resources with operations.

For other systems, see BI for ERP. We also work with Energy and Manufacturing.

HOW IT WORKS

Our process

01

Diagnosis

We establish the version (ECC or S/4HANA), the modules in use, the customizations and the extraction methods the environment and license allow.

02

Secure extraction

Incremental table replication or reading via CDS views, without heavy queries on the production environment.

03

Modeling

VBRK, VBRP and ACDOCA become billing and accounting facts; KNA1, MARA and the organizational structure become dimensions.

04

Dashboards and ongoing support

Power BI with access by company and profit center, load monitoring and continuous evolution.

Integration Robots
+ 0
DASHBOARDS BUILT
+ 0
INTEGRATED SYSTEMS
+ 0

When SAP needs more than the standard reports

SAP case: tax dashboards for a bioenergy group

The company

Bioenergy group with ethanol operations, several companies in the same group and an SAP ERP.

The problem

The tax team needed to compare month over month and year over year more quickly. The data came from SAP reports, such as the tax ledger and inbound and outbound invoices, and there was no dedicated team to replicate ERP tables.

The solution

We built tax dashboards on top of the SAP data, including ICMS exclusion and projection, with tables replicated to SAP Datasphere and filters by group company.

COMMON SAP PITFALLS

Why the SAP number doesn't match the report

  • Client (mandant): the tables carry the MANDT field, and mixing clients duplicates records.
  • Currencies: the same document has values in the document currency and in the local currency; adding the wrong field distorts the result.
  • ECC and S/4HANA: in S/4HANA, accounting lives in ACDOCA; in ECC, in BKPF and BSEG. Changing version changes the model.
  • Brazilian invoices: sit in localization tables, such as J_1BNFDOC and J_1BNFLIN, separate from billing.
  • Organizational structure: company, plant, sales area and profit center need to be mapped before any indicator.

Sales (SD)

VBAK and VBAP for sales orders, LIKP and LIPS for deliveries, VBRK and VBRP for billing.

Purchasing and inventory (MM)

EKKO and EKPO for purchase orders, MARA for materials and MARD for inventory by warehouse.

Finance (FI)

ACDOCA in S/4HANA, or BKPF and BSEG in ECC, with KNA1 and LFA1 for customers and vendors.

Tax

J_1BNFDOC and J_1BNFLIN for invoices and taxes per document.

Indicators by area

What Power BI delivers on top of SAP

Finance

Accounts receivable by due date, actual versus forecast cash flow and delinquency by customer.

Sales

Billing by customer, material and sales area, order backlog and margin.

Supply

Inventory turnover and coverage by plant and warehouse, purchase lead time and savings.

Controllership

Management income statement by profit center, budget versus actual and month-over-month tax analyses.

Frequently asked questions

Questions about BI for SAP

Can you connect Power BI directly to SAP?

Connectors exist, but for recurring analyses we recommend an intermediate model with replicated data. It avoids load on production and handles currencies, client and organizational structure once and for all.

Does it work with ECC and S/4HANA?

Yes. The model changes from one version to the other, mainly in accounting, and the diagnosis defines the path for the company's version.

Do you work with SAP Datasphere?

Yes. We have already built dashboards with SAP tables replicated to SAP Datasphere, and we also work with other replication methods, depending on the environment.

Does data access affect SAP licensing?

It can, depending on the contract. That is why the diagnosis checks with the IT team which access methods the company already has licensed.

Do you deploy or customize SAP?

No. We are data specialists and work alongside the company's IT team or SAP consultancy.

How long until the first dashboard?

The diagnosis defines scope and timeline. We start with one area, such as finance or tax, to deliver value quickly.

Testimonials

What our
clients say

Our integrations

We have already integrated and extracted data from 200+ systems

We innovate in analytics solutions so that our clients are the best

Leave your contact details so our specialists can reach you

I agree that beAnalytic may store my contact details for the purpose of a scheduled meeting and its follow-up. I also agree that my data may be used for direct advertising and to initiate contact in connection with the products and services offered by beAnalytic. I may withdraw this consent at any time by emailing [email protected]

logo rodape e1717620051753
logo 100OS
beAnalytic Parceira Google Cloud

São Paulo, SP
Tv. Dona Paula, 13 – Higienópolis

Natal, RN
Rua Paulo Barros de Góes, 1840 – Sala 504 – Lagoa Nova

Fortaleza, CE
Av. Dom Manuel, 1020 – Centro

© 2026 beAnalytic – All rights reserved | [email protected] | +55 11 93618-3371

Logo beAnalytic

Machine
Learning

Com a consultoria em Machine Learning da beAnalytic, a nossa equipe fica responsável por:

Mapeamento, coleta e tratamento dos dados necessários para o projeto;

Definição do algoritmo apropriado com base nos objetivos do projeto, e início do treinamento do algoritmo;

Avaliação do desempenho do modelo de ML, otimização e implementação no ambiente de produção.

A