Prev Next

SAP / SAP Mid Level (3 to 8 yrs) Interview questions

What are CDS Views in SAP?

Core Data Services (CDS) Views are a modern way of defining data models directly in the database layer, written in a SQL-like, declarative definition language, and compiled into database views — letting you define business semantics (associations, calculated fields, annotations for UI behavior) alongside the raw data structure itself, rather than only in application-layer ABAP code.

@AbapCatalog.sqlViewName: 'ZCUSTOMERVIEW'
define view Z_Customer as select from kna1 {
    key kunnr as CustomerId,
    name1     as CustomerName,
    land1     as Country
}

Unlike a classical ABAP view (which had limited expressiveness and ran purely in the ABAP layer), a CDS View is a genuine database view, letting queries against it benefit from full pushdown to HANA's engine — a core building block behind modern SAP development, from Fiori app backends to analytical reporting.

What language style are CDS Views written in?
What does a CDS View compile into?

More Related questions...

What is SAP HANA and why is it described as an in-memory database? How does in-memory processing improve performance compared to traditional disk-based databases? Explain the difference between row store and column store in HANA? Why does HANA favor columnar storage for analytical workloads? What is code-to-data pushdown in the context of HANA? Why should business logic be pushed down to the database layer in HANA-based applications? What is the difference between OLTP and OLAP workloads, and how does HANA handle both? Explain the internal working of HANA's in-memory computing engine? What is columnar storage and how does it differ from row-based storage? When is column store preferred over row store in HANA? How does data compression work in HANA's columnar storage? Explain how columnar storage improves aggregation query performance? What is a delta store in HANA's columnar storage architecture? How does HANA merge delta store data into the main store? What are CDS Views in SAP? Why are CDS Views considered a shift from classical ABAP data modeling? What is the difference between a CDS View and a classical ABAP view? Explain the concept of code pushdown in CDS Views? What are associations in CDS Views? What is the difference between an association and a JOIN in CDS Views? What are annotations in CDS Views and why are they important? How do you expose a CDS View as an OData service? What is the difference between a basic/interface CDS View and a consumption CDS View? How do you troubleshoot performance issues in a CDS View? What is the RAP (RESTful ABAP Programming) model? What is the difference between RAP and the classical ABAP programming model? What is a behavior definition in RAP? What is the difference between managed and unmanaged RAP scenarios? What is the CAP (Cloud Application Programming) model? What is the difference between RAP and CAP? Explain the architecture of a typical RAP-based Fiori application? How do you implement validations and determinations in RAP? What is OData and why is it used in SAP? Explain the difference between OData V2 and OData V4? What is an OData service in the context of SAP Fiori/Gateway? How do you expose backend data as an OData service? What is the role of SAP Gateway in OData service implementation? Explain the CRUD operations supported by OData services? How do you troubleshoot a failing OData service call? What is metadata in an OData service and why does it matter? What is SAP Fiori and how does it differ from classical SAP GUI? What are Fiori design principles? What is the difference between SAPUI5 and Fiori? How do you debug a SAP Fiori application? What is SAP Activate methodology? What are the Explore and Realize phases in SAP Activate? How does SAP Activate differ from the classical ASAP methodology? What is a fit-to-standard workshop in the Explore phase?
Show more question and Answers...

SAP Senior Level (10+ yrs) Interview questions

Comments & Discussions

Interviews Questions

About Javapedia.net

Javapedia.net is for Java and J2EE developers, technologist and college students who prepare of interview. Also this site includes many practical examples.

This site is developed using J2EE technologies by Steve Antony, a senior Developer/lead at one of the logistics based company.

contact: javatutorials2016[at]gmail[dot]com

Kindly consider donating for maintaining this website. Thanks.

Copyright © 2026, javapedia.net, all rights reserved. privacy policy.

DMCA.com Protection Status