TEC105 SAP HANA Database For SAP Business Suite

TEC105SAP HANA Database for SAP Business SuiteOliver Nocon, SAP AG

DisclaimerThis presentation outlines our general product direction and should not be relied on in making apurchase decision. This presentation is not subject to your license agreement or any other agreementwith SAP. SAP has no obligation to pursue any course of business outlined in this presentation or todevelop or release any functionality mentioned in this presentation. This presentation and SAP'sstrategy and possible future developments are subject to change and may be changed by SAP at anytime for any reason without notice. This document is provided without a warranty of any kind, eitherexpress or implied, including but not limited to, the implied warranties of merchantability, fitness for aparticular purpose, or non-infringement. SAP assumes no responsibility for errors or omissions in thisdocument, except if such damages were caused by SAP intentionally or grossly negligent. 2012 SAP AG. All rights reserved.2

HANA innovation overviewNon-disruptive consumption of innovation12AgilityHANAAccelerators3InsightHANA Analytics(Content & Virtual Data Model)Innovation4 IntegrationHANA Apps(Next Generation &Strategic Investments)Business Suiteon HANASide-by-side scenariosIntegrated scenarioSAPBusiness SuiteAnalyticsAppsVDMPLMSRMHANA DBSCManyDBCRMHANA AppERPERPBWHANA DBAcceleratorHANA DB 2012 SAP AG. All rights reserved.SAP HANA DB3

DemoCustomer Segmentation

Agility like never beforeSAP HANA AcceleratorsNew quality of decisioneffectiveness Fast time to valueClient Increased user efficiency Short implementation timesSAPBusinessSuiteAnyDB No business disruptionSAPHANADBAvailable Solutions 2012 SAP AG. All rights reserved.5

SAP HANA AcceleratorsAccelerate existing applicationsAcceleration by reading from HANA Real-time replication No changes to– UI– Processes Application in control of data access pathBildKey Benefits Faster selection and aggregations Extended functionality possible Non-disruptive for existing customers 2012 SAP AG. All rights reserved.6

DemoWorking Capital Management

Virtual Data Model for SAP Business SuiteEasy-to-use and Extensible AnalyticsClientSpecific ClientsGeneric ClientsHTML5-based UIsSAP Business Objects,3rd partySAPBusinessSuiteAnyDBDirect ReplicationOData, SQL, MDX 2012 SAP AG. All rights reserved.Virtual Data ModelSAP HANADBNew quality of insightfor business decisions Fast and intuitive analysis in real time onprimary data Fine-granular drill-downs without hiddenassumptions Aligned cross applications Protect / leverage investmentsOpen and Extensible Data exposed in consistent way Accessible via standard interfaces SQL level extensibility8

Virtual Data Model for SAP Business SuiteEasy-to-use and Extensible AnalyticsClientSpecific ClientsGeneric ClientsHTML5-based UIsSAP Business Objects,3rd partyConsumptionViewsArea 1ConsumptionViewsArea 2OData, SQL, MDXAnyDBDirect ReplicationSAPBusinessSuiteCustomer ExtensionsVirtual Data ModelPublic ViewsReuse Views (Private)SAP HANADBConsumptionViewsArea nBuilt byCustomerStableInterfaceProvidedby SAPPhysical TablesAvailable Solutions 2012 SAP AG. All rights reserved.9

Layering of ViewsANY VIEWCOST CENTERData Consumption ViewsCOST CENTER COSTSCost Center Master DataCost Center Cost ValuesPublic ViewsCollecting currency codes from cutomizingCCTR COSTS ALLReuse Viewsand master data (incl. period - date conversion)unionCCTR COSTS KSCCTR COSTS KLreplacing object number by buisness keysCOSTS PERIODS EXTDATES OFFISC YEARevaluating customizingfor period - dateconversionjoining tables withCOSTS PERIODSDATES OFF YEAR 1extended key fieldsDATES OFF YEAR 2DATES OFF YEAR 3T009BYEARINDEPT009BYEARDEPunionCOSP PERIODSCOSS PERIODSperiods fromcolumns to rowsCSKSTKA01 2012 SAP AG. All rights reserved.ONRKSONRKLCOSPCOSSCOKEYCOKEY2T009T009BDB tables10

HANA AnalyticsAreas we Focusing on TodayRapid Deployment SolutionsFinancial ReportsLogistics ReportsAnalytical Apps Impl.Analytical ApplicationsWorking Capital ManagementGR / IR ClearingGRC AnalyticsSCM APO AnalyticsVirtual Data ModelERP: FI, CO, SD, MM, PPCRM Sales & MarketingGRC Access Controls GTSSCM Demand Plan 2012 SAP AG. All rights reserved.11

DemoVirtual Data Model

Innovation like never beforeSAP Applications powered by SAP HANABusiness processes on a newlevelClientClient New value in business processes Data driven business processes Superior user experienceSAPBusinessSuiteHANA AppAnyDBSAP HANA DBAvailable Solutions 2012 SAP AG. All rights reserved.13

Innovation and Integration like never beforeApplications on SAP HANASuperior level of competitiveadvantageSAPBusiness Suite Accelerated businessBWApps Business process innovationVDMPLMSRMSCMCRMERP Simplified user experience Simplified IT landscapeSAP HANA DBAvailable Solutions 2012 SAP AG. All rights reserved.14

The technical path to using SAP HANA

HANA accelerators and the virtual data model side by side Start now, this is possibletoday!ClientClientSAPBusinessSuiteVirtual Data ModelAnyDB 2012 SAP AG. All rights reserved.SAP HANADB16

and running even better in place Ensured through design principles for HANA Accelerators and Virtual Data ModelClientSAPBusinessSuiteAnyDB 2012 SAP AG. All rights reserved.ClientClientVirtual Data ModelSAPBusinessSuiteSAP HANADBClientVirtual Data ModelSAP HANA DB17

Technical pre-requisites for side-by side scenariosAs of SAP NetWeaver 7.0 a SAP HANA DBcan be used as secondary DB connection With 7.20 Kernel or higher see SAP Note 1597627 Usage of 7.20 Kernel with NetWeaver 7.x releases see SAP Note 1636252HANA accelerators typically just have aminimum application service packHANA content is for example availablefor SAP ERP 6.0 and SAP CRM 7.0 EHP1 2012 SAP AG. All rights reserved.SAP BusinessSuiteSAP NetWeaver 7.0xSAP Kernel (min. 7.20 PL100)SAP DBSL (min. 7.20 PL100)AnyDBSAPHANADB18

Moving applications to SAP HANAClientClientSAPApplicationSAPApplicationAnyDB 2012 SAP AG. All rights reserved.Smooth DB migrationSAP HANA DB19

Getting the optimum out of your applications with SAP HANAParadigm shift for developersClassical ApproachCalculationHANA ApproachApplicationLayerDatabaseLayer 2012 SAP AG. All rights reserved.Calculation20

Frequently asked question 2012 SAP AG. All rights reserved.21

Answer: 2012 SAP AG. All rights reserved.22

ABAP coding like you know it“Old” ABAP CodeOPEN CURSOR ld cursor FORSELECT *FROM (ls tablenames-tot table)CONNECTION (i dbcon name)WHERE rldnr ld ledgerANDrrcty IN i range rrctyANDrvers IN i range rversANDrbukrs IN i range bukrsANDryear IN i range ryearANDracct IN i range racctANDrtcur IN i range rtcurANDdrcrk IN i range drcrkANDrpmax IN i range rpmaxAND (it where clause)ORDER BY (it orderlist). 2012 SAP AG. All rights reserved.23

Examples for optimizing ABAP code using open SQL“Old” ABAP CodeLeveragethe columnOPEN CURSORld cursorFOR store byselectingSELECT* only required columns!FROM (ls tablenames-tot table)CONNECTION (i dbcon name)WHERE rldnr ld ledgerLeverageSAP HANA capabilitiesANDrrcty IN i range rrctyby selectingfromHANA viewsANDrvers INi range rversANDrbukrs IN i range bukrsANDryear IN i range ryearAND racct IN i range racctDelegateto theANDrtcuraggregationsIN i range rtcurAND SAPdrcrkIN i range drcrkHANAdatabase!ANDrpmax IN i range rpmaxAND (it where clause)ORDER BY (it orderlist). 2012 SAP AG. All rights reserved.“New” ABAP CodeSELECT (lt fieldlist)FROM zviewsdf2CONNECTION (i dbcon name)WHERE rldnr g leading rldnrANDrrcty EQ '0'ANDbukrs IN gt ranges bukrsANDrbusa IN gt ranges gsberANDracct IN gt ranges racctANDryear IN gt ranges ryearAND (lt where clause)GROUP BY (lt grouplist)ORDER BY (lt orderlist).24

Example: “Push down code”Currency conversionTraditional approachSAP ApplicationCurrency conversionAnyDB 2012 SAP AG. All rights reserved.25

Example: “Push down code”Currency conversionTraditional approachSAP ApplicationConverted data already l“Pushcurrencydown”conversionSAP ApplicationCurrency conversionConversion calculationAnyDB usingmulti-core in memory technology 2012 SAP AG. All rights reserved.SAP HANA DB26

Where custom code benefits the most from using SAP HANA DBBest practicesLarge dataset and a small result set: Big scans on full table, full index and range with small result sets All kind of aggregations like “group by” “count”, “sum”, “avg”, “having”Selecting only required fields instead of using “select *”Use DB joins instead of “select end select”Replace “select” inside a “loop” with “select” using “inner join” or “left outer join”Combine many small statements in one big statement (array fetch) Further details in CD202 – ABAP for SAP HANA: Building Business Applications for SAP HANA 2012 SAP AG. All rights reserved.27

Options for starting with SAP HANAOption 1 - Accelerator SAP HANA AcceleratorsClient “Custom” Accelerator1SAPBusinessSuiteAnyDB 2012 SAP AG. All rights reserved.SAPHANADB28

Options for starting with SAP HANAOption 1 - Accelerator SAP HANA AcceleratorsClientClientOption 2 - HANA Content2SAPBusinessSuite “Custom” AcceleratorVirtual Data ModelSAP HANADB Accessing data via analytical tools,e.g. via SAP BusinessObjects BIsolutionsAnyDB 2012 SAP AG. All rights reserved.29

Options for starting with SAP HANAOption 1 - Accelerator SAP HANA AcceleratorsClientClientOption 2 - HANA Content3SAPBusinessSuiteAnyDB “Custom” AcceleratorBWSAPHANADB Accessing data via analytical tools,e.g. via SAP BusinessObject BIsolutionsOption 3 – SAP NetWeaverBW on SAP HANA Data warehouse on SAP HANA DB 2012 SAP AG. All rights reserved.30

What will be next Option 1 - Accelerator SAP HANA AcceleratorsClient “Custom” AcceleratorOption 2 - HANA ContentSAPBusinessSuite Accessing data via analytical tools,e.g. SAP Business IntelligenceStay tuned SAP HANA DB 2012 SAP AG. All rights reserved. applications directly on SAP HANAbeyond SAP NetWeaver BW areupcoming31

Keep in MindSAP HANA provides you with better insight, more agility andinnovation for your businessRun SAP HANA (standalone or with SAP NetWeaver BW on top)side by side to your SAP Business Suite applications andbenefit already todayOptimizing custom applications requires changes tothe custom code and implementation could already bestarted for side-by-side scenarios 2012 SAP AG. All rights reserved.32

Further InformationSAP Public Related SAP TechEd SessionsCD162 - Accelerating ABAP Applications Using the Best Features in SAP HANA (2h hands-on)CD202 - ABAP for SAP HANA: Building Business Applications Optimized for In-Memory (2h lecture)TEC204 - How to Migrate to SAP HANA (2h lecture)Service Offerings (please check with your Enterprise Support contact)HANA Feasibility CheckSAP Rapid Prototyping ServiceWatch SAP TechEd Onlinewww.sapteched.com/online 2012 SAP AG. All rights reserved.33

FeedbackPlease complete your session evaluation for TEC105.Thanks for attending this SAP TechEd session.