Corporate project · Industrial manufacturer · In use
Permission-Controlled HR Analytics Portal Fed Live from SAP
An HR portal that calculates headcount, turnover, overtime, leave and severance liability from SAP's own records. Salary data is visible only to authorised roles, and management gets a simple summary page.
- SAP integration
- Dashboard
- Web app
- Data privacy
- 0 differencesin a field-by-field check against live SAP
- 1 serviceone SAP call returns all HR data
- 30 minautomatic refresh during working hours
- Role-basedsalary fields only for authorised roles
- 1SAP HROne service, one JSON
- 2Snapshot storeSQL, on a schedule
- 3PermissionsLogin and role checks
- 4HR screensHeadcount · overtime · leave · severance
- 5Management summaryOne page
- Headcount
- Turnover
- Overtime
- Leave & quotas
- Severance liability
- Salary for authorised roles only
Built for an industrial company. For confidentiality, the company name, logo, product/part codes and internal data are not shared; images are cropped accordingly. Personal and company names have been replaced in the images; pay data is not shown. Headcounts, rates and unit names are hidden. The diagrams are illustrative.
The need
The portal's first version queried SAP on every page and was slow. Some figures came from the wrong fields: hire date, overtime hours and the severance cap. Some data endpoints were open without login.
The solution
- One SAP function returns staff, overtime, leave, quotas, organisation and payroll results as a single JSON.
- Data is kept in a SQL snapshot store on the server and refreshed on a schedule; a badge shows how fresh it is.
- Severance liability uses the legal cap read live from SAP; apprentices are excluded.
- Payroll close rule: a month's payroll is posted on the 6th–10th of the next month, so open months are left out of calculations.
- A manager rule for units with several chiefs, confirmed with HR.
- Login and permission checks on every endpoint, self-service password change, a summary page for management only.
- SAP-derivable indicators from the old report server were folded into the existing HR pages instead of a separate report page.
Delivered
- Live HR portal
- SAP HR read service (ABAP RFC)
- Management summary page
- Data-quality list for HR
Technologies
- Next.js 14
- React
- TypeScript
- SQL Server
- SAP HCM (PA/PY)
- ABAP RFC
- SOAP