Skip to content
IT Canvass
Menu
ServiceNow
SailPoint
SAP
TutorialsContact
SAP examples · Lesson

HANA examples

Quick answer

The examples embody code-to-data: aggregate and filter in the database (via CDS or SQL) rather than pulling rows into ABAP and looping.

Key takeaways

  • Watch out: Row-by-row processing instead of set-based SQL.
  • Worked examples: a cds view (application modeling), set-based sql (push logic down), what it teaches.
  • How HANA examples fits into SAP development and the wider SAP landscape

A CDS view (application modeling)

define view entity Z_Sales_By_Cust as select from I_SalesOrderItem {
  key SoldToParty,
  sum( NetAmount ) as TotalNet
} group by SoldToParty

Set-based SQL (push logic down)

SELECT sold_to, SUM(net_amount) AS total
  FROM sales_items
 GROUP BY sold_to
 ORDER BY total DESC;

What it teaches

The examples embody code-to-data: aggregate and filter in the database (via CDS or SQL) rather than pulling rows into ABAP and looping. On HANA this is dramatically faster. Layer views for reuse, and push filtering/aggregation as low as possible.

Common pitfalls

  • Row-by-row processing instead of set-based SQL.
  • Pulling data out to aggregate in ABAP.
  • Monolithic views instead of layered/reusable.

Want to learn this properly?

Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.

See the courseAsk a question

Check your understanding

  1. Which statement is true of HANA examples?

    • A. Navigating SAP efficiently is a foundational skill: knowing how to move around the system, launch functions…
    • B. On HANA this is dramatically faster.
    • C. SAP career growth means moving from doing (configuring/coding) to designing and leading, deepening expertise…
    Show answer

    B. On HANA this is dramatically faster.

    Covered in the “What it teaches” section of this lesson.

  2. Which of these also applies to HANA examples?

    • A. Wrong integration style (sync vs async) for the need.
    • B. Reading tables directly instead of using CDS/reports where appropriate.
    • C. Layer views for reuse, and push filtering/aggregation as low as possible.
    Show answer

    C. Layer views for reuse, and push filtering/aggregation as low as possible.

    Covered in the “What it teaches” section of this lesson.

  3. Which part of the Learn SAP curriculum covers HANA examples?

    • A. SAP examples
    • B. SAP ABAP development
    • C. SAP troubleshooting
    Show answer

    A. SAP examples

    This lesson sits in the SAP examples section of the Learn SAP course.

Frequently asked questions

What does the term HANA examples refer to in SAP?

These HANA examples show data modeling and SQL on the in-memory database, a calculation/CDS view and set-based SQL, illustrating the code-to-data approach.

What else is worth knowing about HANA examples?

The examples embody code-to-data: aggregate and filter in the database (via CDS or SQL) rather than pulling rows into ABAP and looping.

What tends to go wrong with HANA examples?

Row-by-row processing instead of set-based SQL. Pulling data out to aggregate in ABAP. Monolithic views instead of layered/reusable.
CallWhatsAppEnquire