SAP ABAP on HANA Certification Books

Please download to get full document.

View again

of 25
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Education

Published:

Views: 8 | Pages: 25

Extension: PDF | Download: 1

Share
Related documents
Description
email:sap.books4you@gmail.com Get latest Certification materials on SAP HANA,SAP S4HANA,SAP success Factors,SAP Fiori,SAP Cloud,SAP Hybris, SAP BW, SAP BO, SAP ABAP, SAP MM,SAP FICO,SAP PRESS Books,security,pi,spm,soa,srm,sem,sd,mobile,b1,banking,basis,bobj,bi,delta,ep,fscm,grc,SAP Fiori,SAP TM,SAP Simple Finance for best prices
Transcript
  • 1. ABAP Programming for SAP HANA PARTICIPANT HANDBOOK INSTRUCTOR-LED TRAINING Course Version: 11 Course Duration: 4 Day(s) Material Number: 50124104 For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 2. SAP Copyrights and Trademarks © 2016 SAP SE or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Please see http://globall2.sap.com/corporate-en/legal/ copyright/index.epx for additional trademark information and notices. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE's or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions. For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 3. Typographic Conventions American English is the standard used in this handbook. The following typographic conventions are also used. This information is displayed in the instructor’s presentation Demonstration Procedure Warning or Caution Hint Related or Additional Information Facilitated Discussion User interface control Window title A O » Example text Example text © Copyright. All rights reserved. For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 4. 0 For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 5. Contents ix Course Overview 1 Unitl: Introduction 3 Lesson: SAP HANA Basics and Technical Concepts 15 Exercise 1: Log on to ABAP Systems and Create Packages 22 Lesson: Introducing the SAP HANA Studio 29 Exercise 2: Log on to SAP HANA 34 Lesson: Introducing the ABAP Development Tools (ADT) 43 Exercise 3: Create a Project in ABAP Development Tools 47 Lesson: Introducing the EPM Sample Application 51 Unit 2: Taking ABAP to SAP HANA 52 Lesson: SAP HANA as Secondary Database- Access via Open SQL 57 Exercise 4: Access SAP HANA Via a Secondary Database Connection 66 Lesson: Preparing for SAP HANA 75 Exercise 5: Improve Open SQL Using ABAP Test Cockpit 86 Lesson: Guided Performance Analysis 95 Exercise 6: Use the SQL Performance Tuning Worklist to Analyze Static and Runtime Check Results 101 Exercise 7: Improve Open SQL Statements Using The SQL Trace (ST05) 110 Lesson: Performance Rules and Guidelines for SAP HANA 113 Unit 3: Code-to-Data with SAP HANA as Secondary Database 115 Lesson: Classical Open SQL and Its Limitations 120 Lesson: ABAP Database Connectivity (ADBC) 123 Lesson: Native SQL Syntax 127 Exercise 8: Issue a Native SQL Join via ADBC 135 Exercise 9: (Optional) Use Native SQL to Access SAP HANA- Specific Functionality 143 Lesson: Working with Views in SAP HANA Studio 151 Lesson: Consuming SAP HANA Views using Native SQL 155 Exercise 10: Analyze a SAP HANA View and Use it in Native SQL 164 Lesson: Working with Database Procedures in SAP HANA Studio 169 Lesson: Calling SAP HANA Procedures in ABAP 173 Exercise 11: Analyze a SAP HANA Database Procedure and Call it with Native SQL For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 6. 185 193 201 213 224 229 236 243 250 255 256 265 276 281 287 288 295 303 309 316 321 327 328 339 345 352 365 375 376 381 389 Lesson: New Open SQL Exercise 12: Apply New Features in OpenSQL Lesson: Core Data Services in ABAP Exercise 13: Core Data Services in ABAP Lesson: Associations in Core Data Services Exercise 14: Use Associations in Core Data Services in ABAP Lesson: Core Data Services with Input Parameters Exercise 15: Core Data Services View with Input Parameter Lesson: Incorporating Authorization Checks with CDS Unit 5: Code-to-Data with SAP HANA as Primary Database Lesson: ABAP-Managed Database Procedures Exercise 16: Create and Call an AMDP Lesson: Debugging ABAP-Managed Database Procedures Exercise 17: Debug an ABAP-managed Database Procedure Unit 6: SAP HANA Proxy Objects Lesson: Accessing SAP HANA Views via ABAP Dictionary External Views Exercise 18: Create an External View for SAP HANA View and Use it in an Open SQL SELECT Lesson: Calling SAP HANA Procedures via ABAP Database Procedure Proxies Exercise 19: Call a Database Procedure Proxy for a SAP HANA Procedure in an ABAP Program Lesson: Transport of SAP HANA Objects Exercise 20: Create a SAP HANA Transport Container for a Delivery Unit Unit 7: Advanced Topics Lesson: Using SAP HANA Full Text Search Exercise 21: Implement a Fuzzy Search Exercise 22: Implement Type-Ahead with Fuzzy Search Lesson: ABAP List Viewer (ALV) with Integrated Access to SAP HANA Exercise 23: Use ALV Optimized for SAP HANA Unit 8: Case Study: Optimize a Report on Flight Customer Revenue Lesson: Creating an Analytic View Exercise 24: Case Study Part 1: Create a SAP HANA Analytic View Exercise 25: Case Study Part 2: Use ALV Optimized for SAP HANA For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 7. 400 401 405 409 419 429 437 447 455 465 475 481 489 493 499 507 511 517 525 537 538 543 549 Lesson: Exercises Based on Flight DataModel Exercise 26: Log on to ABAP Systems and Create Packages Exercise 27: Create a Project in ABAP Development Tools Exercise 28: Access SAP HANA Via a Secondary Database Connection Exercise 29: Improve Open SQL by Using Code Inspector (SCI) Exercise 30: Improve Open SQL Statements Using The SQL Trace (ST05) Exercise 31: Issue a Native SQL Join via ADBC Exercise 32: (Optional) Use Native SQL to Access SAP HANA Specific Functionality Exercise 33: Analyze a SAP HANA View and Use it in Native SQL Exercise 34: Analyze a SAP HANA Database Procedure and Call it with Native SQL Exercise 35: Use New Open SQL Syntax Exercise 36: Core Data Services in ABAP Exercise 37: Use Associations in Core Data Services in ABAP Exercise 38: Core Data Services View with Input Parameter Exercise 39: Create and Call an ABAP Managed Database Procedure Exercise 40: Debug an ABAP-Managed Database Procedure Exercise 41: Create an External View for SAP HANA View and Use it in an Open SQL SELECT Exercise 42: Create a Database Procedure Proxy for a SAP HANA Procedure and Call it in an ABAP Program Exercise 43: Use ALV Optimized for SAP HANA to Display an External View Unit 10: Appendix: Other New ABAP Language Elements Lesson: Additional ABAP Language Enhancements Exercise 44: Use ABAP Expressions and Inline Data Declarations to Simplify Native SQL Calls Exercise 45: Use Table Expressions to Simplify Native SQL Calls vii© Copyright. All rights reserved. For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 8. For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 9. Course Overview TARGET AUDIENCE This course is intended for the following audiences: • Developer • Development Consultant For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 10. For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 11. UNIT 1 Introduction Lesson 1 SAP HANA Basics and Technical Concepts Exercise 1: Log on to ABAP Systems and Create Packages 3 15 Lesson 2 Introducing the SAP HANA Studio 22 Exercise 2: Log on to SAP HANA 29 Lesson 3 Introducing the ABAP Development Tools (ADT) 34 Exercise 3: Create a Project in ABAP Development Tools 43 Lesson 4 Introducing the EPM Sample Application 47 UNIT OBJECTIVES • Describe SAP HANA goals, technical innovations and challenges • Understand the fundamental technical concepts of SAP HANA • Explain the SAP HANA and ABAP evolution, architecture, and direction • Determine if HANA’s row store or column store is used for an ABAP transparent table, and which indices are used on HANA • Explain the central functions of HANA Studio • Switch between different perspectives in the SAP HANA Studio • Set up a connection to a SAP HANA database • Understand schemata and tables in SAP HANA Studio • Analyze the definition of tables in SAP HANA Studio • Use the ABAP Development Tools in Eclipse • Describe the Enterprise Procurement Model business example © Copyright. All rights reserved. 1 For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 12. • Describe the Open Item Analytics sample applications and which computations it involves For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 13. Unit 1 Lesson 1 SAP HANA Basics and Technical Concepts LESSON OVERVIEW In this lesson, you learn how to describe SAP HANA goals, technical innovations, and challenges; understand the fundamental technical concepts of SAP HANA; explain the SAP HANA and ABAP evolution, architecture, and direction; and determine if SAP HANA's row store or column store is used for an ABAP transparent table and which indices are used on SAP HANA. Business Example Your company has recognized SAP HANA as an important strategic topic and has asked you to refresh your ABAP skills, paying particular attention to those required to develop or review code that leverages the strengths of SAP HANA. LESSON OBJECTIVES After completing this lesson, you will be able to: • Describe SAP HANA goals, technical innovations and challenges • Understand the fundamental technical concepts of SAP HANA • Explain the SAP HANA and ABAP evolution, architecture, and direction • Determine if HANA’s row store or column store is used for an ABAP transparent table, and which indices are used on HANA SAP HANA Goals Broad Big Data, many data types Deep Complex & interactive questions on granilar data . Real-Time Recent data, preferably real-time High-Speed Fast response time, interactivity Simple No data preparation, no pre-aggregation Broad Big Data, many data types Deep Complex & interactive questions on granular data w High-Speed Fast response time, interactivity Real-Time Recent data, preferably real-time Simple No data preparation, no pre-aggregation Figure 1: Today's Technology Requires Tradeoff Decisions Developing applications using technology that pre-dates SAP HANA typically required making several trade-off decisions. The figure shows the five dimensions of requirements that are typical for business applications. These dimensions have been conflicting so far. For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 14. For example, you had to make trade-off decisions between providing a high-speed application and developing an application that doesn’t require preparing the data in a special way first, for example, by calculating aggregations beforehand and by storing the results in addition to the base data. Another example is that it was not possible to develop an application which is both real-time and able to analyze a large amount of data, maybe even unstructured data, at the same time. Deep Complex & interactive questions on granular data Broad Big Data, many data types SAP HANA( Real-Time Recent data, preferably real-time High-Speed Fast response time, interactivity • Simple No data preparation, no pre-aggregation Figure 2: SAP HANA: Delivers Across Five Dimensions SAP HANA tries to deliver across all these five dimensions, so that you no longer have to make so many trade-off decisions. In other words, the ambition is to enable the development of applications that combine Online Transaction Processing and Online Analytical Processing usage patterns. This leads to certain goals HANA has to meet. Enable New Applications and Optimize Existing Applications • High Performance and Scalability • Hybrid Data Management System • Compatibility and Standard DBMS Features • Support For Text Analysis, Indexing and Search • Cloud Support and Application Isolation • Support for Temporal Tables • Executing Application Logic inside the Data Layer Figure 3: SAP HANA Goals SAP HANA has the following goals: Enable new applications and optimize existing applications SAP HANA is an In-memory data platform that is deployable as an appliance or in the cloud and makes full use of the capabilities of current hardware to increase application performance, reduce cost of ownership, and enable new scenarios and applications that were not possible before. High performance and scalability For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
  • 15. SAP HANA is designed to make full use of multi-core CPUs by parallelization of execution. It can be distributed across multiple servers to achieve good scalability in terms of both data volume and concurrent requests. Hybrid data management system - combining different paradigms in one system SAP HANA architecture integrates different in-memory storages (column-based, row- based, and object-based), traditional disk-based tables, text analysis and search, and built-in support for planning. Combining all these capabilities in a single product not only improves performance but reduces overall complexity and cost. Compatibility and standard DBMS features An important goal is the possibility to use the SAP HANA database system as a replacement for any standard relational database management system. The SAP HANA database system is a full relational database management system with SQL interface, transactional isolation and recovery (ACID properties) and high availability. SAP applications that use Open SQL should run on SAP HANA without changes. Support For text analysis, indexing and search An important goal of SAP HANA is to provide powerful analysis, and text indexing and search capabilities that support a state-of-the-art search experience. This includes full text search with advanced features, such as free style search (without knowing the name of attributes in the database), linguistic search, and fault-tolerant fuzzy search. Cloud support and application isolation In cloud deployments, it is required that a system be shared - including physical servers and installed software - between multiple customers. SAP HANA will support this in the future, with the planned ability to host multiple isolated databases within a single SAP HANA system. The databases inside one system will have their own data, metadata, and users, but will share the same hardware, the same SAP HANA software installation, and the system administration. This feature helps to support cloud scenarios - but it can also be used in an on-premise deployment, for example, for running multiple unrelated applications in one SAP HANA system with effective isolation and resource management. Support for temporal tables SAP applications that use Open SQL should run on SAP HANA without changes. In temporal tables, update operations do not modify the existing records. Instead, new versions of the data records are inserted. Applications may use temporal tables, for example
  • We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks
    SAVE OUR EARTH

    We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

    More details...

    Sign Now!

    We are very appreciated for your Prompt Action!

    x