Uncover invisible SAP test data to recover costs

07 May 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.

 

tables

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.

 

Data Analysis assessment

 

 

Explore Popular Tags

SAP S/4HANA Test Data Management Data Sync Manager S/4HANA Migrations SAP SAP migration Data Sync Manager (DSM) Archive Central Object Sync SAP test data management Brownfield DSM Data Secure News Transformation s/4HANA technology EPI-USE Labs SAP data Automation Client Sync Cloud Cloud Migration Decommissioning ERP Greenfield Insider Managed Services SAP Landscape SAP environment SAP systems data copy data scrambling data testing Data Archiving Digital transformation Hybrid PRISM S/4 S/4 system landscape S4HANA SAP Cloud Deployment SAP RISE SAP S/4HANA Assessment SAP SuccessFactors SAP TDMS SAP data privacy & security SLO Sandbox Selective Data Transition (SDT) Sunsetting legacy data Upgrade cloud hosting quality of test data sap testing ALM Accurate test data Agile Archive Cloud Solutions DSM solution Data Privacy Data Security DevOps Display only Governance, Risk Management and Compliance (GRC) Lean secure SAP Legacy PRISM free assessment Production system Rise with SAP SAP Landscape Transformation SAP Road maps SAP SuccessFactors Employee Central Payroll SAP certified solution SAP client copy SAP data migration SAP data privacy and compliance SAP system copy SAP test system landscapes Sunsetting System Analysis TDM Video Webinar cloud environment landscape transformation ABAP Acquisition BW, Big data and IA C/4HANA CRM experience Control Center Controller Copy and mask test data Croatia Croatian kuna to euro conversion Customized service DSM Readiness Assessment DSM for HCM DSM5 Data access Data agility Data footprint Data masking Data minimisation Data privacy compliance Data privacy regulations Data visibility Design Thinking EC ECATT EPI-USE Employee Central Europe Eurozone Event Flexible framework GDPR Hybrid SAP SuccessFactors environment Hybrid SAP and SuccessFactors Hybrid cloud Hyperscaler IDOCs IT Improved productivity and efficiency Infotype 41 Managed Refresh Services Migration OData API PCE PCE XXS PI Pilot Premium Support Services Production ERP Production data Reliable Releases S/4 Hana migrations S/4HANA Private Cloud Edition (PCE) S/4HANA version 1709 SAN SAP AppHaus Network SAP Archive Extractor technology SAP BW SAP Basis SAP HCM SAP HCM Data SAP HR SAP IS-U SAP cloud migrations SAP customers SAP data copying and masking SAP environments SAP experts on call SAP landscape design SAP on AWS SAP roadmap for IS-U SAP system refresh SAP system types SAP test systems SAP-certified SAPinsider Secure scrambled production data for testing Solman Solution Manager Success Story SuccessFactors System Landscape Optimization System conversion Tailored expertise User Experience XXS archiving big data analysis business goals content tables data model data tailored design develop divestiture incremental updates industry sectors masking rules mergers multiple clients new functionality predictive analysis production SAP database regression testing release strategy technical data reductio technical logging technical tables test test data masking
+ See More

Get Instant Updates


Leave a Comment: