Corporate project · Industrial manufacturer · Completed · in use

SAP Reporting, ABAP Development and Management Dashboards

Custom ABAP reports fed directly from SAP, a comparative dashboard that automatically merges monthly SAP effort and budget reports, and Power BI reporting for management.

SAP / ERP
Reporting
Dashboard

5+custom ABAP reports
642 linesquote performance report
9+ monthsof reports in one dashboard
Power BImanagement reports

Illustrative ABAP report skeleton

REPORT z_quote_performance.

SELECT-OPTIONS: s_region FOR gv_region,
                s_date   FOR sy-datum.

START-OF-SELECTION.
  PERFORM collect_data.     " quotes + orders
  PERFORM summarise_region. " conversion rate
  PERFORM show_alv.         " Excel-ready list

Built for an industrial company. For confidentiality, the company name, logo, product/part codes and internal data are not shared; images are cropped accordingly. The code snippet is illustrative; real source code is not shared.

The need

The numbers management needs are in SAP but not on standard screens; merging spreadsheets by hand every month is slow and error-prone.

The solution

Region-based quote performance (as a background job), delivery and e-ledger reports.
Material master data maintenance check and an HR leave approval screen.
Automation that merges monthly SAP activity reports into one workbook with charts.
SAP Query for user-specific queries; Power BI management dashboards.

Delivered

ABAP reports
Effort and budget dashboard
User training

Technologies

SAP ABAP
SAP Query (SQ01/SQ02)
Python
Node.js
Excel
Power BI

Related services