SAP BASIS Interview Questions (31 - 40)
31. What is SAP Note?
SAP Note is an official document provided by SAP to fix issues, provide corrections, or give instructions. It may include bug fixes, configuration steps, or code corrections.
For example: You apply an SAP Note using SNOTE to resolve a specific system error.
32. What is client copy?
Client Copy is the process of copying data from one client to another within the same system or across systems. It is used for creating new clients, testing, or system refresh activities.
For example: Copying data from client 100 (production) to client 200 (test) using SCCL / SCC9.
33. What is system refresh?
System Refresh in SAP Basis is the process of copying production system data into a non-production system (like QA or DEV). It is mainly done to keep test systems updated with real-time data.
For example: Refreshing QA system with latest production data using database backup/restore or client copy.
34. What is transport request?
Transport Request in SAP Basis is a mechanism to move customizing and configuration changes from one system to another. It ensures consistency and control over changes across different environments.
For example: Creating a transport request to move a new report from development to testing environment.
35. What is table buffering?
Table Buffering is a technique where table data is stored in application server memory to reduce database access. It improves performance by fetching data from buffer instead of database.
For example: Frequently used tables (like config tables) are buffered for faster reads.
36. What is ST02?
ST02 is used to monitor SAP memory buffers (like program buffer, table buffer, etc.). It helps analyze buffer usage, swaps, and tune memory for better performance.
For example: If you see high buffer swaps in ST02, you may need to increase memory parameters.
37. What is ST06?
ST06 is used to monitor operating system (OS) performance. It shows details like CPU usage, memory, disk, and network statistics.
For example: If system is slow, check ST06 to see high CPU or memory usage.
38. What is HANA Studio used for?
HANA Studio is used to manage and monitor SAP HANA database systems. It helps in activities like database administration, modeling, and performance monitoring.
For example: You use HANA Studio to check database status, run SQL queries, and monitor system performance.
39. What is difference between AnyDB and HANA?
- AnyDB → Traditional databases like Oracle Database, IBM Db2, Microsoft SQL Server; data is stored on disk (slower reads).
- HANA → SAP HANA stores data in memory (RAM), so it is much faster for processing and analytics.
For example: Reports that take minutes in AnyDB can run in seconds in HANA due to in-memory processing.
40. What is DBACOCKPIT?
DBACOCKPIT is a transaction used to monitor and manage database performance and administration tasks. It provides details like database health, SQL performance, locks, backups, and space usage.
For example: Use DBACOCKPIT to check slow SQL queries or database growth.