SAP ABAP on HANA Training for Beginners

Explore how SAP HANA combines in-memory, column-oriented relational database management with processing, development tooling, and data integration on a single appliance to enable real-time applications.

Explore how SAP HANA uses an in-memory database to support real-time OLTP and OLAP, with dynamic tiering, hot and warm data, row and column tables, and HTAP.

Leverage multi-core architecture for parallel processing in SAP HANA, optimizing data loading to minimize CPU cache misses and idle cores, and maximize throughput across quad, octa, and dual core systems.

Explore how SAP HANA uses dictionary compression to store value IDs instead of full values, reducing memory and speeding searches and calculations.

Explore how SAP HANA leverages parallel processing across multi-core processors to boost throughput. Column store tables are automatically processed in parallel, with columns split across cores to scale performance.

Learn how SAP HANA enables on-the-fly aggregation from any line item table without prebuilt aggregates, with run-time views from the source and column stores that reduce indexes and simplify code.

Shift from traditional ABAP data handling to a code-to-data paradigm by pushing data-intensive operations into the database layer, leveraging SAP HANA features for faster ABAP applications.

Discover five golden rules to boost ABAP performance on SAP HANA, including keeping result set small, selecting needed fields, minimizing database calls, and optimizing where, having, joins, and buffering.

Learn how ADT, the eclipse-based ABAP Development Tool, replaces ABAP workbench by providing open APIs, cross-platform development, and a unified environment to edit repository objects on the SAP backend.

Understand the background of core data services by contrasting classical and new Open SQL, and see how CDS views, ABAP dictionary tools, and SAP HANA leverage SQL features and code-push-down.

Discover how core data services enable semantically rich data models for SAP HANA and ABAP. Define models on the database rather than on the application server, facilitating code pushdown.

Learn the basics of CDS, core data services, and its three sub-languages: data definition language, query language, and data control language, with semantic data models and ABAP authorization concepts.

Explore CDS repository objects in ABAP on HANA: data definition and access control, defining CDS views and CDS table functions (DDL SOURCE, DCL SOURCE); editable with ABAP Development Tool.

Explore core data services across SAP platforms, compare ABAP CDS and HANA CDS, and learn to define and consume ABAP CDS for S/4 HANA applications.

Explore ABAP CDS basics and theory, compare dictionary views with CDS, read data with aggregation and associations, and note CDS cannot modify data.

Explore ddl source and access control, and learn how abap cds views and sql views are defined and activated, using the abap development tool in eclipse and annotations.

Learn CDS syntax theory: apply proper keyword casing, comment formats, CDS and SQL view naming rules, and choose CDS field list syntax for improved auto-completion.

Explore the five annotation types in CDS views: view, element, parameter, extension, and function annotations, and learn how to place them to enrich semantic information in your views.

Create a cds data definition, apply view and element annotations, configure buffering and client dependent settings, and validate the sql view in Adept workbench.

Explore case conditional expressions in core data services, Open SQL, and ABAP CDS, including simple and nested forms, mandatory alias, and their parallels to if statements and case statements.

Create and activate a view from the book table, apply case expressions to calculate smoker charges (including nested cases), and verify results with filters.

Learn the theory of aggregations in ABAP CDS views, including mean, max, sum, average, count, and count distinct; apply group by and having with proper aliases.

Learn to build a CDS view with aggregation expressions in ABAP on HANA, applying count, count distinct, min, max, average, and sum with aliases, group by car ID, and having.

Explore inner join, left outer join, and right outer join in ABAP view, plus union and union all concepts, with syntax in curly brackets and the differences in duplicates handling.

Master cds view joins by building an inner join between book and custom tables, aliasing, selecting fields, and applying where, group by, having, and nested joins in ABAP on HANA.

Learn to implement union and union all in CDS views in SAP ABAP on HANA using an example, aligning select lists, aliasing id fields, and observing duplicate removal and preservation.

Learn how to define and use input parameters in CDS views for ABAP on HANA, including typing, annotations, and address syntax with dollar and colon prefixes.

Learn how to consume one CDS view in another by supplying input parameters in the from clause, maintaining parameter order, and building a consuming view.

Consume a CDS view in another CDS view with a hands-on approach, creating input parameters and mapping fields such as airline, adjusted amount, smoker, and flight date.

Create a report program to consume a CDS view in open SQL, reading data from the view and displaying it, using the from clause, parameters in parentheses, and assignment operator.

Discover how ABAP CDS uses associations to model relationships between entities. Leverage alias-like syntax, cardinality, and join-on-demand performance to enhance readability and optimize queries.

Explore ad hoc and expose associations in CDS views, and learn how path expressions enable on-demand joins and filtered associations in CDS and open sql.

Create an ad hoc association in a view between the book and custom tables, using an alias and a join condition on book.custom_id, then select fields from both.

learn how exposed associations in cds views enable on-demand joins, adding join conditions only when you select fields from the association, with practical hands-on examples.

Create an ABAP view with a filtered association between a book and a custom target, filtering by country CA to show the name only when the country is Canada.

Learn how to extend SAP ABAP CDS views without changing the original, using extend view, DDL sources, SQL view append, and annotations to permit projections, group by, and unions.

Learn by hands-on extension of a CDS view in SAP ABAP on HANA, creating extended views, adding associations, and activating and running the enriched output at runtime.

Explore how to authorize ABAP CDS views and restrict records by current user using authorization objects, profiles, and access control checks, including an end-to-end example.

Discover how to find CDS views containing a field by joining DD03L and dependency tables, and output details such as detail source name, ABAP dictionary object name, and table name.

Compare classical CDS views with CDS view entities, noting stricter syntax checks, annotation support differences, client handling, and currency and quantity handling using get numeric value for safe arithmetic.

Migrate a classical CDS view to a CDS view entity with the ABAP on HANA migration tool, using simulate and generate inactive versions, and resolve errors with get numeric value.

Explore CDS string functions and how they transform data in CDS views, including concat, concat with space, length, left, right, lower, upper, substring, replace, instr, ltrim, trim, lpad, and pad.

Discover CDS built-in numeric functions in CDS views, such as abs, cl, flow, div, division, mod, and round, and use get numeric value to compute payment sum and seats.

Explore built-in CDS time functions to validate time formats, add seconds to timestamps, calculate the difference between timestamps, and retrieve the current UTC timestamp from database servers.

Create an AMDP procedure and an MDP method in SAP HANA with SQL script and parameters to fetch data from table scar using fuzzy search. Call it from a report.

Learn how to push down select-options to the database layer in abap on hana using amdp and cds views, by converting selection options to clustering and applying filters.