UD4D — Use data for decisions

Eliminating 27 daily manual SAP extracts with automated Snowflake reporting

We automated the manual SAP extracts behind daily operations, so teams get shift-ready data without the repeated manual refresh.

Get in touch Download PDF
Eliminating 27 daily manual SAP extracts with automated Snowflake reporting

About the client

Global pharmaceutical company running plant maintenance and manufacturing operations across multiple production sites.

The challenge

The client depended on manual, Excel-based extracts from SAP S/4HANA to run plant maintenance and operational reporting.

  • Manual export of 9 SAP transaction codes, each run three times per day, totaling 27 extracts daily
  • Dependence of 50+ users on these reports for shift planning and daily operations
  • Manual refresh of data before every shift, creating an operational bottleneck
  • Inability to ingest SAP transaction codes directly, as they carry embedded business logic

The solution

UD4D built a fully automated Snowflake data platform that replicates SAP transaction logic and replaces every manual extract.

  • Ingestion of roughly 50 SAP S/4HANA source tables required to rebuild the reporting logic
  • Replication of all 9 SAP transaction codes natively in Snowflake, across plant maintenance, procurement and controlling, manufacturing, and inventory management
  • Data Vault modelling for ingestion and Coalesce for transformation
  • Dynamic Tables for scheduled, automated refresh without manual intervention
  • A tiered refresh strategy: master data daily, transactional data three times daily before each shift, large tables via incremental loads on change date

Business impact

  • 27

    daily manual extracts eliminated

    Automated ingestion, transformation, and delivery in Snowflake replaced 27 daily SAP T-code exports and all associated file handling.

  • 50+

    users on shift-ready data

    Reports now refresh automatically before every shift, so 50+ users work from consistent, up-to-date data without any manual pre-shift refresh.

  • 9

    SAP transaction codes rebuilt natively

    All nine T-codes were replicated in Snowflake across maintenance, procurement, controlling, manufacturing, and inventory, creating a single source of truth for operational reporting.

  • 3

    scheduled refreshes per day

    Transactional data refreshes three times a day on an architecture that extends to additional reports and domains without new manual effort.

Frequently asked questions

What was the challenge?

Plant-maintenance and operational reporting depended on manual, Excel-based extracts from SAP S/4HANA: nine transaction codes exported three times a day, 27 extracts daily.

How did UD4D solve it?

By building a fully automated Snowflake platform that ingests around 50 SAP S/4HANA tables and natively replicates the nine SAP transaction codes, using Data Vault modeling and Coalesce for transformation.

How is the data kept up to date?

Snowflake Dynamic Tables handle scheduled, automated refresh with a tiered strategy: master data daily, transactional data three times a day before each shift, and large tables via incremental loads.

What were the results?

All 27 daily manual extracts were eliminated, 50+ users get shift-ready data automatically, nine SAP transaction codes were rebuilt natively, and data refreshes three times a day.

Related case studies