SAP ABAP On HANA and Workflow

Compare row store and column store architectures in SAP HANA, showing how column store accelerates analytics, aggregation, and compression, with the evolution toward ABAP on Hana.

Adopt the code to data paradigm in SAP HANA to push down calculations to the database, and explore data compression, parallel processing, and the OLTP and OLAP contrast.

Discover SAP HANA architecture, from the access engine and index server to the name and script servers, and learn how release and support packs shaped HANA evolution.

Learn how to use eclipse and ADT, Hana Studio, for SAP ABAP on Hana development, connect to Hana database, and master essential eclipse shortcuts.

Discover the evolution of NetWeaver and ABAP on Hana, and master inline declaration, inline data, field symbols, and object traversal to write concise, performant ABAP with new syntax.

Demonstrates using inline declaration to fetch entries from Mara with a single-line select, populate an internal table, and compare inline syntax with classic abap joins.

Explore the value expression in ABAP 7.4+, creating structures and internal tables at runtime with inline declarations, printing and reading internal tables using table expressions in Eclipse debugging.

Explore the new string expression syntax in ABAP on SAP HANA, replacing concatenate for readable code and easier variable interpolation using curly braces.

Learn sql side improvements in ABAP on HANA, focusing on the database abstraction layer that translates open sql to native sql for HANA optimization and join capabilities in NetWeaver 7.4.

Explore ABAP on Hana vs suite on Hana, clarifying that Hana becomes the primary in-memory database, while ABAP remains the middleware layer on top of Hana.

Explore how ABAP on HANA differs from S4 HANA, focusing on in-memory architecture, data-model simplification, new and removed tables, and migration deadlines to 2025.

Learn how migrating from a traditional RDBMS to SAP HANA impacts ABAP code, native SQL, and data handling, including row number issues, unsorted results, and delete adjacent duplicates.

Explore two SAP tools, the SAP Code Inspector and ABAP Test Cockpit, to locate and fix bugs in Z code when migrating ABAP to the HANA database.

Explore SAP code inspection with SCA and ATC on a demo ABAP program, using SAP GUI or ADT, and review syntax errors and quality findings.

Learn how ATC checks validate ABAP code in HANA migrations, compare ATC with SCA, and schedule DB migrations to fix read binary search without order by and delete adjacent duplicates.

Learn how to check ATC errors via ATC code, SAP ABAP development tool in Eclipse, and ATC checks in ADT, and apply quick fixes like adding an order by clause.

Discover how pseudo code can suppress ATC checks without fixing underlying problems in ABAP on Hana, why this cheats the system, and why it is not recommended for production system.

Discover how converting to S4HANA reshapes data models with a simplified data model, and use the simplification database to identify affected ABAP code and plan custom code adoption.

Explore the S4HANA readiness check process using SAP code inspector and ATC, and learn to run RC_COLLECT_ANALYZE_DATA, generate a zip file, and use the free readiness check app.

SAP S/4HANA on premise and cloud edition offer advantages and disadvantages, a simplified data model, memory reduction through data aging, and a digital core powered by HANA with Fiori UX.

Explore greenfield, brownfield, and bluefield SAP S/4HANA approaches for transforming an ERP landscape. Assess data migration, legacy constraints, and project risk to select the right path.

Learn performance guidelines for ABAP on HANA, including keeping result sets small, minimizing database calls, and using joins and group by to optimize custom code on premise.

Demonstrates performance guidelines for ABAP on HANA, showing how to minimize data transfer, reduce database calls, avoid select star, and test with ADT performance checks.

Explore how the SQLM tool, SAP's production SQL monitor, identifies the most expensive entry points and dominating SQL queries with minimal overhead.

We demonstrate using the SQL Monitor tool to identify the most expensive entry point and query in SAP HANA, and we use the SWLT tool to prioritize fixes.

Explore the EPM data model, the enterprise procurement model in SAP HANA, an end-to-end demo application for learning procurement processes. It covers master data and realistic sales and purchase scenarios.

Explore an OIA scenario in SAP ABAP on HANA and workflow, showing unpaid invoices and accounts receivable within an end-to-end EPM data model, using the collective statement to add records.

Demonstrate the OIA scenario part 2 in SAP ABAP on HANA and workflow, building EPM data tables and calculating average days for unpaid invoices across currencies.

See how ABAP meets hana by tracing design time objects in packages and activation creating runtime objects in a hana schema.