This course will be helping to crack the ABAP ON HANA Interview.

This course is part of the ABAP ritual initiative to help all categories of Consultant to Crack the interview for ABAP on HANA in a simple way

This contains the Answer Explanation in Depth so that it can be remembered longer

Repetition is the key for any Interview Preparation so before starting the Next session previous session has been revised and covered in detail. If someone doesn't want to listen they can skip. However, for Fresher/Low Experienced candidates, it is highly recommended.

This ABAP on Hana Questions answer videos is different from traditional Videos.

Request you visit some sample videos which will give a better idea of how the class has been conducted.

Below is the list of Questions

In this video, I have discussed -

Q. What is Linguistic Search

Q. What is the prerequisite of LINGUISTIC SEARCH?

Q. When the FAST PREPORCESSOR IS OFF then NORMALIZATION or TOKENIZATION will take place or not?

Q. Select Query for different search: Same but with a different type of search type

Q. What is the meaning of Preprocessor is ON in HANA Search?

What is the different type of Search?

How to create the Index on HANA Database for full-Text Search?

By Default Fast Preprocessor is on or Off?

How does this index need to be created?

What is the problem with Classical Search?

What is the linguistic search?

What is Fuzzy Search

What is Exact Search

What is Fault Tolerance Search

What is Data Control Language(DCL) in CDS?

What is CDS Supported by all the Databases?

ABAP ON HANA Interview Questions and Answer|Part 21|CDS Performance

What are the different parameters to improve the CDS performance?

What are the different types of Search help

What is the new search help in HANA Database

What is ALV IDA?

How to improve the CDS Performance?

What are the various Annotations to improve CDS Performance?

What are Annotations for Service Quality to improve performance?

What is Annotation for Size Category to improve the performance?

What is Annotation for Data Class to improve the performance?

What is Virtual Data Model?

What are the benefits of the Virtual Data Model?

Why Virtual Data Model

What are the different types of VDM?

What are the different Annotations used in VDM?

Can Association will be written in CDS without mentioning Cardinality?

What is the default Cardinality?

Is Explicit Cardinality optional or mandatory in the association?

What is Path Expression?

How to use the association in SQL using PATH EXPRESSION

What is the limitation of CDS

What is the limitation of Table Function?

In what artifact the CDS table function gets converted into DB Layer

HighLights

What is Association in CDS?

How many types of associations in CDS do you have?

What is Adhoc Association?

What Exposed Association?

What is Cardinality?

What is the suggested naming convention to start with for Association?

Give one Example of EXPOSED Association

Is the Exposed association is JOIN at the DB layer?

What is ADHOC Association?

What is the difference between Adhoc Association and Exposed Association?

What is the difference between Association and Join?

Can CDS be buffered like just a Table?

When we create the custom CDS, is it possible to have SQL View name not starting with ‘Y’ or ‘Z’.?

Does CDS support the FULL OUTER JOIN?

What is the workaround for FULL OUTER JOIN?

Does CDS Support the LEFT OUTER JOIN and RIGHT OUTER JOIN?

What is the purpose of PARAMETERISED CDS?

How to consume the Parameterized CDS in Report

What is Association?

ABAP Ritual | PART13 | ABAP ON HANA Interview Questions and Answer | CDS | SQL View Vs CDS View

When CDS are going to activated what are the objects going to be created?

At which Layer CDS view is written?

With which tool you can create the CDS?

Is it possible to create the CDS in SAP GUI?

What is the mandatory NW Version which is required to create the CDS?

Already we have the DDIC View ( Database view/ Projection/ Help View / Maintenance View ), then why is the CDS View required?

What are the places where we can use this CDS View?

Can you create a Database table with the help of CDS?

What technology is used to create/Alter the DB using the CDS

Q. Can AMDP method be empty?

Q. Can you use the DDL statement inside the AMDP method?

Q. Can COMMIT and ROLLBACK are permitted inside the AMDP method?

Q. Why COMMITS and ROLLBACK are not permitted?

Q. AMDP Class is local or Global?

Q. Can you create the AMDP Class via SE24

Q. How can you create the AMDP Class?

Q. Which interface is responsible for making a CLASS an AMDP Class?

Q. What is the name of the stored procedure which gets created calling very first time the AMDP method.

Q. Can a function module be used inside the AMDP Method?

Q. What is CDS?

ABAP Ritual | PART 11| AMDP Interview Questions and Answer | Stored Procedure

What is AMDP?

Q. In AMDP, PASS BY REFERENCE IS ALLOWED OR NOT?

Q. In AMDP, PASS BY VALUE IS ALLOWED OR NOT?

Q. Is Nested Tables / Structures are allowed in AMDP Parameters?

Q. Is AMDP is supported by NON-HANA db?

Q. Can an AMDP Class contain the normal Method?

Q. Is Returning Parameter is allowed in AMDP Method?

Q. When the Stored Procedure gets created at DB Layer

Q. Suppose you want to use the TABLE, VIEW, or other AMDP Method in your current AMDP method then, how to use?

Ans. Under the method signature using the USING clause refer the TABLES, VIEW or AMDP method which you want to use.

Q. Does the AMDP method support the IMPLICIT Enhancement ?

Ans. No.

Q. Why ?

A stored procedure is going to create a DB Layer and hence Implicit enhancement is not possible.

. What are containers and different types of containers?

2. What are the important rules to remember while doing SQL Script programming?

3. What is Stored Procedure?

4. What is the SYNTAX for Creating Procedure?

5. What are the ways to create the table type?

6. How to populate the data inside an internal table?

7. How to Handle SQL Exceptions

8. How to handle DB Exception?

9. Give one example of DB Cursor with parameters

10. What is an Array? What is the Syntax of it?

What are the different types of database statements?

What is ACID

Tell some important frequently used (SYNTAX) features of New open SQL

How now you can perform easily the existence check using OPEN SQL?

Q. Can we put the select query on the Internal table?

What is the host variable in OPEN SQL and how is it used?

What is the new syntax for concatenation?

How now you can perform easily the existence check using OPEN SQL?

Q. Is the below query is possible now where we have written a select query inside IN Clause?

Q. Is it necessary to have a GROUP BY clause for Aggregate Function used in OPEN SQL?

Q. In HANA is it good to use ORDER BY Clause when we have to do along with comparison operator?

Write a select Query consisting of aggregate functions

Write a select query to get the DISTINCT material type from the MARA table

Q. Write a select query for LEFT OUTER join on MATNR for MARA and MARC

Q. Write a select query demonstrating INNER JOIN on material number of MARA and MARC

Q. Write a select query for LEFT OUTER join on MATNR for MARA and MARC

Q. Write a select query demonstrating INNER JOIN on material number of MARA and MARC

Is left outer/Right outer join is commutative? No.

In this video, I have discussed the below questions -

What is SQL Script?

AMDP Vs NEW OPEN SQL

What is the difference between Normal Programming Language and Script Programming Language?

Why HANA SQL Script?

Why Not Open SQL?

Why not Information Model?

Define SQL script and what are the types of SQL Statement?

What is the rule when HANA comes out from the parallelization mode?

What are the SQL Script Variables?

In this video, I have discussed the below points -

How to consume an Information model in the application program

What is CE Function?

Give some examples of CE Function

What is HANA Transport Container?

What is Native SQL?

Give one example to define the same requirement but their syntax is dependent on the Database?

What is ADBC?

What are the common steps to achieve the ADBC

What are the important Classes Used in ADBC?

Is direction important while putting in information model while putting the join?

What is the cache invalidation period? What is the use of it?

What is Text Table

Can we have same attribute view name in two different package in HANA DB?

What is content?

Does the System understand the graphical model( Information Model )

When we activate the information model which object is generated

What is Text Join

What is Smart Inner Join

What is the different type of Join?

What is Calculation View? What are the different types of Calculation View?

In this video, I have discussed below -

What is OIA Scenario?

What are an information Model and their different types?

What is the Schema naming convention( Standard "SAP + SYSTEM NAME" )

What are the different types of engines corresponding to different information models?

What is Attribute View, Analytical View and Calculation View

In this video, I have discussed the below -

List out all the importatn t-code used in Performance monitoring?

SQL Inbuilt Functions

What is transparent Optimization in S4HANA

What is EPM Model?

What is Schema?

What are new Performance optimization tools(SQLM, SWLT) and its benefit?

What is Schema?

When SQLM/SQLT was introduced?

Write down some frequently used New Open Syntax

How to modify the data into an internal table directly

What is LOOP AT GROUP BY | CORRESPONDING | CORRESPONDING WITH MAPPING |SWITCH WITH LET EXPRESSION

How to debug the new Syntax based coding where the result comes in one go

What is NEW Operator?

What is Mesh type and Meshes?

What is CROSS join?

What is UNION | WITHIN OPEN SQL | CLIENT HANDLING | UNION | REDUCE | FILTER Operator

What is BASE Operator

What are the different types of database statements?

What is ACID?

Tell some important frequently used (SYNTAX) features of New open SQL

How now you can perform easily the existence check using OPEN SQL?

Can we put the select query on the Internal table?

How to get the distinct material from MARC table using new open SQL

Is it necessary to have a GROUP BY clause for the Aggregate Function used in OPEN SQL?

In HANA is it good to use the ORDER BY Clause when we have to do it along with the comparison operator?

Write a select Query consisting of aggregate functions

Write a select query to get the DISTINCT material type from the MARA table

Write a select query for LEFT OUTER join on MATNR for MARA and MARC

Write a select query demonstrating INNER JOIN on material number of MARA and MARC

Write a Query having multiple INNER JOIN used for different table

In which sequence a JOIN( Inner or Outer Join) condition is manipulated

Is inner Join is commutative

Is left outer/Right outer join is commutative

Is full outer join is commutative

Is inner join is commutative

What is the meaning of inner join is commutative

Give a few examples of SELECT queries with Concatenation on fly

Write a Select Query to Replace the below SELECT query along with loop statement

What is the use of COALEASE Function the database tables were replaced by the new table in S4, how previous code is still working?

What is the full form of HANA?

Hana database is supported by which OS?

What is the important feature of HANA? (VI)

What are the different Code Push Down Techniques and in which sequence priorities need to be defined?

What are the different components of HANA? or What is the architecture of HANA DB?

What is the heart of the HANA Database?

What is a Name Server?

What important points need to be taken care while migrating to HANA/S4

What are the important variant in ATC for code check while migrating to HANA/S4HANA

Which layer is responsible for converting the Open SQL into Native SQL?

What is the Best practices( Performance Improvement) when the database is HANA?

What is FDA?

What are the Advantages of Column Storage?

What is the difference between Row Storage and Column Storage?

What is Side Car Scenario and how we could achieve it?

What is Code push Down or What is Code to Data Paradigm or What is the Top-down approach of coding

Tell some name of the tables which replaces many tables in S4HANA

Hana database is supported by which OS?

HANA Was developed in which Language ?

What is the difference between S4HANA ON Premise and S4HANA ON Cloud?