What is SAP R/3? R/3 stands for?
Ans: System Application and Products. R stands for realtime environment version 3.
What is T_Code?
Ans: If we want to perform any operations that can be perfoemed with T_Code. T_Code stands for a collection of dialog steps.
What is the Instance?
Ans: It is group of R/3 services which are started and stopped together.
What is the central instance?
Ans: Where the message server and dispatcher staying toghther that instance will be called as central instance.
What is the Dialog instance?
Ans: If all work processes are dialog the it is called as a dialog instance.
Architecture of SAP Instance, What Message Server and Dispatcher does?
What is the Message Server and Dispatcher?
Ans: Message Server can communicates all the dispatchers that are existing in a system. Dispatcher is used for recives the information from the Presentaion server and dispatches to workproceses.
What is the T_Code for checking the R/3 installation?
Ans: SICK or SM28.
What is the T_Code to activate the objects after installation?
Can I script the starting and stopping of R/3?
Ans: Definitely. You can use the SAPSTART, SAPSRVKILL and SAPNTWAITFORHALT executables.
Where can I get a list of all transaction codes in SAP?
Ans: The following tables hold all SAP transactions:
Table TSTC stores all
transaction codes and their respective ABAP program.
Table TSTCT stores the text (or description) for each transaction.
Table THSTC has also documentation for all transaction. It is a copy of TSTCT.
Table TSTCP stores the possible parameters for each transaction.
Where can I get a list of all tables in SAP?
Ans: Table DD02L stores all tables in SAP.
What happens if I start a dialog instance but the database and SAP services
are down on the central instance?
Ans:The SAP<SID>_xx and SAPOSCOL services will start. However, the work processes will end soon after being started.
What happens if I start a dialog instance but only the database services are up on the central instance?
Ans: The SAP services will start and so will the work processes. However, because the message server is down on the central instance users will get the message “No logon possible (no hardware ID received by message server) when trying to log on. No user logins will work. The “Process List” in the SAP MMC will stay in yellow.
If using Single Sign-On, do the passwords in SAP and Windows have to match?
Ans: No. Only the user IDs must match for single-on to work.
Can SAP be installed on FAT or FAT32 partitions?
Ans: No. SAP needs to be installed on NTFS partitions only.
What is SAP MMC good for?
Ans: The SAP MMC has multiple uses. Among them: starting/stopping instances and viewing/analyzing the developer traces (dev_disp, dev_ms, dev_w*).
After a new installation of R/3 Enterprise, the system has a temporary license. How long does this license last?
Ans: This temporary license lasts up to four weeks. After that, nobody can log into the system except SAP. Therefore, users must request a permanent license at the early stages of an installation.
How does an SAP instance read logs?
Ans: For every lock entry the pointer to the lock is maintained in a separate table. All the instances look into this table to detect lock entries.
How do you use DPMON?
What is the transaction to access the language utility?
Ans: Transaction SMLT takes you to the Language Transport Utility.
How can I see all the available icons in SAP?
transaction BIBS and select Elements -> Icon Overview.
You can use the code that appears on the last column in order to put icons in system messages (SM02).
What are default profiles in SAP R/3?
Ans: We have three profiles in R/3 . They are Startup, Default, Instance.
Startup Profile: It is a parameter file which is read by startsap program. The services which the start profile can initiate the message server, the gateway, Dialog, Enqueue, system log collector and log sender programs. Depending on release version the name is assigned. Start_instance name (or) Start_InstanceName_Host.
Default Profile: Which contain parameter values used by all application servers from same SAP System. The name is DEFAULT.PFL. Only one profile for the System.
Instance Profile: Which contain parameter values which directly effect the configuration and resources for the application server. We have more than one Instance profiles for the system. For each Application server we have one Instance Profile.
SID_InstanceName (or) SID_InstanceName_Host. SID_DVEBMGS00_DEV.
Where we find the all the parameters in the System?
Ans: Execute the report RSPARAM. (or) Enter T_Code TU02 – select the application server – It displays list of available Paramaters.
How to Maintain the Profile Paramaters?
Ans: Using T_Code RZ11.
How to define Parameter and edit the Parameter values? How do you display the profile parameters?
Ans: Using T_Code RZ10. we will define parameter or edit the parameters.
Why should we not change profile parameters from OS Level?
Ans: Because RZ10 supports versioning (Multiple instances of the profile), hence we can recover to an earlier profile if something is wrong with the current. This is not possible through OS level.
How to delete the old ABAP Dumps?
Ans: RSSNAPDL Using this abap program we delete the old Dumps.
Ans: rdisp/max_wprun_time (Default time is 600ms)
Whare u find work processes list?
Ans: SM50 – Work processes overview or SM66 – System wide work processes overview.
If an SAP instance does not start after making changes to the instance profile via RZ10, what is the best course of action?
Ans: In an emergency, the best thing to do is to manually edit and correct the problem in the instance profile (located under usr/sap/sys/profile). After successfully restarting the instance run RZ10 and correct the problem there. Save and activate the profile. If possible restart the instance right away and make sure everything works. Otherwise, plan on keeping a close eye on the instance the next time it restarts.
Restoring the database from a full backup will erase all the work done since the backup ended to the moment the problem occurred. Copying the instance profile from another system is a bad idea. The profiles are unique and contain hard coded values. Logging a trouble ticket is not necessary unless you cannot absolutely bring the system back up.
What is the use Operation Modes?
Ans: For distributing the work processes we use op.modes. To increase or decrease the work processes for a instance. At the time of switching op.modes the running WP may not be distributed till their job finishes.
How to create the Op.Mode?
Ans: Using the T_Code RZ04. Then using the T_Code SM63 we assign the Op.Mode to time table.
How to delete the Op.Mode?
Ans: First delete in the time table and save empty time table. Then delete the Op.Mode using RZ04.
What is Expectional Op.Modes?
Ans: We need to extended the maintence +day, -day, Date. We will do it.
What is the Background job?
Ans: A job is group of steps. A step can be ABAP program, external command or external program. rdisp/btc time – 60seconds.
SAPMSSY6 – An ABAP program run continious for every 1 min.(Scheduled report).
What are the different types of Job classes?
Ans: Class A, Class B, Class C.
Ans: Immediate, Date&Time, After Job, After Event, At the Op.Mode.
Ans: Scheduled, Released, Ready, Active, Finished, Cancelled.
Ans: Using T_Code SM36.
Where you find Job overview or where u find finishes jobs or cancelled jobs?
Ans: Using T_Code SM37. Enter the user name and client number then execute it. It will displays all the jobs that can be finidhed and cancelled.
What is the ABAP report to delete the Background jobs?
All the background jobs are in released state and there is a delay time and the background work processes are in wait status. What could be the reason why the jobs are not in ready or active state and the solution?
How to reserve a bkgd wp for a particlar job to run without any delay?
How to configure the printers and Output Devices?
Ans: Using the SPAD we configure the printers.
Ans: C- Direct O.S Call
L- Printing for using LP/LPR protocol.
F- Front end printing.
S- Printing for using LPD host via sap protocol.
U- Printing for using LPD host via Berkely protocol.
E- Extenal printing.
What are the different types of printing? What are the 3 types of Remote Printing?
Ans: Local Printing: The Spool workprocess is running on the same server as a host o.s spool.
Remote Printing: The Servers are connected on different servers through network.
Front end Printing: The printers are cinfigured with windows pc’s through print manager.
What is the Spool Request and how we accesses it?
Ans: Spool Request contains the acutual data for printing. Using T_Code SP01 we access it.
What is the Output Request and how we access it?
Ans: Output request contains information about the Output device name, no.of copies to be printed and using information. Using T_Code SP02 we access it.
How you delete the old spool requests?
Ans: RSPO0041 this report checks the old spool request and delete it.
Ans: It is the temporary sequentional database. Contains all the information related to job logs, print job logs. Using SP12 we access the Themse Database.
How you find the inconsistencies the THEMSE database?
Ans: RSPO1043 this report finds the inconsistence in the theme database and delete it. It compares the TST01 and TST03 tables and displays the Inconsistencies.
To prevent having to adjust output devices (e.g. print queue definitions) in every system each time they are transported from one system to another, an administrator can:
Ans: A logical spool server mapped to the real spool server can solve this problem by adjusting output devices after importing them.
For example, logical spool server "logicalspooler" can be set up in the customizing, quality assurance and production systems; printers get assigned to this spool server and they get transported. Because "logicalspooler" exists on the target systems, there is no need to change anything after the transport is imported.
When a log is created for the Spool request where exactly it is placed?
How to create user account?
Ans: Using T_Code SU01 we create the user accounts.
Ans: Address Data, Logon Data, Defeults, Parameters, Profiles, Activity groups, Users.
What are the Different types of users?
Ans: External users: SAPSID, SAPServiceSID, SAPR3,Administrator.
Internal Users: Dalog: This is the normal user to execute the interactive task.
BDC user: Access priviligers to execute the Batch input Jobs. (Service)
Background Job User: Access priviligers to execute the Background Jobs. (Reference)
CPIC user: Access priviligers to communite the Gateway services and execute the external programs and external commands. (System)
Special Users: SAP*, DDIC, Earlywatch.
How to create the Mass Users?
Ans: Using T_Code SU10 we create the mass users.
Ans: Using T_Code SUGR we create the User groups.
Ans: Using SU01 We will create the Users, Chang the user data, locking and un locking user, Copying user from existing users and setting the password changes.
What are the reasons why users cannot login?
Ans. A. Archival stuck B. Page file is full. C. Heap Memory
Ans: Central User Administration (CUA) was introduced in R/3 4.6 to provide a mechanism that allows central user management. Once configured, all user accounts are managed from a central client.
What is Logon Load Balanceing and how to create the Logon Groups?
Ans: For distributing the load among the applicastion servers and also for increasing the performance of the system. Using T_Code SMLG we create the Logon Groups.
What is the Kernel Directory?
Ans: Usr/SAP/SID/Sys/Exe/Run/. RUN directory is the Kernel directory.
How to Upgrade the Kernel?
Ans: Download the corresponding the files from SAP service marketplace. These files are in the form of .CAR
First of all stop sevices, then take the backup of existing kernel and uncarry the downloded files and start the Services. SAPService_SID, SAPoscoll.
If the SAProuter.exe, SAProuttab files exists in kernel, if we upgrade the kernel then these files will be corrupt. So, router will not start. To avoid this problem we will keep the copy of SAProuter.exe, SAProuttab files in trans directory.
SAPoscoll, SAP Router.exe.
How do you resolve /usr/sap file system issues?
What is a Role (or) Activity group?
Ans: Role is a collection R/3 transactions, Autharizations and other related objects.
Ans: Composite Activity Group: Composite activity group is made up of collection of activity groups. Istead of assigning each role to user we made composite activity group and assigned to user.
Derived Activity Group: When creating Derived activity group we use an existing activity group as a reference. In Derived Activity Group we are not assign transaction, we inherit transaction from the Existing Activity groups. We will chane the Activities.
Tell me some authorization objects and its purpose?
Ans: S_DEVELOP, S_PROGRAM, S_TRANSPORT, S_TOCDE, BC_A, S_AAAB.
Write one role on the pair u r created in your organization?
Ans: Z_FI_APACCOUNTAG, Z_FI_AP_DATA_ENTER_CLERK.
What the naming convention u follow for roles in our organization? How many charatcers u r using for creating role, do u accept _ and numeric values?
Ans: The first letter must be start with Z, we are accepting _ & Numaeic values with minum 11 charatcters.
What is the Authorization Object?
Ans: Authorization Object is collection of authorizations. Each Authorization object have activities and fields and having max 10 Authorization fields.
What is Authorization?
Ans: Authorization gives the permissin to access the tansaction.
Ans: Profile is a collection of Authirizations. If profile having more than 150 transaction its automatically generates the new profile.
In role how many profiles we have?
Ans: 100 profiles for one Activity group (or) Role.
Ans: Using T_Code PFCG we create the role.
Ans: Description, Menu, Authorizations, Users.
Ans: Using the T_Code SU53 we find the missing Authorizations.
Ans: If we are unable to find the missing authorizations using SU53. Using ST01 we find the missing authorizations. We logon the particular Application server where user exists and enter the ST01, Check the Authorization field and click on the traceon button. It displays the missing authrizations and activity.
What is the User Information System?
Ans: Using SUIM we access the User information like users, authorizations, transaction, profiles, roles, Change documents.
What is the Audit Information System?
Ans: Using SECR we access the Audit information system.
Ans: Use transaction SM01. Look for the transaction you want and then check the “Locked” box. Because some transactions are “dangerous” and a user without the proper training may accidentally corrupt or destroy the system.
How can I see what users are currently logged on an R/3 system?
Ans: Use either transaction SM04 or AL08.
What is the fastest way to log off in SAPGUI?
Ans: Type /NEX at the command field. Notice that this transaction exists without asking for confirmation. Save your work before using it.
How do I find information about transaction codes?
Ans: Run transaction SE93 to create, edit or display transactions.
How can I quickly check if the passwords for the accounts SAP*, DDIC, SAPCPIC and EarlyWatch are not the default ones? What does report RSUSR003 do?
Ans: Run SE38 and execute report RSUSR003. Report RSUSR003 lists all logon system settings and it reports if passwords for accounts SAP*, DDIC, SAPCPIC and EARLYWATCH are trivial. That is, the system will report the passwords for those accounts that have not been changed from the delivered ones. This is a handy report – SAP auditors frequently ask for it immediately when doing an SAP audit.
To prevent the use of common password combinations, a system can be set up to include:
Ans: To avoid this problem, populate Table USR40 with forbidden or illegal passwords combinations. Also, as of Web AS 6.10, instance profile parameter "login/min_password_digits" can be set to a value >= 1 to force users enter at least one digit in their password.
Which of the following are possible ways to display the R/3 Kernel patch of a system?
Ans: Within SAP run SM51, click Release Notes, and then read the line that says "Kernel Patch number." At the OS level, change it to the:
Usr/sap/sys/exe/run directory and run disp+work –version or disp+work –V
Also, look for the "kernel patch number" line.
What is the purpose of T_Codes su24?
Ans: It display what are the authorization obtects we maintain for particular T-Code.
How do you lock mass users?
Tell me some important parameters related to security?
Ans: rdisp/gui_auto_logout – Automatically logout.
Login/min_password_len -- Minimum Password Length.
Login/password_expiration_time – Password Expired Time.
Login/fails_to_user_lock – User Auto Lock.
Login/fails_to_user_unlock – User Unlock.
Dangerous Combination of transaction codes?
Ans: RZ02, RZ03, SU01, SU02.
Important Audit Information Reports?
Ans: RSUSR003 – Default passwords of SAP* and DDIC.
RSUSR005 – List users with critical Authorizations.
RSUSR006 – List the users who are locked due to incorect login.
RSUSR007 – List the users with incorrect data.
RSUSR008 – List the users with critical combination of Authorizations and T_Codes.
RSUSR100 – List the change documents for users and show changes made to user
RSUSR101 – List the change documents for profiles and shows changes made to
RSUSR102 – List the change document for authorizations and shows changes made
to security authorizations.
What is the tool you are using for performing the Transports?
Ans: The system in which we logon TMS that system acts as Domain Controller.
Ans: Domain contains more than one transport groups and having only one Domain controller.
What is the Transport group?
Ans: The system which have got the Trans directory from a transport group. In a Transport group we have 3 systems like Integration, Consolidation and Recepient Systems.
Ans: Transport Layer defines transport path from the integration system to Consolidation system. Tranport Layer is used for grouping all the Development objects that will always use same Transport Route with in the same development Project.
What is the Transport Route?
Ans: Transport Route is used for defining the different transport routes that exists between two systems with in the same transport group.
What are different Types of Routes?
Ans: Consolidation Route: This is the route exists in between Integration System And Consolidation System.
Delivery Route: This is the route exists in between Consolidation System And Receipent System.
What is the Development Class? How to create the Development Class? Who create the Development Class?
Ans: Development Class is used for grouping the all the development objects in module or project. Using T_Code SE80 we create the Development Class. The ABAP team lead will create the Development Class.
In which table development classes are stored?
What is the Change Request?Who creates the Change Request? How to create the Change Request?
Ans: Change Request is a list in the system containg objects to be transported and information on the purpose of the Transport, Transport Type, Request Category,Target System. Team Lead will create the Change Request and assign to the team members. Using the T_Code SE09/SE10 we reate the Change Requests.
What are the Different types of Change Request?
Ans: Workbench Requests: Changes to SAP standard objects are put in the Workbench Requests. ABAP er’s do modifications at object level which are applicable for all clients.
Customoizing Requests: Changes to company specific objects are put into Customizing Requests.
What is the prerequisite to change the SAP standard object?
Ans: We need to have the developer key to make changes to SAP standard objects.
Ans: <SID>K9<00001>. SID is System Name and K9 is Correction Request.
Ans: Tp—Transport Controll Program: Is used for to control transport requests at o.s level.
R3trans: Is used for to controll the Transport Data at the o.s level.
What are Commands for Import, Adding the request to Queue, Import All Requests at o.s level using TP?
Ans: To Import Single Request --- Tp Import SIDK900012 PRD(SID Name).
To add request to Buffer --- Tp addtobuffer SIDK900012 PRD.
To Import all the Requests --- TP Importall PRD.
What is the standard way of moving the transport to production?
Where the TPPARAM locatd?
Ans: It is Transport Parameter File that contains all the Important parameters that directly effected the way TP program works for performing Exports/Imports. It contains the Location of TP, R3TRANS, DB Host ,DB Name, SAPEvtpath, ALLLOG, SYSLOG, IMP_BY_EVENT=True, StartSap, StopSap, Start DB, StopDB.
How to know the all the Parameters for TP?
Ans: TP Showparam <SID>.
Ans: BIN: Contains TPPARAM file.
Data: Contains the transport data files.
Log: All the individual and general transport logs and trace files located.
Buffer: Contains Buffer fies, includes control information on the transports that will be imported to other systems and order of them.
Cofiles: It is the control file directory, containing information about the steps of transportable change request as well as return codes.
Sapnames: Information on SAP user performing Imports.
Tmp: Contains Control Flags and semsphores.
ActLog: Includes action log files for all task and Change Requests. Import,Export.
What is the Transport Log?
Ans: Transport Log keeps the record of log files generated by the transport steps.
0 – Transport Succesfully 4 – Transport has at least one Warning
8 – Transport has Some Errors 12 – Transport failed to due to fatal error.
What are the steps to configre the STMS?
Ans: Configure the TRANS directory and TPPARAM file.
Initialize CTO. Using SE06 we initialize the CTO(Change and Transport System).
Configure the Transport System and Routes.(STMS)
Create a Development Class. (SE80)
Create or Modify Object.
Release and Export the Object.(SE09/SE10)
Import Into the Target System.(STMS)
Check the Log Files.
What are the tools available in R/3 for Transports?
Ans: SE01 – Transport Organizer. SE09 – Workbench Organizer.
SE10 – Customizing Organizer. STMS – Transport Management Syatem.
TP, R3Trans – These Tools are used at O.S Level.
One hour back Tranport Done Perfectly with out errors. Now when we are trying to perform transports we getting error what happens?
Ans: At least one Background Job Should be free.
Ans: Enter T_Code SE06 – Configuration – Overview -- Click on system list – Enter SID’s involved in the Transports – Save (or) F3 – Back.
Click on Deliveres – Make SID entries here – Save (or) F3 – Back.
Click on consolidation Route – Enter the source system SID and Integration Syatem SID – Save – Back.
Click on Transport Layer – New entries – Fill information for the Layer name, Integration System, consolidation system and Description – Save – Back.
Click on Development Class – New entries – enter development class and assign transport layer that we created – Save – Back.
TSYST – All the systems in the land scape.
TASYS – All the Deliveries systems in the LS.
TWSYS – All the Consolidation Systems in the LS.
DEVL – All the Tranport layers.
**With out Configureing the STMS we cann’t apply the Support Packages.
Ans: From time to time SAP does modifications to the various objects of it’s R/3 S/w and make the modification available to customers in form of the Support packs.
In Which Form Support Packs Available? From where The Support Packs are Downloaded?
Ans: Support packs are availble in the form of .CAR, We need to Unpacked.
Support Packs are availble in the form of .SAR from 4.7 onwards.
We have download the required support packs from SAPServerVX (or) www.service.sap.com/sp-stacks
What is the Command for Unpacking the CAR files?
Ans: Go to kernal Directory and type CAR –XVF kb46b007.
From Which Client do you apply Support Package? Why are packages applied in 000 client?
Ans: With client 000 and DDIC user we apply the support packs.
What is the T_Code for applying the Support Packs? What does transaction SPAM do?
Ans: SPAM(Support Packs Manager). Transaction SPAM not only lists the support packages that have been imported into the system, but it also defines queues of support packages that can be imported. It's also the transaction that carries out the import.
What is the T_Code for to Access The SAPServerVX? How do I log on to SAPNet?
Ans: Use transaction OSS1 to log on to SAPNet R/3 FrontEnd. To log on to SAPNet R/3 Web visit: http://service.sap.com.
What is the latest SPAM Version? And What is the current Patch nembers for Basis, ABA, HR, BW?
Ans: The latest SPAM version for 4.7 is 6.20/0019
(May Be Basis – 55, ABA – 55)
Ans: Download the Required .car files from SAPNet.
Put them in a temporary directory in /usr/sap/trans/tmp.
Use the command CAR –XVF path the car file including .Car Extention
The command CAR decompress the CAR files and put two files( .ATT, .PTT in the /usr/sap/trans/eps/in/ ).
Log on to the system client 000 as user DDIC.
Execute the T_Code SPAM.
Goto – Support Packages – Load Package – from Application Server.
We get the Pop-up menu with the list of Patchesin the Queue. The applied Patches and new ones will be listed.
Press F3 (or) Back icon to get main sereen.
Click on display/Define.
We will get the pop-up menu with unapplied patch.
Select the patch or group of patch that u want to apply and hit enter icon.
The patch Number will be defined in the Queue box.
Goto – Support Packages – Import Queue.
After the patch is successfully applied , we will have to confirm the Patch application.
Goto – Support pacage – Confirm.
The status box should trun to green.
After The Patches applied , Execute the T_Code SPAU.
When we are applying Support Packs from Front End and Application Server?
Ans: If the Support Pack size is less than 10mb we applied from Front End. Otherwise we can apply from application server. 200MB.
What is the use of T_Codes SPAU and SPDD?
Ans: SPAU T_Code will Check for changes made by the patches in the reprositry as well as by the user via OSS Notes to the system.
SPDD will checks for changes made by the Patches in Data Dictionary Objects in the System.
What are problem we get while applying the Support Packages?
Ans: Cannot_Create_Cofile: Delete the concerned file of path from Usr/sap/trans/cofile and Usr/sap/trans/data directory. After deleting the files restart the Process.
EPS in is old Format: Check the Spam Version and do a SPAM update. Deletete the concerned files( .ATT and .PTT)
Objects_Locked: An object that it is trying tomodify is locked by a Change Request.
How to Update the SPAM?
Ans: Download the files from the SAPNet. Enter T_Code SPAM. Support package – Upload SPAM file.
What is the Add-ons and Plug-ins?
Ans: Add-ons is the additional functionality to the SAP R/3.
Plug-ins is the additional functionality to the Core/Basis Module. Plug-ins available in the form of .CAR.
What is the T_Code for applying the Plug-ins?
Ans: Log on the Client 000.
Execute the T_Code SAINT.
Upload the Plug-ins by going thru Menu options.
One the files are uploaded , we get two boxex on the screen. The top box contain the list of plug-ins already applied in the system. The bottom box will contain the list of plug-ins which are be available to be applied.
Select Plug-in from the second box and click on the continue button.
In the next screen Put the cursor on the Plug-in box and click the continue button.
After plug-ins installed successfully you will be asked to do SPAU or Continue. Click on Continue.
Support packages and SAINT. What are they and how do you install them?
Where we find the Notes in a system?
Ans: Some of the errors will be rectified with notes. Enter T_Code SNOTE, we get all the notes available in the system. Double click on the Note it will be executed.
What is the client?
Ans: Client is a logical unit of a system which is self contained technically, commerically and organizationally. (or)
A client is an independent business unitin with in an R/3.
What is Client Independent and Client Dependent?
Ans: Client Independent: Data Such as ABAP Programs, Reprositry objects and etc..
Client Dependent: Data includes customizing application and user data.
A client with out application data needs aproxmately 150 – 200 MB space in the Database.
What r the default clients in R/3?
Ans: 000 —SAP*, DDIC -- 06071992, 19920706. Used for administrative purpose. It is used as reference client for creating new client.
001 -- SAP*, DDIC -- 06071992, 19920706. It is the replica of 000.
066 -- SAP*, Earlywatch -- PASS, SUPPORT. R/3 support people will be used and it is for SAP remote Sevices.
800 – For IDES System.
I lost the password for SAP*. What can I do?
Ans: You can delete the record for SAP* in table USR02 as follows:
delete USR02 where BNAME=”SAP*” and MANDT=’XXX’
Replace ‘XXX’ for a valid client number.
What are different client roles?
Ans: Role defines express the purpose of the Client.
Production, Testing, Customizing, Demonustration, Traning.
What are the Authorizations need to perform Client copies?
Ans: S_TABU_CLI – Table Maintaience in all clients.
S_TABU_DIS -- Maintaience of contents of Table.
S_USER_PRO – For the User Profiles.
S_USER_GRP – For the User master Records.
How to create the New Client? In which table all clients will be stored?
Ans: Usimg T_Code SCC4 we create a new client. The table enytries are made in T000.
Enter T_Code SCC4 — Click on Change Icon – Click on New Entries.
In the Screen Enter the Client Number, Name, City, Currency, Logical system, Client Role.
Changes and Transports For C.D Objects – Automatic Recording
Client Independent Object Changes – Changes to Repositry and C.I Customizing allowed.
Protection client copies and comparision tool – Level0: No restriction.
Click on Save Button.
What are different types of Client copies?
Ans: Local Client Copy: Copy the data into the new client from the client With in the same system. Using T_Code SCCL we perform Local client copy.
Remote Client Copy: Copy the data into the new client from the client for the remote system. Using T_Code SCC9 we perform remote client copy.
RFC connection must be established between the target system and Source System.
What is the T_code to test RFC Connection?
Ans: SM59. (Remote Function Call)
Ans: Using T_Code SCC3 We find client copy Logs.
How to perform Local Client Copy?
Ans: Log on Newly created client with SAP* and PASS.
Enter The T_Code SCCL – Enter Target Client No, Name, Select the Profile.
Click on Execute in Background.
How to perform Remote Client Copy?
Ans: Log on Newly created client with SAP* and PASS.
Test the RFC connection using RFC system check button on the toll bar.
The R/3 System Relaese versions also Checkd.
Enter The T_Code SCC9 – Enter Target Client No, Name, Select the Profile.
Click on Execute in Background.
Diff. bet. Client Transport and Remote Client copy?
What is Client Transport ( or) Export?
Ans: Data to be filled into new client from another system by the way of transport Request. Using T_Code SCC8 we perform Client Transport.
What is the T_Code to perform client Import?
Ans: SAP_ALL, SAP_USER, Sap_Appl, SAP_Cust.
If we delete the one client from the sytem where we find details who delete the client, when it will be deleted?
Ans: We find the needed information in client Copy logs. Using T_Code SCC3 we get these details.
How we know how much space is required for client copy? How can I determine the size of a client?
Ans: After enterning the needed information click the check box for test run and execute the it. It displays the no. of files to be copied and amount of space is required. You can run a local client copy in “test” mode.
Can I copy all users from client to another?
Ans: Yes. Use copy profile SAP_USER.
How can I hide a client from the users?
Ans: There is no way to actually hide a client but there is a workaround: delete the entry in table T000 via SCC4. This way, nobody will able to log on to it. To “unhide” it, simply re-create the entry via SCC4.
How can I lock a client?
Ans: You can use one of these two: 1) delete the entry in table T000 via SCC4; 2) run tp locksys at the OS level.
Can I import transports between different R/3 releases?
Ans: Read the technical and logical problems SAP reports when doing transports between different R/3 releases. SAP Notes 126776 and 330267.
Can I copy just data from client to another?
Ans: No. There
is no copy profile that allows you to copy just data.
For this you need to configure and use ALE or buy a third-party program that has this type of functionality.
What I sthe use of SAP Router?
Ans: It is s/w program to connect the SAPNet Directly. SAPRouter.exe
SAPRouter –r to start the Router.
SAPRouter –s to srop the Router.
What is SAPRouttab?
Ans: It is a file which we will give IP addresses. Default port is 3299. SAP reads the parametr file from top to bottom. So SAProuttab Permit(p) always followed by DENY(D).
What is the sequence of memory allocation when a user logs on to SAP like Roll,Extended and Heap?
Ans: Roll memory is allotted to user (Which stores the user –specific information, such as parameters are stored),Once user finishes with a certain transaction, his info’ is rolled –out to roll file & when he needs to use something else again, the data is rolled back in, This Improves efficiency.
Once user starts using a transaction, all the processing date fetched from DB is processed in Extended Memory (Which is shared across multiple users), but when Ext. Mem gets full, heap memory starts to get used. But the problem with heap memory is it can’t be shared & too much usage of Heap will lead to Dialog process stopping with error “PRIV mode”
What is SGA?
Ans: System Global Area. Database uses a memory region known as SGA. This region is shared by all background processes.
What is a control file?
Ans: Control file contains the schema of the Database. To initialize the Data files and online redo log files.
What is check point?
Ans: Check point is the one of the oracle background processes, send the signal to DBWR(Database writer) at check point. It updates the headers of control file and data files.
What is a core file?
Which background process writes data to Database?
Ans: DBWR (Database Writer) Process writing the data blocks from Data buffer to the Data files.
Which Background process writes off line redologs?
Ans: LGWR (Log Writer) process writing redolog entries to the from redolog buffers to the online redolog file on disk.
What is BRRESTORE?
Ans: BRRESTORE is the toll for restore the Database. Restore is the process of the transfering all the data files needed for a recovery from backup media to the server disks. Recovery is the process of setting the database to a consistent state using files that were prevoiusly restored.
How do I backup a database?
Ans: You can create a maintenance plan or use the “backup database” SQL statement in Query Analyzer or OSQL.
Within SAP, you can use DB13.
ABAP Query does not seem to work, what should I do?
Ans: It could be that you need to execute report RSAQUM40 to set the release flag. See SAP note 92124 for more information.
Can Query Analyzer tell me if there is insufficient disk space to restore a database?
Ans: Yes. It will display message (Msg) 3257 indicating that there is not enough disk space to perform the restore.
True or False? In order to read developer traces you have to go the operating system because SAP does not have a way to do this within the application.
Ans: False! SAP provides transaction ST11 for this purpose. ST11 can even sort the trace files by date and time.
True or False? MS-SQL Server can be installed using all the delivered default settings. Everything is controlled within the application, so SAP requires only a database engine to work.
Ans: False! MS-SQL Server needs to be configured with binary sort order and 850 multilingual character set. Therefore, using all defaults during a SQL Server installation will not work. The SAP installation program will fail.
What is T_Code to access the Business Work Place?
How do I logon to a SAPServX FTP server?
Ans: User = ftp; password = ftp.
How can the logon screen be modified to include informational text, such as the company name, address, the system role, etc.?
Ans: As of SAP version 4.6, transaction SE61 can be used to create object ZLOGIN_SCREEN_INFO. Text and icons can be added to messages that can appear at the logon screen.
What is th checklist for R/3 Monitoring?
DB12 – Backup logs : Using this T_Code we check the any errors found in the last successful backup. If we find any errors Intimate to the Database administrator.
SM51 – SAP Servers : Using SM51 we check all the application server are up or not.
SM50 / SM66 – WorkProcess Overview: Using SM50 we check the status of the Work Processes. Whether it is running (or) Waiting (or) locked by the user.
What is the T_Code for active servers and what is the T_Code for displaying the all the servers in the landscape?
SM21 – System Log : Using SM21 we check angy error in the R/3. The system Log will record the Every thing in R/3 that is Errors, Warnings, Succeful messages.
Why u r looking system log?
Ans: The system log is the R/3 system log of events, errors, problems and other system messages. The log is important because unexpected errors or unknown errors and warnings could initiate serious problems.
How do I check for errors in R/3?
Ans: Run transaction SM21 for read the System Log.
SM37 – Background Job Overview : Using SM37 we check the Background Job Status. Whether it is finished (or) Running (or) Cancelled. If it is cancelled we analyze the background job log and resehrdule it. R/3 administrator need to know when we are running some critical Jobs.
SM12 – Lock entries List : Using SM12 we find old lock entries. If we found any lock entries we contact the particular user nad delete the locks.
Where u finds the lock entries and locked tables?
Ans: SM12 – We find the Lock entries.
Ans: Oracle supports locking on a single database which is not practical for SAP which involves multiple database, hence SAP has created its own locking concept which can trigger lock on multiple tables.
What are the different types of locks?
Ans: Two types – Shared & Exclusive
Shared – One user can write & the other user can read the table.
Exclusive – Only a particular user can read it, nobody else can access it.
SM13 – Failed Updates : Using SM13 we find the Failed Updates. When the user trying enter the data in the databse it is not saved properly. If we found any failed updates intimate to user where the Error occurred. (In which Module, Program and Transaction).
SM04 and AL08: User List : Using SM04 we see the all the logged users. Using AL08 we see application server wise logged users. With this we prevent the unauthorized users.
SP01 - Spool Problem : Using sp01 we check the Spool Problems.
SM35 – BatchInput Initial Screen : Using SM35 we check what are jobs ready for executing and which jobs will be cancelled by errors. If we find errors Intimate to the users.
ST22 – ABAP Dump Analysis :Using ST22 we find the ABAP dumps what the system generates. We are looking abap dumps fo Raise Exceptional errors and Timed out errors. Related to Raise exceptional Errors ABAPers will take care. We are looking into he Timed out errors. If any job execute more than 600ms, the will be terminated and records the Snapshot.
What is the ABAP dump directory?
Ans: An ABAP dump is generated when a report or transaction terminate as a result of error. The system records the error in the system log and writes snapshot of the program. We use an ABAP dump to analyze and determine why the error occurred and take crrective action.
RZ20 – CCMS Alert Monitor : Using RZ20 we find alerts. Using CCMS we logon on one application server and monitor the all application server that are available in the land Scape. Using RZ20 we set threshold values. If it meet criteria it generate the alert.
ST03 – Workload analysis : Using ST03 We find work load of the system.
ST02 – Buffer Statistics : Using ST02 We look into the buffer sttistics.
DB02 – Database Statistics :Using DB02 we look the database statisycs for table and Indexces and Tablespace information.
ST04 – Database Performance analysis : Using ST04 we analyze the Databse Oerformance.
ST06 – Operating System Alerts : Using ST06 We find the Database alerts.
How do you resolve performance issues?
Ans: Using ST03, St02, ST06, ST04 we find the performance related issues find corrective solutions.
In ST03 – Worlkload Analysis: we will look for Avg.Respone Time, Avg.Wait Time, Avg.Roll In Time, Avg.Database request Time for particular Jobs.
In ST02 – Tune Summary of Buffers: we will look for Hitratio and Swaps. If the Swaps and Hitratio’s are very high we analyze the Detailed analysis. It shows details to the Roll Memory, Extended Memory, Heap Memory.
In ST06 – O.S Alerts: we will look for CPU Utilization Time and Idle time, Load average and Disk with high response . If the CPU time < 20% we are getting problems to resolve it.
In ST04 – DB Performance Analysis: We will look Memory Usage, Buffer Usage, Disk Usage, I/O Statistics.
Response Time: Starts when the user request enters the dispatcher queue, end when the next screen is executed to user.
Wait Time: This is the time a user request sit in the dispatcher queue. It starts wen the user request is entered in the queue and ends when the request starts being processed.
Roll-In Time: The amount of time needed to roll user context information into workprocess.
Load Time: The time needed to load from database and generate objects like ABAP source code, CUA and Screen information.
Processing Time: Responsetime minus sum of wait time, DB request time, load time, Enqueue time.
Database Request Time: Starts when a DB request is put through to the database interface ends when the database interface has delivered the result.
Where do you check response time in SAP?
Ans: Enter T_Code ST03. Here we will see the respose time. If the Avg.Response time is very high we will analyze the Transaction Profile, Task Profile and Time Profile.
What is the Bottleneck?
Ans: Anything which can cause to decrease the performance of the system called Bottleneck. This may be RAM/HDD/Processor/ABAP Program/SQL Statement.
What SAP transaction can assist in detecting I/O bottlenecks?
Ans: Either ST06 or OS06 can monitor disk I/O. These transactions are very convenient, as you do not have to go to the OS level. On the other hand, tools at the OS level may offer a more detailed analysis (e.g. Performance Monitor in Windows.
R/3 Memory Management
User Needs two kinds of memeory.
R/3 Buffers. (Memory accessable for all users) – Programs, Table and field Definitions, Customizing Tables.
User Context. (Memory attached individual users) – Variables, Lists, Internal tables, Administration Data(Authorizations).
Local Memory: Local memory is associated with individual workprocesses. Local Memoryis Exexutables, Data, Stack, Buffer for data tranfer, Local roll area, Local Paging area.
Shared Memory: Share memory is associated with all the processes of one instance. R/3 buffers contains global objects for all users and workprocesses such as programs and customizing tables.
Extended Memory: Contains user context i.e; objects associated with individual users such as variables, list and Internal tables.
Heap Memory: Contains User context, when Extended memory is full. It is allocated and released on demand.
The Six R/3 Memory areas are:
Buffers, Extended Memory, Heap Memory, Roll Memory, R/3 Paging Memory, Local workprocess Memory.
What is Roll area and Paging area?
Roll Area: User context data is stored. i.e; Authorizations, set/get parameters, Internal Tables, Report lists.
Paging Area: which stores application program data that corresponding to specific ABAP Commands.
Ztta/roll_first – Defines first part of the roll area set to 1. 170kb for 4.6.
Ztta/roll_extention – User quota for extended memory.
Ztta/roll_area – Total roll area for workprocess.
Rdisp/roll_shm – The size of the roll buffers.
Rdisp/roll_maxfs – The size of roll buffer and roll file.
Em/initial_size_mb – the fixed size of extended memory.
Em/address_space_mb –Amount of extended memory for workprocesses.
Abap/heap_area_total – Total amount of heap memory allocated to all WP.
Abap/heap_area_dia – Limit for the amount of local memory allocated to Dialog WP.
Abap/heap_area_nondia – Amountof local memoryallocated to non dialog WP.
Abap/heaplimits – Maximum heap limit – if it is reached the WP is flagged for restart.
Heap memory is released after use.
After ending the transaction the heap memory is automatically released and the workprocess restarted to release the swap space.
In what tables can I find P.O. documents?
Purchase Orders are stored in table EKPO and field EBELN.
You can also find them in these two tables:
EKK0 (Purchasing Document Header)
EKET (Scheduling Agreement Schedule Lines)
How do you check file systems in Unix?
How do you check process in unix?
What is the command to list of files in Unix?
Ans: LS, LS –L
What is the command to view the Contents of File?
What is the command to copy the file with what permission?
What is the command to find a string in a file?
What is the command to compare the files in unix?
What is the command to delete the file, and rename the file, delete directory, create the directory?
Ans: Rm, mv, rmdir, mkdir.
What is the command to change the file protection?
What is the command to get help, date and time?
Ans: Man, date.
What is the command to display the free disk space?
What is the command to print file and print queue?
Ans: Lpr, lpq.
Ps –ef|grep DW, what is DW?
How do you edit file in unix?
Ans: Open the file in the vi (or) ed mode and then edit the file.
What is NFS mount in Unix?
Telnet, FTP(File transfer protocol).