E_HANAAW_14 ABAP for SAP HANA

Data Smart Based on SAP HANA.

AS ABAP with SAP HANA as primary database.

Native SAP HANA Applications.

SAP HANA as Business Acelerators.

Host Name

Instance Number

Cliente ID

User Name

Logon Language

Package

Schema

Table

Calculation View

External Views

CDS Views

Database Procedure Proxy

ABAP-Manage Database Procedure

Use of native QSL or DB Hints.

Use of secondary database connection.

Coding that assumes that a SELECT result is always sorted.

The existence of customer-specific cluster tables.

The existence of table appends.

In a Code Inspector object list.

In a Code Inspector object check variant.

In a Code Inspector inspection.

Use of SELECT.. FOR ALL ENTRIES..

Use of JOINS with more than 3 tables.

Use of SELECT statements in LOOPS.

Use of SELECT * for tables with many fields.

Do static code checks with Code Inspector or ABAP Test Cockpit.

Collect runtime data with SQL Monitor.

Collect runtime data with Runtime Analysis.

Combine runtime data and static check result in SQL Performance Tuning Worklist.

Collect runtime data in the productive system.

Do static SQL checks in the productive system.

Do static SQL check in the development system.

Combine runtime data and static check result.

Keep the result set small.

Minimize amount of transferred data.

Minimize number of database accesses.

Minimize search overhead.

Keep unnecessary load away from the DB.

Keep the result set small.

Minimize amount of transferred data.

Minimize number of database accesses.

Minimize search overhead.

Keep unnecessary load away from the DB.

Translate Open SQL syntax into Native Sql Syntax.

Add client handling to the statement.

Check User Authorizations

Handle SAP table buffering

Transaction handling

Data definition (aka DDL source)

CDS view

SQL view

Data Definition ( aka DDL source ).

CDS view.

SQL View.

The Association points to a table, not to another CDS View.

The Association has cardinality 'to N'.

All fields mentioned in the ON condition are part of the field list.

The Association is the only Association in this view definition.

In the Data Preview of ADT.

In the Data Browser ( transaction SE16 ).

In another CDS view

In an Open SQL SELECT statement

In Data preview in ADT.

In the Data Browser ( SE16 ).

In ABAP Open SQL.

In the definition of another CDS view.

In Data preview in ADT.

In the Data Browser ( SE16 ).

In ABAP Open SQL.

In the definition of another CDS view.

Key words are not case-sensitive.

Identical client handling.

Table names have to be upper-case.

Comma-separated field lists.

Field list after FROM clause is supported.

Numeric or character-like scalar types.

Structure types with only scalar components.

Table types with only scalar columns.

Nested table types without secondary keys.

Display an AMDP method implementation.

Edit an AMDP method implementation.

Test an AMDP method implementation.

Debug an AMDP method implementation.

Create an instance of CL_SQL_CONNECTION.

Create an instance of CL_SQL_STATEMENT.

Create an instance of CL_SQL_RESULT_SET.

None, all three are mandatory.

You don’t forget a result.

An exception is raised.

DB resources remain blocked.

Nothing.

FROM _SYS_BIC.“ha400.primdb.::CA_BOOKINGS_COUNT”

FROM “ha400.primdb::CA_BOOKINGS_COUNT”

FROM _SYS_BIC.“ha400.primdb/CA_BOOKINGS_COUNT”

FROM “ha400.primdb/CA_BOOKINGS_COUNT”

Two table-like results.

Two scalar results.

One scalar result.

One table-like result.

Procedure Proxy.

Database View.

SQL View.

External View.

No native SQL required to access the SAP HANA object.

Automatic synchronization of proxy object definition

Automatic transport of SAP HANA artefacts in ABAP transport request.

No need for SAP HANA database to define the proxy objects.

Table TAB is located in column store.

Column COL is of type TEXT or SHORTTEXT.

A full text index exists for column COL of table TAB.

The application server release is 7.40 SP05 or higher.

Transparent table

Database view

CDS view

External view

Personalization

Editing values

Excel export

Double-click

Increasing connectivity of people and devices

Move transactional processing and analysis to separate servers for better
scalability

Increase in use of mobile devices

Massive growth in data volume

Faster disk access.

Multi-core processing.

Larger memory availability.

In-memory database

Automatic compression of data

Removes the need for cache

Combined OLTP and OLAP processing on one platform

SAP HANA runs on Intel x86 and SPARC hardware platforms.

SAP HANA runs on Unix.

SAP HANA can be installed only by certified engineers for production purposes.

Customers can re-use their own certified hardware components in an SAP HANA system.

SAP HANA is available in the cloud or on premise, or a combination of both.

Data cleansing

Data transformation

Data streaming

For data loading

1

2

3

A native, lightweight application server

An optional engine to handle excessive data loads

A data cleansing engine

A user interface

To move to Cloud Foundry architecture to allow flexible application deployment options

To include ABAP as a key development language for native SAP HANA applications

To implement micro-services architecture

To provide better source code management tools inside SAP HANA

Database Explorer

Development

Catalog

Calculation Views

Analytic Privileges

Procedures

Tables

Calculation View

Analytic Privilege

HTML file

Flowgraph

To provide KPIs to help focus on business performance

To provide key system performance information for one or more HANA instances

To provide an application developer collaboration hub

Data footprint is automatically reduced through compression

Only the columns required are actually loaded to memory

Columns can be partitioned

They are optimized for high-volume read/write transactional processing

To store data that has been unloaded from memory

To hold the delta store for newly-arrived records

To enable full database recovery if we have a power failure

To store data that is frequently used

A table that can hold data in row and column orientation

A table that can distribute its partitions across memory and extended storage tiers

A table that can be shared across multiple instances of HANA

An application built with SAP HANA XS Classic (XS) that supports on-premise and
cloud deployments

An application built with SAP HANA XS Advanced (XSA) that supports on-premise
and cloud deployments

Log area

Data volume

Memory

Delta store

To push data-intensive processing up to the application to obtain the best performance

To develop reuseable data processing logic in the database

To simplify applications

Dimension

Cube

Cube with star schema

Dimension with star schema

Procedure

Function

SQL permission

Authorisation object

Analytic privilege

SAP S/4HANA

SAP Business Suite

SAP Ariba

ABAP CDS

SAP HANA Live

Universe

SAP HANA CDS

Polygon

Line

Point

To extract the sentiment from customer feedback on social media

To extract common entities such as company, country, currencies, and so on, found in documents

To identify close matches in words and expressions, to catch misspellings

A tool to support sizing of an SAP HANA solution

A tool used to define a data loading job

A tool to support the build of a logical data model

A tool used to simulate a work load on different HANA hardware configurations

Virtualization

Duplicate data

Real-time

Streaming

SDI

SDA

SDS

SDQ

Automatic data type translation

Data cleansing

Evaluation and execution of push-down possibilities to remote sources

Merging data from multiple sources

The new table always has a 1:1 mapping between the file and table columns.

The supported file types for upload are .csv, and .txt.

When loading new data in a table that already contains data, the new data is appended to the existing data.

Renaming of columns and changing data types is allowed when loading data to new HANA tables.

ODBC

JDBC

MDX

SQL

ABAP

Embedded Analytics for operational analytics

ABAP is replaced with JAVA

Combine operational analytics and transaction processing

Massive performance improvement

Optimized for SAP HANA but maintains compatibility with other platforms

Embedded Analytics

Rewritten ABAP code optimized for SAP HANA

SAP HANA Live provides real time operational analytics

IDOC

ODBC

JDBC

ODBO

Tighter security

Data loading performance

Superior data quality

Reporting performance

Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views

Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views

Integration of models from BW on non-HANA databases combined with SAP HANA
optimized BW models

SAP HANA Studio

SAP BW/4HANA

SAP HANA Data Warehousing foundation

SAP HANA Web-based Workbench

SAP Web IDE for SAP HANA

SAP HANA Studio

SAP Web IDE

The Eclipse platform is an important part of SAP’s strategy for development tools

The Eclipse IDE is an interesting but non-essential addition

ABAP tools in Eclipse is just a proof of concept for the moment

In the project properties dialog box

Under Window→ Preferences

In both the project properties dialog box and under Window→ Preferences

ABAP

Transport Organizer

Debug

Package

ABAP programs

Data elements

ABAP classes

Packages

Text elements

Shift + Enter

Ctrl + Enter

Alt + Enter

Ctrl + Shift + Enter

Setting breakpoints dynamically during debugging

Memory analysis

Source code editing in the debugger

Displaying the contents of an internal table

Use the IMPORTING, EXPORTING, CHANGING, EXCEPTIONS, and RAISING additions in the FUNCTION statement

You can’t - the interface must be edited using the Function Builder in the SAP GUI

Choose the Code Wizard icon from the application toolbar

Choose F2 then choose the required action

Choose Ctrl + Space then choose the required action

Add the implementation of the method

Move the method definition to the protected or private section

Delete the method

Ctrl + F2

F3

Ctrl + Shift + F5

F6

Ctrl + Shift + H

Ctrl + H

Ctrl + A

Ctrl + Shift + A

“&

*

“!

!”

The Code Inspector

The Extended Program Check

The ABAP Trace

Test classes are not generated in a production system

Test methods can access the private components of the class under test

The class under test can access the methods of the test class

Each test method is executed independently of all of the others

Packages.

Delivery Units.

Calculation Views.

Procedures.

Cube

Composite

Cube with star join

Dimension

They do not expose their meta data to reporting tools

They are mainly used for reusing inside other calculation views

They must include at least one measure

They include a star join node

Calculation views

Flat files

Virtual tables

Column tables

Row tables

A view that is only accessible by users for a limited time

A view that stores the values of attributes across time

Excel pivot tables

Custom SQL queries

Data preview function in Web IDE

To apply filters on the data

To extract only the required columns from a data source

To aggregate measures

To join data sources

To improve performance of joins that do not need to check integrity if no column from the right table is selected by a query.

When you need to display only facts that have associated master data attributes

When you want to display facts even when the associated master data attributes are missing.

Left Outer Join

Right Outer Join

Temporal Join

Full Outer Join

Intersect

Minus

Union

Keep Flag

Transparent filter

Dynamic join

Cube calculation views

Column tables

Dimensions calculation views

Before a query on the calculation view begin to execute

On the final result of a query, similar to a ‘where’ clause

Before any joins are executed within the calculation view

Modeler

Attributes

Input parameter

Variable

Variable

Input parameter

A parent can be formed by combining attributes.

Parent and child columns have the same data type.

Recursive data structure defines the hierarchy.

The hierarchy always generates two levels.

Time

Country

VAT rate

To migrate deprecated object types to the supported types

To access the latest features of calculation view modeling

To maintain attribute and analytic views

To work with a tool you are familiar with when modeling XSA based development objects

So that they can avoid creating calculation views and use SQL

So that they can understand how to implement a function or procedure

So that they can extend the capabilities of a calculation view using SQL
expressions

When writing SQL against a database connection of the type HDI Container

When writing SQL against a database connection of the type SAP HANA Database.

Table

Column

Scalar

As a replacement for a graphical calculation view when you need more flexibility

When you need to write results back to a table

When you need to define custom data processing logic that the graphical
calculation view cannot provide

Write your code in a source file in the SAP Web IDE with the
extension .hdbprocedure

Use the CREATE PROCEDURE statement in SQL Console

The syntax is much simpler than the standard SQL Create Table expression.

A table that is created with CDS performs better than one created with the
standard SQL ‘Create Table’ expression.

The table definition is easily transported as part of the overall application to ensure
all artifacts are kept together.

Calculation views of data category cube without star join

Calculation views of data category cube with star join

Calculation views of data category ‘blank’

Calculation views of data category dimension

It provides a quick start to use SAP HANA Live for customers using SAP Business Suite on non-SAP HANA databases.

There is no requirement to copy data from SAP Business Suite to SAP HANA.

It offers a simplified landscape where SAP Business Suite and SAP HANA Live share the same in-memory tables.

ABAP CDS

SAP HANA CDS

More use cases are available with calculation views than CDS

Not all features and settings relevant to BI are available with CDS.

More optimization possibilities are available with calculation views

Calculation views can define the persistence layer as well as data modeling layer

To identify the longest running SQL statements.

To investigate the generated SQL for each node in my calculation view.

To highlight syntax errors in my SQL code.

Join nodes.

Union nodes.

Projection nodes.

Data lineage

Column lineage

Impact analysis

Persistence layer

User interface

Business logic

Data modeling

The project is not assigned to a Space.

Building a project does not generate the database objects defined in its HDB modules.

You do not have the Developer role in the assigned Space.

Calculation view

Synonym

Logical schema

User-provided service

Development

Design

Planning

Running

A reusable analytic privilege that can be used for several users who need to access
different data.

An analytic privilege that takes its filter values from variables defined in the calculation view

A temporary analytic privilege that has a defined time validity set for its use

Obscuring column values by hiding some or all characters with replacement characters

Replacing column values with a higher level group such as replacing a person id with team name

Removing complete rows of data that should not be seen by users

To hide sensitive data using alternative characters such as ‘XXXXX’.

To hide sensitive data by adding noise at the record level so that aggregated values
still make sense but individual records are not exposed.

To remove complete records so that they cannot be seen by unauthorized users