SAP ABAP on HANA Interview Questions And Answers for experienced professionals from Codingcompiler. These SAP ABAP on HANA interview questions were asked in various interviews conducted by top multinational companies across the globe. We hope that these interview questions will help you in cracking your job interview. All the best and happy learning.
—-
SAP ABAP on HANA Interview Questions
What is SAP HANA?
What does ABAP stand for?
What is the difference between Row Storage and Column Storage?
What is a Schema in SAP HANA?
What is the concept of ABAP on HANA?
What is difference between SAP ABAP and SAP HANA?
What is displaying studio?
What is an AMDP procedure?
What are the benefits of SAP NW 7.5?
Can multiple ABAP systems connect to ABAP Database?
—-
SAP ABAP on HANA Interview Questions and Answers
Q. What is SAP HANA?
Answer:
SAP HANA is an in-memory registering motor (IMCE) utilized for on-going preparing of enormous volumes of information and fabricating and conveying true applications. Receiving the line based and section based DB innovation, SAP HANA is a progressed social DB item overhauled by SAP SE. With this elite logical (HANA) framework, the huge information exists on the primary memory and not on the solid circle. It replaces the onus of information upkeep independently on the heritage framework and rearranges the errands of chairpersons in this advanced world.
Q. What does ABAP stand for?
Advanced Business Application Programming
ABAP (Advanced Business Application Programming, originally Allgemeiner Berichts-Aufbereitungs-Prozessor, German for “general report creation processor”) is a high-level programming language created by the German software company SAP SE.
Q. What is the difference between Row Storage and Column Storage?
| Row Store | Column Store |
| Choosing table as Row Store is not as restrict as column | If you see there is large amount of data and having non-unique (Repeating e.g. Material group, Material Clas.. In MARA) |
| If there is a data set where you have unique values(distinct) | Aggregation of data is required (sales order table) |
| Not applying any aggregation on table. | Always selecting FEW columns in your programs out of so many columns in table. |
| No Aggregation like org data, configuration | |
| SELECTING all column all time. |
Q. What is a Schema in SAP HANA?
Ans. A Schema is a dedicated area of database which can be used to store database objects like table, packages, folders, procedures.
It provides a namespace for systems which connects to Database.
Q. What is the concept of ABAP on HANA?
ABAP (development) for SAP HANA refers to all developments which leverage the power of SAP HANA within ABAP-based applications. In this context, the SAP HANA platform is the primary database underlying the ABAP platform. This system deployment option is supported with AS ABAP 7.4 onwards.
Q. What is the difference between SAP ABAP and SAP HANA?
Answer:
The main difference is that, while a view defined in SE11 can only be executed within the SAP system, a CDS view resides on the HANA database itself. Therefore, CDS views can be consumed not only by ABAP programs; but also by non-ABAP applications as well. CDS views are also more powerful than regular SE11 views.
Q. What is displaying studio?
Answer:
Modeling studio in HANA plays out different errands like:
Declares the tables which are put away in HANA, initial segment is to get the meta-information and after that timetable information replication employments
Manage Data Services for entering the information from the SAP Business Warehouse as well as from different frameworks
Manage ERP cases association; the present discharge does not bolster interfacing with a few ERP occurrences
Use information administration for the demonstrating
Do demonstrate in HANA itself
Essential licenses for the SAP BO information administrations
Q. What is an AMDP procedure?
Answer:
ABAP Managed Database Procedures are a framework for managing and calling stored procedures or database procedures in AS ABAP. An ABAP Managed Database Procedure (or AMDP procedure) is a procedure written in a database-specific language (Native SQL, SQL Script, and L..,) implemented in an AMDP method of an AMDP class.
Q. Benefits of SAP NW 7.5?
Ans.
- Transparent Optimization
- SELECT QUERY : NetWeaver creates a query plan : Plan based Optimizer & Cost Based Optimizer , which decides the order/sequence in which query will be processed.
- Allows more complex joins
- Open SQL Enhancement
- Extended the static code check and SQL performance analysis
- Fast Data Access, Optimized data access
- Reuse Components, ALV ,Fuzzy Search
- Extension to open SQL
- Features specific to HANA related artifacts
- Standard programming guidelines by SAP
- ABAP/ Fiori Applications
Q. Can multiple ABAP systems connect to ABAP Database?
Ans. Yes. HANA 1.0 SP09 onwards
—-
Advanced SAP ABAP on HANA Interview Questions and Answers
Q. What is a Catalog in SAP HANA?
Ans. A Catalog is collection of Database Schemas in HANA. Schema: grouping of all database objects, Schema is a mandatory database object allows companies to use same database keeping data from multiple system where DCL and DB constraints can be managed at schema level
Q. What is difference between SAP User and DB user?
Ans. Schema user , i.e the database user is used to access the data with certain authorization levels.
Q. What is Information Model and why is it required?
Ans. Information Model: main purpose is to hide the technicalities to select data and make it easier for business users to model their data which can be pulled w/o technical knowledge just db functional knowledge is sufficient.
An information model: ( purpose was to hide the complexity and to overcome some setbacks with the queries )
- Used to convert linear structure to a multi dimension structure w/o knowing technical language.
- Are Process of converting source data (in tables) into business understandable format.
- They also make use of Hardware advancements in HANA.
- If we define information models inside HANA DB, We can also reduce the data transfer b/w DB and App layer.
- Complex logic as well as transformation executed in DB layer.
Q. What are the difference Pool tables and transparent tables?
Answer:
Transparent tables table will have one to one relation with the database tables, while pooled tables have many to one relation with database tables.
Q. What is Batch Data Communications (BDC)?
Answer:
This is a mechanical way to move outside data into SAP system. Queue file receives the data by input programs and groups that are associated into sessions.
Q. What are the benefits of SAP NW 7.5?
- Transparent Optimization
- SELECT QUERY: NetWeaver creates a query plan: Plan based Optimizer & Cost Based Optimizer, which decides the order/sequence in which query will be processed.
- Allows more complex joins
- Open SQL Enhancement
- Extended the static code check and SQL performance analysis
- Fast Data Access, Optimized data access
- Reuse Components, ALV, Fuzzy Search
- Extension to open SQL
- Features specific to HANA related artifacts
- Standard programming guidelines by SAP
- ABAP/ Fiori Applications
Q. What is Normalization in ABAP on HANA?
Answer:
Normalization concept means to reduce the redundancy of data.
Q. Syntax to call a PROCEDURE in HANA?
Answer:
CALL “<procedure_name>”(?)
Q. What is the difference between Procedural (Scripting) Vs Programming Language?
Answer:
The programming language is independent products, they generate their own executables. The code is compiled by programming language and converted to machine code / OS code.
E.g.: Compile a .java file it create a .class
Scripting languages are embedded in the programming language. They rely on the APIs of programming language. In SAP HANA, we have SQL scripting which is a Procedural Language.
—-
Most Frequently asked SAP ABAP on HANA Interview Questions
Q. What is the use of AMDP in SAP HANA?
Answers:
ABAP Managed Database Procedure
Database Procedures are stored and executed in the Database. We can create and execute database procedures in HANA database through ABAP using AMDP Class and AMDP Method called ABAP Managed Database Procedures. SQL SCRIPT is the language for creating stored procedures in HANA.
Q. What is the name of the interface we need to implement AMDP class?
Answer: An AMDP is implemented in an AMDP class with a regular static method or instance method in any visibility section. The editing environment for AMDP is the ABAP class editor. The AMDP class must contain the appropriate tag interface. IF_AMDP_MARKER_HDB is Marker Interface for DB Procedures.
Q. What is Full Text Search in SAP HANA?
Ans. To enable Full Text search – there has to be a FULLTEXT index that needs to be present in the Table, which is a DB specific feature.
Syntax: CREATE FULLTEXT INDEX <indextextvariable> on <table_name(field)> FAST PREPROCESSOR OFF;
Q. What are different syntaxes in SQL script for different functionalities?
Answer:
If condition
IF <cond> THEN
…..
ELSE IF <cond> THEN
….
END IF;
Loops – iteration
While Loop
While <condition> DO
END WHILE;
BREAK;
2. For loop
FOR i IN startIndex..EndIndex DO
….
END FOR;
Q. Clarify how SQL explanation is handled.
Answer:
Inside the HANA databases, each SQL articulation is actualized in the orientation of the exchange. A new session is dispensed to another exchange.
Q. Detail all the license key which are required in the HANA system along with their validity.
Answer:
The different license keys which are required for the HANA systems are:
? Permanent License Key
? Temporary License Key
The Temporary License keys are installed automatically during the installation of the HANA database. These keys are only valid for 90 days and before the expiration of it, you should opt for the permanent license key from the SAP marketplace.
Related Interview Questions
- SAP HANA Interview Questions
- Core Java Interview Questions
- JSF Interview Questions
- JSP Interview Questions
- JPA Interview Questions
- Spring Framework Interview Questions
- Spring Boot Interview Questions
- Core Java Multiple Choice Questions
- 60 Java MCQ Questions And Answers
- Aricent Java Interview Questions
- Accenture Java Interview Questions
- Advanced Java Interview Questions For 5 8 10 Years Experienced
- Core Java Interview Questions For Experienced
- GIT Interview Questions And Answers
- Network Security Interview Questions
- CheckPoint Interview Questions
- Page Object Model Interview Questions
- Apache Pig Interview Questions
- Python Interview Questions And Answers
- Peoplesoft Integration Broker Interview Questions
- PeopleSoft Application Engine Interview Questions