Intermediate Level Sap Basis Interview Questions
11. How can the SAP system be locked or unlocked?
The SAP system can be locked or unlocked using transaction SM04. Locking the system prevents new users from logging in, which is useful during maintenance. This ensures that no additional users can access the system, allowing for safe updates or troubleshooting. Unlocking the system afterward allows users to log in again and resume their activities.
12. Mention the various categories that help in executing SAP Background jobs.
The categories for executing SAP background jobs are:
- Immediate: Starts the job immediately
- Scheduled: Starts the job at a scheduled date & time
- Calendar: Uses factory calendar to determine job start
- Forecast: Job is proposed & may be scheduled later
13. What is the difference between support package, kernel & SAP note?
A support package is a bundle of corrections & enhancements for the SAP system.
The kernel is the core of the SAP system that manages memory, processes & programs.
An SAP note is a document with information on issues, corrections or enhancements.
14. Define RFC. How many different kinds of RFCs are there?
RFC (Remote Function Call) allows communication between SAP systems. The main types are:
- Synchronous RFC: Waits for a response before proceeding
- Asynchronous RFC: Continues without waiting for a response
- Transactional RFC: Ensures COMMIT/ROLLBACK actions are synchronized
15. How do you monitor & tune database performance in SAP?
Key steps to monitor & tune database performance in SAP:
- Use transaction ST04 to check database performance
- Analyze SQL statements using transaction ST05
- Monitor & optimize database memory usage
- Regularly check for & correct database errors
- Perform database statistics update & reorganization
16. Explain the process of an SAP upgrade.
Main steps in an SAP upgrade process:
- Plan the upgrade & assess impact on customizations
- Prepare development, quality & production systems
- Perform pre-upgrade tasks & checks
- Execute upgrade in maintenance window
- Perform post-upgrade steps like testing & transports
- Apply manual activities & test the upgraded system
17. What are the different type of users in SAP?
The main types of users in SAP are:
- Dialog users: Used for interactive activities
- System users: Used for background processing
- Communication users: Used for external system communication
- Service users: Used for specific SAP services
18. How do you perform a client copy in SAP, and what are the key steps involved?
- Step 1: Log into the target client using the transaction code SCCL.
- Step 2: Choose the client copy profile according to the requirements (e.g., SAP_ALL, SAP_CUST).
- Step 3: Specify the source client details.
- Step 4: Start the client copy process, either immediately or schedule it for later.
- Step 5: Monitor the client copy process using transaction code SCC3.
- Step 6: Review the log files for any errors or issues to ensure successful completion.
- Step 7: Post-copy activities like adjusting user authorizations and verifying data integrity.
19. What is the purpose of the STMS_IMPORT transaction?
Transaction STMS_IMPORT in SAP is used to import transport requests into an SAP system. It enables users to select the transport directory, where transport requests are stored, and review the contents of the transport. The transaction also provides options to control the import behavior, such as whether to import immediately or schedule for later, and whether to overwrite existing objects or keep the originals. Additionally, STMS_IMPORT allows for the checking of transport logs and handling of any errors or conflicts that arise during the import process, ensuring a smooth integration of new changes into the system.
20. What are the standard stages of the SAP Payment Run?
The standard stages of the SAP Payment Run are:
- Create payment proposals
- Modify payment proposals & post payments
- Control payment results & output payment media
- Transmit payments & execute post-processing
Advanced Level Sap Basis Interview Questions
21. In CMC (Central Management Console), how do we set up an OLAP (Online Analytical Processing) connection?
To set up an OLAP connection in CMC:
- Log into CMC & select OLAP Settings
- Choose "Create New OLAP Server Connection"
- Enter system details like server, port & username
- Test & save the OLAP connection
22. In SAP, distinguish between S/4HANA On-premise & S/4HANA Cloud.
S/4HANA On-premise is installed on company servers & offers full control & customization.
S/4HANA Cloud is a subscription model hosted by SAP with automatic updates but limited customization.
23. What is the purpose of the ztta/roll area profile parameter?
The ztta/roll area profile parameter specifies the size of the roll area, which is used for the SAP table logging mechanism. It determines how much data can be kept in the roll area before being written to disk.
24. What are the authorization objects in the user master record that are always present?
The authorization objects always present in the SAP user master record are:
- S_USER_AGR: Controls user master maintenance authorizations
- S_TABU_NAM: Specifies which tables the user can access
- S_USER_GRP: Determines the user group assignment
25. How to perform a SAP-export & import tables in SAP from OS level?
To export & import tables in SAP from the operating system level:
- Log onto the OS & navigate to the SAP system directory
- Use the R3trans executable with appropriate parameters
- Specify the export/import command, username, password etc.
- Execute the command to export or import the specified tables
26. How do you handle high availability in an SAP environment?
To handle high availability in an SAP environment:
- Implement redundant hardware components
- Set up clustering & failover for critical systems
- Configure database mirroring or replication
- Use load balancing for distributing workload
- Regularly test & update the HA/DR plan
27. What are SAP Enhancement Packages & how do you install them?
SAP Enhancement Packages are optional software packages that add new features & functionalities to existing SAP systems. They allow innovation without disrupting the core system.
To install an enhancement package:
- Check prerequisites & perform backup
- Download & extract the package files
- Run the installer & follow the guided steps
- Perform post-installation configuration & testing
28. Explain the steps for troubleshooting an SAP performance issue.
Key steps for troubleshooting SAP performance issues:
- Analyze the issue & gather relevant data
- Check hardware resources like CPU, memory & disk
- Review SAP performance monitors & logs
- Identify the bottleneck (database, network, application)
- Apply appropriate resolution & optimize settings
- Monitor to verify the issue is resolved
29. What are the steps involved in SAP disaster recovery planning?
Main steps in SAP disaster recovery planning:
- Identify critical systems & recovery objectives
- Design the DR architecture & select DR site
- Implement data replication & backup procedures
- Develop failover & failback procedures
- Test the DR plan regularly & train personnel
- Maintain & update the DR plan as the landscape changes
30. How do you handle SAP system security?
Key aspects of handling SAP system security:
- Assign appropriate authorization roles to users
- Regularly review & adjust authorizations as needed
- Implement strong password policies & authentication
- Monitor security logs & respond to incidents
- Apply security patches & notes in a timely manner
- Perform periodic security audits & penetration tests
Conclusion
We hope you have gained some insights on SAP Basis Interview Questions through this article. We hope this will help you excel in your interviews and enhance your knowledge of SAP Basis and related stuff.
You can also practice coding questions commonly asked in interviews on Coding Ninjas Code360.