s4 hana abap interview questions

SAP S/4HANA is the next-generation business suite designed to Run Simple in a digital economy. Built for the revolutionary SAP S/4 HANA in-memory computing platform, it fundamentally redefines how enterprise software creates value across industries with instant insight. SAP S/4HANA also personalizes the user experience on any device and natively connects to Big Data, the Internet of Things, and business and social networks – all in real time.

Cursors are used to fetch data records from table row-by-row from result of a query assigned to cursor. We always bind a Query to cursor. It is also possible to parameterize cursor.

For field symbols there is the new declaration operator​​ FIELD-SYMBOL(…)​​ that you can use at exactly three declaration positions.

Ans. It is recommended to use an Attribute View with only Master Table because of performance​​ criteria. It is advisable that Fact/Transaction Table​​ used with​​ Analytical view, and​​ not be used​​ with Attribute view due to performance implication since Attribute View is processed in the join Engine of SAP HANA, it is not processed by OLAP Engine which is equipped to do aggregation.

If you have additional questions and answers, feel free to share with us at [email protected] and we would be happy to include them in this list.

Ans.​​ A Decision Table​​ is used for planning scenarios, that allows business users to model business rules with less/no technical knowhow and apply the rules to see the results with read data.

Top 10 Frequently Asked SAP ABAP on HANA Interview Questions

More than 70% of clients run the SAP workloads on Linux by the utilization of the SUSE Linux Enterprise Server, which is the best OS decision for SAP HANA.

SAP ABAP on HANA Interview Questions and Answers

Q. What is SAP HANA?


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?

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?


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?


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?


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?


  • 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

    Latency is referred to the length of time to replicate data from the source system to the target system.

    The transaction manager co-ordinates database transactions and keeps a record of running and closed transactions. When transaction is rolled back or committed, the transaction manager notifies the involved storage engines about the event so they can run necessary actions.

    In the HANA database, each SQL statement is implemented in the reference of the transaction. New session is allotted to a new transaction.

    If the replication is suspended for a longer period of time, the size of the logging tables increases.

    You can avoid un-necessary logging information from being stored by pausing the replication by stopping the schema-related jobs.


    What is S4 HANA interview questions?

    SAP S4 HANA Interview Questions and Answers
    • What is SAP HANA? …
    • What is the SAP S/4HANA? …
    • What are the main building blocks of S/4HANA? …
    • What is an in-memory database? …
    • What is SAP HANA? …
    • What are the features of SAP HANA? …
    • Explain SAP HANA architecture.
    • Explain about the Columnar database.

    What is S4 HANA in SAP ABAP?

    ABAP Development in S/4HANA is a path into the New ABAP programming world. The course covers the major building blocks of S/4 HANA: Core Data Services (CDS Views) OData and Netweaver Gateway. BOPF (Business Object Processing Framework)

    Does s 4 HANA use ABAP?

    ABAP Platform 2020 consists of the AS ABAP, the ABAP Development Tools (ADT) in Eclipse and several additional technology components which are required to run SAP S/4HANA. Previous SAP S/4HANA versions such as 1511, 1610, 1709, 1809 and 1909 can be upgraded to SAP S/4HANA 2020 which is based on ABAP Platform 2020.

    How do I debug a CD view?

    Answer: It is not possible to debug CDS view. If a CDS is using Table function, then of course underlying AMDP can be debugged. CDS view is a by design is Database artifact which can be created, modified and accessed using ADT with Eclipse.

    Related Posts

    Leave a Reply

    Your email address will not be published.