Data Management for SAP Business Suite and SAP S/4HANA

1 Robert Wassermann, SAP SEData Management for SAP Business Suite and SAP S/4 HANA 2015 SAP SE or an SAP affiliate company. All rights presentation outlines our general product direction and should not be relied on in making a purchase decision. This presentation is not subject to your license agreement or any other agreement with SAP. SAP has no obligation to pursue any course of Business outlined in this presentation or to develop or release any functionality mentioned in this presentation. This presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.

2 This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent. 2015 SAP SE or an SAP affiliate company. All rights Management for SAP Business Solutions -OverviewSAP data Aging Overview RoadmapData Archiving -OverviewInformation Lifecycle Management (ILM) Overview InnovationsPublicData Management for SAP Business Solutions Overview 2015 SAP SE or an SAP affiliate company.

3 All rights Business Solutions in ScopeOn-Premise EditionCloud EditionSuite on anyDBSuite on HANASAP HANASAP HANASAP HANAanyDBSAP S/4 HANA SAP Business Suite 2015 SAP SE or an SAP affiliate company. All rights Management for SAP Business Solutions in ScopeData TemperatureSolution / FeatureStorage Technology BusinessSuite S/4 HANAB usiness ValuePossible Actionsany DBHANAOn-Premise EditionCloud EditionDataAgingHot / CurrentSAP HANA in-Memory 1 Optimizing the HANA data footprintHot / Current Active/ operationally-relevant data stored within HANA memory. Hot data is frequently accessed and has higher performance requirements.

4 Write, Read, Update, DeleteData Aging Cold / HistoricalSAP HANAon disc 1 Optimizing the HANA data footprintCold / HistoricalDatawhich is closed/cleared and is moved to cold partitions on disk Write, Read, DeleteArchived data (ADK) + SAP ILMRMS eparate WORM, diskor DBfile-based storage 2 2 HANA Enabler & data Volume ManagementData which is readonly/infrequently accessed (historical) is moved to ADK files (enriched with retention time) on a secure long-term storage (important before migrating to SAPB usiness Suite on HANA or SAP S/4 HANA)Write,Read Destruction function available using SAP ILM Generally available Not available Different solution approach1 Available for selected basis objects only2In S/4 HANA Finance only partially availablePublicData Aging -Overview 2015 SAP SE or an SAP affiliate company.

5 All rights Aging for SAP Business Suite on HANA and SAP S/4 HANAData Aging is a Business data Management concept for reducing the HANA memory footprint Only operationally relevant ( hot or current ) data is loaded into HANA main memory Other ( cold or historical ) data remains primarily stored on disk, not affecting current data performance, yet historical data remains accessible via SQL on request 2015 SAP SE or an SAP affiliate company. All rights Aging for SAP Business Suite on HANA and SAP S/4 HANA Reducedmemoryfootprint Shorter loadtime Fasterprocessing Nodeltamergeforuntouchedpartitions+ SQL !Loadsall dataConsiders only partitions neededLoads page-wiseData Aging is a Business data Management concept for reducing the HANA memory footprint only operationally relevant ( hot ) data is loaded into HANA main memory other ( cold ) data remains primarily stored on disk, not affecting hot data performance, yet cold data remains accessible via SQL on request 2015 SAP SE or an SAP affiliate company.

6 All rights Management Evolution Archiving, SAP ILM, and data Aging in S/4 HANA SAP S/4 HANAC ompliant ArchiveCompliant ArchiveArchiveClassic ArchivingSAP Business SuiteSAP ILMSAP Business SuiteData AgingHot/CurrentCold/HistoricalFrozenSAP ILMF ootprintreductionpotential estimatedbysizingreport(SAP note1872170) Way forward >> 2015 SAP SE or an SAP affiliate company. All rights by Application-Defined TemperatureAdditional genericAgingcolumnforhorizontal partitioning Insert Agingvalue(temperature) duringagingrun TomoveclosedobjectsfromHOT toCOLD Tosupportpartitionpruning Same valueforall recordsofobject ABAP data type: DATA_TEMPERATURE(DATS) COLD partitions Manyofthem Mappedtopage-loadablecolumns(aka pagedattributes) NouniquenessenforcementbyDB SQL accessibleUpdate toColdHot PartitionColdPartition(s)AgingKeyColdCol dColdColdColdAgingKey 2015 SAP SE or an SAP affiliate company.

7 All rights Management Strategy for SAP Business Suite on HANA and SAP S/4 HANAOver the last couple of years SAP has been evaluating how to optimize the overall data Management for SAP Business Suite on HANA. Moving forward, our data Management strategy will be based on two corner stones: For SAP Business Suite on HANA and SAP S/4 HANA our proven and well-established standard data Archivingis the basis for data Management . Customers can finally delete data using information destruction by SAP Information Lifecycle Management . Additionally DataAginghelps customers optimize storage costs of technical Business objects such as IDOCs and application logs.

8 data Aging is the standard data Management approach for newly developed HANA-based applications like SAP S/4 HANA Finance. PublicData Aging -DemoData Aging -Roadmap 2015 SAP SE or an SAP affiliate company. All rights for SAP data AgingPlanned innovationsFuture directionCurrent InnovationsReduce system complexity and costCloud ReadinessBig data ReadinessCut datavolumeFramework Parallelization Enhancement ConceptAging Objects IDocs Application Logs Change Documents Workflow FI DocumentFramework Cloud Qualities for S/4 HANA Proposal for partition Ranges Support for Aging RulesAging Objects Basis Application 2015 SAP SE or an SAP affiliate company.

9 All rights data Aging Objects 1 Basis available SAP Business Suite on HANA and SAP S/4 HANA2 Application SAP S/4 HANA onlyApplication Log1 IDocs1 Change Docs1 Workflow1FI Document2 SPS 12 SAP Simple Finance add-on SPS SPS 08 SPS 12 2015 SAP SE or an SAP affiliate company. All rights for data AgingMonitor Database Table Growth Visualizetop N tableson different tablegrowthcriteriaandtime intervals: Numberofrecordsfortablesandpartitions Growth rate fortablesin percentage Identifycriticaltableswhicharenot coveredbydataagingobjectsMonitor data Aging Objects Representationoftherecordsin hotandcold Activate inactivedataagingobjectsManage data Aging Groups Monitor and track the data aging jobs , data distribution across partitions are optimal Avoid partition table overflows, be alerted in case of error situations 2015 SAP SE or an SAP affiliate company.

10 All rights for SAP data AgingPlanned innovationsFuture directionCurrent InnovationsFramework Parallelization Enhancement ConceptAging Objects IDocs Application Logs Change Documents Workflow FI DocumentFramework Cloud Qualities for S/4 HANA Proposal for partition Ranges Support for Aging RulesAging Objects New Aging ObjectsReduce system complexity and costCloud ReadinessBig data ReadinessCut datavolume 2015 SAP SE or an SAP affiliate company. All rights Aging Objects Planned2 Application SAP S/4 HANA onlyMM Material Document2MM Purchase Order2SD Sales Order2SD Billing Document2PP Production Order2LE Delivery2FI Unified Journal Entry2 2015 SAP SE or an SAP affiliate company.