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.
BI FOR SAP S/4HANA AND ECC
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
We establish the version (ECC or S/4HANA), the modules in use, the customizations and the extraction methods the environment and license allow.
Incremental table replication or reading via CDS views, without heavy queries on the production environment.
VBRK, VBRP and ACDOCA become billing and accounting facts; KNA1, MARA and the organizational structure become dimensions.
Power BI with access by company and profit center, load monitoring and continuous evolution.
Bioenergy group with ethanol operations, several companies in the same group and an SAP ERP.
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.
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
VBAK and VBAP for sales orders, LIKP and LIPS for deliveries, VBRK and VBRP for billing.
EKKO and EKPO for purchase orders, MARA for materials and MARD for inventory by warehouse.
ACDOCA in S/4HANA, or BKPF and BSEG in ECC, with KNA1 and LFA1 for customers and vendors.
J_1BNFDOC and J_1BNFLIN for invoices and taxes per document.
Indicators by area
Accounts receivable by due date, actual versus forecast cash flow and delinquency by customer.
Billing by customer, material and sales area, order backlog and margin.
Inventory turnover and coverage by plant and warehouse, purchase lead time and savings.
Management income statement by profit center, budget versus actual and month-over-month tax analyses.
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.
Yes. The model changes from one version to the other, mainly in accounting, and the diagnosis defines the path for the company's version.
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.
It can, depending on the contract. That is why the diagnosis checks with the IT team which access methods the company already has licensed.
No. We are data specialists and work alongside the company's IT team or SAP consultancy.
The diagnosis defines scope and timeline. We start with one area, such as finance or tax, to deliver value quickly.
Testimonials
Our integrations
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]


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

Machine
Learning