Uncover invisible SAP test data to recover costs

May 07, 2020
Written by Daniel Parker

With more than 15 years of SAP experience, Daniel Parker specialises in data copy automation and data security. He leads an experienced consulting team, and delivers a variety of landscape solutions to organisations in the APJ region.

Uncover invisible SAP test data to recover costs
Save costly space in SAP test systems by cleaning up technical tables

To reduce the volume of data in SAP test system landscapes, we’ve used innovative techniques with our Data Sync Manager™ suite for a long time. The simplest technique we use is to exclude the many technical logging and content tables in the data copy. This reduces space nicely for the majority of our clients. However, not all apply the same reduction approach back to the source of the problem: production.

System Landscape

Consider a typical ERP or S/4 system landscape. The production SAP database will exist as a full copy additional times across your complete infrastructure. While block level deduplication in SAN and Backup systems will help to reduce this overhead, with even a conservative estimate we can assume that every 1GB of production database used is replicated up to five times across the entire environment. This assumption holds regardless of the hosting approach – on-premise, cloud or hybrid.

SAP Database5

The following typical example System Analysis from a ~1TB ERP system shows that the top four of ten largest tables in the system are all prime targets for technical data reduction. The top four tables contain application logs, change documents, DB table change logs and IDOCs. Each of these can typically be simply removed or archived with no impact on business processes in the system.



Let’s extrapolate the potential cumulative storage saving from this example:

  • Top four tables consumed space in production: ~84GB
  • If we assume a 90% data reduction is possible, then ~75GB can be removed
  • Applying our general 1:5 rule gives the potential of ~375GB reduction in storage across the entire environment.

With a production database size of ~1TB, the potential of 375GB in space saved across the environment is significant. This could be the difference between an expensive SAN update planned for the current quarter happening now, or being moved to next year.

Our example covers just one system type. This same approach can be applied to other common SAP system types such as BW, PI, Gateway and Solution Manager, often with similar results.

EPI-USE Labs’ expert service delivery team can help you identify these technical table clean-up opportunities. Our consultants can build you an action plan detailing the steps to reduce data in problem tables like this example. Our teams are also available to perform the clean-up and reduction process for you.


TDM Questionaire CTA



Explore Popular Tags

Data Sync Manager Test Data Management News SAP Transformation s/4HANA technology SAP migration Cloud Cloud Migration Insider Managed Services Object Sync S/4HANA Migrations SAP S/4HANA data copy data testing Automation Data Secure Digital tranformation SAP Cloud Deployment SLO cloud hosting sap testing Brownfield Client Sync DSM solution ERP S/4 S/4 system landscape SAP S/4HANA Assessment SAP data SAP system copy SAP test data management Sandbox Upgrade Video Webinar data scrambling landscape transformation ALM Accurate test data Acquisition Agile BW, Big data and IA C/4HANA CRM experience Cloud Solutions Control Center Controller Customized service DSM DSM Readiness Assessment DSM5 Data Privacy Data Sync Manager (DSM) Data access Data agility Data minimisation Data visibility DevOps ECATT Event Flexible framework GDPR Greenfield Hybrid cloud IDOCs IT Improved productivity and efficiency Infotype 41 Lean secure SAP Managed Refresh Services Migration PI Pilot Premium Support Services Production ERP Production system Reliable Releases S/4HANA version 1709 S4HANA SAN SAP BW SAP Basis SAP IS-U SAP Landscape SAP SuccessFactors SAP SuccessFactors Employee Central Payroll SAP TDMS SAP client copy SAP customers SAP data migration SAP data privacy & security SAP environment SAP environments SAP experts on call SAP landscape design SAP roadmap for IS-U SAP system refresh SAP system types SAP systems SAP test system landscapes SAP test systems Solman Solution Manager Success Story System Analysis System Landscape Optimization System conversion TDM Tailored expertise big data analysis business goals content tables data model data tailored design develop divestiture incremental updates industry sectors masking rules mergers new functionality predictive analysis production SAP database quality of test data regression testing release successfactors technical data reductio technical logging technical tables test
+ See More

Get Instant Updates

Leave a Comment: