Modeling
Quick answer
Models are consumed by Fiori/analytics via OData, by reporting tools (SAC), and by ABAP.
Key takeaways
- Rather than querying raw tables directly, you build views that join, filter, aggregate and enrich data, then applications and…
- Good models are layered and reusable, base views close to tables, composite views on top, so logic is defined once and reused.
- Calculation views: the current, flexible standard (graphical or SQLScript).
- Watch out: Querying raw tables instead of reusable views.
What modeling is
Rather than querying raw tables directly, you build views that join, filter, aggregate and enrich data, then applications and reports consume the views. On HANA the modern modeling artifact is the calculation view (and, in the ABAP world, CDS views), designed to run efficiently in the HANA engine.
Types of views (historical to modern)
- Calculation views: the current, flexible standard (graphical or SQLScript).
- (Legacy) Attribute & analytic views: older types now unified into calculation views.
- CDS views (ABAP): the SAP-application modeling layer, executed on HANA.
Modeling principles
Good models are layered and reusable, base views close to tables, composite views on top, so logic is defined once and reused. Push filtering and aggregation as low as possible, and design for the consumption pattern (transactional lookup vs analytical aggregation).
Consumption
Models are consumed by Fiori/analytics via OData, by reporting tools (SAC), and by ABAP. In S/4HANA, CDS is the primary modeling layer for application data, while native calculation views serve broader HANA use cases.
Common pitfalls
- Querying raw tables instead of reusable views.
- Monolithic views instead of layered, reusable ones.
- Aggregating late instead of pushing it down.
Want to learn this properly?
Our live, instructor-led SAP Training covers this hands-on, with real projects and a certification path.
Check your understanding
Which statement is true of Modeling?
- A. FB50 is the SAP transaction code for Post G/L Document (FI).
- B. On HANA the modern modeling artifact is the calculation view (and, in the ABAP world, CDS views), designed to…
- C. SAP functional consultant interviews focus on your module expertise, business-process understanding…
Show answer
B. On HANA the modern modeling artifact is the calculation view (and, in the ABAP world, CDS views), designed to…
Covered in the “What modeling is” section of this lesson.
Which of these also applies to Modeling?
- A. Good models are layered and reusable, base views close to tables, composite views on top, so logic is defined…
- B. Upgrading without reading the notes.
- C. Row-by-row processing instead of set-based SQL.
Show answer
A. Good models are layered and reusable, base views close to tables, composite views on top, so logic is defined…
Covered in the “Modeling principles” section of this lesson.
Which part of the Learn SAP curriculum covers Modeling?
- A. SAP SD
- B. SAP HANA
- C. SAP reference
Show answer
B. SAP HANA
This lesson sits in the SAP HANA section of the Learn SAP course.