s4 hana security interview questions

SAP S/4 HANA Interview Questions and Answers
  • What is SAP S/4HANA? …
  • Can you explain inventory management in SAP S/4? …
  • Can you define Lean Manufacturing? …
  • What are the SAP S/4 HANA current versions? …
  • Can you define Rebate processing? …
  • Can you define the master data in SAP? …
  • Can you explain PPDS in SAP? …
  • Why use SAP S/4HANA?

FAQ: SAP HANA Security

Listed below are the SAP HANA alerts that indicate problems in the security area:





Secure store file system (SSFS) consistency

Regarding the database if there is consistency with the secure storage file system (SSFS) is determined by this.


Expiration of database user passwords

The database users are identified whose password in line with the configured password policy is due to expire. The user will get locked if the password expires. The application availability can be impacted if the technical user is in question. In case of technical users it is recommended that the password lifetime check is disabled to prevent the password from getting expired (ALTER USER DISABLE PASSWORD LIFETIME).



To any database users if the internal support role (SAP_INTERNAL_HANA_SUPPORT) is granted currently is determined.


Total memory usage of table-based audit log

The database table used for table-based audit logging consumes the percentage of the effective allocation limit is determined.

SQL: “HANA_Configuration_MiniChecks” returns a potentially critical issue (C = X) for one of the following individual checks:

Check ID



Secure store (SSFS) status


Number of users with expiration date


Number of SAP users with password expiration


CATALOG READ privilege granted to current user


Size of audit log table (GB)

SQL: “HANA_Security_MiniChecks” returns potentially critical issues (C = X).

To analyze security topics which tools are there?

In SAP 1969700 the following analysis commands are available:

SQL statement


SQL: “HANA_Security_CopyPrivilegesAndRoles_CommandGenerator”

From one grantee to another to copy privileges and roles GRANT commands are generated

SQL: “HANA_Security_GrantedRolesAndPrivileges”

Roles and privileges granted to roles and users are displayed(via roles either directly or indirectly)

SQL: “HANA_Security_MiniChecks”

In the SAP HANA Security Check List a subset of provided checks and from the expectation the deviations are marked as potentially critical is executed by this command(C = X).

SQL: “HANA_Security_Roles”

Overview of defined SAP HANA roles

SQL: “HANA_Security_Users”

Overview of SAP HANA users and schemas

Information about security related topics is provided by the following monitoring views and dictionary tables:

  • Explain the CATALOG READ privilege effect

    In SAP HANA dictionary tables (e.g. TABLE_COLUMNS or INDEXES) to what extent a user can access data is controlled by CATALOG READ. All information is visible if CATALOG READ is granted. The information for own objects only is shown if CATALOG READ is not granted. Due to the required security checks at the same time the performance can be worse for these dictionary queries.

    A missing CATALOG READ right does not result in an error unlike on other databases; the result set of dictionary queries is just restricted.

    Top 10 SAP Security Interview Questions And Answers

    This gives personal information about which particular authorization checks need execution inside the transaction and which authorization check doesn’t need to be. This table gives information regarding the proposal data of the authorization that includes the data related to an authorization which is useful for transactions
    This table also looks at the checks which are present in the profile generator. It looks at the default set values that need to be present in the profile generator.

    SAP S4 HANA Interview Questions and Answers

    These interview questions are targeted for SAP HANA and S/4HANA. All mid level experienced professionals and freshers must know the answer of these frequently asked SAP S/4HANA questions to clear an interview. We have a separate document for questions of different modules like SD, MM, FICO, ABAP, Logistics etc.

    1. What is SAP HANA?

    SAP HANA, a SAP Product is a high performance, column oriented, in-memory relational database management system. As a database server its main function is to store and retrieve the data requested by applications. SAP HANA provides fast and advanced analytical and transactional processing on multi-model data, in cloud and on premise. For more visit What is SAP HANA?

    2. What is the SAP S/4HANA?

    S/4HANA or SAP S/4HANA is a future ready enterprise resource planning (ERP) solution which is a collection of different things and comes with built-in technologies, including machine learning, AI and analytics. “SAP Business Suite 4 SAP HANA” is abbreviated as SAP S/4HANA in short. S/4HANA runs on HANA platform or HANA database – A very popular in-memory database that offers real time processing speeds. To understand SAP S/4HANA origin visit SAP HANA and S/4HANA and to know more about S/4HANA visit What is SAP S/4HANA?.

    3. What are the main building blocks of S/4HANA?

    S/4HANA has three main building blocks.

  • HANA Platform or HANA Database SAP S/4HANA ERP systems runs on this in-memory HANA database. It solves many problems faced by ERP.
  • S/4HANA (Business suite) an updated version of SAP business suite 7 and has built-in technologies, including AI, machine learning and analytics.
  • Fiori UI a modern user interface built into SAP S/4HANA that provides consistent look and feel across all devices and ERP systems. It helps in both employee satisfaction and productivity.
  • 4. What is an in-memory database?

    In-Memory databases rely primarily on main memory instead of SSDs or disks for data storage and to perform operations. In-memory databases provide minimal response time by eliminating the need of accessing the data from SSDs. In-Memory databases perform all the operations on main memory. For more visit In-Memory Database.

    5. What is SAP HANA? Explain the key benefits of an in-memory database

    SAP HANA is an in-memory high performance, column oriented relational database management system. It processes the transactions with advanced analytics on multi-model data, cloud and on-premise. For more visit SAP HANA.

    6. What are the features of SAP HANA?

  • Database Services – It offers various database services to reduce data management burdens. These services include Database Management, Database Administration and Database Security.
  • Multi-Model Processing – SAP HANA provides the capabilities to process complex multiple data types such as documents, graphs etc. It processes transactions with advanced analytics and provides hybrid transactional and analytical processing.
  • Application Development – You can develop real-time, intelligent applications with built-in development and run-time capabilities. It offers simplified application architecture, can use existing skills and programming languages, support of various tools like Eclipse, ABAP development tools etc.
  • Data Virtualisation – It improves the data quality with built-in data quality capabilities, offers data federation, data replication and integration capabilities. SAP HANA offers a real-time gateway to all your data across applications, cloud and storage.
  • For more visit

    7. Explain SAP HANA architecture.

    8. Explain about the Columnar database.

    11. What is the decision table in SAP HANA?

    12. What is native SAP HANA?

    13. Explain SAP HANA Performance Optimization Techniques.

    14. How to delete duplicate records?

    15. What is a referential join in SAP HANA?

    16. Explain Table Functions in SAP HANA.

    17. What is Open ODS view

    18. What is a row based and column based approach in SAP HANA?

    19. Explain advantages and disadvantages of row based tables in SAP HANA?

    20. Explain advantages and disadvantages of column based tables in SAP HANA?

    21. Why is SAP HANA so fast? How does it improve performance?

    22. What is the use of DSO and ADSO?


    What is SAP security Interview Questions?

    SAP HANA Security is protecting important data from unauthorized access and ensures that the standards and compliance meet as security standard adopted by the company. SAP HANA provides a facility i.e. Multitenant database, in which multiple databases can be created on single SAP HANA System.

    What is difference between ECC and s4 Hana?

    SAP Security Interview Questions for Freshers
    • Can you explain what a ‘user compare’ does in SAP security? …
    • Write different layers of security in SAP. …
    • What are different SAP Security T-codes? …
    • Describe the different types of SAP System users. …
    • How many types of users are there for background jobs?

    What is s4 Hana in simple terms?

    Differences between SAP ECC vs S/4HANA

    Database: ECC supports databases from other providers such as Db2, Oracle, or Informix, however, S/4HANA only runs on SAP HANA. As a result, S/4HANA has much faster reaction times thanks to its in-memory database.

    Related Posts

    Leave a Reply

    Your email address will not be published.