Interview

cds interview questions sap

Robby
SAP ABAP HANA CDS Interview Questions
  • Question #1: What is SAP HANA CDS view?
  • Question #2: Which three TADIR objects/artifacts are created on activation of a ABAP HANA CDS?
  • Question #3: How many types of ABAP HANA CDS views are there?
  • Question #4: What is Association and Path expression in ABAP HANA CDS?

If you’re resembling SAP ABAP on HANA Interview Questions for Experienced or Newcomers, you are at the accurate place. There are a lot of occasions from many alleged companies in the world. According to research SAP ABAP on HANA has a market share of about 0.9%. So, You still can move forward in your career in SAP ABAP on HANA Developer. ACTE suggests Advanced SAP ABAP on HANA Interview Questions 2021 that benefits you in solving your interview & acquiring an ideal career as SAP ABAP on HANA Expert.

26. What is the difference between Copy and derived from option while creating a new SAP HANA Attribute information view?

ABAP ON HANA Interview Q & A| 17 | Association | Path Expression

Question #11: What are the best practices which developers should keep in mind while using ABAP Core Data Services (CDS)?

SAP ABAP HANA Core Data Services(CDS) are foundation of new ABAP. It uses code push down technique and data virtualization for data fetching from much faster HANA database.

Some of best practices are as below:

  • Use latest innovations in CDS after ABAP 7.50. They help to reduce ABAP code logic and conditions on application layer. CDS executes at Database layer hence makes the application faster.
  • Publishes oData services on the fly
  • CDS can be consumed directly by Fiori reports effortlessly. This feature should be used as and when required instead of providing conventional reporting solutions to customers(e.g. ALV).
  • Analytics out of box

    • Question #12: How ABAP CDS controls Access with DCL(Data Control Language)?

    SAP ABAP HANA Core Data Services(CDS) uses syntax Define Role for access condition. This role management arrangement can further utilizes PFCG based role access. Example:

    And CDS view is as follows:

    Basic ABAP CDS Interview Questions

  • What is SAP CDS View?
  • How to create a ABAP CDS View?
  • How many types of CDS Views are there?
  • What are the artifacts generated during CDS View creation? Also explain the concept of cardinality and path expressions.
  • Explain the concepts of CDS View Association.
  • Explain the benefits of ABAP CDS Views over ABAP Views.
  • Explain the limitations of ABAP CDS.
  • Explain the use of Access Control
  • Explain the concept of Metadata Extensions
  • Explain the concept of Annotation in SAP ABAP CDS
  • Explain the concept of Field level data manipulation in ABAP CDS
  • Explain the concept of “Group By” in ABAP CDS.
  • Explain the use of BOPF in ABAP CDS.
  • Explain the concept code-to-data’ or ‘code-pushdown” paradigm.
  • Explain the following in terms of ABAP on HANA:
    1. Enhanced Search Help (F4 help)
    2. SAP List Viewer with Integrated Data Access (ALV with IDA)
    3. Open SQL
    4. ABAP Core Data Services (CDS)
    5. ABAP Managed Database Procedures (AMDP)
    6. ABAP CDS table functions
    7. Metadata Extensions
  • Explain the best practises related to ABAP CDS.
  • What is the use of Data Control Language (DCL) in ABAP CDS?
  • Explain the concept of CDS View extension.
  • How to perform unit and currency conversion in ABAP CDS?
  • How to use String Functions in ABAP CDS Views?
  • How to implement the mathematical aggregate expressions in ABAP CDS?
  • How to use joins in ABAP CDS Views?
  • Explain CDS Test Double Framework.
  • Explain ABAP CDS Unit Testing.
  • Explain ABAP CDS Hierarchical Testing.

    • Question #13: Which annotation in SAP ABAP CDS View is used to define underlying ABAP Data Dictionary(DDIC) structure?

    ABAP Core Data Services uses syntax @AbapCatalog.sqlViewName to define underlying ABAP Data Dictionary(DDIC) structure. Example:

    In above example, view DEMO_VIEW_ANNOT can be checked in ABAP dictionary Transaction SE11 however it can’t be edited there. To edit a CDS view, developer needs to use ADT(ABAP Development Tools for Eclipse). Detailed tutorial on how to install & use ADT is HERE.

    Another example:

    @EndUserText.label is used to define short text of underlying ABAP Data Dictionary(DDIC) structure.

    FAQ

    What type of questions are asked in CDS interview?

    CDS INTERVIEW QUESTIONS
    • Tell something about yourself.
    • Tell us your educational qualifications?
    • If you are working, why you want to leave your current job?
    • Why banking sector and how you are the right person for it?
    • What is your father’s job?
    • What type of improvement you want to make in your unit?

    How many types of CDS views are there in SAP?

    SAP CDS stands for SAP Core Data Services. SAP CDS is an infrastructure for data modelling that enables data models to be defined and consumed on the database server rather than the application server.

    Why CDS is used in SAP?

    There are two types of views: ABAP CDS views and HANA CDS views.

    Related posts:

    1. business development intern interview questions
    2. execution interview questions
    3. department of health interview questions
    4. interview questions to determine arrogance
    5. dataweave interview questions
    6. sales role play interview questions and answers
    7. Amazon excel interview questions
    8. interview questions for sales leaders

    Related Posts

    Interview

    The Top 20 XHTML Interview Questions for Web Developers in 2023

    Robby
    Interview

    Preparing for a Udacity Interview: Commonly Asked Questions and How to Answer Them

    Robby

    Leave a Reply

    Your email address will not be published. Required fields are marked *