Part 1:
- What are the key responsibilities of SAP Basis Administrator?
The key responsibilities are −
- System installation and configuration.
- Load balancing on servers.
- Performance management of different components.
- Managing interfaces and integration with servers.
- Managing servers and different services.
- What is the current version of SAP GUI? How do you install it?
SAP GUI 7.4, the latest version for Windows was released in October, 2014. It supports various features like — it is by default installed with NWBC 5.0 and SAP GUI and GUI shortcuts are launched through NWBC.
- Which SAP GUI type is suitable for different kind of users? How do you decide?
When users are working mostly in the SAP system
SAP GUI for Windows or SAP GUI for Java is recommended.
When users are ABAP developers
For ABAP developers, SAP GUI for Windows is recommended.
When users use operating systems other than Microsoft
It is recommended that they use SAP GUI for Java and HTML or they can use SAP GUI for Windows on a remote server
For integrating Dynpro transactions to the Portal
The use of SAP GUI for HTML is recommended. This allows you to integrate classic Dynpro-based applications into the portal easily.
- How do you maintain roles in the SAP system?
To maintain roles in the SAP system, we use transaction code — PFCG
- Why do we create instances in SAP system? How are these instances configured?
SAP instance is defined when you install and configure a SAP system. These are used to refer to memory, processors and other resources in the system. SAP instance allows users to login to the SAP system and share the same resources.
A SAP instance is managed by CCMS and is used by users to login.
A SAP system can consist of one or more instances — you can set up a SAP system with a single instance with only one CCMS or you can configure a system with two or more separate instances in client/server environment.
We need to consider the following points to configure a SAP instance −
- You need to define separate directories for UNIX, AS/400, or Microsoft Windows NT server on which the instance is to be run.
- You can use a shared file system.
- For each instance, there are entries created in operating system configuration files (/etc/services, /etc/sapconfig…).
- Explain the architecture of SAP system with different layers. What is the use of Gateway?
Presentation layer communicates with the application server to perform all the processing. This is known as the brain of a SAP system.
An application server consists of multiple instances and communicates with the database layer of the three-tier architecture.
Bottom layer is called the database layer. This is responsible to store all the data. Database of SAP system is kept on a separate server for performance and security reason.
The Presentation layer consists of different components for ABAP and JAVA that enables the communication and processing of data in SAP system. The key components at Presentation layer also includes — Gateway. This is used to manage communication between SAP system and external systems.
- Suppose you have to integrate SAP ECC 6.0 to AWS cloud. How can you achieve this?
You have to make use of SAP Cloud Appliance Library (CAL). This will help you to directly push SAP ECC software to your cloud environment by entering the Security key.
- How do you check the installed software components and product versions on SAP system?
Go to SAP system data → Click on component magnifying glass.
The following two options will be displayed −
- Installed Software Component Versions
- Installed Product Versions
Under installed software component, you can see all the software installed, support package, service pack, description etc. If you want to check the details of each component, you can select the component and go to the details tab as shown above.
Go to Installed Product Versions; it will show you the version of the installed SAP NetWeaver.
- What is client administration in SAP system? Why do we use multiple clients in SAP system?
A client is used in SAP system for multiple login on a single instance. You can create multiple clients on a single instance. It also provides data security as one user with one client can’t see the data of the other user with another client and also there is no need to install the software again.
The following are the advantages of client administration in SAP system −
- Using SAP Clients, the same resources can be shared between multiple users.
- It helps you to manage SAP system landscape as you can create multiple clients for DEV, QA and PROD team.
- It allows you to share the SAP system with a large number of users.
- We have standard clients in SAP system
- What are the default clients in SAP system? How can you create a new client in SAP system?
SAP system comes with the following three standard clients −
000 − This is called the master client and is available when you install R/3 system.
001 − This is a copy of 000 and it comes with a test company. Generally, this client is used to create new clients.
066 − This is called the SAP Early watch. This is used for diagnostic scans and monitoring service in the SAP system.
Following are the steps to create a New Client in SAP −
- To create a new client in SAP system, use transaction code — SCC4
- To create a new client, enter the following details after clicking on New Entries −
- Client number and name
- City
- Currency, Roles
- Enter your client-specific data and set permission for the clients as per your requirement and click on save.
- How can you create a new user in SAP system? How do you assign roles to new users?
You can create multiple users with different access rights in SAP system. Follow these steps to create a new user −
Step 1 − Use transaction code — SU01
Step 2 − Enter the username you want to create, click on the Create icon.
Step 3 − You will be redirected to the Next Tab — the Address tab wherein, you have to enter details like First name, Last name, Phone number, email id, etc.
Step 4 − You will further be directed to another Tab — the Logon Data tab wherein,
- You have to enter the user type under Logon data tab.
- Type the first login password – New Password and Repeat Password
Step 5 − You will now be directed to the Roles tab wherein, you have to assign the roles to the user
Step 6 − Now, the next tab is the Profiles tab wherein, you have to assign the Profiles to user.
Step 7 −Click on Save and you will get a confirmation.
- What are the different user types in SAP system that an admin can use while creating a new user?
The following are the five different types of user types −
- Dialog user — This user is used for interactive system access from GUI.
- System user — This user is used for background processing and communication within a system.
- Communication user — This user is used for external RFC calls.
- Service user — This user is created for a larger and anonymous group of users.
- Reference user — These are reference users with no logon possible, non-person related users that allow the assignment of additional authorizations.
- Is it possible to lock users in SAP system? What are the different ways to lock/unlock users?
The different ways to lock/unlock users are −
- Manually/Forcefully
- Automatically
Manually or Forcefully
You can lock a user forcefully/automatically using the following transaction codes −
- Transaction- SU01 for single user
- Transaction –SU10 for multiple users
- How can you define login policy for users in SAP system?
You can set the number of incorrect login attempts and then system can end the session or can also lock the user account if parameter value is set by Administrator. There are two types of parameters used −
Static − This parameter doesn’t apply immediately and the system needs a Restart for this.
Dynamic − This parameter can be applied directly and the system does not need a Restart.
To set the value of parameters, use transaction code — RZ11s
- What are the different login and password parameters that can be applied in SAP system?
To set the number of failed attempts, use parameter — login/fails_to_session_end.
Likewise, you have other parameters such as login/fails_to_session_end, login/fails_to_user_lock
The following are the password policy parameters −
- login/min_password_lng
- login/password_expiration_time
- How do you maintain password selection for users? What are the different parameters that can be used for this and which table maintains these details?
Passwords are maintained in table USR40 and transaction code — SM30 is used for this purpose.
There are two wildcard characters −
- ?- stands for a single character
- *- stands for a sequence of any combination characters of any length.
If you select 123* in table USR40, it means that any password that begins with the sequence “123.” is prohibited.
If you enter *123*, it prohibits any password that contains the sequence “123.”
If you select AB?, it indicates that all passwords that begin with “AB” and an additional character are not allowed. For example, “ABB”, “ABF”, etc.
- What are the categories to execute SAP Background jobs?
Class A (High Priority) − This is used for urgent or critical tasks. These tasks must be scheduled with class A priority job. Class A job reserves one or more background work processes.
Class B (Medium Priority) − These jobs are executed after the completion of Class A high priority jobs.
Class C (Low Priority) − These jobs run once class A and class B jobs are completed.
- What are the different options available for scheduling a background job? What start conditions type can be used?
To schedule a background job you must specify the conditions that will trigger the job to start.
The different types of start condition you want to use are −
- Immediate
- Date/Time
- After Job
- After Event
- At Operation Mode
- What are the different types of job status? Can you unschedule an active job?
The different types of status are – Scheduled, Released, Ready, Active, Finished, Cancelled
You can’t unschedule a job if it is active. You need to wait for the completion of the job to unscheduled it.
- What is the use of commit value while deleting jobs in SAP system?
Commit value is proportional to program performance. If the commit value is high, then job deletion will run faster. Recommended value is >= 1000.
- In Transport Management System (TMS), which file is used to store TMS configuration and is used by domains for checking configuration?
DOMAIN.CFG file is created under usr/sap/trans/bin directory which stores TMS configuration and is used by systems and domains for checking existing configurations.
- What is a Transport Request in TMS? What are the different types of Transport Requests that can be created in a SAP system?
A Transport Request contains number of changes to be implemented in the development system. It consists of the type of change, purpose, change category, target system and other details.
Transport Requests are named in a standard format — <SID>K<Number>
For example, in <SID>K<Number> −
- SID represents System ID
- K stands for fixed keyword/alphabet
- Number can be anything from a range starting with 900001
There are two type of request types that can be created in SAP system −
Workbench Request − This request type contains repository and cross-client customizing objects. Workbench requests are used to make changes to the ABAP workbench objects.
Customizing Request − This request type contains objects that belong to client-specific customizing. These requests are created in system automatically when a user performs customize setting and a target system is automatically assigned as per the transport layer.
- What is the use of transport logs in TMS system? What are the different log types and record value in the log files?
There are two types of logs that are available in Transport Management System
Transport Logs − This keeps track of transport log files which have been moved in a transport request.
Action Log − This includes the details of action logs that have been performed in a Transport Request. This also includes exports, import, etc.
One of the important functions provided by the logs are the following return codes −
- 0 — This value represents that export was successful.
- 4 — This value represents that a warning was issued and objects were transported successfully.
- 8 — This represents that a warning was issued and at least one object could not be transported.
- 12 or higher — This value represents an error in Transport Request and this normally does not result because of objects in TR and probably occurs because of system failure.
- Which transport directory is used to implement support package and add-ons?
Transport directory /usr/sap/trans should have enough space.
- What is the use of Kernel in SAP system? How do you check the current Kernel version in SAP system?
Kernel is an executable program that exists between SAP Applications and operating system. It consists of executable program under the path — “/sapmnt/<SID>/exe” for UNIX and \usr\sap\SID\SYS\exe\run Windows. It starts and stops application services such as message server, dispatcher, etc.
In Kernel upgrade, new .exec files replace old executable files in SAP system. To check the current version, use Transaction SM51 and go to Release Notes.
To check the status, go to System → Status tab → Other Kernel info
- What are the key activities that you perform as part of SAP Basis support?
- Job Processing and Scheduling
- User Management
- SAP system configuration and Client Administration
- Installation and Patch Upgrade
- Installation and Patch Upgrade
- Managing interfaces and integration with servers
- How do you check the users logs in your system and how many sessions each user is generating?
SM04:
To check number of users are logged into the system and in which client and how many session each user is generated and in each session what transaction is being executed.
- How do you maintain roles in SAP system?
PFCG:
This is used to maintain roles in SAP system.
- What is SAP GUI?
SAP GUI is known as client tool which is used to access remote central server and runs on different operating systems like Microsoft Windows, UNIX, Mac, etc. This is used to manage and access SAP applications like SAP ECC and SAP Business Intelligence system.
- Do you know the different supported platforms for SAP GUI?
SAP GUI for the Windows environment
SAP GUI for the Java(TM) environment
SAP GUI for HTML / Internet Transaction Server (ITS)
- Are you aware of Blue Crystal design of SAP GUI?
SAP Blue Crystal is a new visual design theme which succeeds Corbu. It provides a consistent design that allows users to seamlessly experience SAP GUI and NWBC elements. It is the standard theme of Fiori applications and comes with a new color palette and icons which are better scalable.
- What is SAP Market place?
To download SAP Products. Service.sap.com to login to SAP Market Place
- What is the difference between Sandbox, Development box and Production server?
Sandbox server
When a project is implemented, at the initial stages a sandbox server is used where all the customization, configuration is performed.
Development Server
Next is to save the configuration in development server and saved in workbench requests and this has to be transported to Production server.
Production Server
You can consider it as last or most refined stage where the work is done when project is in production/go live. All the changes that are requires by client are performed in DEV environment and later and the request is transported to production.
- How do you create an instance?
To create an instance, you should first define an operation mode. To create an instance, go to CCMS > Configuration or use Transaction code RZ04.
- What are the different components in SAP system architecture?
Presentation layer communicates with the application server to perform all the processing and which is known as brains of an SAP system.
An application server consists of multiple instances and communicates with the database layer of the three-tier architecture.
Bottom layer is called database layer which is responsible to keep all the data. Database of SAP system is kept on a separate server for performance and security reason.
At Presentation layer you consist of different components for ABAP and JAVA that enables the communication and processing of data in SAP system. Key components at Presentation layer includes −
Message Server
This is used to manage communication between distributed Dispatchers in ABAP system.
Message Server
This is used to manage server processes and JAVA dispatchers. It is used to manage communication within JRE.
Dispatcher Queue
This is used to store multiple work process types.
Dispatcher
It is used to distribute the requests to the work processes.
Memory Pipes
This is used to manage communication between ICM and ABAP work processes.
Enqueue Server
This is used to handle logical locks set by the executed Java application program.
Java Dispatcher
JAVA dispatcher is responsible to receive the client requests via presentation layer and forward to the server process.
Gateway
It is used to manage communication between SAP system and external systems.
ABAP Work processes
It is used to execute dialog steps in R/3 applications separately.
Where do you download trail version of SAP ECC, what is SAP CAL?
You can download SAP ECC 6.0 free trial from SAP Market place. It is also possible to integrate SAP ECC 6.0 trial using SAP Cloud Appliance Library ACL to AWS or other cloud environment service provider by providing user public cloud key.
- What is SAP NetWeaver?
SAP NetWeaver is known as open technology software component that provides you a platform to run critical business applications and integration between people, processes and information. It allows the composition, provisioning, and management of SAP and non-SAP applications across a heterogeneous software environment.
- Do you have an idea about SAP NetWeaver architecture?
SAP NetWeaver is one of central component of entire SAP software stack and provides you a platform for other components and JAVA and ABAP applications.
SAP Application server consists of multiple several application server instances and also database servers. With use of dialog instance, it also contains message server and an enqueue server.
Internal Communication Manager
It is used to process both client and server web requests. It supports protocol – HTTP, HTTPS, SMTP
Dispatcher
Dispatcher is used to distribute the user request to different work processes. If all the work processes are busy, requests are stored in Dispatcher queue.
Work Processes
These are used to execute Java or ABAP programs.
SAP Gateway
This provides RFC interface between SAP instances.
Message Server
Message Server
- What is SAP NetWeaver Administrator tool?
SAP NetWeaver Administrator (NWA) is a Web-based tool that allows you to perform configuration, advanced administration, monitoring, troubleshooting, and diagnosing a SAP NetWeaver system.
You can use NWA tool in these working modes −
- Online
- Local and remote
- What do you understand by SAP Client administration?
A client is used in SAP system for multiple login on single instance. You can create multiple clients on a single instance. It also provides data security as one user will client can’t see data of other user and also there is no need to install the software again.
- What are the benefits of using different clients in SAP system?
- Using SAP Clients, you can share the same resources between multiple users.
- It helps you to manage SAP system landscape as you can create multiple clients for DEV, QA and PROD team.
- It allows you to share the SAP system within large number of users.
- Standard Clients in SAP system.
- You can create clients in SAP system from 000-999.
- When your database size is large, how you can perform client copy in SAP landscape?
It is always recommended to use import/export option for client copy when database size is large.
Steps to export a client −
Log on to Target system and create an entry for new target client using Transaction SCC4. To perform export for transferring data files to target system import buffer use Transaction SCC8.
- What is password policy?
It is also possible to define password policy for users in SAP system. This includes −
- User has to set minimum password length
- Password expire policy
- Password complexity, etc.
- What do you understand by executing background jobs in SAP system?
Background jobs are jobs in SAP system that run in the background without effecting normal operations in the system. Background jobs are used to reduce manual effort and to automate the process. They can run in the background without any user input and can be scheduled to run when system load is low.
- What should be the job status to make it run?
Released
- How do you access Job Overview screen?
Transaction Code: SM37
Use * in job name column and select the status to see all the jobs created by this user. Also enter the date range as per the requirement → Execute
- What do you understand by Transport Management in SAP Basis?
TMS is one of the key component in SAP system and used to control the new requests, to monitor the changes- who has implemented the changes, defining and configuring system landscape in SAP environment.
- What are the different components in Transport Management system?
Change and Transport Organizer CTO
Transaction: SE01
This is used to manage, configure the changes in SAP repository and other objects. This provides you a central environment for development and configuration projects.
Transport Management System
This is used to manage, control and copy development objects and for customization to perform in SAP system landscape using transport routes configured with RFC Connections. This includes exporting the objects from one SAP system and importing to target system.
Tools
Tools are part of SAP Kernel and are used to manage R3 trans and transport control program.
- How to add a system to Transport domain?
Log on to SAP system that you want to add to system, use client 000 and start transaction STMS. If system is not added, TMS will check configuration file DOMAIN.CFG and will ask to join the domain. Click on -Select the proposal and save. System will remain in ‘Waiting’ status initially.
To complete the task → login to Domain Controller System → Transaction STMS → Go to Overview → Systems.
You can see new system that will be available. Go to SAP System → Approve
- What are Transport routes? What are the different Transport routes type in SAP Basis?
Transport routes are defined as routes that are defined by SAP Administrator to transmit the changes between different SAP systems.
You can define two types of transport routes −
- Consolidation (From DEV to QAS) – Transport Layers are used
- Delivery (From QAS to PRD) – Transport Layers not required
- Where do you check Transport request logs?
You can also check the logs once the transport request is completed. To check the logs, Transaction SE01 → GoTo → Transport Logs
- What is the use of Patches in SAP system? Could you name few common patch types?
In SAP system, when a bug is found you have to use patches to fix the bug. There are different types of patches that can be used in SAP system. All patches start with SAPK followed by patch type.
ABAP (SAPKA620XXXX)
ABAP (SAPKA620XXXX)
ABAP (SAPKA620XXXX)
ABAP (SAPKA620XXXX)
- In what sequence patches should be applied in SAP system?
Patches are also called support packs and they should be applied in this sequence −
BASIS (SAPKB620XXXX)
ABAP (SAPKA620XXXX)
ABAP (SAPKA620XXXX)
APPLICATIONS (SAPKH470XXXX)
- Where do you download Support Package and Stack update?
You can download support package from SAP Service Market place. Open the link- service.sap.com and login with your SID.
- How do you perform proactive monitoring of Application servers, CPU Utilization, Database space, monitoring log files?
System monitoring involves proactive monitoring of Application servers, CPU Utilization, Database space, monitoring log files, etc.
System monitoring also includes −
- Batch Jobs monitoring
- Batch Jobs monitoring
- Monitoring Application Users
- Spool Request Monitoring
- Print Requests
To monitor SAP system, use Transaction SM51
- What is RFC connection?
To communicate between SAP systems, there is a need to define a mechanism. One of the most common way is to define Remote function Call RFC connection between two systems. By creating a trusted RFC connection between two, it allows you to create trusted-trusting relationship between systems and you can communicate and exchange information and data.
- What are the different types of Trusted RFC connections in SAP system?
Type 3
This connection type is used to specify connection between ABAP systems. As mentioned in next article, you need to mention host name and IP address of source system and also the logon information. This is applicable for both type of RFCs, between ABAP systems and external calls to ABAP systems.
Type I
It is used to specify ABAP systems connected to the same data base as the current system.
Type T
It is defined as connection for destinations to external programs that use the RFC API to receive RFCs. This can be activated using start or registration.
- How do you create Trusted RFC connection in ABAP system, Explain?
Creating a Trusted RFC Connection −
On your source SAP system AA1 you want to setup a trusted RFC towards target system BB1. When it is done it would mean that when you are logged onto AA1 and your user has enough authorization in BB1, you can use the RFC connection and logon to BB1 without having to re-enter user and password.
Using RFC trusted/trusting relationship between two SAP systems, RFC from a trusted system to a trusting system, password is no required for logging on to the trusting system.
Open SAP ECC system using SAP logon. Enter transaction number sm59 → this is transaction number to create a new Trusted RFC connection.
Part 2:
1) What is SAP Basis?
SAP basis acts as an operating system or a platform for SAP applications to run. It supports the entire range of SAP applications.
2) What is the difference between Developer Trace, System Log and System Trace?
- System Trace: When you want to record internal SAP system activities, system trace is used. The trace is useful in diagnosis internal problems within SAP system and the host system.
- System Log : To know the recent logs for application server and CI, System log is referred.
- Developer Trace: In the event of problems, developer trace, records the technical information about the error or problem
For problem analysis and system monitoring Developer trace or System log is used.
3) In a situation where My SAP system is down (Users unable to login to SAP system), how to analyze the problem?
- Check the Database status
- SAP services
- SAP management console ( Dispatcher, IGS and Message Server)
- You need to find out trace root on the basis of point at serial no ( c ).
- Check network connectivity if everything is ok
4) What is private mode?
In private mode, the heap data is exclusively allocated by the user and is no more shared or available across the system. This occurs when your extended memory is exhausted. Interview Questions and Answers
5) What is OSP$ mean?
Two users “OPS$adm” and “OPS$SAP” Service are created in your SAP system and to connect and communicate with database internally this user mechanism is used.
6) What are the different types of RFC and explain what Transactional RFC is?
RFC (Remote Function Call) is a mechanism to communicate and exchanging the information between other SAP systems. There are four types of RFC’s system
- Synchronous RFC ( S RFC)
- Asynchronous RFC (A RFC)
- Transactional RFC ( T RFC)
- Queued RFC (Q RFC)
Transactional RFC ( T RFC ) : This type of RFC is similar to asynchronous RFC, but by allocating a transaction ID (TID) it makes sure that the request sent multiple times due to an error must process only for once. In T RFC the remote system does not have to be available at the moment unlike asynchronous RFC.
7) What is OCM and how to apply OCM Patches?
OCM stands for online correction system, by using SPAM you can apply OCM Patches.
8) How to perform a SAP-export and import tables in SAP from OS level?
To export or import tables in SAP from OS level you have to follow three steps and by using R3trans utility in SAP
Step 1: Collect all list of tables to be exported
Step 2: Check whether enough disk space is available in the directory where you going to export.
Step 3: Create two control files for R3trans which will be used for import and export.
9) What is the difference between – support package, kernel and SAP note?
SAP Note: An error in a single transaction or program is removed by implementing a SAP note.
Kernel: Kernel contains the executable files (.EXE) like other applications and when a Kernel upgrade is done a new version of the EXE file replaces the older versions.
Support Package: SAP support packages is a bunch of corrections, this can be used by applying transaction SPAM
10) How can you find the list of objects that have been repaired in the system?
The list of objects that have been repaired can be found in the system having ADIRACCESS keys.
11) What is the purpose of table TADIR?
Table TADIR contains object directory entries.
12) Is it possible to install SAP patches when other users are online?
When other users are online we can’t install SAP patches, as support manager will not be able to update and it will terminate it. So it is always feasible to better apply support packs when there is no users login into the system.
13) Mention what is the difference between SDM and JSPM?
JSPM ( Java Support Package Manager) is used to apply support packages on deployed software components. In other words it’s a tool that allows you to install the components and support packages.
SDM ( Software Delivery Manager) is used for importing Java Support Packages. To deploy and manage software packages received from SAP, SDM tool is used.
JSPM uses SDM for the deployment purpose
14) What is the procedure to disable import all option from STMS in SAP?
To disable import all option from STMS in SAP, steps are:
- Go to STMS T-code
- Go to menu option overview
- Select System
- Choose SAP System
- Go to transport tool tab
- Create parameter “No_Import_All” with value set as 1
- Save it
15) Mention the use of personalized tab and parameter tab in user master record?
Parameter Tab: It will allow access to assign T-code on which one has to work
Personalization Tab: It is required for RFC connection between systems other than user personal information
16) What is the different type of users in SAP?
Different types of users in SAP are
- Dialog Users
- System Users
- Communication Users
- Service Users
- Reference Users
17) Explain what is the use of reference and service user in SAP?
- Service User: For “service user” initial password or expiration of password are not checked. Only admin has rights to change the password, users cannot. Multiple logins are possible.
- Usage: Service users are for anonymous users. Minimum authorization should be given to such type of users
- Reference User: For this kind of users GUI login is not possible.
- Usage: In case of emergency, with the help of reference user, it is possible to provide one user authorization to another user.
18) Explain how you can restrict multiple logins of user in SAP? What are the thing you have to take care of while writing the ID’s?
To restrict multiple logins you have to set the parameter as
Parameter should set in RZ10
- a) login/multi_login_users= set to 1 to activate (If this parameter is set to value 1, multiple dialog logons to the R/3 system are blocked)
- b) login/disable_multi_gui_login= List out the users that should be allow to logon for multiple times
While writing the user ID’s things to be taken care are, list the user IDs separated by commas “..” , between user IDs do not leave space characters and to see the changes restart the R/3 instance.
19) At OS level how you can change the number of work process? How you can analyze the status of work process at OS level?
To change the number of work process at the OS level, you can increase the no. of work processes by modifying the parameter rdisp/wp_no_=
Status of a WP at OS level can be checked by executing dpmon.
20) Explain how to define logon groups?
Logon groups can be defined using the Tcode smlg. In order to do that you have to create the group and then assign the instances for that particular group.
21) What is SAP single stack system?
A single stack system is defined by SAP system either with JAVA as runtime engine or SAP Netweaver as ABAP.
Eg: Single Stack System (Java) is SAP Enterprise Portal System (Ep)
Single Stack System (ABAP) is SAP ERP (ECC)
22) What are the tools to install JAVA patches?
To use the JAVA patches , SAP installer (SAPinst.exe) is employed. SDM and JSPM are the latest versions of tools used to deploy Java Patches.
23) Explain what is “Data Sets” in SAP?
To solve queries which cannot be solved by using the method interfaces, a set of information is used. This set of information is known as “ Data Sets”.
24) At O.S level where to check for system logs of SAP application?
To check the system logs of SAP application at OS level, SAPMMC -> SAP systems -> SID -> SysLog
25) Explain what is LUW (logical unit of work)?
A list of steps among t-code in known as logical LUW
26) Explain what is heterogenous system copy and homogenous system copy?
Homogenous system copy= Same OS + Same Database
Heterogeneous system copy= Different OS + Different database or same database
27) Explain what are the functional modules used in sequence in BDC?
Using BDC programming a data can be transferred successfully. There are 3 functional modules which can be used in a sequence.
- BDC _OPEN_GROUP: Name of the client, sessions and user name are specified in these functional modules.
- BDC_INSERT: It is used to insert the data for one transaction into a session.
- BDC_CLOSE_GROUP: It is used to close the batch input session.
28) Explain what is an “OK” code is and what is the difference between “t-code” and “OK” code?
An “OK” code is used by a program to execute a function for example after a push button has been clicked.
Transaction code or “t-code” is a “shortcut” that helps a user to run a program.
29) Explain how client refresh is different than client copy?
Client refresh is overwriting or copying to existing client, while copying the newly created client is called client copy.
30) What is a background processing batch scheduler?
To check the schedule background jobs and to execute them parameters like rdisp/btctime is used. These parameters define background processing batch scheduler.
31) Explain what is SAP IDES?
SAP Internet Demonstration and Evaluation System or SAP IDES, this system demonstrate the functionality of various SAP solutions used by important customers.
32) Explain what is the purpose of TDEVC ?
The purpose of TDEVC contains development classes and packages.
33) How many types of work processes are there in SAP ?
There are seven types of work processes they are:
- Dialog
- Enque
- Update
- Background
- Spool
- Message
- Server
- Gateway
34) What is the role of “Application Server”?
Application Server takes the request from the user and if the request requires data then it connects to the database server and gives output.
35) What is process for applying patches?
Process for applying patches are:
- Download patches from the service .sap.com to Trans Directory
- Using CAR command extract the patches in the Trans Directory
- Using SAPM, import patches into SAP level and Apply
36) How to perform the transport?
Transport can be done through STMS_IMPORT or through FTP.
37) What are the types of transport queries?
- Customising Request
- Workbench Request
- Transport of Copies
- Re-location
38) Explain what is business KPIs?
Business KPIs are Key Performance Indicators. It indicates the performance of a company at a strategic level. They help in leading the company on the desired track by comparing company’s previous performance with the market leaders in the same market.
39) Explain what is the importance of table T000?
Table T000 contains a list of defined clients, where we can maintain transaction code SCC4.
40) What is SAPS?
SAPS stands for SAP Application Performance Standard, which is a hardware independent unit which describes the performance of a system configuration in SAP environment.
41) Mention what is the difference between Central Instance & Application Server?
Central Instance has message server and dialog, update, spool, enque, gateway, background work processes.
Application server has dialog, update, spool, gateway and background work process.
42) In what ways you would know whether a system is Unicode or Non-unicode?
By code sm51 t-code we can see whether it is Unicode or non-unicode. In this code we can find the release notes button in the application tool bar if you click on that you can see the total information like Database, Kernel version, Unicode or non- Unicode.
43) In SAP basis what are the different types of transport requests?
Four types of transport requests are there
- Customizing request
- Workbench request
- Transport request
- Relocation
44) What is logical system? How to create and why?
For communication between systems within the landscapes logical system is required. It enables the system to recognize the target system as an RFC destination.
TCODE used is SPRO
45) How you can assign an object to 100 roles at time?
To assign an object to 100 roles at time,
- Go to sell T-code from there go to the table agr_agrs.
- You will be asked for Access key
- Enter the objects that needs to be added to 100 roles
- Select the range of roles in which the object needs to be added
- Save or Activate whatever option is given
46) On a particular system how you can get a list of the users with development access on a particular system?
By using table “DEVACCESS” you can get a list of the users with development access.
47) How can you view locked transactions?
To view locked transactions you need to look in field CINFO, table TSTC. Within SAP you can either use SE11 or SE16 to browse the table contents. Make sure that you enter “A0” as the “HEX01 data element for SYST” starting value and “A9” as the ending value. This will list all the transactions locked in the system.
48) What is an ‘OK’ code? What are the differences an ‘OK’ code to a ‘T-code’?
OK code is used by a program to execute a function for example after a pushbutton has been clicked. A transaction code is a “shortcut” that helps a user run program.
49) How you can disable the ‘Import All’ button on STMS for the queues?
- Login to your Transport Domain Controller
- Run STMSàOverviewàSystem
- Choose the system you want to disable ‘Import All’
- Go to Transport Tool tab
- Add/Create parameter “ No_IMPORT_ALL” set its value to 1
50) How you can apply SAP notes to SAP system?
- Goto Tcode SNOTE
- GOTO MenuàDownload SAPNote
- Give the Note No
- After downloading check the status, if implemented
- Select Note, GOTO Menu SAPNoteàImplement Note
51) Mention what is the purpose of table USR02?
This table stores passwords and User IDS.
52) What is the difference between kernel replacement and support package?
Kernel replacement is the replacement of the SAP executable on the OS level, while support package contains fixes to the ABAP code within a SAP instance.
53) Which are the most frequent errors encountered while dealing with TRANSPORTS ?
Return code (4) indicates import ended with warning.
Return code (8) indicates not imported ended with error
Return code (12) indicates import is cancelled.
Return code (16) indicates import is cancelled.
54) How will go about doing a client copy ?
You can do a client copy using the SCCL transaction
55) List the difference between asynchronous and synchronous transport –
Synchronous Transport – Dialog or batch process are blocked until import is ended
Asynchronous Transport – Dialog or batch process is released after import is started.
55) How will determine whether your SAP server is Unicode or ASCII ?
Go to SM51 , Click Release Notes. Entry corresponding to ICU Version will tell you whether your system is ASCII or Unicode.
56) List the types of Transport requests?
There are 4 types of transport requests in SAP –
- Customizing Request
- Workbench Request
- Transport of Copies
- Relocation
57) What is the difference between Consolidation and Development route ?
In consolidation route – objects can be changed and they can transport from one system to other. This is the route between development to quality
In Development route – Objects can not be changed and they can not be transported from one system to other. This is the route between quality to production
58) How will you define logon groups ? What is Load Balancing in SAP ?
You can set the logon group using SMLG transaction.
59) What is supplementation language ?
Default SAP systems are pre-installed with English and German.
SAP does support many other language which may not full translate from the default English and German. To fill this gap , Supplementary language (a program) is installed.
60) Is SAP a database ?
NO . SAP is not a database but it uses databases from other vendors like Oracle. Although SAP has recently released its own database HANA
61) Which transaction do you use to check Buffer Statistics ?
ST02 , RZ10
Part 3:
- What Are Steps To Install Sap?
Answer :
- Install os load the VGA and LAN drivers after increase the SWAP Memory 3 timesof physical RAM and Assign IP Address .
- Install Kernel patches and java files
- Install dialog and central instance (Start à Programs SAP system setup of install DialogandCentral and Database instance .
- C11a install central and database instance.
PARAMETERS:
1.Memory
2.Number of parallel process
3.Instance number
4.SID
5.Central Transport host
6.Data base name
7.Sap data.. Up1 to Data six locations .
- What Is The Folder It Will Ask To Install Oracle ?
Answer :
Orahome81 path=Oracle.
- What Is You Allocate Disks To Different Areas In Sap ?
Answer :
- Disk1,Disk2,(Raid 1 min 4 GB)à winnt, Saparch.
b. Disk3,Disk4( Stripe Min 4 GB)à swap.
c. Disk5 (min 4 gb) Origilog A, Mirror log B, TRANS:
d. Origlog B , Mirror log A, SAPREORG.
e. Sapdata1, Sapdata2 ,Sapdata3 , up to Sapdata6. - How Much Swap Memory Should Be In The System ?
Answer :
Three times of main Memory – at least 2GB.
- What Is Meant By The Terms L And F Access?
Answer :
An L access method refers to local printer. It is local to the SAP server, not the user.
An F access method refers to front end printer. This uses the users Windows printer.
- How Many Types Of Work Processes?
Answer :
There are 7 types:
( Dialog , Enque , Update , Background,Spool,Message server,Gateway)
- What Is Difference Between Central Instance And Dialog Instance ?
Answer :
Central Instance have message server installed on it where as Dialog Instance do not have message server.
- How To See The Work Process Status ?
Answer :
SM50.
- How Many Types Of Printer You Have Configured ? How Do You Differentiate Between Them ?
Answer :
4 types of printers
Production Printing , Mass Printing ,Test Printing, Desktop Printing .
- Where Printer Port(lpt) Is Running On The System ?
Answer :
Network and Desktop printers.
- What Is The Transaction Code For Creating Roles And How To Users And What Is Method You Will Follow ?
Answer :
PFCG , then we generate the profile after that assign roles to users.
- Have U Applied Patches What Is The Transaction Code ?
Answer :
yes, SPAM.
- What Are The Two Files Present While Importing Patches From Os Level To Sap Level ?
Answer :
PAT,.ATT.
- On Which System You Have Applied Patches ?
Answer :
DEV and QA.
- How Many Types Of Client Copies And Which Method Do You Prefer ?
Answer :
we prefer mainly remote Client Copy.
- What Is The Difference Between Remote Client Copy And Client Export ?
Answer :
RemoteCopy Using RFC connection we will perform remote copy.
ClientExport Using TMS configuration we will perform client export and then we have to import client to copy the client – STMS has to be created first for doing Client Export.
- How Mucn Time It Will Take To Copy A Client Of Size 650gb?
Answer :
More than 17 hours.
- What Is The Job Of Application Server?
Answer :
It takes the request from the user and if the request requires data than it connects to database server and gives output.
- What Are The Daily Activates?
Answer :
Background job logs, Spool Logs, Work Processes Overview , Users Overview, All Application Servers active or not .
- What Will You Observe In St06 ?
Answer :
CPU, SWAP , Memory , Hard Disk Space.
- What Is St03 ?
Answer :
Workload Analysis.
- What Is The Difference Between St06 And St03
Answer :
ST06 is OS Monitoring.
ST03 is used for – Monitor OS and Database and SAP System.
- What Will Observe In St03?
Answer :
Hit Ratio and Buffer Fillers and Roll Memory and Swap memory .
- Have You Configured Operation Modes?
Answer :
yes (RZ04,SM63,RZ03).
- Where Will You Change The Parameters In Three Profiles?
Answer :
Instance Profile ,RZ10.
- Can You Change The Profile Parameter In The Os Level? Which One Is Advisable Why ?
Answer :
We can change the profile parameter from OS level. Its not recommended .
- What Is Development Class ? Why To Create The Development Class ?
Answer :
Group of requests under one logical name is development class. When ever we change in R3 repository it should be assigned to development calss and it internally assigned to transport layer .
- Do You Know About Oss What Do You Do With Oss?
Answer :
Yes it is online system service.
- Do You Know Logon Groups At Which Situation Will Be Created Logon Group ?
Answer :
Yes, If we find load on application server then we have to create logon group (If the production department users are more than we have to create logon group for that department ).
- How Many No Of Users Have Been Connected To That Particular Logon Group ?
Answer :
100 to 150 users.
- What Is The Purpose Of Enqueue Processor ?
Answer :
Enque work process makes sure that database in consistent state.
- What Are The States Of Back Ground Job ?
Answer :
6 states
- Scheduled
- Ready
- Released
- Active
- Finished
- Cancelled
- If A User Complaints That He Could Not Execute Some Of The Transaction Codes Then What Will You Do ?
Answer :
Use T-code SU53 , This will show which authorization is missing in his profile.
- What Are The Daily Transactions ?
Answer :
AL03,SM04,SM37,SP01,SM21 etc..
- What Are Patches You Applied ?
Answer :
SAP_BASIS,SAP_ABAP,SAP_HR,SAP_SD.
- What Are The Different Types Of Sap Profiles?
Answer :
There are 3 types of profiles in SAP.
They are
- DEFAULT.PFL (known as System Profile)
- Start Profile
- Instance Profile
- What Is Purpose Of Logon Load Balance?
Answer :
To distributed the workload between application servers.
- Which Tcode Is Using Logon Load Balance ?
Answer :
SMLG.
- I Am Having Two Application Servers The Logon Load Balance Is There ; If The User Wants To Connect To Application Server Which Will Connected First.
Answer :
Messages server is will assign the Application server automatically.
- How Do You Distribute The Load.
Answer :
Depend upon the load, according to module we have to configure logon groups.
- How To Analysis Abap Dumps ?
Answer :
- By seeing ABAP dump error we come to know that whether the error or developer technique.
- If belongs to insufficient memory dump error display at which stage the transaction terminate and how much memory requires. So that we have to increase the memory (Through Instance profile).
- If belongs to table space error it displays the table name so that we increase the table space through the SAPDBA.
- If belongs to program error we have analysis the ABAP program through se30.
- If belongs to developer technique cancel the ABAP program.
- Each And Every Work Processor Is Full Even Though The User Wants To Execute The Program. Then What’s The Solution ?
Answer :
- If you don’t have second applicaitno server than we have to cancel te particular work processor (through SM50).
- If u have second application server than we have to configure the logon groups.
- At What Stages We Need To Transport The Requests?
Answer :
Whenever we need the change the objects and need to transport we have to perform transports like user request , client transport etc..
- How To Perform The Transport?
Answer :
Through STMS_IMPORT or through FTP.
- What Is The Procedure To Applying Patches ?
Answer :
first we will download the patches from the service .sap.com to Trans Directory . In the trans Directory extract the patches using CAR command after that using SAPM we have to import patches into sap level and apply.
- How To Configure Tms ?
Answer :
Select all systems in a landscape and select for domain controller and type stms and give domain name and go to remaing systems and configure the same and come to dc and select configure and distribute option . Create transport route and paths .
- If Your Sap Landscape Is Composed Of A Dev Server And Prd Server And You Need To Transport A Change Request From Dev Client 111 To Dev 131 (i.e. Transport In The Same Server). How Can This Be Accomplished?
Answer :
Transaction SCC1.
- We Have Recently Experienced Some Internet Outages Caused By Our Isp. Although We Have Resolved Our Isp Problems, The Users Refuse To Believe That Losing The Internet Connection Was To Blame For The Sap Problems. How Can We Ensure That This Was An Internet Problem And Not An Sap Problem?
Answer :
Open a maintenance window, connect to the machine and kill the ISP connection and see if this kills your connection. Repeat at will until they believe that the ISP was the problem.
- What Is An Ok Code? What Are The Differences An Ok Code To A T-code?
Answer :
An OK Code is used by a program to execute a function for example after a pushbutton has been clicked. A transaction code is a “shortcut” that helps a user run a program.
- Where Are T-code Name And Program Values Stored? How Can I Find A List Of All The T-codes In The Sap System?
Answer :
You can use transaction st11 to view Table TSTC. You can define a new t-code using transaction se93.
- How Can One Disable The “import All” Button On Stms For The Queues?
Answer :
Login to your Transport Domain Controller. Run STMS->Overview->System. Choose the System you want to disable import all. Go to Transport Tool tab. Add/Create Parameter “NO_IMPORT_ALL” set its value to 1.
- What Are The Different Types Of Work Processes In R/3?
Answer :
Dialog (D), Update (U), Enqueue (E), Background(B), and Spool(S).
- Why Can Web Help Be Considered Easier To Install Than Chm, The Standard Delivered Sap Help?
Answer :
Web help is easier than trying to get every remote user connected to a network share. If you don’t want to use SAP’s help site, you can setup your own website to do it. The best route depends on your business’ network structure.
- What Is The Difference Between A Client Copy And Client Refresh?
Answer :
Some times these are the same, For example, if you are performing a copy to an existing client for the express purpose of updating the data, then it is called Client Refresh.
If you are copying to a newly created client then it is more appropriate to say “client copy.”
Another way of thinking about this is that a client copy from production to a QA server or from production to DEV server is really a client refresh.
- What Is The Purpose Of Table T000?
Answer :
Table T000 contains a list of defined clients, which you can maintain with transaction SCC4.
- What Is The Purpose Of Table Usr02?
Answer :
This table stores User IDs and passwords.
- What Is The Purpose Of Table Tadir?
Answer :
Table TADIR contains object directory entries.
- What Is The Purpose Of Table Tdevc?
Answer :
Table TDEVC contains development classes and packages.
- How Can You Get A List Of The Users With Development Access On A Particular System?
Answer :
Table DEVACCESS.
- Where Can You Find A List Of Object Keys Included In A Transport?
Answer :
E071K Object keys contained within transports.
- How Can You Tell If A Transport Entry Is In The Process Of Being Imported?
Answer :
Check table TRBAT.
- How Can You Find A List Of Objects That Have Been Repaired In The System?
Answer :
ADIRACCESS List of repaired objects and their access keys.
- What Is The Difference Between Tp And R3trans
Answer :
TP controls the process and calls several tools, like r3trans but also e.g. DDIC-Activation.
- Is There A Difference Between User Ddic And Sap_all/sap_new ?
Answer :
Yes, DDIC is hard coded to do some things other IDs cannot. But you should be able to activate tables in SE11 using a SAP_ALL user.
- What Is The Purpose Of The Unix File /etc/passwd ?
Answer :
/etc/passwd contains valid user passwords, accounts, default login directories, and user security permission levels.
- Is It Possible To Install Ecc 5.0 As A Test System And Not Production, Without Installing Solution Manager?
Answer :
During the installation you will be asked for a key, which can only be generated by the solution manager.
- We Are Trying To Install Java-add An Abap System As Part Of An Xi 3.0 Installation. At The End Of The J2ee Installation, While Trying To Start Sap J2ee Engine, A Timeout Error Occurs. How Would You Fix This?
Answer :
Increase paging space to 20 GB.
- I Received 2 Transports (k And R) To Be Imported From An External Vendor. We Need To Import These Into Our Qa System. I Have Moved The Transports To The Cofiles And Data Subdirectories. What Do I Need To Do Next?
Answer :
Follow pathway STMS -> Overview -> Imports.
Double-click on QA’s SID. Next, follow path Extras -> Other Requests -> Add. Finally, type transport number and import as you would normally transport.
- We Have A Sap R/3 47×200 (unix/oracle) The Sapdba Program No Longer Exists Since We’ve Upgraded From 6.20 To 6.40. Where Can I Download Br*tools Gui For Oracle Dba -gui After Installing Kernel 6.40?
Answer :
You can still use SAPDBA from version 6.20.
You must however combine it with BR*Tools 6.40.
- We Are Planning An Upgrade Of The Os From The Existing V5r2 To V5r3 Of Our I-series Server Which Hosts Sap Application. We Are Currently On R/3 Release 4.6c At Support Pack Level 50. After We Do An Upgrade We Plan To Migrate All Applications To A Power 5 I-series 550 Server. Our Current Kernel Is Ascii 46d Patch Level 1977. Should We Consider A Sap Kernel Upgrade?
Answer :
Before upgrading OS , database or SAP version, Always update your kernel to latest level.
- The Job “sap_collector_for_perfmonitor” Is Being Continuously Being Cancelled In Our Quality System Bw. I Keep Receiving An Error That Says The Load Program Is Not Found. What Should I Do To Resolve This?
Answer :
The problem is in the support package. The Solution is you need to delete the SWNC* reports and insert RSSTAT83 and RSSTAT87 into TCOLL.
- Is There A Way To Change The Transport Request Number To Start With A Number That I Choose?
Answer :
Assuming your release is 4.6, user SAPR3 is owner of the database. Call the last transport number by issuing “select * from sapr3.E070L.” Change the transport sequence number by issuing:
”Update sapr3.E070L set TRKORR='<SID>K9xxxxx’.”
If your SAP release is higher than 4.6, replace SAPR3 with the owner of the database.
- I Want To Change Five Dialog Work Processes Into Batch. Where Can I Do This?
Answer :
You can configure work processes through parameters in RZ10. Use “rdisp/no_wp_dia” for dialog and “rdisp/no_wp_btc” for background. Or you can configure operation modes for that through RZ04.
- How Would I Setup Table Maintenance For Customized Table Z1?
Answer :
Use Transaction code SE11.
- The Temporary Spooling Table Space Is Approximately 5gb In One Of Our Customer’s Production Systems That Runs 24 Hours A Day. We Would Like To Reduce This Over Time. What Strategy Would You Have For Reducing This Tablespace?
Answer :
You could schedule report RSPO0041 for deleting the spool (TEMSE) objects. Schedule it as a daily background job in order to minimize impact on your system.
- I Installed The Kernel Patch 6.40 Level 098 And Now The Transport System Is Not Working Properly. The Job Rddimpdp Is Not Starting, Although I Start It Manually. I Keep Receiving Error Messages. How Should I Solve This Problem?
Answer :
First go into SE38 in both client 000 and your working client. Run program RDDNEWPP. This will schedule program RDDIMPDP with proper parameters. Then, check if any “TP” programs are running . If this is the case, check in /usr/sap/trans/log and look for the most recent files contents.
- Is There Any Report Or Table In Which User Log Off Time Is Stored In Sap?
Answer :
There is no standard report. However, you can find out about the user’s last transaction time in table USR02 and field TRDAT, which is close to logoff time.
- Is It Safe To Delete Old Background Jobs Using The Program Rsbtcdel While Users Are Working In The Prd Server?
Answer :
Yes. It is safe to run this program while users are working since this only deletes jobs that were completed or aborted, not active jobs.
- We Are Currently Running 4.7 Enterprise On Oracle 9.2.0.6, On Solaris 9. I Am In The Process Of Upgrading Production Which Has A Central Instance Server And 3 Application Servers Where The Sapmnt Directory Is Shared Out From The Central Instance Server. I Upgraded The Kernel On The Central Instance With No Problems, But When I Try To Start Sap On The App Servers I Receive An Error Message Stating The Database Must Be Started From A Remote Server. I Have Changed All Environment Variables But I Still Receive The Error Message. What Could Be The Issue?
Answer :
Ensure that the Oracle client is properly installed on each of the application servers. Also, make certain that you are using the latest versions of all of the kernel, associated files (R3trans, tp, startdb, stopdb, etc.) and the DB library.
- What Is Meant By The Terms L And F Access Methods?
Answer :
An “L” access method refers to local printer. It is local to the SAP server, not the user. An “F” access method refers to front end printer. This uses the user’s Windows printer.
- I Am On Sap 4.7, 6.20 Hp Ux Oracle. When We Complete Our Weekly Offline Backup, Application Is Not Coming Up And The System Goes Down. Which Log Will Give Some Input As To What Is Wrong With The System?
Answer :
Start with the alert log. It is usually found in oracle/SID/saptrace/background/alertSID.log.
- Will A Client Copy Transfer The Background Job Schedules And All Client Dependent Data?
Answer :
SAP_ALL will copy all client dependent data including schedules to the new client. Remember that ABAP programs are always client independent. Only the masterdata (variant) is client dependent.
- I Have An Abap+j2ee Instance On Xi 3.1. Is It Necessary To Stop Web As And J2ee To Apply The Support Packs For J2ee?
Answer :
Any J2EE patches are applied while system is up and running but no activities. The only patch applied while system is down are binaries (ABAP kernel).
- When I Check Transaction Sm37 And I Want To See The Spool I Get A Message That Says “no List Available.” Why Is This?
Answer :
There are several possible reasons. The spool is sent to a printer and deleted. The spool is too old and the housekeeper deleted it. Also, some test reports simulate a calculation then rollback. It works fine online. When a background job does a rollback then it rolls back the spool as well.
- I Have Some Housekeeping Abaps That I Have To Create Variants For. There Are Cases When I Have To Specify A Time Interval For The Abap In The Variant. If I Explicitly Enter A Start And End Date They Will Remain At That Current Date Continuously. Is There Any Way To Dynamically Enter Dates In The Variant?
Answer :
In transaction SE38 enter the variant name and choose the attributes radio button. Here you can set the field to “selection variable.” Then, under selection variables button, you can define that it is SY -DATE+7.
- Some Transactions In Sap Are Seen As Customizing, For Instance Ovrf (updating Routes). In Some Systems This Is Set As Master Data And Can Be Set Open. Where Do You Do This?
Answer :
That depends on each transaction. Sometimes it is determined by other configuration and sometimes it is set according to system function, production or test/develop/demo/etc.
- We Are Running Win 2003, Oracle 9i, Sap 4.7. We Are Having Performance Issues Around Tx Miro Which Updates Table Rbkp. Table Rbkp Has Five Indexes In Sap, But Only Three Of Which Exist In Oracle. Why Is This?
Answer :
In SAP there are many predefined indexes.
You can see these indexes via DB02->checks-> database ->ABAP dictionary ->display. Under optional indexes you see all indexes of which the definition is created in the dictionary, but not created at database level.
- I Need To Do A System Copy From Prd To Tst. I Cannot Follow Sap Documentation, But Must Do It Manually. When I Run “@/tmp/tstcntrl.sql,” Will It Change All The Prd To Tst In The Restored File Names? Would The Restored Files Be Recognized As A Tst System?
Answer :
You must first open the DB as PRD on your new system. Second, apply redo logs. Next, run your script to change SID. This will change SID but will not change tablespace names if using WAS 6.10 or above.
- Will Restarting The Prd Server Every Week Affect Server Performance?
Answer :
When you restart the server, the SAP ABAP program buffer and other buffers are emptied. As far as performance goes, the reports runtime will be a bit longer during the first run. You can restart the system every week without harm. The only reason against it may be the SLA/users demand.
- I Am Attempting To Complete A System Copy Of Bw. When I Try To Go In To Rsa1 Afterwards I Get The Error Message, “entry In Inbound Table Already Exists.” What Should I Do To Solve The Problem?
Answer :
Read the homogenous system guide and follow all directions under “subsequent steps” section. Check transaction codes BDLS and SALE as well.
- One Of My Btc Jobs Fails When I Try To Run It, Giving Me An Error Message Stating “lock Table Overflow.” It Recommends To Modify The Enqueue / Table Size Parameter To Solve This Issue. I Do Not Have This Value In My Default Or Instance Profile. How Do I Solve The Problem?
Answer :
Run ABAP RSPARAM program. It will give you the real value of the SAP parameter and where they have been set up. The lock table can hold 10,000 entries, which is more than enough for the average system. It is possible that the program is not written properly and the developers should modify it.
- I Am Working On A Backup Strategy To Disk. I Want To Perform A Copy_save_delete Equivalent On Various Disks. This Function Does Not Work For Disk Saves But Ideally I Would Like To Have Two Copies. Is There Another Function I Can Use?
Answer :
In your init<sid>.SAP file log on to another drive/server to store another copy of your archive log.
- While Doing Sap Installation Of Db Instance On A Different Box Other Than Ci, The Input We Have Given In Sapinst Of Db Instance Is Wrong In System Number Of Ci Instance. How Can I Change This Entry After Installation?
Answer :
You must reinstall the CI instance with the right system number.
- Are Direct Updates On Sap Tables Allowed?
Answer :
You can call SAP functions directly to update data (RFC calls) but it is not recommended to try and manipulate data directly at database level (sql scripts, jdbc).
- When Sending An Email From Transaction Sbwp I Wish To Enter The User’s Login Name Only, Not An Email Address. Also I’d Like Sap To Look At The User Details Email Address And Communications Method Held In Su01 And Send The Mail To This External Email Address. Can This Be Configured?
Answer :
Yes. Follow pathway SO16-> Tab Mail Sys group-> bottom radio button.
- In My Development Server When I Perform St02 The Program Buffer Shows A Value Of 1056 In Red Under The Swap Category. Users Are Getting A Shortdump With The Pxa Buffer Error Message. What Should I Do?
Answer :
Use “my links” in “my signature” and use the keywords: PXA Buffer.
- When We Install Sap R/3 Enterprise 4.7, There Are Several Error Messages In The Sapview.log. What Does This Mean?
Answer :
This means that one of your load jobs did not run successfully.
- I Am Installing A Sap J2ee Engine At Crm. When It Reaches Phase 22 It Halts For More Than 10 Minutes And Gives Up Starting The System. What Should I Do?
Answer :
A restart is often the solution. If it is an add-in and you have restarted your ABAP then you may be missing the profile parameters. If this is okay and a restart does not help look in the work directory and check dev_icontrol. If the J2EE engine software is the problem, applying a patch will solve the problem.
- How Do You Configure The Internet Email Gateway In Sap Netweaver 04?
Answer :
Starting with version WAS 6.x, SMTP comes built in to kernel. Go to transaction. SCOT and configure it there.
- We Setup A Saprouter In Dmz So That All Sap Requests Can Be Routed In And Out From That Machine And The Sap Application Servers Are Not Necessary To Be Exposed To The Internet User. However, The Saprouter Does Not Handle The Bw Web Reporting Application Requests. We Do Not Have E.p. Are There Any Tools Which Can Help Us To Route Web Reporting Requests The Way Saprouter Does?
Answer :
You need a SAP Web dispatcher. It acts like a SAP Router but routes SAP ICM traffic. BW Web reporting is a BSP that sits on the ICM. You can look for sapwebdisp.exe in the kernel directory or do a self-generated profile using command option “bootstrap.”
- After A Recent Upgrade Of Kernel 6.20 To 6.40, While Doing A Transport I Received Several Warning Parameters Although Everything Looked Okay On Sap T-code Stms, What Should I Do About The Warning Parameters.
Answer :
You can delete these parameters from TPPARAM.
- We Have A J2ee + Abap 6.40 Instance Running A Portal 6.0. It Seems 1gb Of Memory Is Not Enough And J2ee Has Problems If We Assign More. What Can Be Used To Balance The Load In The Servers?
Answer :
You can create a second server process using config-tool. Also, load balancing is possible through SCS.
- When I Release All Of The Requests To Dev It Is Not Being Displayed In An Import Queue On The Qa System (t-code Stms). When I Check The Log Of Transport Request Overall Status Is Successful, But A Message Appears Saying “continue: Other Transport Group.” Why Is This Message Appearing?
Answer :
The transport group for QA is misconfigured. Go to STMS, then Overview. Double-click QA and choose communication. Next enter the correct transport group and save.
- I Need To Schedule A Background Job To Run For 3 Consecutive Days And Would Like To Use Db13. How Can I Schedule A Report To Run From Db13 And Not Sm37?
Answer :
There is no way to schedule a report to run from DB13 other than pre-configured DBA jobs. Instead, use SM36 and make the jobs event driven.
- Is There A Way To Find Out What Was Entered In A Particular Transaction Code Screen?
Answer :
No, but you can analyze tables associated with the transaction code and see if there is a username field that traces what this user has done.
- I Want To Let Sap Skip Printing Cover Pages During Printing For Any Kind Of Report. How Can This Be Done?
Answer :
Find the source for the cover page. It will either be from SAP itself or the OS spooler. Take the appropriate action.
- I’m Trying To Send Email From Sap To Microsoft Outlook. When I Attempted To Configure Sapconnect It Failed. On Unix Level I Try To Run Command “mlunxsnd” And “mlosmadm” But Found That It Doesn’t Exist In Unix. How Should I Solve This Problem?
Answer :
In versions with basis release 6.20 or higher, you don’t need to use sapconnect. Directly put your mail server in the SMTP node in SCOT.
- In Our Dev System We Have Opened The Client With All Options “changed Without Automatic Rec,” “changes To Repository And Cross Customization Allowed,” And “protection Level-0 No Restriction” In Scc4. The Developers Complain That They Get An Error Message Saying The System Is Non-modifiable. What Should We Do To Fix This?
Answer :
In a DEV system, set the global system change option (SEO6) to modifiable for all namespaces/objects. The developers must have the ability to change any, including SAP, namespace/object. Change client options (SCC4) to “changes allowed for repos and cross-client cust” and radio button to “auto. save changes.” Next, enable CATTS sessions.
- If Sapconsole Telnet Screen Size Is Too Big How Do You Make It Smaller?
Answer :
Go to the control panel, and then to the SAP console administrator and general tab.
- Is There A Way To Perform Sapgui 640 Roll Out Using A Centralized Server?
Answer :
Look for SAPADMIN and SAPSETUP on the installation CD. Then, use a utility such as Microsoft’s SMS to distribute this program or use a login script to call the SAPSETUP program.
Part 4:
1) How would you define BASIS R/3
Basis is primarily a collection of R/3 system programs which present the user with an interface. By utilizing this interface the user can initiate the ABAP/4 programs. This is like an operating system for R/3 it sits between the ABAP/4 code and the computer’s operating system.
2) How can user maintain roles in SAP systems?
In order to maintain the roles in the SAP system, user can use transaction code — PFCG
3) Distinguish between Support package, kernel and SAP note?
- SAP Note: is an error in a single transaction or program and this is removed by implementing a SAP note.
- Kernel: Kernel encompasses the executable files (.EXE) like other applications and when a Kernel is performed using a new version of the EXE file replaces the older versions.
- Support Package: SAP support packages is a bunch of corrections, this can be utilized by applying the transaction SPAM
4) Explain client administration in SAP systems?
For multiple login on single instance, a client is used in SAP system. User can create multiple clients on a single instance. Client administration also provides data security in which, one user with one client cannot see the data of the other user with another client.
5) Can we get a list of the users with development access on a particular system?
Yes. Table DEVACCESS will show the required details.
6) What is Tcode for displaying and deleting the locked objects?
Transaction code SM12 is used Display and Delete locks objects
7) How to find out the dialog response time?
Please use Tcode rz20 in order to find dialog response time
8) What is the use of t-code SCC3 – Client Copy & Transport Log Analysis?
Transaction code SCC3 can be utilized for monitoring the process of client copy which is functioning in the background or validate the log of front-end process.
9) How can the user transfer the package from one client to another client made by ABAPER’s?
- User logs into the client where he wants to transport ABAP package.
- Now use transaction ‘scc1’
- Then transport the request which entails the ABAP package
10) Define SGEN in SAP Basis?
SGEN is an ABAP compilation. User can utilize the transaction SGEN in order to generate ABAP loads for a number of programs, classes, function groups, and so on, also for Business Server Page applications (BSP applications).
11) Is there any Table or function module in order to check Authorizations in user ID
Check AGR* tables (e.g. AGR_USERS, AGR_1251, etc).
12) The background job scheduler does not function on a server because an enqueue lock hangs on table BTCREMTCLN?
As of Basis Release 750, the background job scheduler itself validates whether a lock on the table BTCREMTCLN has been hanging for a longer period (at least 100 seconds). If so, the background job scheduler triggers the deletion of this lock.
13) How can we delete saved queues in SQM3?
- SMQ3 is ideally meant for exceptional cases which are then handled, and it’s not unusual that there are thousands of entries accumulating.
- There is a report meant for cleanup SMQ3 entries, RSTRFCIT, however, this accepts TID and queue name as input.
- Therefore, there is no option available as such in case so many queues need to be deleted.
- Another option is that you may write a Z-report with function module TRFC_QINS_DELETE_QUEUE which deletes the mentioned saved queue
14) How can the user details be collected in transaction SM04?
Please follow the steps below to get user details:
- User Opens the transaction SM04 at application server where the session is functioning.
- Select the line of the user which must be analyzed.
- User Opns the menu User -> Technical Information.
- Now the complete output of the session is displayed.
For saving output in a file:
- Once output is opened, access Either via Menu List -> Export -> Local File OR press F9
- Please select the ‘Unconverted‘ format.
- Now, at last, save the file on your machine.
15) DB error in client copy when there are plenty of address records?
A database committed in the Reports RS2ADRCL and RS3ADRCL during the client copy. As the reports delete all the address tables and all records deleted till the next database committed to the log files, the log files can result in an overflow.
Note: The deletion is performed in batches of 100000 records at a time and is later separated by COMMIT WORK
- In which directory, the central system log will store?
ANS: LDAP Dir.
17. What is the t-code for Logon Load balancing? What is the use of logon load balancing text here to convert case?
T-code-SMLG; It allows you to dynamically distribute the SAP users to application server instances. You can increase the efficiency of individual work groups by setting up multiple logon workgroups that consist of one or more application instances.
18) In which directory, the transport Data files will store?
Tr. and R3trans
19) What is roll-in / roll-out / response time / wait time ?
Roll-in:- The amt. of time needed to roll user context info. into work process.
Roll- out:-
Response time:- Starts when the user request enters the dispatcher queue end when hte next screen is executed to user.
Wait time:- This is the time a user request sit in the dispatcher queue. (means It start when the user request is entered in the queue and end when the request starts being a process)
- What is the command line to take a backup?
Use br tools for backup at os level
- How to analyze this problem If sap system is down (Users are unable to login to sap system)?
In case if ur sap system down firstly checks ur network connections next see that all ur sap services are up and running i.e 3orcale services and 2 SAP services
Oracle services are:
- oracle agent
- oracle sid
- oracle listener
SAP services are
- SAPOSCOL
- SAPSID_SNO
If the services are stopped bring start these services and bring down the sap and bring up the process view after that go ur console management and see the work process are up and running.
- How can we import the transport request at operating system Level? While importing a transport request, what are the basic errors which you face?
Importing the request from the command prompt:
- tp add to buffer K9######
- tp import (target_SID> K9#### Client #
The common errors encountered during transports are:
- 0- successful transports – shows green color
- 4- successful tansports with warnings – yellow color
- 8- unsuccessful transports – red color
- 12- fatal errors
- If any user is unable to execute any t-code because the authorization object is missing, How to add this authorization object to the user?
First, we have to go to su24 it shows the relation between objects classes and t-codes there we find all the object classes and authorization objects copy those missing object classes & authorization objects and paste in the s_tcode manually and do the user comparison then that user will be authorized to that transaction.
- For example, consider a client 800. This client having 75 users. But 15 users account was locked. I want to unlock this 15 users account at a time. How to do?
You can go su10 where su10 is a mass user creation just unlock those 15 users by using the symbol unlock so that the user will get the previous permission and can use the user.
- How to change the number of work process at OS level? How to analyze the status of work process at OS level?
Go to rz10 t-code which is used for (profile parameters)take the Instance profile and Extended maintenance display hit on change icon button. It displays the list of parameters change the parameters by (copy) go back and again(copy)go back and save after that bring down SAP Console management and bring up so that we can see the change in the parameters in the work process
- How many enqueue work process allowed for sap system having 4 application servers?
Central system will have 5 wp and 2 services so that enqueue will reside in central system i.e (c.i+dbi) without the central system dialog instance cannot be loaded i.e application server so that all the dialogue instance(application servers) depends on one enqueue work process that enqueue wp resides in CENTRAL SYSTEM but any individual appl servers do not have a enqueue.
- User wants to transfer 50GB of data from DEV to Quality. He is using the client export and import method; can you tell me how many hours take for client export and import? And also How many hours take for remote client copy?
For 50GB of data with help of export and import method, it takes almost half a day. Instead of DNG export and import method you can do the system copy it takes less time than export and import Cmg to remote client copy for sap_all it takes 3hrs and for other i.e sap_usr,sap_cust etc its take 5to 10mins bcoz we have only 90tables in this and in sap_all we have more than 52902 tables so that it takes much time.
- For example, I scheduled one ABAP program as a background job, But it was running 10 days and above. How to analyze this problem?
Based on the priority i.e class A, class B, class C background jobs run when u give the highest priority to program or package it runs accordingly…boz one thing in background wp we do not have any particular time to complete the give particular program or package so that it takes time (therefore it is known as answer for long running jobs is known as background wp) if u want the job to be done immediately run the progrm immediately so that it goes to dia wp and completes the work in the specified time.
- What are the configuration details of ECC6.0?
1.Server ConfigurationèHDD, RAM, OS, DATABASE.
- System Configurationè HDD, RAM, OS, DATABASE.
The main h/w& s/w requirements of system configuration are
1.windows-2003 enterprise edition with latest service pack sr-2(service release-2)
2.jsdk 1.4.2.x
3.rdbms or orcale 9.2.0.x or 10g
4.installation master
5.kernel
6.sap gui
HARDWARE requirements are
1.Minimum of 80GB HDD
2.1GB RAM is preferable
3.pIV-3GHZ
For the server, the s/w requirements are one and same the H/W requirements differ PIV 4 r 8 processer max GB the individual can have for both the i.e RAM and HDD.
- What are things we have to monitor in ST02, ST06, ST04, and ST03?
- ST02————–Buffer and swap monitoring
- ST06————- Monitoring of OS Resources CPU,RAM,HARD DISK
- ST04————–Monitoring of Database
- ST03————- Analysis of workload
- When applying a support pack to sap system. Can you tell me what are errors you are faced?
Types of errors
- OBJECTS_LOCKED
- Cannot disassemble R-DATA
- Tp cannot connect to the system
- TP_STep failure
- Error reading EPS Parcel
- write access error
- cannot schedule RDDIMPDP Job
- SPAU_SPAD Check
- cannot import DDIC
- How to CONFIGURE the output device. (SPAD)?
- Execute SPAD
2. Click on the Spool Server – Display then Change
3. Click on create
- Server Name: LOGICAL SP1
- Server Class : Mass Printing
- Logical Server: Mapping : willsys28_00
- Alt server: ………………….
- How to Read Parameter ID in Guixt Script?
use the command CALL with the Bapi BAPI_USER_GET_ DETAIL (table PARAMETER)
SAP BASIS Certification Interview Questions and Answers
Transport Change Request
Question 1: How can this be accomplished if you need to transport a change request from DEV client 111 to DEV 131 (i.e. transport in the same server) and your SAP landscape is composed of a DEV server and PRD server?
Answer: Transaction SCC1
Internet outages
Question 2: Some internet outages have been experienced recently caused by our ISP. The users refuse to believe that SAP problems were to blame for losing the internet connection although our ISP problems have been resolved. How can it be ensured that this was not an SAP problem but an internet problem?
Answer: Connect to the machine and kill the ISP connection after opening a maintenance window, and see if this helps in killing your connection. It can be repeated at will until the users believe that the ISP was the problem.
Question 3: What is the use of an OK code? How does an OK code differ from a T-code?
Answer: To execute a function an OK Code is used by a program for instance after the clicking of a push button. A transaction code helps a user run a program as it is a “shortcut”.
T-Codes are stored in table TSTC Transaction Codes
Question 4: Where do you store t-code name and program values? How a list of all the t-codes in the SAP system can be found?
Answer: To view Table TSTC, you can use transaction st11. Using transaction se93 you can define a new t-code.
STMS Importing
Question 5: How on STMS for the queues the “Import All” button can be disabled?
Answer: In Transport Domain Controller you should login. STMS->Overview->System should be run. The System that you want to disable import all should be chosen. Transport Tool tab should be selected. Parameter “NO_IMPORT_ALL” should be Added/Created and set its value to 1.
Work Processes
Question 6: Which types of work processes are found in R/3?
Answer: Dialog (D), Update (U), Enqueue (E), Background(B), and Spool(S).
Patch Level for GUI
Question 7: How the patch level for SAP GUI can be confirmed?
Answer: SAPGUI should be logged in to, and click Alt-F12 -> About
Web help installation
Question 8: Why compared to CHM, the standard delivered SAP help one considers web help to be easier to install?
Answer: Trying to get every remote user connected to a network share, web help is easier. You can setup your own website if you don’t want to use SAP’s help site. On your business’ network structure, the best route depends.
Web Resources
Question 9: What are some website you can visit to find the Answer if you can’t find the Answer: to a question?
Answer:
OSS notes: http://service.sap.com/notes
SAP help: http://help.sap.com
Google: http://www.google.com
Instance installation
Question 10: Is it possible to install another new instance on same development box? Which considerations are important?
Answer: Yes, on a single box, it is possible to have more than one instance. Using a different SID and a different system number is the key here. It is also important to note that for 1st instance SAP recommends a 20 GB swap space and 10 GB per each additional instance for a 64 bit SAP kernel.
Client copy
Question 11: How can a client copy be differentiated from client refresh?
Answer: These are the same sometimes; For example, Client Refresh is when you are performing a copy to an existing client for the express purpose of updating the data. It is more appropriate to say “client copy.”if you are copying to a newly created client. A client copy from production to a QA server or from production to DEV server is really a client refresh and this is another way of thinking about it.
Table T000
Question 12: What purpose does table T000 serve?
Answer: A list of defined clients is contained in Table T000, which with transaction SCC4 can be maintained.
Table USR02
Question 13: What purpose does table USR02 serve?
Answer: User IDs and passwords are stored in this table.
Passwords
Question 14: How a password exception list is created?
Answer: In table USR40, the Answer:s should be placed.
Table TADIR
Question 15: What purpose does table TADIR serve?
Answer: Object directory entries are contained in table TADIR.
Table TDEVC
Question 16: What purpose does table TDEVC serve?
Answer: Development classes and packages are contained in Table TDEVC.
Change Requests
Question 17: Which transaction codes are associated with changing requests, request headers, or request object lists?
Answer: Information about change requesets are hold by the following tables. E070 Change request headers E071 Change request object lists
User Access
Question 18: How on a particular system can you get a list of the users with development access?
Answer: Table DEVACCESS
Transport object keys
Question 19: Where a list of object keys included in a transport can be found?
Answer: Within transports E071K Object keys are contained.
Transport in progress
Question 20: If a transport entry is in the process of being imported, how can this be known?
Answer: The table TRBAT should be checked.
Repaired Objects
Question 21: How a list of objects that have been repaired in the system can be found?
Answer: A list of repaired objects and their access keys that have been repaired can be found in ADIRACCESS.
Disable Multiple Logins
Question 22: How in the Same Client Multiple Logins are disabled?
Answer: Implement this parameter in the instance profile: login/disable_multi_gui_login = 1 to disable multiple user logins within the same client. Users have the ability to ignore the warning window at the time of login to the same client if you do not use this parameter in your system. If you get audited, activating this parameter in your system will make you look good! What would happen in case of exceptional logins? You can implement parameter login/multi_login_users, in case you’re wondering how to allow multiple logins for certain key users. If the parameter above is active in your system, you can list the user IDs that should be ignored.
Locked Transactions
Question 23: How Locked Transactions can be viewed?
Answer: Via SM01As one can lock/unlock transaction codes. But, how viewing the transactions that are locked in the system can be managed? Field CINFO, table TSTC should be looked into. To browse the table contents within SAP, you can use either SE11 or SE16. You should Enter “A0” as the “HEX01 data element for SYST” starting value and “A9” as the ending value necessarily. All the transactions locked in the system will be listed by this.
Note: “HEX01 data element for SYST” is the CINFO field description.
Locking Accounts
Question 24: What happens behind the scenes when you are Locking/Unlocking accounts?
Answer: Via SU01 (User Maintenance.) user accounts can be locked/unlocked But, behind the scenes what actually goes on? To actually set this what does the system do? Update the table USR02. If the user account is locked or unlocked is determined by the field UFLAG. The user account is locked is indicated by value “64”. The user account is unlocked is indicated by the value “0”. At the database level you can issue an update statement that locks all users in mass. Although you should not lock yourself out! For super user accounts in your update statement, exceptions should be used. The locking/unlocking has been made a bit easier by improving 4.6b and above to this kind of task. However, it is just one simple query that changing at the database level is much faster.
TP and R3TRANS
Question 25: How TP can be differentiated from R3TRANS?
Answer: The process is controlled by TP and several tools are called, like r3trans but also e.g. DDIC-Activation.
SAPALL User
Question 26: What is the difference between DDIC and SAP_ALL/SAP_NEW ?
Answer: Yes, some things which other IDs cannot are done by DDIC which is hardcoded. In SE11 using a SAP_ALL user, you should be able to activate tables. For basis login accounts (SAP*), 06071992 is the default username and password.
UNIX OS
Question 27: What purpose does UNIX file /etc/passwd serve?
Answer: Valid user passwords, accounts, default login directories and user security permission levels are contained in /etc/passwd. user:password:UID:GID:login_directory:shell is the file format.
SAP DB Error
Question 28: When trying to install the DBInstance (SAP DB) if you receive an “error occurred during installation” message what can be done to get this problem fixed?
Answer: Shorter pathnames should be used.
ECC 5.0
Question 29: Is it possible to install ECC 5.0 without installing solution manager as a test system and not production?
Answer: You will be asked for a key during the installation, which solution manager can only generate?
Java and XI
Question 30: As part of an XI 3.0 installation we are trying to install Java-Add an ABAP system. While trying to start SAP j2EE engine at the end of the J2EE installation, a timeout error occurs. How would this be fixed?
Answer: Paging space should be increased to 20 GB.
SAPGUI Install
Question 31: How a centralized server can be used perform SAPGUI 640 roll out?
Answer: On the installation CD look for SAPADMIN and SAPSETUP. Then, to distribute this program use a utility such as Microsoft’s SMS or to call the SAPSETUP program use a login script.
Telnet
Question 32: How do you make SAPconsole telnet screen size smaller if it is too big?
Answer: The control panel should be selected, and then the SAP console administrator should be selected and general tab.
DEV System with Open Client
Question 33: In our DEV system the client have been opened with all options “changed without automatic rec,” “changes to repository and cross customization allowed,” and in SCC4 “protection level-0 no restriction”. An error message is received by the developers saying the system is non-modifiable. What should be done to fix this issue?
Answer: The global system change option (SEO6) to modifiable should be set for all namespaces/objects in our DEV system. Ability to change any, including SAP, namespace/object should be possessed by the developer. The client options (SCC4) should be changed to “changes which is allowed for repos and cross-client cust” and radio button should be changed to “auto. The changes.”should be saved. Next, the CATTS sessions should be enabled.
Email from SAP to UNIX
Question 34: From SAP to Microsoft Outlook, I’m trying to send email. Configuration of SAPConnect failed when I attempted it. I tried to run command “mlunxsnd” and “mlosmadm” on unix level but found that it doesn’t exist in unix. How should this problem be solved?
Answer: You should not use sapconnect in versions with basis release 6.20 or higher. The mail server should be placed in the SMTP node in SCOT directly.
Printing Cover Pages
Question 35: During printing for any kind of report I want to let SAP skip printing cover pages. How this can be completed?
Answer: The source for the cover page should be found. Either it will be from SAP itself or from the OS spooler. Then appropriate action should be taken.
User Auditing
Question 36: Can the user find out what was entered in a particular transaction code screen?
Answer: No, but tables associated with the transaction code can be analyzed and see what this user has done if there is a username field that traces.
Background Job Runs
Question 37: To run for 3 consecutive days I need to schedule a background job and would like to use DB13. How can a report to run from DB13 and not SM37 be scheduled?
Answer: A report to run from DB13 other than pre-configured DBA jobs cannot be scheduled. Use SM36 instead of this and make event-driven jobs.
Technical and Troubleshooting Questions
Transport requests
Question 38: On the QA system (t-code STMS) when all of the requests are released to DEV it is not being displayed in an import queue. A message appears saying “continue: other transport groups.” in the log of transport request although the overall status is successful. For what reason, is this message appearing?
Answer: The transport group is misconfigured for QA. Go to Overview after going to STMS. Choose communication by double-clicking on QA. Next the correct transport group should be entered and save.
Memory and Sizing
Question 39: A J2EE + ABAP 6.40 instance running a portal 6.0 is with us. If more is assigned, it seems 1GB of memory is not enough and J2EE has problems. To balance the load in the servers, what can be used?
Answer: Using config-tool you can create a second server process. Also through SCS, load balancing is possible.
Upgrading
Question 40: While doing a transport I received several warning parameters after a recent upgrade of kernel 6.20 to 6.40. What should I do about the warning parameters if everything looked okay on SAP t-code STMS?
Answer: These parameters from TPPARAM can be deleted.
SAPRouter and DMZ
Question 41: In DMZ a SAPRouter is set up so that the SAP application servers are not necessary to be exposed to the internet user and all SAP requests can be routed in and out from that machine. However, the BW Web reporting application requests is not handled by SAPRouter. E.P. is not with us. Which tools can help in routing WEB reporting requests the way SAPRouter does?
Answer: A SAP Web dispatcher is needed. SAP Web dispatcher routes SAP ICM traffic while acting like a SAP Router. A BSP that sits on the ICM is BW Web reporting. In the kernel directory you can look for sapwebdisp.exe or by using command option “bootstrap.”do a self-generated profile.
Internet email gateway
Question 42: How the Internet email gateway is configured in SAP Netweaver 04?
Answer: SMTP comes built in to kernel, starting with version WAS 6.x. Select transaction. Configure and SCOT it there.
J2EE and CRM
Question 43: What should I do if when installing a SAP J2EE engine at CRM it halts for more than 10 minutes and gives up starting the system after it reaches phase 22?
Answer: The solution to this is to restart the system. You may be missing the profile parameters if it is an add-in and you have restarted your ABAP then. Look in the work directory and check dev_icontrol if this is okay and a restart does not help. Apply a patch to solve the problem if the J2EE engine software is the problem.
Installing R/3 Enterprise
Question 44: There are several error messages in the SAPVIEW.log when installing SAP R/3 enterprise 4.7. What do you mean by this?
Answer: The error messages indicate that one of your load jobs run unsuccessfully.
Program buffer / swap
Question 45: When performing ST02 the program buffer shows a value of 1056 in red under the SWAP category in my development server. With the PXA buffer error message users are getting a shortdump. What shall I do to fix this?
Answer: In “my signature”, “my links”should be used along with the keywords: PXA Buffer.
Email from SBWP
Question 46: I wish to enter the user’s login name only, not an email address when sending an email from transaction SBWP. Also I’d like SAP to send the mail to this external email address and look at the user details email address and communications method held in SU01. How can this be configured?
Answer: Yes. SO16-> Tab Mail Sys group-> bottom radio button pathway should be followed.
Updating Tables
Question 47: Do direct updates are allowed on SAP tables?
Answer: To update data (RFC calls) you can call SAP functions directly. To try and manipulate data directly at the database level (sql scripts, jdbc) is not recommended. In general to update tables directly in SAP is a very bad idea.
Installing DB instance
Question 48: The input which has been given in SAPInst of DB instance is wrong in system number of CI instance while doing SAP installation of DB instance on a different box other than CI. How can this entry be changed after installation?
Answer: The CI instance with the right system number should be reinstalled.
Backup Strategy
Question 49: A backup strategy to disk is my area of working. The equivalent on various disks, I want to perform a copy_save_delete. Ideally, I would like to have two copies but this function does not work for disk saves. What other functions I can use?
Answer: To store another copy of your archive log, log on to another drive/server in your init<sid>.SAP file.
Lock table overflow
Question 50: When I try to run it one of my BTC jobs fails, giving me an error message stating “lock table overflow.”. To solve this issue it recommends modifying the enqueue / table size parameter. In my default or instance profile, I do not have this value. How can this problem be solved?
Answer: ABAP RSPARAM program should be run. The real value of the SAP parameter and where they have been set up can be obtained by this. 10,000 entries can be hold by the lock table, which is over enough for the average system. It is possible that the developers should modify it if the program is not written properly.
System copy for BW
Question 51: A system copy of BW is being attempted to complete. I get the error message, “Entry in inbound table already exists.”when I try to go in to RSA1 afterwards. What should be done to get the problem solved?
Answer: Under “subsequent steps” section read the Homogenous System Guide and follow all directions. Transaction codes BDLS and SALE should be checked as well.
XI 3.0 Configuration
Question 52: My XI 3.0 Production server (MSCS 2003) on oracle 9.2.0.6 for backups is getting configured. On single nodes (both A and B), split nodes (Oracle node B and SAP node A), I have successfully run offline backups, but when I run Oracle on Node A and SAP on Node B it fails. The initsid.sap, initsid.ora spfilesid.ora files, the files within the “%Windir%SAPCluster and the FSCMD location path have been checked and they are identical to my development servers. Servers rebooting has not been successful as well. How can this issue be resolved?
Answer: As SIDADM one should log in on both nodes and this command: brbackup -V should be run. Ensure “%Windir%SAPCluster” should be a part of your path.
Restarting server
Question 53: Will server performance be affected if the PRD server is restarted every week?
Answer: The SAP ABAP program buffer and other buffers are emptied when the server is restarted. During the first run, as far as performance goes, the reports runtime will be a bit longer. Without harm, the system can be restarted every week. The SLA/users demand may be the only reason against it.
System copy PRD to TST
Question 54: From PRD to TST, I need to do a system copy. SAP documentation cannot be followed but must do it manually. Will it change all the PRD to TST in the restored file names when I run “@/tmp/TSTcntrl.sql,”? Would a TST system be recognized as the restored files?
Answer: The DB as PRD on your new system should be opened first. Second, the redo logs should be applied. Next, to change SID the script should be run. If using WAS 6.10 or above this will change SID but will not change tablespace names.
MIRO updates to RBKP
Question 55: We are having performance issues around Tx MIRO which updates table RBKP while running Win 2003, Oracle 9I, SAP 4.7. Five indexes are there in Table RBKP in SAP, but in Oracle only three of which exist. For what reason, is this happening?
Answer: There are many predefined indexes in SAP. Via DB02->checks-> database ->ABAP dictionary ->display one can see these indexes. You see all indexes of which the definition is created in the dictionary under optional indexes, but at database level it has not been created.
Customizing and Master Data
Question 56: Some transactions in SAP, for instance, OVRF (updating routes) are seen as customizing. This is set as master data and can be set open in some systems. Where does this need to be done?
Answer: On each transaction it depends. According to system function, production or test/develop/demo/etc. it is sometimes determined by other configuration and sometimes it is set.
Variants for ABAP
Question 57: I have to create variants for some housekeeping ABAPs. There are cases for the ABAP in the variant when a time interval needs to be specified. The current date remains continuously even if I explicitly enter a start and end date. How can the dates in the variant be entered dynamically?
Answer: Enter the variant name and choose the attributes radio button in transaction SE38. The field can be set to “selection variable.” You can define that it is SY -DATE+7, under selection variables button.
SM37 and Spool
Question 58:Why do I get a message that says “no list available.”when I check transaction SM37 and I want to see the spool?
Answer: Several possible reasons can be responsible for this. To a printer, the spool is sent and deleted. The housekeeper deleted the spool if it is too old. Also, some test reports rollback after simulating a calculation then. Online it works fine. The spool is rolled back as well when a background job does a rollback.
J2EE and Support Packs
Question 59: On XI 3.1, I have an ABAP+J2EE instance. To apply the support packs for J2EE is it necessary to stop WEB AS and J2EE?
Answer: While the system is up and running but no activities any J2EE patches are applied. Binaries (ABAP kernel) are the only patch that is applied when the system is down.
Missing Secondary Index
Question 60: A Win NT/SQL7/R3 kernel -46D is with me. While I run DB02, I am missing one secondary index (Z0CPS0-1). This gives me the error message “Index could not be setup in the DB.” when I tried recreating the index. In the database, another index with the same name exists, but it is not known to the ABAP/ 4 Dictionary. How the error from the DB02 can be removed to resolve the problem?
Answer: In the DB directly, it is possible that an individual can create an index, however, it is not recommended. The index DB level firs must be deleted, and then in SAP create it.
Client Copy
Question 61: Will the background job schedules and all client dependent data be transferred by the client copy?
Answer: All client dependent data including schedules to the new client will be copied by SAP_ALL. Remember that the clients are always independent for ABAP programs. Only the client dependent is the master data (variant).
Offline Backup
Question 62: When we complete our weekly offline backup, application is not coming up and the system goes down while using SAP 4.7, 6.20 HP UX Oracle. Which input as to what is wrong with the system be given by a log?
Answer: The alert log should be started with. Iin oracle/SID/saptrace/background/alertSID.log, it is usually found.
Access Methods
Question 63: What do you mean by L and F access methods terms?
Answer: Local printer is referred to an “L” access method. Not the user but it is local to the SAP server. To front-end printer an “F” access method is referred to. The user’s Windows printer is used by this.
Remote server starting
Question 64: On Oracle 9.2.0.6, we are currently running 4.7 enterprise, on Solaris 9. A production has a central instance server and 3 Application servers where the Sapmnt directory is shared out from the central instance server and I am in the process of upgrading production. On the central instance the kernel is upgraded with no problems, but I received an error message stating the database must be started from a remote server when I try to start SAP on the APP servers. Even after all environment variables are hanged I am still receiving the error message. What could be the reason for this issue?
Answer:On each of the application servers, ensure that the Oracle client is properly installed. The latest versions of all of the kernel, associated files (R3trans, tp, startdb, stopdb, etc.) and the DB library should be used.
Deleting Background Jobs
Question 65: While users are working in the PRD server, is it safe to delete old background jobs using the program RSBTCDEL?
Answer:Yes. While users are working it is safe to run this program since this deletes completed or aborted jobs and not active jobs.
User logs
Question 66: In which report or table does the user logoff time is stored in SAP?
Answer: No standard report is there. However, in table USR02 and field TRDAT you can find out about the user’s last transaction time, which is close to logoff time.
Transport problems
Question 67: The transport system is not working properly after the kernel patch 6.40 level 098 has been installed. Although I start it manually, the job RDDIMPDP is not starting. The error messages keep coming in. What should I do to get this problem solved?
Answer: In both client 000 and your working client, go into SE38. Run program RDDNEWPP. With proper parameters this will schedule program RDDIMPDP. Then, if any “TP” programs are running should be checked. Check in /usr/sap/trans/log if this is the case, and the contents of the most recent file should be looked for.
Spooling tablespaces
Question 68: In one of our customer’s production systems that runs 24 hours a day, the temporary spooling tablespace is approximately 5GB. This can be reduced over time. For reducing this tablespace which strategy should you use?
Answer: For deleting the spool (TEMSE) objects, you could schedule report RSPO0041. In order to minimize impact on your system, schedule it as a daily background job.
Table Maintenance
Question 69: In what way should the table maintenance be set up for customized table Z1?
Answer: Transaction code SE11 should be used.
Dialog and Batch Processes
Question 70: Where can I change five dialog work processes into batch?
Answer: Through parameters in RZ10, you can configure work processes. For dialog “rdisp/no_wp_dia”should be used and for background “rdisp/no_wp_btc”should be used. For that through RZ04 you can configure operation modes.
Transport numbering
Question 71: To start with a number that I choose, in what way shall I change the transport request number?
Answer: Assuming user SAPR3 is owner of the database and your release is 4.6. The last transport number should be called by issuing “select * from sapr3.E070L.” By issuing: “Update sapr3.E070L set TRKORR='<SID>K9xxxxx’.” change the transport sequence number Replace SAPR3 with the owner of the database if your SAP release is higher than 4.6.
Jobs that don’t quit
Question 72: In our quality System BW the job “SAP_COLLECTOR_FOR_PERFMONITOR” is being cancelled continuously. What should I do if I keep receiving an error that says the load program is not found?
Answer: In the support package, the actual problem exists. Delete the SWNC* reports and insert RSSTAT83 and RSSTAT87 into TCOLL as this is the only solution for this.
Kernel Upgrades
Question 73: From the existing V5R2 to V5R3 of our i-series server which hosts SAP application we are planning an upgrade of the OS. At support pack level 50 we are currently on R/3 Release 4.6C. We are planning to migrate applications to a power 5 i-series 550 servers after the up gradation is done. Should we consider a SAP kernel upgrade if our current kernel is ASCII 46D patch level 1977?
Answer: Always update your kernel to latest level before upgrading OS, database or SAP Version.
SAPDBA
Question 74: A SAP r/3 47×200 (unix/oracle) is with us. Since we’ve upgraded from 6.20 to 6.40, the SAPDBA program no longer exists. After installing Kernel 6.40 from where can I download BR*Tools Gui for Oracle DBA -GUI?
Answer: From version 6.20, SAPDBA can still be used. Combine it with BR*Tools 6.40 essentially.
Transporting
Question 75: 2 transports (K and R) to be imported are received from an external vendor. These need to be imported into our QA system. The transports have been moved to the Profiles and Data subdirectories. What should be done next?
Answer: The pathway STMS -> Overview -> Imports should be followed. On QA’s SID, one should click twice. Next, this path Extras -> Other Requests -> Add should be followed. Finally, the transport number should be typed and imported as when transported normally.
SAP BASIS Interview Questions Anonymous
What is TMSADM?
while configuring TMS , TMSADM usr created, This is used for internally.
How to estimate the client size?
In order to check client size use command:
- SE38/SA38 and run RSSPACECHECK!!!
How to find out the object and object class for a specific role?
- SE03 tcode helps you to find out object, locked object/TR etc..
- PFCG SUIM are also helpful..for finding roles containing objects etc
Can I transport printer settings?
Printer settings can be transported by creating Workbench TR and include below object with * as their field values:
- TSP03
- TSP03C
- TSP03D
- TSP03L
How to find SAP r/3 system patch level and kernel version?
Hit SPAM–> select all it will be display all patch levls kernel—> SM51–> release notes or OS level disp+work
What is System table? how can I find out system table in SAP?
The database system contains a series of system tables with information about database objects and their connection to each other, statistics system tables, monitor system tables and loader system tables. We usually look in SE16 for system tables!!
Can I convert authorizations field to org, field?
- There are standard housekeeping jobs for cleanup of spool request and abap dumps.. or you can run the standard programs RSSNAPDL and RSPO1041 in SA38/SE38.
- There is one background job you need to schedule RSPO1041.Run this job in SE38 and fill the required entries in there!!!
How we do Scheduled jobs in background to cleanup spool request, dumps?
There is one background job you need to schedule RSPO104, run this job in SE38 and fill the required entries in there.
Can wild card use for authorization
How to check kernel ,tp.exe version?
How to find out the object and object class for a specific role?
- SE03 tcode helps you to find out object, locked object/TR etc..
- PFCG SUIM are also helpful..for finding roles containing objects etc
What is mass transportation and where can we use?
SAP BASIS Interview Questions for 2 Years Experienced
- What type of servers is used in sap(like HP or Dell Servers names)?
- How do you configure System Landscape in your company? with detailed(dialog servers, Background jobs server need a diagram)? with clustering concept?
- how you connect to servers? which VPN software is used?
- Give me your daily activities in your company?
- give the list of third tools which are used in your company?
- In company how the roles are assigned[like monitoring(maintenance admin), config admin, install admin] how the work is assigned?
- what kind of roles will be given to the basis admin or for ABAP users?
- Solution manager is mandatory or optional….if it is mandatory how the monitoring will be done in sol.man? version? seperate employee will be there are basis admin look into it?
- how to take backups, os / sap / oracle…is there any third party tools used?
- can we say that i worked on the windows server?
- where do we mention new user employee id and acc. number in su01?
- describe database storage servers?
- SM51 describe? process and errors? what to do?
- differ application server and message server? how many application servers will be there?
- Licensing process..complete ? developer key / SSCR key / Object Key?
- when we do background jobs?
- when using remote client copy entire data ,how much time it will take?approx?
- archive administrator?
- production servers how many? pre-production servers?
- ST22 ABAP dump analysis? describe scenarios?
- GRC tools? third party tools for security?
- in support project what kind of authorization we’ll have?
- Load balancing(SMLG), where and when we’ll do? describe with scenario?
SAP BASIS Interview Questions and Answers for 3 to 10 Years Experience
- What is the access method?
- What IS TMSADM?
- How I estimate the client size?
- How to find out the object and object class for a specific role(eg. basis admin, mm purchase)?
- Can I transport printer settings?
- How I find sap r/3 system patch level and kernel version?
- What is a system table how can I find out in sap?
- Can I convert authorizations field to org, field?
- Can wild card use for authorization?
- How to check kernel, tp.exe version?
- what is mass transportation and where can we use?
SAP BASIS FAQs
1) How would you define BASIS R/3
Basis is primarily a collection of R/3 system programs which present the user with an interface. By utilizing this interface the user can initiate the ABAP/4 programs. This is like an operating system for R/3 it sits between the ABAP/4 code and the computer’s operating system.
2) How can user maintain roles in SAP systems?
In order to maintain the roles in the SAP system, user can use transaction code — PFCG
3) Distinguish between Support package, kernel and SAP note?
- SAP Note: is an error in a single transaction or program and this is removed by implementing a SAP note.
- Kernel: Kernel encompasses the executable files (.EXE) like other applications and when a Kernel is performed using a new version of the EXE file replaces the older versions.
- Support Package: SAP support packages is a bunch of corrections, this can be utilized by applying the transaction SPAM
4) Explain client administration in SAP systems?
For multiple login on single instance, a client is used in SAP system. User can create multiple clients on a single instance. Client administration also provides data security in which, one user with one client cannot see the data of the other user with another client.
5) Can we get a list of the users with development access on a particular system?
Yes. Table DEVACCESS will show the required details.
6) What is Tcode for displaying and deleting the locked objects?
Transaction code SM12 is used Display and Delete locks objects
7) How to find out the dialog response time?
Please use Tcode rz20 in order to find dialog response time
8) What is the use of t-code SCC3 – Client Copy & Transport Log Analysis?
Transaction code SCC3 can be utilized for monitoring the process of client copy which is functioning in the background or validate the log of front-end process.
9) How can the user transfer the package from one client to another client made by ABAPER’s?
- User logs into the client where he wants to transport ABAP package.
- Now use transaction ‘scc1’
- Then transport the request which entails the ABAP package
10) Define SGEN in SAP Basis?
SGEN is an ABAP compilation. User can utilize the transaction SGEN in order to generate ABAP loads for a number of programs, classes, function groups, and so on, also for Business Server Page applications (BSP applications).
11) Is there any Table or function module in order to check Authorizations in user ID
Check AGR* tables (e.g. AGR_USERS, AGR_1251, etc).
12) The background job scheduler does not function on a server because an enqueue lock hangs on table BTCREMTCLN?
As of Basis Release 750, the background job scheduler itself validates whether a lock on the table BTCREMTCLN has been hanging for a longer period (at least 100 seconds). If so, the background job scheduler triggers the deletion of this lock.
13) How can we delete saved queues in SQM3?
- SMQ3 is ideally meant for exceptional cases which are then handled, and it’s not unusual that there are thousands of entries accumulating.
- There is a report meant for cleanup SMQ3 entries, RSTRFCIT, however, this accepts TID and queue name as input.
- Therefore, there is no option available as such in case so many queues need to be deleted.
- Another option is that you may write a Z-report with function module TRFC_QINS_DELETE_QUEUE which deletes the mentioned saved queue
14) How can the user details be collected in transaction SM04?
Please follow the steps below to get user details:
- User Opens the transaction SM04 at application server where the session is functioning.
- Select the line of the user which must be analyzed.
- User Opns the menu User -> Technical Information.
- Now the complete output of the session is displayed.
For saving output in a file:
- Once output is opened, access Either via Menu List -> Export -> Local File OR press F9
- Please select the ‘Unconverted‘ format.
- Now, at last, save the file on your machine.
15) DB error in client copy when there are plenty of address records?
A database committed in the Reports RS2ADRCL and RS3ADRCL during the client copy. As the reports delete all the address tables and all records deleted till the next database committed to the log files, the log files can result in an overflow.
Note: The deletion is performed in batches of 100000 records at a time and is later separated by COMMIT WORK
- In which directory, the central system log will store?
ANS: LDAP Dir.
17. What is the t-code for Logon Load balancing? What is the use of logon load balancing text here to convert case?
T-code-SMLG; It allows you to dynamically distribute the SAP users to application server instances. You can increase the efficiency of individual work groups by setting up multiple logon workgroups that consist of one or more application instances.
18) In which directory, the transport Data files will store?
Tr. and R3trans
19) What is roll-in / roll-out / response time / wait time ?
Roll-in:- The amt. of time needed to roll user context info. into work process.
Roll- out:-
Response time:- Starts when the user request enters the dispatcher queue end when hte next screen is executed to user.
Wait time:- This is the time a user request sit in the dispatcher queue. (means It start when the user request is entered in the queue and end when the request starts being a process)
- What is the command line to take a backup?
Use br tools for backup at os level
- How to analyze this problem If sap system is down (Users are unable to login to sap system)?
In case if ur sap system down firstly checks ur network connections next see that all ur sap services are up and running i.e 3orcale services and 2 SAP services
Oracle services are:
- oracle agent
- oracle sid
- oracle listener
SAP services are
- SAPOSCOL
- SAPSID_SNO
If the services are stopped bring start these services and bring down the sap and bring up the process view after that go ur console management and see the work process are up and running.
- How can we import the transport request at operating system Level? While importing a transport request, what are the basic errors which you face?
Importing the request from the command prompt:
- tp add to buffer K9######
- tp import (target_SID> K9#### Client #
The common errors encountered during transports are:
- 0- successful transports – shows green color
- 4- successful tansports with warnings – yellow color
- 8- unsuccessful transports – red color
- 12- fatal errors
- If any user is unable to execute any t-code because the authorization object is missing, How to add this authorization object to the user?
First, we have to go to su24 it shows the relation between objects classes and t-codes there we find all the object classes and authorization objects copy those missing object classes & authorization objects and paste in the s_tcode manually and do the user comparison then that user will be authorized to that transaction.
- For example, consider a client 800. This client having 75 users. But 15 users account was locked. I want to unlock this 15 users account at a time. How to do?
You can go su10 where su10 is a mass user creation just unlock those 15 users by using the symbol unlock so that the user will get the previous permission and can use the user.
- How to change the number of work process at OS level? How to analyze the status of work process at OS level?
Go to rz10 t-code which is used for (profile parameters)take the Instance profile and Extended maintenance display hit on change icon button. It displays the list of parameters change the parameters by (copy) go back and again(copy)go back and save after that bring down SAP Console management and bring up so that we can see the change in the parameters in the work process
- How many enqueue work process allowed for sap system having 4 application servers?
Central system will have 5 wp and 2 services so that enqueue will reside in central system i.e (c.i+dbi) without the central system dialog instance cannot be loaded i.e application server so that all the dialogue instance(application servers) depends on one enqueue work process that enqueue wp resides in CENTRAL SYSTEM but any individual appl servers do not have a enqueue.
- User wants to transfer 50GB of data from DEV to Quality. He is using the client export and import method; can you tell me how many hours take for client export and import? And also How many hours take for remote client copy?
For 50GB of data with help of export and import method, it takes almost half a day. Instead of DNG export and import method you can do the system copy it takes less time than export and import Cmg to remote client copy for sap_all it takes 3hrs and for other i.e sap_usr,sap_cust etc its take 5to 10mins bcoz we have only 90tables in this and in sap_all we have more than 52902 tables so that it takes much time.
- For example, I scheduled one ABAP program as a background job, But it was running 10 days and above. How to analyze this problem?
Based on the priority i.e class A, class B, class C background jobs run when u give the highest priority to program or package it runs accordingly…boz one thing in background wp we do not have any particular time to complete the give particular program or package so that it takes time (therefore it is known as answer for long running jobs is known as background wp) if u want the job to be done immediately run the progrm immediately so that it goes to dia wp and completes the work in the specified time.
- What are the configuration details of ECC6.0?
1.Server ConfigurationèHDD, RAM, OS, DATABASE.
- System Configurationè HDD, RAM, OS, DATABASE.
The main h/w& s/w requirements of system configuration are
1.windows-2003 enterprise edition with latest service pack sr-2(service release-2)
2.jsdk 1.4.2.x
3.rdbms or orcale 9.2.0.x or 10g
4.installation master
5.kernel
6.sap gui
HARDWARE requirements are
1.Minimum of 80GB HDD
2.1GB RAM is preferable
3.pIV-3GHZ
For the server, the s/w requirements are one and same the H/W requirements differ PIV 4 r 8 processer max GB the individual can have for both the i.e RAM and HDD.
- What are things we have to monitor in ST02, ST06, ST04, and ST03?
- ST02————–Buffer and swap monitoring
- ST06————- Monitoring of OS Resources CPU,RAM,HARD DISK
- ST04————–Monitoring of Database
- ST03————- Analysis of workload
- When applying a support pack to sap system. Can you tell me what are errors you are faced?
Types of errors
- OBJECTS_LOCKED
- Cannot disassemble R-DATA
- Tp cannot connect to the system
- TP_STep failure
- Error reading EPS Parcel
- write access error
- cannot schedule RDDIMPDP Job
- SPAU_SPAD Check
- cannot import DDIC
- How to CONFIGURE the output device. (SPAD)?
- Execute SPAD
2. Click on the Spool Server – Display then Change
3. Click on create
- Server Name: LOGICAL SP1
- Server Class : Mass Printing
- Logical Server: Mapping : willsys28_00
- Alt server: ………………….
- How to Read Parameter ID in Guixt Script?
use the command CALL with the Bapi BAPI_USER_GET_ DETAIL (table PARAMETER)
SAP BASIS Certification Interview Questions and Answers
Transport Change Request
Question 1: How can this be accomplished if you need to transport a change request from DEV client 111 to DEV 131 (i.e. transport in the same server) and your SAP landscape is composed of a DEV server and PRD server?
Answer: Transaction SCC1
Internet outages
Question 2: Some internet outages have been experienced recently caused by our ISP. The users refuse to believe that SAP problems were to blame for losing the internet connection although our ISP problems have been resolved. How can it be ensured that this was not an SAP problem but an internet problem?
Answer: Connect to the machine and kill the ISP connection after opening a maintenance window, and see if this helps in killing your connection. It can be repeated at will until the users believe that the ISP was the problem.
Question 3: What is the use of an OK code? How does an OK code differ from a T-code?
Answer: To execute a function an OK Code is used by a program for instance after the clicking of a push button. A transaction code helps a user run a program as it is a “shortcut”.
T-Codes are stored in table TSTC Transaction Codes
Question 4: Where do you store t-code name and program values? How a list of all the t-codes in the SAP system can be found?
Answer: To view Table TSTC, you can use transaction st11. Using transaction se93 you can define a new t-code.
STMS Importing
Question 5: How on STMS for the queues the “Import All” button can be disabled?
Answer: In Transport Domain Controller you should login. STMS->Overview->System should be run. The System that you want to disable import all should be chosen. Transport Tool tab should be selected. Parameter “NO_IMPORT_ALL” should be Added/Created and set its value to 1.
Work Processes
Question 6: Which types of work processes are found in R/3?
Answer: Dialog (D), Update (U), Enqueue (E), Background(B), and Spool(S).
Patch Level for GUI
Question 7: How the patch level for SAP GUI can be confirmed?
Answer: SAPGUI should be logged in to, and click Alt-F12 -> About
Web help installation
Question 8: Why compared to CHM, the standard delivered SAP help one considers web help to be easier to install?
Answer: Trying to get every remote user connected to a network share, web help is easier. You can setup your own website if you don’t want to use SAP’s help site. On your business’ network structure, the best route depends.
Web Resources
Question 9: What are some website you can visit to find the Answer if you can’t find the Answer: to a question?
Answer:
OSS notes: http://service.sap.com/notes
SAP help: http://help.sap.com
Google: http://www.google.com
Instance installation
Question 10: Is it possible to install another new instance on same development box? Which considerations are important?
Answer: Yes, on a single box, it is possible to have more than one instance. Using a different SID and a different system number is the key here. It is also important to note that for 1st instance SAP recommends a 20 GB swap space and 10 GB per each additional instance for a 64 bit SAP kernel.
Client copy
Question 11: How can a client copy be differentiated from client refresh?
Answer: These are the same sometimes; For example, Client Refresh is when you are performing a copy to an existing client for the express purpose of updating the data. It is more appropriate to say “client copy.”if you are copying to a newly created client. A client copy from production to a QA server or from production to DEV server is really a client refresh and this is another way of thinking about it.
Table T000
Question 12: What purpose does table T000 serve?
Answer: A list of defined clients is contained in Table T000, which with transaction SCC4 can be maintained.
Table USR02
Question 13: What purpose does table USR02 serve?
Answer: User IDs and passwords are stored in this table.
Passwords
Question 14: How a password exception list is created?
Answer: In table USR40, the Answer:s should be placed.
Table TADIR
Question 15: What purpose does table TADIR serve?
Answer: Object directory entries are contained in table TADIR.
Table TDEVC
Question 16: What purpose does table TDEVC serve?
Answer: Development classes and packages are contained in Table TDEVC.
Change Requests
Question 17: Which transaction codes are associated with changing requests, request headers, or request object lists?
Answer: Information about change requesets are hold by the following tables. E070 Change request headers E071 Change request object lists
User Access
Question 18: How on a particular system can you get a list of the users with development access?
Answer: Table DEVACCESS
Transport object keys
Question 19: Where a list of object keys included in a transport can be found?
Answer: Within transports E071K Object keys are contained.
Transport in progress
Question 20: If a transport entry is in the process of being imported, how can this be known?
Answer: The table TRBAT should be checked.
Repaired Objects
Question 21: How a list of objects that have been repaired in the system can be found?
Answer: A list of repaired objects and their access keys that have been repaired can be found in ADIRACCESS.
Disable Multiple Logins
Question 22: How in the Same Client Multiple Logins are disabled?
Answer: Implement this parameter in the instance profile: login/disable_multi_gui_login = 1 to disable multiple user logins within the same client. Users have the ability to ignore the warning window at the time of login to the same client if you do not use this parameter in your system. If you get audited, activating this parameter in your system will make you look good! What would happen in case of exceptional logins? You can implement parameter login/multi_login_users, in case you’re wondering how to allow multiple logins for certain key users. If the parameter above is active in your system, you can list the user IDs that should be ignored.
Locked Transactions
Question 23: How Locked Transactions can be viewed?
Answer: Via SM01As one can lock/unlock transaction codes. But, how viewing the transactions that are locked in the system can be managed? Field CINFO, table TSTC should be looked into. To browse the table contents within SAP, you can use either SE11 or SE16. You should Enter “A0” as the “HEX01 data element for SYST” starting value and “A9” as the ending value necessarily. All the transactions locked in the system will be listed by this.
Note: “HEX01 data element for SYST” is the CINFO field description.
Locking Accounts
Question 24: What happens behind the scenes when you are Locking/Unlocking accounts?
Answer: Via SU01 (User Maintenance.) user accounts can be locked/unlocked But, behind the scenes what actually goes on? To actually set this what does the system do? Update the table USR02. If the user account is locked or unlocked is determined by the field UFLAG. The user account is locked is indicated by value “64”. The user account is unlocked is indicated by the value “0”. At the database level you can issue an update statement that locks all users in mass. Although you should not lock yourself out! For super user accounts in your update statement, exceptions should be used. The locking/unlocking has been made a bit easier by improving 4.6b and above to this kind of task. However, it is just one simple query that changing at the database level is much faster.
TP and R3TRANS
Question 25: How TP can be differentiated from R3TRANS?
Answer: The process is controlled by TP and several tools are called, like r3trans but also e.g. DDIC-Activation.
SAPALL User
Question 26: What is the difference between DDIC and SAP_ALL/SAP_NEW ?
Answer: Yes, some things which other IDs cannot are done by DDIC which is hardcoded. In SE11 using a SAP_ALL user, you should be able to activate tables. For basis login accounts (SAP*), 06071992 is the default username and password.
UNIX OS
Question 27: What purpose does UNIX file /etc/passwd serve?
Answer: Valid user passwords, accounts, default login directories and user security permission levels are contained in /etc/passwd. user:password:UID:GID:login_directory:shell is the file format.
SAP DB Error
Question 28: When trying to install the DBInstance (SAP DB) if you receive an “error occurred during installation” message what can be done to get this problem fixed?
Answer: Shorter pathnames should be used.
ECC 5.0
Question 29: Is it possible to install ECC 5.0 without installing solution manager as a test system and not production?
Answer: You will be asked for a key during the installation, which solution manager can only generate?
Java and XI
Question 30: As part of an XI 3.0 installation we are trying to install Java-Add an ABAP system. While trying to start SAP j2EE engine at the end of the J2EE installation, a timeout error occurs. How would this be fixed?
Answer: Paging space should be increased to 20 GB.
SAPGUI Install
Question 31: How a centralized server can be used perform SAPGUI 640 roll out?
Answer: On the installation CD look for SAPADMIN and SAPSETUP. Then, to distribute this program use a utility such as Microsoft’s SMS or to call the SAPSETUP program use a login script.
Telnet
Question 32: How do you make SAPconsole telnet screen size smaller if it is too big?
Answer: The control panel should be selected, and then the SAP console administrator should be selected and general tab.
DEV System with Open Client
Question 33: In our DEV system the client have been opened with all options “changed without automatic rec,” “changes to repository and cross customization allowed,” and in SCC4 “protection level-0 no restriction”. An error message is received by the developers saying the system is non-modifiable. What should be done to fix this issue?
Answer: The global system change option (SEO6) to modifiable should be set for all namespaces/objects in our DEV system. Ability to change any, including SAP, namespace/object should be possessed by the developer. The client options (SCC4) should be changed to “changes which is allowed for repos and cross-client cust” and radio button should be changed to “auto. The changes.”should be saved. Next, the CATTS sessions should be enabled.
Email from SAP to UNIX
Question 34: From SAP to Microsoft Outlook, I’m trying to send email. Configuration of SAPConnect failed when I attempted it. I tried to run command “mlunxsnd” and “mlosmadm” on unix level but found that it doesn’t exist in unix. How should this problem be solved?
Answer: You should not use sapconnect in versions with basis release 6.20 or higher. The mail server should be placed in the SMTP node in SCOT directly.
Printing Cover Pages
Question 35: During printing for any kind of report I want to let SAP skip printing cover pages. How this can be completed?
Answer: The source for the cover page should be found. Either it will be from SAP itself or from the OS spooler. Then appropriate action should be taken.
User Auditing
Question 36: Can the user find out what was entered in a particular transaction code screen?
Answer: No, but tables associated with the transaction code can be analyzed and see what this user has done if there is a username field that traces.
Background Job Runs
Question 37: To run for 3 consecutive days I need to schedule a background job and would like to use DB13. How can a report to run from DB13 and not SM37 be scheduled?
Answer: A report to run from DB13 other than pre-configured DBA jobs cannot be scheduled. Use SM36 instead of this and make event-driven jobs.
Technical and Troubleshooting Questions
Transport requests
Question 38: On the QA system (t-code STMS) when all of the requests are released to DEV it is not being displayed in an import queue. A message appears saying “continue: other transport groups.” in the log of transport request although the overall status is successful. For what reason, is this message appearing?
Answer: The transport group is misconfigured for QA. Go to Overview after going to STMS. Choose communication by double-clicking on QA. Next the correct transport group should be entered and save.
Memory and Sizing
Question 39: A J2EE + ABAP 6.40 instance running a portal 6.0 is with us. If more is assigned, it seems 1GB of memory is not enough and J2EE has problems. To balance the load in the servers, what can be used?
Answer: Using config-tool you can create a second server process. Also through SCS, load balancing is possible.
Upgrading
Question 40: While doing a transport I received several warning parameters after a recent upgrade of kernel 6.20 to 6.40. What should I do about the warning parameters if everything looked okay on SAP t-code STMS?
Answer: These parameters from TPPARAM can be deleted.
SAPRouter and DMZ
Question 41: In DMZ a SAPRouter is set up so that the SAP application servers are not necessary to be exposed to the internet user and all SAP requests can be routed in and out from that machine. However, the BW Web reporting application requests is not handled by SAPRouter. E.P. is not with us. Which tools can help in routing WEB reporting requests the way SAPRouter does?
Answer: A SAP Web dispatcher is needed. SAP Web dispatcher routes SAP ICM traffic while acting like a SAP Router. A BSP that sits on the ICM is BW Web reporting. In the kernel directory you can look for sapwebdisp.exe or by using command option “bootstrap.”do a self-generated profile.
Internet email gateway
Question 42: How the Internet email gateway is configured in SAP Netweaver 04?
Answer: SMTP comes built in to kernel, starting with version WAS 6.x. Select transaction. Configure and SCOT it there.
J2EE and CRM
Question 43: What should I do if when installing a SAP J2EE engine at CRM it halts for more than 10 minutes and gives up starting the system after it reaches phase 22?
Answer: The solution to this is to restart the system. You may be missing the profile parameters if it is an add-in and you have restarted your ABAP then. Look in the work directory and check dev_icontrol if this is okay and a restart does not help. Apply a patch to solve the problem if the J2EE engine software is the problem.
Installing R/3 Enterprise
Question 44: There are several error messages in the SAPVIEW.log when installing SAP R/3 enterprise 4.7. What do you mean by this?
Answer: The error messages indicate that one of your load jobs run unsuccessfully.
Program buffer / swap
Question 45: When performing ST02 the program buffer shows a value of 1056 in red under the SWAP category in my development server. With the PXA buffer error message users are getting a shortdump. What shall I do to fix this?
Answer: In “my signature”, “my links”should be used along with the keywords: PXA Buffer.
Email from SBWP
Question 46: I wish to enter the user’s login name only, not an email address when sending an email from transaction SBWP. Also I’d like SAP to send the mail to this external email address and look at the user details email address and communications method held in SU01. How can this be configured?
Answer: Yes. SO16-> Tab Mail Sys group-> bottom radio button pathway should be followed.
Updating Tables
Question 47: Do direct updates are allowed on SAP tables?
Answer: To update data (RFC calls) you can call SAP functions directly. To try and manipulate data directly at the database level (sql scripts, jdbc) is not recommended. In general to update tables directly in SAP is a very bad idea.
Installing DB instance
Question 48: The input which has been given in SAPInst of DB instance is wrong in system number of CI instance while doing SAP installation of DB instance on a different box other than CI. How can this entry be changed after installation?
Answer: The CI instance with the right system number should be reinstalled.
Backup Strategy
Question 49: A backup strategy to disk is my area of working. The equivalent on various disks, I want to perform a copy_save_delete. Ideally, I would like to have two copies but this function does not work for disk saves. What other functions I can use?
Answer: To store another copy of your archive log, log on to another drive/server in your init<sid>.SAP file.
Lock table overflow
Question 50: When I try to run it one of my BTC jobs fails, giving me an error message stating “lock table overflow.”. To solve this issue it recommends modifying the enqueue / table size parameter. In my default or instance profile, I do not have this value. How can this problem be solved?
Answer: ABAP RSPARAM program should be run. The real value of the SAP parameter and where they have been set up can be obtained by this. 10,000 entries can be hold by the lock table, which is over enough for the average system. It is possible that the developers should modify it if the program is not written properly.
System copy for BW
Question 51: A system copy of BW is being attempted to complete. I get the error message, “Entry in inbound table already exists.”when I try to go in to RSA1 afterwards. What should be done to get the problem solved?
Answer: Under “subsequent steps” section read the Homogenous System Guide and follow all directions. Transaction codes BDLS and SALE should be checked as well.
XI 3.0 Configuration
Question 52: My XI 3.0 Production server (MSCS 2003) on oracle 9.2.0.6 for backups is getting configured. On single nodes (both A and B), split nodes (Oracle node B and SAP node A), I have successfully run offline backups, but when I run Oracle on Node A and SAP on Node B it fails. The initsid.sap, initsid.ora spfilesid.ora files, the files within the “%Windir%SAPCluster and the FSCMD location path have been checked and they are identical to my development servers. Servers rebooting has not been successful as well. How can this issue be resolved?
Answer: As SIDADM one should log in on both nodes and this command: brbackup -V should be run. Ensure “%Windir%SAPCluster” should be a part of your path.
Restarting server
Question 53: Will server performance be affected if the PRD server is restarted every week?
Answer: The SAP ABAP program buffer and other buffers are emptied when the server is restarted. During the first run, as far as performance goes, the reports runtime will be a bit longer. Without harm, the system can be restarted every week. The SLA/users demand may be the only reason against it.
System copy PRD to TST
Question 54: From PRD to TST, I need to do a system copy. SAP documentation cannot be followed but must do it manually. Will it change all the PRD to TST in the restored file names when I run “@/tmp/TSTcntrl.sql,”? Would a TST system be recognized as the restored files?
Answer: The DB as PRD on your new system should be opened first. Second, the redo logs should be applied. Next, to change SID the script should be run. If using WAS 6.10 or above this will change SID but will not change tablespace names.
MIRO updates to RBKP
Question 55: We are having performance issues around Tx MIRO which updates table RBKP while running Win 2003, Oracle 9I, SAP 4.7. Five indexes are there in Table RBKP in SAP, but in Oracle only three of which exist. For what reason, is this happening?
Answer: There are many predefined indexes in SAP. Via DB02->checks-> database ->ABAP dictionary ->display one can see these indexes. You see all indexes of which the definition is created in the dictionary under optional indexes, but at database level it has not been created.
Customizing and Master Data
Question 56: Some transactions in SAP, for instance, OVRF (updating routes) are seen as customizing. This is set as master data and can be set open in some systems. Where does this need to be done?
Answer: On each transaction it depends. According to system function, production or test/develop/demo/etc. it is sometimes determined by other configuration and sometimes it is set.
Variants for ABAP
Question 57: I have to create variants for some housekeeping ABAPs. There are cases for the ABAP in the variant when a time interval needs to be specified. The current date remains continuously even if I explicitly enter a start and end date. How can the dates in the variant be entered dynamically?
Answer: Enter the variant name and choose the attributes radio button in transaction SE38. The field can be set to “selection variable.” You can define that it is SY -DATE+7, under selection variables button.
SM37 and Spool
Question 58:Why do I get a message that says “no list available.”when I check transaction SM37 and I want to see the spool?
Answer: Several possible reasons can be responsible for this. To a printer, the spool is sent and deleted. The housekeeper deleted the spool if it is too old. Also, some test reports rollback after simulating a calculation then. Online it works fine. The spool is rolled back as well when a background job does a rollback.
J2EE and Support Packs
Question 59: On XI 3.1, I have an ABAP+J2EE instance. To apply the support packs for J2EE is it necessary to stop WEB AS and J2EE?
Answer: While the system is up and running but no activities any J2EE patches are applied. Binaries (ABAP kernel) are the only patch that is applied when the system is down.
Missing Secondary Index
Question 60: A Win NT/SQL7/R3 kernel -46D is with me. While I run DB02, I am missing one secondary index (Z0CPS0-1). This gives me the error message “Index could not be setup in the DB.” when I tried recreating the index. In the database, another index with the same name exists, but it is not known to the ABAP/ 4 Dictionary. How the error from the DB02 can be removed to resolve the problem?
Answer: In the DB directly, it is possible that an individual can create an index, however, it is not recommended. The index DB level firs must be deleted, and then in SAP create it.
Client Copy
Question 61: Will the background job schedules and all client dependent data be transferred by the client copy?
Answer: All client dependent data including schedules to the new client will be copied by SAP_ALL. Remember that the clients are always independent for ABAP programs. Only the client dependent is the master data (variant).
Offline Backup
Question 62: When we complete our weekly offline backup, application is not coming up and the system goes down while using SAP 4.7, 6.20 HP UX Oracle. Which input as to what is wrong with the system be given by a log?
Answer: The alert log should be started with. Iin oracle/SID/saptrace/background/alertSID.log, it is usually found.
Access Methods
Question 63: What do you mean by L and F access methods terms?
Answer: Local printer is referred to an “L” access method. Not the user but it is local to the SAP server. To front-end printer an “F” access method is referred to. The user’s Windows printer is used by this.
Remote server starting
Question 64: On Oracle 9.2.0.6, we are currently running 4.7 enterprise, on Solaris 9. A production has a central instance server and 3 Application servers where the Sapmnt directory is shared out from the central instance server and I am in the process of upgrading production. On the central instance the kernel is upgraded with no problems, but I received an error message stating the database must be started from a remote server when I try to start SAP on the APP servers. Even after all environment variables are hanged I am still receiving the error message. What could be the reason for this issue?
Answer:On each of the application servers, ensure that the Oracle client is properly installed. The latest versions of all of the kernel, associated files (R3trans, tp, startdb, stopdb, etc.) and the DB library should be used.
Deleting Background Jobs
Question 65: While users are working in the PRD server, is it safe to delete old background jobs using the program RSBTCDEL?
Answer:Yes. While users are working it is safe to run this program since this deletes completed or aborted jobs and not active jobs.
User logs
Question 66: In which report or table does the user logoff time is stored in SAP?
Answer: No standard report is there. However, in table USR02 and field TRDAT you can find out about the user’s last transaction time, which is close to logoff time.
Transport problems
Question 67: The transport system is not working properly after the kernel patch 6.40 level 098 has been installed. Although I start it manually, the job RDDIMPDP is not starting. The error messages keep coming in. What should I do to get this problem solved?
Answer: In both client 000 and your working client, go into SE38. Run program RDDNEWPP. With proper parameters this will schedule program RDDIMPDP. Then, if any “TP” programs are running should be checked. Check in /usr/sap/trans/log if this is the case, and the contents of the most recent file should be looked for.
Spooling tablespaces
Question 68: In one of our customer’s production systems that runs 24 hours a day, the temporary spooling tablespace is approximately 5GB. This can be reduced over time. For reducing this tablespace which strategy should you use?
Answer: For deleting the spool (TEMSE) objects, you could schedule report RSPO0041. In order to minimize impact on your system, schedule it as a daily background job.
Table Maintenance
Question 69: In what way should the table maintenance be set up for customized table Z1?
Answer: Transaction code SE11 should be used.
Dialog and Batch Processes
Question 70: Where can I change five dialog work processes into batch?
Answer: Through parameters in RZ10, you can configure work processes. For dialog “rdisp/no_wp_dia”should be used and for background “rdisp/no_wp_btc”should be used. For that through RZ04 you can configure operation modes.
Transport numbering
Question 71: To start with a number that I choose, in what way shall I change the transport request number?
Answer: Assuming user SAPR3 is owner of the database and your release is 4.6. The last transport number should be called by issuing “select * from sapr3.E070L.” By issuing: “Update sapr3.E070L set TRKORR='<SID>K9xxxxx’.” change the transport sequence number Replace SAPR3 with the owner of the database if your SAP release is higher than 4.6.
Jobs that don’t quit
Question 72: In our quality System BW the job “SAP_COLLECTOR_FOR_PERFMONITOR” is being cancelled continuously. What should I do if I keep receiving an error that says the load program is not found?
Answer: In the support package, the actual problem exists. Delete the SWNC* reports and insert RSSTAT83 and RSSTAT87 into TCOLL as this is the only solution for this.
Kernel Upgrades
Question 73: From the existing V5R2 to V5R3 of our i-series server which hosts SAP application we are planning an upgrade of the OS. At support pack level 50 we are currently on R/3 Release 4.6C. We are planning to migrate applications to a power 5 i-series 550 servers after the up gradation is done. Should we consider a SAP kernel upgrade if our current kernel is ASCII 46D patch level 1977?
Answer: Always update your kernel to latest level before upgrading OS, database or SAP Version.
SAPDBA
Question 74: A SAP r/3 47×200 (unix/oracle) is with us. Since we’ve upgraded from 6.20 to 6.40, the SAPDBA program no longer exists. After installing Kernel 6.40 from where can I download BR*Tools Gui for Oracle DBA -GUI?
Answer: From version 6.20, SAPDBA can still be used. Combine it with BR*Tools 6.40 essentially.
Transporting
Question 75: 2 transports (K and R) to be imported are received from an external vendor. These need to be imported into our QA system. The transports have been moved to the Profiles and Data subdirectories. What should be done next?
Answer: The pathway STMS -> Overview -> Imports should be followed. On QA’s SID, one should click twice. Next, this path Extras -> Other Requests -> Add should be followed. Finally, the transport number should be typed and imported as when transported normally.
SAP BASIS Interview Questions Anonymous
What is TMSADM?
while configuring TMS , TMSADM usr created, This is used for internally.
How to estimate the client size?
In order to check client size use command:
- SE38/SA38 and run RSSPACECHECK!!!
How to find out the object and object class for a specific role?
- SE03 tcode helps you to find out object, locked object/TR etc..
- PFCG SUIM are also helpful..for finding roles containing objects etc
Can I transport printer settings?
Printer settings can be transported by creating Workbench TR and include below object with * as their field values:
- TSP03
- TSP03C
- TSP03D
- TSP03L
How to find SAP r/3 system patch level and kernel version?
Hit SPAM–> select all it will be display all patch levls kernel—> SM51–> release notes or OS level disp+work
What is System table? how can I find out system table in SAP?
The database system contains a series of system tables with information about database objects and their connection to each other, statistics system tables, monitor system tables and loader system tables. We usually look in SE16 for system tables!!
Can I convert authorizations field to org, field?
- There are standard housekeeping jobs for cleanup of spool request and abap dumps.. or you can run the standard programs RSSNAPDL and RSPO1041 in SA38/SE38.
- There is one background job you need to schedule RSPO1041.Run this job in SE38 and fill the required entries in there!!!
How we do Scheduled jobs in background to cleanup spool request, dumps?
There is one background job you need to schedule RSPO104, run this job in SE38 and fill the required entries in there.
Can wild card use for authorization
How to check kernel ,tp.exe version?
How to find out the object and object class for a specific role?
- SE03 tcode helps you to find out object, locked object/TR etc..
- PFCG SUIM are also helpful..for finding roles containing objects etc
What is mass transportation and where can we use?
SAP BASIS Interview Questions for 2 Years Experienced
- What type of servers is used in sap(like HP or Dell Servers names)?
- How do you configure System Landscape in your company? with detailed(dialog servers, Background jobs server need a diagram)? with clustering concept?
- how you connect to servers? which VPN software is used?
- Give me your daily activities in your company?
- give the list of third tools which are used in your company?
- In company how the roles are assigned[like monitoring(maintenance admin), config admin, install admin] how the work is assigned?
- what kind of roles will be given to the basis admin or for ABAP users?
- Solution manager is mandatory or optional….if it is mandatory how the monitoring will be done in sol.man? version? seperate employee will be there are basis admin look into it?
- how to take backups, os / sap / oracle…is there any third party tools used?
- can we say that i worked on the windows server?
- where do we mention new user employee id and acc. number in su01?
- describe database storage servers?
- SM51 describe? process and errors? what to do?
- differ application server and message server? how many application servers will be there?
- Licensing process..complete ? developer key / SSCR key / Object Key?
- when we do background jobs?
- when using remote client copy entire data ,how much time it will take?approx?
- archive administrator?
- production servers how many? pre-production servers?
- ST22 ABAP dump analysis? describe scenarios?
- GRC tools? third party tools for security?
- in support project what kind of authorization we’ll have?
- Load balancing(SMLG), where and when we’ll do? describe with scenario?
SAP BASIS Interview Questions and Answers for 3 to 10 Years Experience
- What is the access method?
- What IS TMSADM?
- How I estimate the client size?
- How to find out the object and object class for a specific role(eg. basis admin, mm purchase)?
- Can I transport printer settings?
- How I find sap r/3 system patch level and kernel version?
- What is a system table how can I find out in sap?
- Can I convert authorizations field to org, field?
- Can wild card use for authorization?
- How to check kernel, tp.exe version?
- what is mass transportation and where can we use?
What are the derived roles?
Derive role is nothing but the child rolewhich is inherited from the parent role.
Purpose of creating derive role
The parent role is the main branch of the company it has full authorizations for org.levels.
The derive role is the subbranch of the company where it depends on the main branch only authorized to the parent org.levels
What is the difference between mb51 and mb59?
Both are same for material document list its just same as SE11(or) SE09(or) SE01 all are for ABAP directory.
Difference between a Role and a Profile
Role
- A role always depends on a profile.
- A single role consists of an individual profile.
- A Role won’t work independently.
Profile
- A Profile can hold 150 Objects at a time but not all at a time one by one.
- A profile can work independently.
- Authorization objects resides in profiles.
- A profile can have ‘n’ number of roles.
What are the three system profiles what is a domain controller?
In SAP directories we find three system profiles
- Instance profile.
- Default profile.
- Start Profile.
A domain controller is nothing but server with AD(Active directory) installed