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 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.

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.

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 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.

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.

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 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.

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 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.

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.

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.