BASIS Interview 6

SAP BASIS Interview 6

How do you handle the update failures?

Ans: Hi Most of the update failures occures due to object locks.Please double click on the update which has failed in SM13 , you can get information for the failure , so we need to act accordingly.

What is the purpose of a gate way server?

Ans: gateway service helps to make communication and data transfer within two/more application in our landscape. as the communication with two applications uses RFC method in sap, this RFC connection is made via this gateway service.you can see this in Tcode - SMGW

What type of security problems you will get?

Ans: IN R3 level ,mosttly Missing authorisaions,adding authorisation objects manually,addeding roles,users valideity,SU01 level issues,Org levels, authrisaion field values,giving full permission, restricting users to authrisaion objectlevel,creating roles and derived roles and transporing roles.user creations,finding solution through SUIM,should be good knowledge on AGR_AGRS(SINGLE ROLE AND COMPOSTE ROLE)AGR_1251(Autorisatin field ,objecst, values)AGR_1252(Org levels)AGR_users(roles for users)ARG_test(Role details)usobt ad usobx,usro2

What are the profiles that are maintained in the R3 system?

Ans: THE PROFILES THAT ARE MAINTAINED ARE START PROFILE, DEFAULT PROFILE, INSTANCE PROFILE :)

Do you know about operation modes? how do you define operation modes? SM63 , RZ04?

Ans: first we need to create the day mode and night mode in rz04.and we need to set the timing for this modes through sm63.that yat over.

more importent thing is,as per our demand we can change the OP modes using rz03.

What is response time?

Ans: Response time is the time utilied by a dialog workprocess to access data from the database and return to the presentation layer.

What is roll in and roll out?

Ans: when a user login to a system the user contex data has been collected from the data base to Roll Buffer, Roll File. when user execute any transaction the user data are loaded  to the workprocess roll memory from the roll buffer/file. this is known as roll-in. and after the completrion of one dialog LUW the roll data rolled out to the roll buffer. this is known roll-out.this method is used for the dialog multiplexing, means the dialog wp make free to accept any other dialog request.

What is V1 and V2?

Ans: Here Update Process is represented with V1 and V2 where V1 stands for Time Critical update process and V2 stands for Non Time critical Update Process.

What will you do when spool process fails?

Ans: first we need to check why the spool proces is fails.Next we need see the SM50 & sap MMC console regarding spool process .check sm21 for any information.and if possible check the printer configration.

How R3 systems are communicated?

Ans: SAP R/3 systems can Communicate through RFC (Remote Function Call),for doing so one should check OS level,IP Address and HostName,Logical System Name and Binding of Client with Logical System name.

What is central user administration and its uses?

Ans: SAP CUA - Key benefits

Administration of entire system landscape from one

central system

-Overview of all user data in entire system landscape

-Consistent, accurate user data

- Flexibility to do local maintenance as well as central maintenance

Key Circumstances for recommending CUA

CUA can be a big benefit to companies with these criteria present:

- The company has a global system landscape with clients in different systems

- It has users who work in more than one system

- It needs to maintain only one user ID per person across all systems

- Its administrative set-up requires the administrator to log on for users to get access

- It requires manual effort to synchronize user data across systems

- It is difficult to determine which systems users are defined in, which leads to difficulty deleting terminated employees and difficulty in compliance auditing

How do set the alert monitors?RZ20.

Ans: you can set from CCMS

I want to import my Transport request from DEV. to Test system (from STMS buffer of DEV.(domain only) but I don’t want Login/PWD screen while importing from DEV to Test System. But I need login/pwd screen while importing TR from Test to PRD system. Presently I have activated all systems as a non trusted systems. If any one has idea please let me know. Thanks in advance! Regards, Raj Chavan.

Ans: u can do it from the O/S level..go to CMD...tp help....you l hav the screen with the commands..then follow the import command...it is like c:/tp import  ....like that

What is Remote Transaction Processing?

Ans: RTP "Remote Transaction Processing" is not part of SAP but its an OS level app.

What are the post steps after client copy ?

Ans: Apart from SCUO, We need to run the BDLS which create the logical system,Any new RFC connections if required and Configuring the default client in profile parameter if required.

Or

One of the most important post client copy step is client compare using SCU0:

It will compare the objects

evaluate the differences and check the table entries....

I think this is one (or only step) of post client copy activities

what all checks will you perform when sap is down?

Basically we have the following 4 types of check

1. Hardware check

2. R/3 check (with application servers)

3. OS check

4. Database check

1. Hardware check

Check console messages

Check hardware components

Check main log files

Start up/shut down log files

Check the disk space

2. R/3 check (with application servers)

Check for problems with PDC file server.

Check processes or services at operating system level

Check connection with database

Check the buffer size and disk capacity

3. OS check

Check the event viewer

4. Database check

Check database specific error log file

Check database error numbers

Check database alerts.

If you are using P550 and P570 from IBM, please restart the

application server without restarting the database server..

if user calls and reports to you that his background job is taking long time, and which normally does not take so much time. What will you do?

Ans: there could be lots of reason for long running BG job.

1. check with the job owner what the report contains,long critical programs might uses long run time,

2. Did this job runs for the first time or runned previous.if previous then what was the time taken past.

3. check for the real status of the job, might be some situations the job completed/cancelled but due to communication problem the status might not be updated in SM37

4. check for the memory utilisation, and resource constrainsit is only the job owner who knows what is the jobs and what is it doing or what purpose the job has runned.

so take help and work with the job owner.

Can you import a transport request using STMS_QUEUES and STMS_IMPORT?

Ans: Yes we can import the request from the above T codes, but T code STMS_IMPORT is better as it directly takes to the import request screen.

What do you know about Default user DDIC?

Ans: DDIC is the owner of Data Dictionary Elements.

This is SAP predefined user which consists of all

authorizations.SAP recommends to do some main activities like Post installation activities, Applying Support Packages etc.with the user DDIC only.

differentiate system refresh,system copy,client refresh.and client copy.

Ans: system refresh:it is only database only tranfer from prd to qua

system copy:whole system

client refresh: client only related , not system

can we transport requests from production to development for client copy using scc8?

Ans: we can not transport any requests from production to development, transporting of request can only be done fromdevelpment to quality, as we cant create any transportrequest in production environment we there fore cannottransport any request from production to development.

can we adjust tablespaces from DB02 or we have to it at os level using brtools?

Ans: no we cant adjust tablespace using tcode DB02, brtools can adjust it.

I have a question ,suppose all users are unable to login into (sap system including basis administrator)then what are the ways to check the system and how to unlock it.

Ans: Connect to DataBase and delete the SAP* user

Set the parameter in default Login/no_automatic_user_sapstar=0

after that login sap system using 'SAP*' with password 'PASS'and unlock the user whatever u want.

Could you please tell me the whole process of TMS configuration,export,import and when to use Tcode se09 in this process.?

Ans: TMS (Transport Management System) works only if RFC is configured (Remote Function Call) If RFC is not configured then TMS cannot be configured.

there are 500 users logged into the sap system, the system goes down and one cannot login using sapgui. Whyen check the workprocess from dpmon the dialog workprocesses are free. what action does one take as basis consultant?

Ans: the question sounds little tricky, if the system goes down,then how can you check dpmon??, Now assuming that if theserver is down, how can the work process be free??? Nowassume that all the other users can login except one, thenthere is no question of server going down as all the others are logdin and are working fine.

How can we see system logs os SAP at OS level?

Ans: syslog folder in the sap directory usr/sap/sid/dvegms/syslog.

How can users be transported between different clients?

Ans: Goto T-code SCC1

2. Choose the Source client from where the Users to be transferred to other client

3. Chose the SAP_USR profile

4. Transport request NO. is generated

5. Release the Transport request and export

6. Import the transport request into target system

Which java tools can be used for installation of Java patches?

Ans: JSPM is used for installation of java stacks, java support packs, new components, JSPM patches and BP's.

Describe the various types of transport request?

Ans: Customizing requestABAP workbench,Transport of copies,Relocation

simple transport request is taking so much time to get impoted.what will you do?

Ans: There are lot of reason, why simple transport request is taking so much time to get impoted .The common one is Once We will trigger the request, in backend batch Job RDDIMPDP will also trigger same time. If all the batch WP are in running/Hold Mode then also a simple transport request will take long time. Once RDDIMPDP job will complete then the respective transport request will execute successfully. If the all the batch WP are in running mode for a long time , we can monitor the batch WP status & in case of urgency we can convert the some DIA WP to BATCH & after execution , the default setting will be restored back.

Other one is TP program (Hang).

while applying patches with jspm java engine restarts while the jspm is still running.how?

Ans: jaspm is a tool it is not related to the system whther system is up or down.

while using jspm /sdm the user is locked.what will you do?

Ans: for dual stack systems you can unlock the user from ABAP tcode  SU01.

for Java only systems follow Note 669848:

- open configtool

- goto Global server config > Services > com.sap.security.core.ume.services

-

Property : ume.superadmin.activated

Value :true

This activates the SAP* user.

Property : ume.superadmin.password

Value:

Enter any password of your choice. This defines the password for the SAP* user.

- restart AS Java

- SAP* is activated and all other users are deactivated

where do you see the transport logs?

Ans: you can see the logs in  /usr/sap/trans/logs

in Os level

Or

use t-code se03, and se01. when transporting is failed see the t-code stms u can see the log

what is the monitoring tool you're using?

Ans : use t-code rz20 or t-code ssaa

How often u do the SSO Cofiguration...

Ans: SSO, SINGLE SIGN ON,IS A ONE TIME ACTIVITY.

what do you do with solution manager in an R/3 support project?

Ans: With help of maintenance optimizer of solution manager we can download support packages and enhancement packages. We can generate Early watch report for performance monitoring.

what are the pre-requisites for java stack upgradation in bulk?and which EP components you have to upgrade first?

Ans: You r applying Java patch in Bulk so use JSPM.

SDM is used to apply java patch one by one not in Bulk.some prerequisites for applying java patches through JSPM(as you want to apply java stack in bulk)is

1.Make sure you having Admin Rights.

2. Don't do any modification or change in dir or subdir of

kernal /usr/sap//SYS/exe/run and

profile /usr/sap//SYS/profile otherwise it will not recognized the Kernal and profile dir .

3.JSPM use SDM to apply java patch so no other thing is connected with SDM.

what is the purpose of parameters tab in su01?

Ans:

The frequently keyd data can be stored by using parameter.

for Eg: If you are running Va01,in its initial screen you need to put all field value every day like sale org,distribution channel,sales area etc.We can reduce this hectic job by storing the parameter value in SU01--> parameter tab for that particular user.

Enter Pid and value there and save.from next time onwards if the user hits Va01 he will get all the values automatically coming in initial screen.similar like "variant".

what is the use of tcode pfud?what is it's advantage

Ans: PFUD is used to compare User Master data.It is used to ensure that valid authorization profiles arecontained in user master record. we need to run

PFCG_TIME_DEPENDENCY as a background job periodically.

what is the difference between user buffer and table buffer?

Ans: Table buffer : The table buffer exists between the database and the application server. It caches on the application server so it can reduce the workload on the application server.

User buffer: When a user login to the system, the database creates a buffer with the user authorization. This is called as user buffer

when user sends su53 report how do you which of his roles you need to modify?

Ans : steps:Goto SUIM-->roles by complex selection criteriaEnter the authorization object name in object field:enter those auth fields with values that are showing on red shadow in SU53 report.

click on execute this will show all the available roles that are holding the missing authorizatin.

It's a best practice to see if there is already role available or not before modifying a role.

----------------------

Role modification:

First see if the access[tcodes] belongs to which functioanl module/area then reach out to relevant Business Process Owner and ask them which parent role to modify.After they suggest /approve you can go ahead and modify the role.

If you don't have authorization for executing suim tcode,how do you get user reports?can you access usr* tables in se16 without authorizations for suim?

Ans: If you are not having access to SUIM code then it is highly impossible to gather information for a particular User unless you are master in SAP,for this you will have to know about backdoor entries and in the same way try to access T code:OY20,OY21,OY22,OY24,OY25,OY27,OY28;Usually these T codes are not known to your Administrator and they are not Locked try to access these codes and gather Information related to User this is called as Backdoor entry to access

User reports.

of the two client copy methods remote and export-import which method lets you copy to different r/3 version? which method requires both systems to be on same support pack level?

Ans:both the method requires same r/3 version+ patch level

if a user says he couldn't print more than 312 records,what will you do?

Ans: check SPAD setting for user and check spool queue if it is full then you may need to delete old spool request via t-code sp01 or sp02.

if somebody changes printer configuration or say,deletes printer,how do you find who did it?

Ans: Unless, log was enabled, there was no precise way of

finding the user details who deleted the printer in SAP.

But you can shortlist the users by below steps:

1. Look for system log when the printer was deleted.

2. Run STAT transaction for that time/date, and see who

executed the SPAD transaction in SAP

You can be reasonably sure that one of the users listed

executed the delete. Usually only few people in Basis team

will have transaction access to SPAD, and so should not be

hard to pinpoint.

However one thing you should be highly cautious about

is 'the information with you is not 100% system provided,

and include some guess work like pin pointing the user with

in this shortlisted users'.

where can you do user maintenance for a java engine?   

Ans: The User Management Engine (UME) provides a centralized user management for all Java applications and can be configured to work with user management data from multiple data sources.

is a transport route bidirectional?can you transport requests generated during client copy(scc8)from production to dev?

Ans: Transport route is not bidirctional,because in STMS transport route configuration is always from DEV to PRD not vice versa.

how do you lock users if CUA is configured?

Ans: We can lock/unlock users in either central system or target system, depending onconfiguration. You can configure lock/ unlock in CUA system with the following option:

1. Lock/unlock only in central system

2. Lock/unlock only in client system

3. Lock/unlock in both systems

during client export(scc8),what type of requests are created,customizing or workbench?

Ans: KO: this file is for client-independent data

KT: this file is for client-specific data

KX: this file is SAPscript texts

a user says he couldn't login.his account isn't locked,not expired,no network issues.what will you do?

Ans: First ask the user what the exact error message is.And at what step is the error message coming?

how to change the owner of a file in unix?

Ans: by using chown user:group filename

how to check if your r/3 system is 32bit or 64bit?

Ans: To check if your R/3 system is 32bit or 64bit you can get

it by executing "disp+work" file which is part of your

kernel in /sapmnt//exe. Just follow the following step:

su - adm

cd /sapmnt//exe

disp+work

When you execute this file it will give the output which

will contain the following line.

disp+work information

--------------------

kernel release                640

kernel make variant           640_EX2

compiled on                   AIX 2 5 00029F1AD300

compiled for                  64 BIT

compilation mode              Non-Unicode

compile time                  May 31 2009 22:26:33

update level                  0

patch number                  286

source id                     0.286

You can see in the above lines stating "Complier for

64bit". Incase of 32bit it will show 32bit.

how to know if there are expensive sql statements running?what will you do then to improve the response time?

Ans: You can check your Early watch report which gives the list of expensive SQL statement.

we do uncar support packs into trans/eps/in before applying them through spam to r/3 ecc6.do we need to uncar support stacks while we do abap and java stack upgradations through jspm to nw2004?

Ans: First of all you cannot apply support pack for ABAP using JSPM. JSPM is used only for JAVA support packs. For ABAP support pack you can use tcode SPAM.Secondly for applying JAVA support pack you do not need to uncar any JAVA support pack. You just need to copy the files as it is in the /usr/sap/trans/EPS/in folder and apply them using JSPM. But in case of ABAP support pack you

need to uncar all the support pack and then apply them using tcode SPAM.

I am doing a client copy with sap_user profile in a cua environment.but the cua doesn't let the user master data be over written in the target client.what to do?

Ans: go to scc4 edit the client

change cross-client object changes allowed,and protection level 0

Difference between mount point and file system?

Ans: file systems will be created on mount point

What do will do in OS level monitoring?

Ans: To check the High I/O utilization

sar -d 5 5

in HPUX, execute the glance command it invoke GUI and monitor the resouce utilziation( CPU, DISK and SWAP)top command to check with processes consumes more cpu resource netstat, vmstat, iostat, uptime,

                                                                                   

what is the difference between db01 locks and sm12 locks?

Ans: DB01 show Databses locks and deadlocks

where as SM12 deals with SAP level locks.

I've performed table space adjustment while doing a client copy in production system.do i need to do that table space adjustment in my disaster recovery system as well?

Ans:

no, you dont require to do adjustment again.

The attributes has been already default set  and one thing u have observe that u are not allow to develop  any kind of customizing in production system because it is  set to not modifiable  and it is for end users only .....

Where will you defind logon balancing, how would define and what strategy will you use?

Ans: use SMLG to define logon load-balancing.

Grouping of App servers should be based on Application area (HR/FICO/SD) to optimise the server resources according to usage of these work groups.

E.g. to avoid cases where buffers of HR objects gets replaced by FICO and this leads to performance issues for both HR & FICO users, if both users are on same server.

What happens if you restart the system, will you loose the trace file, or can you see?

Ans: The files are lost you cannot retrive the same once restarted.

The trace files are not lost on restart.

It is further to configure the size and number of files with the following parameters:

rstr/filename

rstr/max_filesize_MB

rstr/max_files

After client copy is table space and database sizes will be increased or not?

Ans: Yes.DB Size & Tablespace size will definitely increase after

client copy.

How to configure TMS/? Step by step pprocess?

Ans: To configure TMS, first go to SE06 to perform post

installation activities.

Go for the transaction STMS. It will ask you to choose the

Domain system. Give the details of the Domain system and

save it. Then click on other configuration and give the

details of the other two systems one after the other and

save it.

Now check the connection and Directories using,

Configuration--> check--> Connection and Directories.

After that, go to Extras--> Transport Routes. Go to change

mode and click on Standerd Configuration. Give the name of

the landscape and click on Distribute and Activate.

what is the difference between spam /saint , how can you apply patches through saint ,suppose you applied sapkb62067 u r manger asked reduce the some 51 level how u will you do that?

Ans: Spam are used to import support packages and saint is used to install Plug-ins and add-ons.

how u apply OSS note how you roll back?

Ans: select the note number than go to Sap note click on Reset SAP note implementation.

What are the pre requisites to download patches from marketplace ?

Ans: ensure that you have enough space in usr\sap\trans

and database also.

ensure that spam/saint tool is updated or not

ensure that tp,sapcar and r3trans updated or not

how to delete the client from os leve l?

Ans: Client from OS level can be removed through ADS (Active Directory Services),User Manager For Domains and Users.

Archive Strcuk?

Ans: when u r ORARCH dircetory full no user to be login what we will do i take the backup and delete orarch directory ur system works fine

who is the owner of system files?

Ans: adm

what is SAPMNT?

Ans: SAPMNT is the sharable name of folder /usr/sap. IT containsthe global parameters like profiles, global,exe and local (specific to instance) parameters like work,data,logs.It also contains the trans directory which is used by allthe systems in transport group.

How u will assign Logon Groups?where u find logo.ini

Ans: SMLG and logon.ini windows folder

what is the purpose of Logon groups? expalin me briefly ?

Ans: 1)LOad Balancing

2)Seurity purpose(with out logon group end user will see the I.P address) with logon group(NO Visinility)Logon load distribution  allows you dynamically distribute  the sap users to application instances.

Why we need to configure Develpment system as Domain controller? and can we transport requests from PRD to dev ?

Ans: We can create domain controller as any of the systems(i.e DEV,QAS or PRD).But, Generally we maintain all the change request in DEV and we don't do any changes in PRD Systems.

Or

NO you cannot transport requests from PRD to DEV because Landscape is desingend based on single directional means DEV-QAS-PRD not from reverse.

a transport is imported into QAS in 2 minutes time.the same transport when imported into prd is taking more than 20minutes.why?and what to do?

Ans: One reason for the above issue could be that the QA system has been defined as domain controller and since /usr/sap/trans is there in the local system so the time it takes to transport in QA is very less and since in case of PRD it has to travel over network it will take more time. You can check you network also if incase there is any issue.

Advantage of central instance on application server

Ans: Application server throw all instance connaced,application server to connected to GUI.

Apart from Update WP,which WP can also perform update in Database?? When we give print request, which WP comes into the picture??

Ans: Regards update Dialog WP will update temp tables of respective wp and lock the table by inheriting lock from enquie, after that Update will update Main data base,Comes to your quesition All database main updated will be done by Update only.

When we give print request, dialog will update spool tables

i.e TST01 and TST03,

Then Spool wp willcomes to the picture..

are any other tools other than SAP used to manage transport ? if so please provide details?

Ans: Revtrac--many in the market

At OS level in which directory Oracle alerts are stored?

Ans:oracle//saptrace/background/alert..log

Buffer monitoring?

Ans: The buffer monitoring is for analyzing, tuning the size and quality of the SAP buffers.

Can anyone tell me what is Server and Instance in sap,wat is exact meaning of that?

Ans: In plain terms 'Server' means a object/componenet that services request.

Instance in SAP

=================

An Instance in SAP is a combination of Application Server &

Database Server i.e.

When you use the SAP GUI to connect to the Application

Server, the application server in turn communicates to the database server to service your requests.

The entire Instance is divided into subcomponents

(Application server, Database server) so that the

complexity is reduced, maintenance & deployement becomes easy. The above are some of the advantages, to understand what it all means hou have to get hold of some material that dwelves on 'Client-Server' Architecture.

Can I configure STMS on a single system on windows 2003 server if so what are the prerequisite. why I am getting the error "tp distribution failed"

Ans: yes you can configure the STMS in a single system.

prerequisite are

1. make the system as a Domain Controller were you are

going to configure STMS.

2. Create 2 Virtual System and name it. eg:- Server1 &

Server2.

3. Assign the Transport Routes.

4. Create 3 system landscape.

follow these steps you wont get errors

can i delete any record from table. if yes, what is Tcode for display table?

Ans: In production system you can not. it generate inconsistancy in database. T-code is SE16.

can i know the relation between sap security and Grc tools?

Ans: I think GRC tool is SAP tool mainly for the end user.User administration is main advantage of that.

As user have to request to get access for particular roles and have to mention the roles in request.GRC is mapped with SAP system and roles are assigned to user in SAP.

Adavantage is that no need to login to SAP system and create(assign roles)user.

can we prepare a landscape with ides systems?

Ans: yes. It is like a Production copy like design.

Diff between local client copy and remote client copy?

Ans: Local Client copy mean Client copy in same server mean you copy Quality to quality and remote client copy mean one server to other server mean Production server to Quality server for local Client copy use SCCL Transaction Code and

Remote client copy use SCC9, for Local client copy no RFC Connection req. for Remote client copy RFC Connection require.

                                                   

Difference between adding a data file and resizing the data file?

Ans: Adding a new datafile to the existingTablespace

Resizing the datafile means changing the size of the existing datafile

Explain Client Compare and Maintenance Tools available in SAP?

Ans: To use the compare function, from the SAP systems initial

screen, choose transaction SCU0. The compare function

enables you to compare and adjust the contents of a table or

view in two different clients, using RFC connections. This

is especially useful after an upgrade or language import.

The objects that can be adjusted are some of the tables and

views that can be maintained using transaction SM30. All

other objects can only be compared.

Set client option: Protection level : 2

No overwriting, no external availability

All production clients should use this setting.

Explain layers and instances with explain???

Ans: A SAP Instance is all the components created by the sapinst

program who all share the same database.

There are three sub-Instance.

1. Database Instance.

2. Central Instance.

3. Diaglog Instance.

Sap works on Three layers.

1. Presentation Layer. Ex.-WinXp

2. Application Layper. Ex.-Sap Ecc 6.0

3. Database Layer.     Ex.-Oracale, MSSQL

Explain the method of making client copy, how can we do it when the SAP user is not there in the system?

Ans: Client Copy is possible only if the client is 000 and User is created under 000 client and if user is from someother client other than 000 ie:001 to 999 then client copy is not possible as 000 stores Master data and other than 000 are all copy clients so it is possible only with 000 client and the user should be created in 000 client if SAP User is not there then one can do with SAP* or DDIC.SCC4 is the T code for creating Client Copy.

For example, my sap system having patch number was 8.I want to apply patch 9 and 10.Mistakenly I will apply the patch directly 11 without applying 9 and 10.How sap system will recognize this problem?

Ans: patches apply oneby one only , u cannot skip patch order

Ex : uhave 10 level ,,u want to apply 13 level it will read internally 11, 12 after that only it will take 13 level

i hava a question, i have to assign sm36,3m37,su01 has to assign to a user with only options (display ,create).how can ia assign this to user? need quick reply......

Ans: here create one profile and assign sm36,sm37 and su01 in the menu tab, then goto to authorization tab, search for "Actvt" in authorization filed, after search results,

now remove all activities except 01(create or generate) & 08(display). and save the profile and assign to required user.you can follow this for any kind of this ..

generally what types of security problem you will get ?

Ans: 1.user date expire 2.t-code not authorized 3.organization level not maintain 4.user do't have authorizsation.

Hai which kernel version, and patch version and now in real time we need to apply? ie means which version is now running on real time?

Ans: The kernel version which we are running in real time is 700.Upgrade or else 700 is good enough.

How to take back up to local disk . And also tell me where i need to change the parameters to take back up , please give me the list of parameters and appropriate values. Please provide me the steps to take back up.......

Ans: If it is a Widnows system u need to

go /oracle/Version/database. then u will find ora.ora

ora.sap. u have to open these files and do change

appropriate place. backup device,type etc. after that it

will save data to Hard disk.

the How to monitor EP and what type of T-codes are using in this EP

Ans: its not an abap stack

its an java stack only web acess there is no tcode

http:\\systemname:500\nwa

Please tell me what kind of testing USUALLY done against CRM application?

Ans: In SAP ERP or CRM once SAP is installed is one can check

whether the SAP Installation was Successful or not and to

check for application testing one should make use of Tcode

SICK or SM04 to check installation was successful

How can one send and receive emails in SAP what is the procedure to send and receive emails through SAP Application a brief description?

Ans: goto txn. "scot"  to configure the emails

goto "Internet" "smtp"

put email server in "description"

tick on "node in use"

fill in "localhost"

than click on internet box "set"

add ur email address in "address area"

now go to txn. "su01" select user which needs to use email

and add the email address in appropriate field.

now u are ready to use ur email.

go to txn. "sbwp"

Enjoy ur work with configured email

How can one start Sap Application Server through Command prompt and what is the command used to start SAP Application Server ?

Ans: below procedure is for linux os,

first u need to login as ora,

then type : sqlplus "/as sysdba",

so now u r in sql.

now give command "startup", then exit oracle,

now enter into listner through command

"lsnrctl" and start with command "start" and now you need

to start sap with command "startsap"..so automatically sap

will start then you can check work process with dpcon command.

Note: for Windows this procedure wont applied .

how can u change the location of control files of oracle in sap?

Ans: 1. Shutdown the databse

2. Copy the control file to the new location

3. Adjust the changes in your ini.ora ( spfile asapplicable) the parameter CONTROL_FILES

4. Bring back the database

how can u do kernal upgrade in dual stack?

Ans: 1. uncar the car or sar file.

2. stop all services.

3. replace that exe folder in shared profile location of the sap system.

4. start the sap system.

how can we transport customize request? pls give me some step.

Ans: to do any sort of customization work you need to create a development package or a development class, while creating it with the help of object navigator (SE80), or with the help of Package Builder(SE21), you create a request number.

All your customization work is supposed to be saved in this package. After all you work is done, now comes the actual transport task.

Go to the Transport organizer(SE01), Click on the create transport request (F6), after this select relocation of complete package, and then give your package name and you request number, This request is generated but is still there in you source system. Now in the same transaction go the the tab Transports, and then click on Display button.

Here you can see all the request that has been sent for transport but are still there with the source system. The request you generated would be here as well, click on the plus sign and you would see the change request, click on that and then click on the transport button on the top (The red truck button on the application toolbar), After this,

go to the target system, login to it, and provided you have appropriate authentication (S_CTS_ADMI authorization profile) type STMS_IMPORT transaction code, click on the refresh system button, select your request number and then click on the button Import request (Again a truck but not red) the import would be carried out.

How do you configure the TMS?

Ans: STMS is the t-code for configuring the TMS.

1.first you need to configure domain and u need to add other system to domain controller system.

How do you configure transport profile?

Ans: how to configure the transport Route is the right question ..i think ...

How do you do the "SIZING OF AN APPLICATION SERVER" ?

Ans: Sizing is determining the hardware requirements. It can be

done in two ways.

       (i) User based sizing

       (ii) Throughput based sizing

It can be done using the tool quick sizer.

How do you do the load balancing?

Ans: SMLG is the transaction code to use Logon Load BalancingBefore that you need to install Dialogue instances and then create a group.

How do you do the transports?

Ans: you do the transport by releasing the change request from the DEV using SE01/SE09/SE10 T-Codes.

how do you troubleshoot when user complains that he is not getting login screen?

Ans: First check if all the services are running both sap and database

If yes then check for if sll the workprocess are used that you can do by dpmon pf=" "

You have to also check if any file system is full

how many max application server we created in company. last limitation pls tell me in figure?

Ans: You can create 100 application servers per system, like the

number from 00 to 99.

how many max user's can apply for one application server? last limitation pls tell me in figure.

Ans: That is deepens on your Hardware capacity there is no

limit,If u don’t have logon group

How many types of log file in Oracle ?

Ans:Archive logs redo logs

Online Redo logs,Offline redo logs

Alert logs -> check the oracle system logs

How the buffers are reset?

How to change SID?

Ans: SID stands for System Identifier.

It is not possible to change the SID of SAP System.

How to Check From SAP Level and OS level, that your system is DUAL STACK or SINGLE STACK???

Ans: Check your Instance profile in RZ10 for parameters starting with jstartup/xxxxx, which means the systems is double stack (ABAP + JAVA).

How to check how many users have logged in one perticular system e.g say production with their login timing and IP address .. If possible Plz also see is there any option using which we can also find that datewise ?

Ans:AL08

how to check network among Central Instance, Application Server, Database Instance?

Ans: transaction st06  ---> detail analysis menu --> lan check by ping

how to configure JCO Rfc connection and waht is the use of jco rfc?

Ans: JCO Rfc Connection is used for comminication between ABAP and JAVA stack. WE configure it using Visual Admin.

how to connect external mail server to sap?

Ans: To connect to Mail Server with the help of T Code SO01,this code is used both for configuring mail server and to connect to mail Server .

HOW TO CREATE TRANSPORT GROUP?

Ans: STMS.

how to delete a table in sap?

Ans: Goto t-code se14 or se16 enter the table name

select and delete it.

how to export and import client between two systems?

Ans: 1 SCC8 is used to export client in the form of transport requests.

2 Import transport requests

3 After Import is complete perform "post processing steps" from client tool (SCC7)

How to increase swap memory without doing any changes to Parameter value?

Ans: Yes, it can be done by right clicking my computer properties click advanced-->Performance settings-->advanced-->Virtual memory change--> enter paging file size as based on your memory of your system.

How to increase tables space, resizing, backups and in what situation are these done?

Ans: Brtools are use to prefome all the database related task in sap .always use adm or ora user to access brtools .

how to increase the table space?what are the methods to do that?

Ans: login @OS as a ora == Using BRTOOLS -> 2. Space Management -> 1. extend Tablespace -> here select 3. option to enter tablespace name in which you want to add space ->than continue 2 times -> here check and change all theinputs which you required -> than continue 2 times it will be added space in tablespace.

How to kill a background job which is not showing any pid in sm50

Ans: PID is given by the operating system ,so go to command promt execute the dpmon command there you will find process id cancel the btc process by identifying PID at os level.Note:Dont delete the BTc directly it makes the inconsistence in thedata base.

how to know the port number of message server?

Ans: go to etc/services

there u find  seervice sapms

How to selftest whether the Sap Application Server is installed properly or not through command prompt?what is the command to selftest ?

Ans:SICK.

How to set the trace level for file dev_rd?

Ans: T-CODE SE38-> RSPFPAR->rdisp/TRACE_LOGGING should be ON

to change the valuse goto RZ11 or directly goto RZ11 Dynamic

parameter change.

It'll invoke tracing for

GATEWAY trace: dev_rd

Workprocess trace: dev_w*

Dispatcher trace: dev_disp

Message server trace: dev_ms

ICM Trace: dev_icm

How to Upload and Downloading of roles?

Ans: its very simple to upload and downloading roles.

just execute PFCG --> goto -> file --> select upload or

download option as per your requirement.

how will you delete the spool datas without using rspo0041(tell all the other method}

Ans: Run report rspo1041 or Use T code SPAD- click on Admin-delete spool files.

i cant find the user TMSADM in my system after the tms single system configuration.can any one tell me the reason

Ans: you have to perform post installation activities by using t-code se06

I have all the authorizations but still unable to do client export what may b the cause..............?

Ans: May be TMS is not configured.

Configure TMS and do the client export by using SCC8.Import into the target, by using SCC7.

For Client export, TMS configuration is mandatory.

I want to find all non executed transaction list (user wise) for last three months one option is through st03n but in that i have to find by each and every t-code there is any facility to get this list user wise?

Ans:we will use SM59 for creating and maintaining RFC connection only.you can use STAD to get the list of transaction done by any user.

if 100 users are accessing perticular table how to know the users who are acessing table?

Ans: use the t-code sm12--give the table name,Lockargument as * and user as * click on  list

If a background job runs more than the time it should be completed normally then what action will u take ?

Ans: 1. Check the system (if u have any dedicated application server for background jobs check the particular application server Status and response time and os logs) response time.

2. If there is no enough background process to execute that background job increases the background process if u have enough background process then check the network speed and network response.

IF Import one request from Dev to Qua through STMS_IMPORT but after some time stms_import is still running and I dont no what is happening in behind so what will be my trace point.

Ans: See the import log and check whether there is some new activity mentioned in import log.

You can also check in RDD* jobs in SAP. In case some job is canceled , you can reschedule.

In case nothing is going on from several hours then import is hanged. you can check status of import through table TRBAT and TRJOB

if java instance stop or failed so what action you will take?

Ans: check the startup logs

Dev_jcontrol etc.. see the error and solve it

if saposcol service is not start? how can u troubleshoot?

Ans: Saposcol is a collector and stands for SAP Operating System

Collector.To check whether if saposcol is running one check

through TCode "SMX" ,One can start saposcol through the

below path :

c:/USR/SAP/SID/SYS/EXE> Type saposcol -d and can start the

SAPOSCOL on system file or on particular file.

Once saposcol is started it starts collecting information for Operating System.

If sechuduled backup through db13, but it is not triggered?

Ans: Programs scheduled via DB13 can be executed on different background servers (source hosts) depending on the system status and the current load distribution.Under certain circumstances, server-dependent analyses (such as the parameter value for SAPDBHOST or privileges for RSH connections) must therefore be carried out on every possible source host.  For more information, see Notes 10403 and

118057 also.

If the server buffer memory reaches 95% of memory what will will be the measure have to take for solve that issue.

Ans: it depends upon the no.of application servers u have in ur prd,you may solve this issue with Logon load balancing using the tcode smlg. if it repeatedly accuring and u have enough memory u may increase the abap/buffersize parameter but prefered id do logon load balancing so that it may not

Repeat.

If you are DEPLOY and UNDEPLOY java patch through SDM so why you need JSPM?

Ans: by using jspm we can do kernal upgrade and we can apply support package stacks and we can install addon components(BI java to existing ep system).we can connect to nwdi also if there are dev,qas,prod systems configured usingnwdi.we can't do these in sdm.and one more advantage with jspm is we can't undeploy.during undeployment dependent packages also may removed some times which causesinconsistencies in the system.so sdm is depricated from netweaver 7.10 on wards.

i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?

Ans: yes, it will effect to your child role by clicking Pushing button in master role.

No in child role we can't assigne any tcode but we can maintain our Org lee, Values.

In ECC6 can we change the number of dialog workprocesses without restarting the system and with out using operation modes?

Ans: No, we can not because of the two condition

included.

1]with out restart--> bar the use of parameter[RZ10]

2]With out OP Mode--> bar the use of RZ04

In sm51 screen what are the possibilities for status field? If the status is active then we can double click on the instance name to goto it's work process over view screen(sm50). but if the application server is down,will it still be displayed in the sm51 screen with status shutdown?if so,what happens if we double click on an instance name with status shutdown>will it still goto sm50 screen?what would be the workprocess status then?

Ans: If an application server is down then it will not be displayed in sm51 screen.

Is BRTOOLS add on or does it come with SAP installation?

Ans: comes with sap installation.

Is SAP is used as a database or not?

Ans: SAP is a R3 Application.It cannot be used as a Database but database we can use in SAP.Example Oracle.

Kernel upgrade steps in dual stack and java stack.

Ans: Kernel upgrade :

For Dual stack:

1)from service market place,you have to download the .sar

files.there will be a total of 3 files having following

format :

SAPEXE_-.SAR - database

independent file

SAPEXEDB_-.SAR - database

dependent file.

there will be a database library also aong with this file.

Once you have downloaded all the files, you have to uncar

them using below command:

sapcar -xvf .

Uncar all the files in a temporary folder.

Now stop sap,DB,all services.

then take a backup of the run folder where kernel resides.

Now copy all the recent files from the temp folder that you

have extracted.

Again start DB,SAP, and all services.

Now check if your kernel is patched.

In case the system doesn't comes up we can again use the

backup kernel folder.

In case of java stack there is no kernel upgrade done

seperately.it is done along with SP upgrade via jspm.

Lets suppose we have 500 users in sap system 250 members are already logged into the system and rest of the 250 are unable to login along with master users like sap* etc. How do you troubleshoot this issue ?

Ans: The login procedure always depends on Ram Size and each dialog WP can switch to 8 login at a time .If the Ram size is 512 MB then we could seeatleast 8 dialog WP and it can accomodate atleast 60 logins at a time in one instance with same User credentials all over the Network and usually when coming to SAP the Ram size will be in TeraBytes and not less than that in Corporate organizations which shoudl not cause any difficulty .

Minimum number of dialogue work process to start SAP and why?

Ans: By default there are atleast 2 dialog work process and each

dialog work process can with held 8 logins at a time to connect to SAP Application server at a time and it also depends on Ram size if the Ram size is 512 MB then it can

accomodate around 8 logins at a time.

Name of the ABAP program to delete background jobs?

Ans: RSBTCDEL-

It deletes finished or cancelled jobs

once a request is imported,is there any way to undo it? how about version management?

Ans: No we can't undo it if it gives any error we can transport the correction request and again retransport it.

Version management is used for transport of

table,report,programs for checking if the previous version is transported or not else the current version gives error in the target client.

One dispatcher per application server. Is above statement correct or we can have more than one dispatcher per application server?

Ans: The above Statement correct  but cannot have more than one dispatcher in an application Server.

Each application server can have only one dispatch server.

sapcar -xvf " in this command what is '-xvf'stands for.

Ans: I am not pretty sure about this, would recommend you to

cross check this, I think that

x- stands for extract

v- stands for Verbose mode,

f- stands for forcefull

sm21 shows the system log for the application server you're currently logged on.I want to see the system logs of all appliction servers.what to do?

Ans: sm21-->systemlog-->choose all remote system logs will give you all system's logs with that system.

Table space creation?

Ans: You can extend the Table Space by using the BRTOOLS.

Tell about dbrefresh?

Ans: Db refresh, in SAP basis practice is considered ashomogeneous system copy. We restore backup on other system(Say it Test) to refresh the test system data with

production. after restoring, we change the key setting setting to adopt it as original system with refreshed data of other system ( Production)and make sure to delete /clean up the sensitive production data and running logical system conversion and adopting original rfc connections.

he end user was facing performance problems.how can u trouble shoot this?

Ans: based on situation and error,we have to check.first we check sm50 for any report is running for along period of time.check st02 for buffer hit ratio.sm37 background jobs.db13 and db12 for checking backup status running or fail.sm21 and st22 for system logs and abap dumps. we have to check all this t-codes.

The Users are not able to save the data, as a BASIS ADMIN me to not able to save, what is the problem would be..?

There is a requirement like a user role to be created and he must have rights to view(read rights) the transactions.How it will be created in PFCG

Ans: ->excecute transaction su53 and note down the avtivity.

->ecxecute tarnsaction pfcg.

->click on change authorization data tab.

->click on utilities menu-with technical names ON

->then expand respective authorisation obj.

->double click on Avtivities.

->select respective activities.

->save the profile

->generate the profile.

->move back and click user tab and do user comparision

user says yesterday they could use some transaction where as today they are not what will you do ?

Ans: 1.check user expire date

2.check user buffer

3.if role contains more authorization user buffer full we cant logon

3.check what type of user like service, ref, or licence of validity

WAHT IS SOX , SOD ,TOOLS?

Ans: SOX--> Serbane Oxley Act..it is the Metric of us Security method. now in india also following.

as per sox no one can have more than one authority in the organization.

SOD: Segregarion of Duties / Separation of duties.

Tools: Plz let me know in which sence you are aksing abt tools.

what are activities u will do when long running bkg jobs?

Ans: If you find a long running Bkg Jobs running first thing is to goto Tcode "SMX" and if you feel it is taking long time one can cancel jobs to overcome this issue and can schedule at other time.

Usually the scenario of Bkg jobs are sceduled in Night time due to many Dialog work process running during day time.

What are the .sca files and their importance?

Ans: sca stands for SAP Component Archive.

or .sda for SAP deployed Archive

These two are same and it use to deploy the java components,

patches and other java developments in the form of .sca,.sda, .war and .jar.

what are the activity you have done by using solution manager? please explain briefly some activity?

Ans: Using the solution Mnager you can configure the Early watch alert, you can maintain the SLD, you can also configure the MOPZ (Maintanence optimizer) and can also cofigure Help desk for the end users.

What are the differences between application server and central instance?

Ans: In central instance we have the messenging server the msg server is responsible to communicate with the database,in application server there will be dispathcher who is responsible for appl server to central instance

communication.

what are the jspm related logs that you see at os level at the time of java stack upgradation?

Ans: JSPM_MAIN.LOG

SCAN_INBOX.LOG

DETECT_SYSTEM_PARAMETERS.LOG

DETECT_SYSTEM_COMPONENTS.LOG

ENGINE_OPERATION.LOG

EXCHANGE_KERNEL_BINARIES.LOG

EXCHANGE_IGS_BINARIES.LOG

what are the logs that you can access at os level?and their paths?(like system log,batch job logs,spool logs,transport logs,support pack related logs,etc..)?

Ans:All the system logs reside in the directory

\usr\sap\\dvebmgs\work directory. but it is alwaysrecomended to use at sap level st22 and st21 transactions to view logs.

what are the prerequisite for before applying support packs? Shall I apply sap basis patch to all the system, like BW, ABAP, HR, etc?

Ans: Check Table Space,check SPAM/SAINT Lavel update,Requred Supprot Pack Effect studay,and Proper Downtime because after appling support packages SGEN run.

What are the Prerequisite for Refresh?? If there are 100 rfc before refresh in Quality Systesm, then after refresh..do we need to create them manually in Quality sys.???

Ans: Pre requisites of db refresh:

1.Take valid backup of target system either full offline or

online

2.Set the system message using SM02

3.Verify file system sizes usig command " df -k ".

4.Save sap license using  " saplicense -show "

or "slicense" tcode

5.Stop all sheduled jobs using command "crontab -e" or

tcode sm37 .

6.Save the database calender using DB13

7.Save OP modes using RZ04

8.Save logon groups using SMLG.

9.Save RFC groups using RZ12

10.Save logical systems using BD54 or sale (tables TBDLS

adn TBDLST)

11.Make a note or take screen shots of TMS settings(Save

the System overview screen,Save the Transport Routes

screen,Save the Import overview screen)

12 Save the client settings using SCC$ or T000.

13.Save RFC destinations using SM59 (RFC destination table

RFCDES)

14.Export output devices using SPAD (goto --> utilities-for

o/p devices -export devices)

15.Make a note of SMTP configuration

16.Save last transport request using E070L table

17.Save distributing model using BD64(select the model--

>choose edit-->model view--> transport )

18.Export usermaster and profile (sap_user).

19.Save the TBTCS talble( background tables ).

what are the problems usually occurs during the transport and return codes ?

Ans:0→successfully completed

4→ended with warnings

8→ Ended with errors (should be reported to ABAPers)

12 & above→ended with errors (taken care by Basis admin).

what are the semaphore numbers you faced in sm50?what did you do?

Ans:

What are the transport routes?

Ans:   1.consolidated route between DEV and QUA

               2.Delivary route between QUA and PRD

These are two tranport Routes in SAP STMS systems..

What happens when there 2 enqueue in R/3 system ?

Ans: Enqueue service can be more than one...it depends on the users and load on the DB/CI/APP.

There will be no issue if more than one enque

What is a Domain Controller?

Ans: The transport domain contains all SAP systems whose transports are to be administrated jointly. One of these SAP systems is chosen as the transport domain controller.Since all activities relevant to the entire transport domain, such as configuring transport routes or RFC connections, can only be carried out on the domain controller, the SAP system selected to be the domain controller should have:High availability,

A high level of security

A high level of maintenance.

what is client copy?

Ans: Client Copy is nothing but creating your own client by copying form standard Template '000', you also can copy client from your existing client.

It can be done by SCCL(Local client copy) or SCC9(Remote Client Copy).

What is Data Dictionary ?

Ans: data dictionary is the metadata ie data about the data. It can be defined using DML in oracle or sql like attribute types, no of rows , no of coloumns etc.

what is different between SQL AND BRTOOLS in sap?

Ans: sql is a structured query language which is useful to do operations in database.we can execute sql commands by connecting to the database using the tools like sqlplus,isqlplus,oem(oracle enterprize manager).these tools are provided by oracle and specific to oracle.

brtools are the interactive based character user interface tools(brgui also available and btstudio(webbased also avaible))using which we can perform batabase operations by

selecting the approptiate options.by using brtools we need not have the knowledge of sql.

as per my knowledge brtools are specific to oracle.in case brtools supports other db,s like db2,informix,sapdb,sqlserver

what is front-end printing?

Ans: In Sap front-end printing defines itself as a printer configured to your own front end workstation. Means your printer is installed on you own system. Due to this it's different than local & remote printing.

what is MCOD ?

Ans: use one database server for two systems

what is meant by AT and ATX ?

Ans: Advanced technology & Advanced technology Extended.

What is organization level ?

Ans: In order to assign authorizations based on specific force elements, the system determines values for specific, organizational-level fields using Business Add-In /ISDFPS/GET_ORG_LEVELS and the closest higher-level force element to which a user is assigned.

What is OSCollector and where can one see whether OSCollector is running or not what is the path of OSCollector?

Ans: OS collector is nothing but Operating System Collector which collects the data from OS. It can be viewed is services, if SapOScol is running or not.

What is REMEDY Ticketing tool, how it works? can any body answer.?

Ans: REMEDY is a customer relationship tool which can be used to log / monitor the issues or problems faced by customers by the means of incident management tickets. Each ticket is like an incident (problem) which is created by helpdesk and

assigned to relevant support team.

Concerned support team memeber take the ownership of the ticket and updates the work log (troubleshooting steps performed during the course of action)

Also , it can be used to monitor Service Requests / change  managment ( Change Requests) and problem management.

what is role and authorisation?

Ans: Role:set of logically linked transaction codes.

Authorization : set of authorization objects called authorization.

Basically a Basis security guy will create roles and authorization objects to users.

What is sap, sap is company name or product please describe

in breife i m very confuse to take these term that sap is

product or company name?

Ans:SAP stands for System Application Products in DataProcessing .SAP is the name of Company and Application and it supports more than 140 modules.SAP has got many features related to Users,clients,Remotely calling a Function parameters, Profiles,and SAPDBA which works on Oracle platform and is more powerful .

What is SAPCPE.EXE??

Ans: Program sapcpe ensures automatic adjustment of locally installed executables, if changes have been made to the executables on the central instance.

If sapcpe finds any of the following list files in

/usr/sap//SYS/exe/ctrun, it copies only the executables listed in these files to the local

/usr/sap/

What is SAPS?

Ans: The SAP Application Performance Standard (SAPS) is a hardware-independent unit that describes the performance of a system configuration in the SAP environment. It is derived from the Sales and Distribution (SD) Benchmark, where 100 SAPS is defined as 2,000 fully business processed

order line items per hour.

What is SMTP configration?

Ans: SMTP is a Technical Term used in Networking concept and  SMTP stands for Simple Mail Transfer Protocol (SMTP).SMTP  is used to Send Emails from source to destination.When we configure Exchange Server SMTP should be enabled in

Services through which one can receive emails from source  to destination and viceversa.If SMTP is disabled in Outlook Configuration and SMTP service is enabled in Services one cannot send messages and gets an error message SMTP error.To overcome this one should make changes in configuring account and should enable SMTP Service through Outlook ------tools-------options------ and email aaccount

and can enable SMTP protocol and can send messages.SMTP protocol is used to Send messages from source to destination .

what is static profiles and dynamic profiles?

Ans: Usually in a system the info belongs to memory,CPU, kernal (Sensitive system data) we can treat as static data, and remaning we can say dynamic.so the profiles which belongs to static are called static profiles, and rest called as dynamic profiles.we need system restart if we change static profile, but in

the case of dynamic profiles we dont need restart.

Ex: if we change wp's runtime we dont need system restart.

rdisp/max_wprun_time=800; we can do this through rz10 T-

code.

this is example for dynamic.

comes to dynamic profile, if u need to change dia process

no with below prameter we need restart called as static.

rdisp/wp_no_dia=8(based on requirement).we have to do this

wih rz11.

what is the benefit of tms?

Ans: 1.Monitor all the sytem in the landscape

2.easy way to transports between the sysems in the landscap

3.better performance between the systems

4.give the quality in the production.

what is the common storage file for oracle ?

Ans: ora arch?

What is the database backup strategy?

Ans: Daily online and weekly offline backup.

Or

OS Backup full - on change+monthly - 1st SUN of the month.

Repair Disk & Disk config - on change+monthly - 1st SUN.

Database (Online) - Daily night

Transaction Log - daily twice.

what is the default file for TMS ?

Ans: domain_sid.

what is the definitions oh ROLL IN TIME,ROLL AREA, ROLL OUT TIME AND WAIT TIME?

Ans: Roll in: time taken by the process to copy the context.

Roll out: time taken by the process to copy the user information from its local memory to  buffer area.

Wait time: the amount of time d user request to allocate a process by dispatcher.

what is the differ between 4.7EE and ECC5.0?

Ans: The diffrence in between 4.7 or ECC is related mostly to Functinal point of view. from Basis related we have don'thave much changes excepts some advance usage of Trasaction code screens.

and Brtools are available both in 4.7 Extension 2, and ECC 5/6

What is the difference between installing SAP R/3 and installing a SAP CRM system? OR, what are the installation steps for i) Installing an SAP R/3 and ii) Installing SAP CRM /SAP PLM/SAP business suite?

Ans: SAP R/3 is the core package while CRM/SRM etc are Netweaver products.Installation steps are the same difference is the installation master media and configuration to certain extent.

what is the difference between logon group(tcode-smlg) and rfc group(tcode-sm59)?

Ans: Logon load distribution allows you to dynamically distribute the SAP users to application server instances. You can increase the efficiency of individual workgroups by setting up multiple logon groups that consists of one or more application instances.

RFC groups, you can control which servers can be used for parallel-processed jobs. An RFC group specifies the set of allowed servers for a particular parallel-processed job.

what is the difference between SAP R/3 and ECC?

Ans: If you are a Basis guy this might help you to explain in near futur, focusing on the underlying technical "Basis" or "NetWeaver" versions will help you stay on the right track. Technically, ECC 6.0 is 2 "technology" versions higher. Following is the terminology/version information for the last 3 ERP product versions:

SAP R/3 Enterprise (4.7x) SAP BASIS 6.20

SAP ERP 2004 SAP NetWeaver 2004 (BASIS 6.40)ECC 5.0

SAP ERP 2005 SAP NetWeaver 2004s (BASIS 7.00)ECC 6.0

The main technology feature delivered with NetWeaver is the integrated J2EE engine (Web Application Server Java).

What is the difference between Synchronous and asynchronous transports?

Ans: Dialog or batch process is blocked until import has ended in synchronous transport Dialog or batch process is released after import is started in asynchronous transport.

what is the difference between system copy and system refresh?

Ans: Systm copy and system refresh are more or less the same however for convinience purposes system copy is generally defined as creating a new database as a copy of exisitng one while refresh means copying an exisitng database onto

another exisitng database.

System copy:Building new system with a refernce system.May be a restore backup or export import.

System refresh:Copy the db from source on to the existing target.

What is the easiest way to find out if the server is production?

Ans: as per the SAP Naming conventions, the SAPSID

that ends with a 'P' is the Production server. Or else go to STMS, then go to Overview -> System, Check out which one is the production server. Or else go to the Transaction area, type in SCC4, all the clients would be listed in it, check the Company client, the one that is not by default provided by the SAP system. Check out what the client role in that is, if its production, then its surely a productive system. However, if its not production, then you SAP system may or may not be productive system.

What is the importance of early watch client?

Ans: This client is purely a service client that enables SAP to access remotely the customer system with regard to analyzing errors and performance. You must not change or delete this client.

Monitoring Service will provide Intact and your company an emailed report that displays the system status. The report is easy to read and identifies any critical system

issues in red for easy identification. The idea is to alert the user in advance to address any issues that may cause any system integrity issues.

What is the importance of the clients 000,001 and 006?

Ans: 000 is also called as Master Client or Golden client. It contains cross client data & Companies Hardware configuration, Patches, Add ons Plug ins Etc

001 is the copy of the Master Client.

066 is called as Early Watch Client. If there is any problem with the SAP system then the early watch client throws the alerts.

what is the main difference between remote client copy, and client export and import.?

Ans: remote client copy is done in the same land scape i.e it is in lan or wan,client import and emport are two different landscape.

What is the link between roles profiles and projects?

Ans: role is created,profile is generated after role,role contain authorazations and objects,profle contain combination of roles.

What is the main difference between sap and erp?

Ans:The Main Difference between SAP and ERP is SAP stands for System Application Products In Data Processing and ERP stands for Enterprise Resource Portal.SAP is an ERP package which can support upto more than 140 modules.There are other ERP packages available in market but cannot support these many modules as compared to SAP.

what is the name of the xml file that you place along with support stack at the time of java stack upgradation?

Ans: SPSTab.xml

What is the procedure to apply Patches?

What is the procedure to delete a client?

Ans: First log in the client you would like to delete with username as SAP* and password as pass if you are logging into that client for the first time. Hit the transaction code SCC5 and select the check box which says Delete entry from T000 and click on start immediately... It would ask if

it should continue, click continue and wait till it deletes the client. Once the client is deleted login to 000 Client and hit the transaction code SS4 and see if the deleted client is listed in the list or not... If it is not listed then you have successfully deleted a client.

What is the R3 system startup and shutdown process?

Ans: when start sap it will start first

1.Database server

2.Message Server.

3.Dispatcher and workprocess

4.Dialog Instances for shut down Riverse order

what is the size of ur oraarchieve directory? how can u prevent archiver stuck situation?

Ans: Every day we have to take backup of archieve logs in the archieve director. through db13 select online redologs  and –sd ,it means that the system copy the online redo logs to backup folder and delete the logs from archieve directory.go to oraarch directory and type du -sh in linux.it shows the size of directory.

What is the start up Sequence of Dual stack(ABAP+ JAVA) SAP system??

Ans: 1.database (strdbs.cmd)in abap stack and java stack

2.message service in java stack

3.enque service in java stack

4.message service in abap stack

5.icm in abap stack

6.dispatcher in abap stack .finally work processes comes to wait status.

What is the state of Processes once it is started?

Ans: when you start your R/3 instance, message server will start, then initial  processes state would be in Run then slowly all will turn into Waiting state. we can say this status as healthy.

you can monitor work processes using below T-codes.

SM50:work process over view.

SM66 Global work process overview.

what is the table space in ecc5.0 and its size?

Ans: there are only one table space in ecc5.0 and its size is of 100 GB.

what is the TEMSE size?

Ans: i think there is no limit size for temse,

temse stores spool requests and there is two types of storage locations that is defined in the parameter Rdisp/store_location=db or g

db=temse resides in database tables tst01 tst03,

g= temse resides in global directory  usr/sap/sid/sys/global temse stores request 32000 it will increase up to 99000.

what is the use of psaptemp table space?if we delete all the data files in temporary table space will oracle throws any error?

Ans: A temporary tablespace is mainly required for the intermediate storage of temporary data during certain database actions, for example:

Sorting/aggregation with CREATE INDEX, SELECT ...

DISTINCT, ORDER BY, GROUP BY, UNION, INTERSECT, MINUS (when the memory area defined using SORT_AREA_SIZE is insufficient)If data files are deleted it throws following error ORA-01652: unable to extend temp segment

What is the use of reference and service user in sap?

Ans: Reference user is used only to assign additional authorizations. you can not login by using reference user ( not dialog user) Service user is dialog user that is available to larger, anonymous gruop of users.Multiple logon are possible with service user.

what is the user group and use in sap?

Ans: User group means we are creating a group using t-code SUGR and assigning some particular users to that group. For example, creating a group for ABAPers assigning all ABAP users to that group.

what is the workbench organiser and customizing organiser in transport ?

Ans: the changes that are client specific are recorded to customizing requests.

the changes that are cross-client/repositary are recorded to work bench requests.

What is transport domain?

Ans: its a group of all systems which are managed by a single transport domain controller.

What is Transport domain and Domain controller?

Ans: Transport Domain is possible only if SAP is installed and if RFC (Remote Function Call)is configured between systems.

A system is said to be a Domain Controller if ADS is installed on a WorkGroup Computer and ADS is Integrated with DNS and whereas DNS is not Integrated with ADS.

what to do, if a workprocess is in hold status?

Ans: While debugging directly in the PRD system, thta time work process will be on hold status. double the hold process and check the info and release that process.

What types of files are created during the export?

Ans: here you have not mentioned what's exported ? ?

in a CR export/release you'll find

data file  in /trans/data directory

control file  in /trans/control directory

other log files in /trans/log directory like

ALOG,SLOG,etc...

What will you do when there is a performance issue?

Ans: There are so manyfactors we need to consolidate when a performance problem

occurs.There are several types of performance issue...it may be

overall system performance / performance issue with a

program of transaction.

Performance issue with a program of a t-code:

1)First find out it is user developed transaction/Program (Yor Z programs) or SAP parent program.

2)We need to find out how much of data the job/t-code tryingto process and ammount of time taken in previous for thesame amount of data.

3)Find out is there are any changes in the program recently(find out the recent transports moved for this progam recently)

4)Best point to start with performance issue is trace in st12.

5) if this is a problem with application programming need toconsult developer if this is because of exclusive sqlstatement need to correct this with help of DBA (like

 creating new index/Table partitioning)

over all system performance :

This is also we can not say it is completely because ofresource bottle neck.But some times it may be.Here also starting point is to get info this is happening in a particular time/ or all the day.if it is happening at a articular time try to analyze what are the actions users doing in that particular time.and many more things we need analyze.I think we will not describe total resolution here.But these are some thing we can analyze to fix issue.if we are not able to find any thing we can open a message to

SAP.But most of the cases we can fix it with deep analysis.And please keep in mind SAP will not support used developed programs (y or Z ) :-)

What will you do when you cannot login to a dialog server?

Ans: Depend upon situation it needs to be diagnosed. check our network, check if you could to server via ping. then if this is fine check system no and sid where you are trying to get into. Now if you get login screen but you did nt get welcome screen then it need to look by server side, which need deeper inspection in SAP and database. First is to check out space on file systems and then continue to use other oslevel tool to diagnose the problem.

whats is happening in post import processing in scc7?

Ans: You need to perform postprocessing activities to adapt the runtime environment to the current state of the data.

When you use DB02 Transaction, You see something called as Swaps, What are they, and how the increase in swaps does affect your SAP system Performance?

Ans: DB02 - Table and Indexes Monitor, monitors the storage behaviour of the database (for example, space statistics showing the history of the database, or size and free space in each tablespace) and the status of database objects (for

example size of each table in kilobytes and blocks, or indexes that are defined in the ABAP Dictionary but missing in the database)

High swap/page activity usually is a sign of a memory bottleneck. To reduce the load on memory, you can:

Distribute process that do not need to run on this specific hardware to other hardware.

If necessary, reduce the size of the file system cache to less than 10% of the total physical memory

Identify users/programs that cause a high memory consumption by analyzing the mode list. Choose ST02 --> Detail analysis menu --> SAP memory --> Mode list and analyze the transactions for signs of expensive SQL statements or suboptimal programming.

Where can one see Archived files and what is the Tcode?

Ans: Tcode DB12 if LOG_ARCHIVE_START=True, for see the parameter type commend in SQL

show parameter LOG_ARCHIVE_START;

where can u see the dead locks in sap?

Ans: it is st04---->detailed analysis-----> exclusive lock wait

Where the patches are installed (CI or DI or both)?

Ans: Not CI or DI,we are applying to server ( system),every system having C.I and Databade instance,if reqyuired we create dialog instance.

here will you first see if there is a performance problem....

Ans: Start monitoring the system health...

1. How many users logged on

2. How much the load currently in the system (running BGD

jobs, DIALOG works & etc)

3. Full analysis of Workload (ST03N)

4. And, buffers status (ST02)

5. Memory roll-in, roll-out ratios.

6. Load on database (DB02)

By having a quick look into all these areas we can dicide something finally.For BI system, additional checks also required.

which modules need to be monitored by BASIS consultant in the organization? Ans: Hi,Basis Consultant has to monitor R/3 Modules.Where R stands for RealTIme and 3 stands for 3 Layers in SAP as Presentation,Application and DataBase Layers.

Which type of language use in sap?

Ans: SAP has its own Language and it runs on different platforms

(DB)too.

Till SAP 4.7 version it was running on ABAP language,which is a own product of SAP but for this 4.7 version installation SAP used Java too in front end. In later years when they have introduced NetWeaver & ECC versions they have

added one more language that is JAVA. Now ECC version will run on both ABAP & JAVA stack. Coming to Database it supports all the major database platforms like Oracle,MS SQL,DB2,MAX DB.

which type plate form is use in devlopment of sap application for example c# language use .Net Frame Work.?

Ans:ABAP & JAVA

while installation of sap bi7.0 sr2 ides . it asking to check DDIC password in client 001 but i try by using master standard password but it show error popup"unable open RFC connection". is there any solution for RFC connection and password for ddic in client 001? pls it urgent for me.

Ans: SAP 4.7 Enterprise Install Failure "FRF-00007  Unable to open RFC connection" During the Install of SAP 4.7 Enterprise the installation fails with "FRF-00007  Unable to open RFC connection" when you are prompted to enter the DDIC password. The solution I found was that you need to stop the install then log ito SAP with the User SAP* with password - "06071992" then change the DDIC password to whatever you want.Once done restart the install and continue to the stage where you need to install the DDIC password, enter the changed password and the installation will continue without errors.

The only OSS notes related to this was "Press the continue button" and the installation may continue, or restart the installation.

while scheduling backup in background using db13, which brtool activity runs?

Ans: brbackup

who is the owner of sap like owner of .net frame work is Microsoft?

Ans: The Owner of SAP is SAPAG.

why are creating virtual system +sap?

Ans: Virtual Systems are SAP systems that are planned by not yet physically present. In order to subsequently replace a SAP system by a Virtual System use the same SID for both.In order to replicate the transport routes of the planned system landscape and to ensure that the import queues of the subsequent system already exist.

Why dont we apply patche like Transports? (DEV--->QA-->PRD)

Ans: Patches DO follow the Dev->QA->PRD path but in a slightly different manner.They are manually imported in each system due to their size, high resource consumption and large changes (technical/functional) done in the system. This also involves downtime (for end users) as system is not usable during Patch imports.

why sap implemented lock concept seperatly as db locks(Oracle) are already there?

Ans: A "SAP lock" is named "enqueue lock", the enqueue is on a much higher level, e. g. a complete sales document is locked there whereas in the datbase usually only row locks exist.Since SAP runs on more database than Oracle  one needed to

have a mechanism, that is database independent and on a higher level. sap locks can be viewed in sm12 and db locks we can view in db01.

Why there should be atleast 2 Dialog Wp per instance?

Ans: There should be atleast 2 Dialog wp per instance as it is by default when you install SAP application server if you want to increase Dialog Wp one can add Dialog wp through modifying  profiles.Depending on RAM size one can accomodate

dialog wp per instance .If the ram size is 512 mb then each dialog wp can accomodate at a max of 8 users to login at a time .

will the work processes other than dialog ever goto priv mode?

Ans: It wont goto PRIV mode. since only DIA is supposed to multiplex between user requests.

while other work processes are meant to be blocked until they finish the activity

which ticketing tool you are using?

Ans:Remdy,First Users send mails to 1st level

support stating their issue,they then create service call and assign them to respective Team.Unique no is provided which is call service call no and it's used as reference no in future.

what is ticketing tool? what is SODA?

Ans: ticket tool means which software ur using for handling the ticket.generally, RADIX and REMEDY tools using for handling the ticket.

Further SODA is one of Tools of Client Side.

What is ticketing ? and what problems u have solve in ?

Ans: Handling tickets is called Issue Tracking system. The errors or bugs forwarded by the end user to the support team are prioritized under three seviority High, Medium and Low. Each and every seviority as got its time limits before that we

have to fix the error.

The main job of the supporting consultant is to provide assistance on line to the customer or the organisation where SAP is already implemented for which the person should be very strong in the subject and the process which are implemented in SAP at the client side to understand,to analyse,to actuate and to give the right solution in right

time.This is the job of the support consultant. 

The issues or the tickets(problems) which are arised is taken care of on priority basis by the support team consultants.  The work process in support projects are given below for your reference. 

 1.  The customer or the end user logs a call through any tool or by mail (RADIX).      

 2.  Each one of the support team is a part of support group.      

 3. Whenever a customer logs a call he /she  has to mention to which work group (by name).      

 4. Once the calls came to the work group, the support consultant or the team need to send an IR (Initial Response) to the user depending upon the priority of the calls.

(Top,High,Med,Low,None) 

  5. Then the error is fixed, debugged by the support consultant or the team. Then after testing properly by generating TR(Transport Request through the basis admin) 

 6. Then it is informed to the end user/customer/super user about the changes which have moved to the production server by CTS process. 

These are the process.  In summary, what I understand is that if any configuration or customization is required to solve the issue, then the consultant have to work on DEV

Client, then the end user will test it in the QA client and after approval the BASIS consultant has to transport it to the PRODUCTION client.

An example: 

Tickets in SD can be considered as the problems which the end user or the employee in the company face while working on R/3.  Tickets usually occur during the implementation or after theimplementation of the project.  There can be numerous problem which can occur in the production support and a person who is working in the support has to resolve those tickets in the limited duration, every ticket has the

particular deadline alert so your responsibility is to finish it before that deadline. 

To begin with , we should give "TICKET" to you for not

knowing it.

Here is an eg of a ticket raise: End user is not able to  

 1. Create Sales order for a customer from a New plant ,since shipping point determination is not happened . (Without Shipping point the document becomes INCOMPLETE and he will not be able to proceed further like DELIVERY,

BILLING). 

He raises a ticket and the priority is set in one of the

below: 

 1. Low  2. Medium  3. High.

Now you need to solve this ticket. You would analyze the problem and identify that the SP configuration has to be done for the new plant. You would request a transport for DEV CLIENT to BASIS. You do the change and Request one more Transport to BASIS for QA client. The End user will test the same by creating a sales order for the new plant and approve it.

Finally, you request a transport to move the changes to PRODUCTION. Once the change is deployed in production the TICKET is closed.  What I have given is a small example. You would get some real issues with severity HIGH in your  day-day support.

HOW CAN I CHANGE MY SCN PASSWORD?

In SAP Community Network (SCN), mouse over Profile Management in the upper right-hand corner. Select the Change Password option.

NOTE: If your SCN user-id is your OSS / SMP s user

I CHANGED MY SCN PASSWORD. HOW WILL THIS AFFECT OTHER SAP SYSTEMS I USE?

If your SCN user-id is your OSS / SMP s user, your password change will take place on those systems and affect them as well.

If you are an SAP employee, this password change will not affect any other SAP system.

I CHANGED MY PASSWORD IN A DIFFERENT SAP SYSTEM. HOW WILL THIS AFFECT SCN?

If your SCN user-id is your OSS / SMP s user, and you changed your password on those systems, make sure to use your new password next time you log in to SDN.

If you created mappings from SCN to other SAP sites, you must go to Profile Management -> User Mapping to update these mappings with the new passwords.

WHERE CAN I UPDATE MY PASSWORD REMINDER HINT?

In SCN, mouse over Profile Management in the upper right-hand corner. Select the Update Profile option. Your profile information loads and you can update your password reminder hint question and answer.

When finished, don't forget to click on the Update button.

NOTE: This option is not relevant for s users since user-is and password maintenance is done directly on OSS / SMP.

I'M CHANGING PERSONAL INFORMATION IN MY SCN PROFILE. WILL THIS AFFECT OTHER SAP SYSTEMS?

If you're an SAP customer, partner or employee, changing personal information in your SCN profile will not affect any other SAP systems. (s users - please refer above to information about password changes).

I DON'T WANT TO RECEIVE NEWSLETTERS FROM SCN ANYMORE.

In SCN, mouse over Profile Management in the upper right-hand corner. Select the Update Profile option and select the "No" button under "Would you like to receive or continue receiving our newsletter, other marketing materials, and offers?".

When finished, don't forget to click on the Update button.

How can I lock a transaction?
Use transaction SM01.
Look for the transaction you want and then check the “Locked” box.

Why should I lock a transaction?
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?
Use either transaction SM04 or AL08.

What is the fastest way to log off in SAPGUI?
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?
Run transaction SE93 to create, edit or display transactions.

How do I check for errors in R/3?
Run transaction SM21 for read the System Log.

How do I logon to a SAPServX FTP server?
User = ftp; password = ftp.

Do I always have to use the new visual design in SAPGUI (EnjoySAP)?
No. In fact, you can switch to the SAPGUI “light”. Simply use the “SAP Configuration” program in Control Panel.

How do I log on to SAPNet?
Use transaction OSS1 to log on to SAPNet R/3 FrontEnd. To log on to SAPNet R/3 Web visit: http://service.sap.com.

Can I copy all users from client to another?
Yes. Use copy profile SAP_USER.

Can I script the starting and stopping of R/3?
Definitely. You can use the SAPSTART, SAPSRVKILL and SAPNTWAITFORHALT executables.

Where can I get a list of all transaction codes in SAP?
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?
Table DD02L stores all tables in SAP.

How can I hide a client from the users?
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?
You can use one of these two: 1) delete the entry in table T000 via SCC4; 2) run tp locksys at the OS level.

How can I determine the size of a client?
You can run a local client copy in “test” mode.

How do I backup a database?
You can create a maintenance plan or use the “backup database” SQL statement in Query Analyzer or OSQL.
Within SAP, you can use DB13.

What is the transaction to access the language utility?
Transaction SMLT takes you to the Language Transport Utility.

How can I see all the available icons in SAP?
Execute 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).

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)

ABAP Query does not seem to work, what should I do?
It could be that you need to execute report RSAQUM40 to set the release flag. See SAP note 92124 for more information.

What happens if I start a dialog instance but the database and SAP services are down on the central instance?
The SAP_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?
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?
No. Only the user IDs must match for single-on to work.

Can I import transports between different R/3 releases?
Read the technical and logical problems SAP reports when doing transports between different R/3 releases.
SAP Notes 126776 and 330267.

I lost the password for SAP*. What can I do?
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.

Can SAP be installed on FAT or FAT32 partitions?No. SAP needs to be installed on NTFS partitions only.

How can I quickly check if the passwords for the accounts SAP*, DDIC, SAPCPIC and EarlyWatch are not the default ones?
Run SE38 and execute report RSUSR003.

Can I copy just data from client to another?
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.

Can Query Analyzer tell me if there is insufficient disk space to restore a database?
Yes. It will display message (Msg) 3257 indicating that there is not enough disk space to perform the restore.

What is the difference between R/3 and ECC?

R/3 is a term used for SAP Core prior to version 4.7 and after 4.7 and
especially 5.0 and above it is called ECC-Enterprise Central Component.


What databases can SAP installation support?

SAP is built to be DB independent so practically it can be installed on
any RDBMS. However, majority of the installations are in Oracle.


How does SAP handles memory management?

SAP handles memory management at many different levels and is robust to
handle millions of transactions per second.


What is an SAP Basis?

Basis is a set of middleware programs and tools from SAP. Basis
includes client/server architecture and configuration, a relational
database management system (RDBMS), and a graphical user interface
(GUI)


What is the differences between ABAP and OOABAP. In which situation we
use OOABAP?

OOABAP is used to develop BSP/PCUI applications and also anthing
involved object oriented like BADIs, SmartForms..etc.where as ABAP is
used to develop traditional programs in R/3.


What are the functional modules used in sequence in BDC?

These are the 3 functional modules which are used in a sequence to
perform a data transfer successfully using BDC programming:
BDC_OPEN_GROUP - Parameters like Name of the client, sessions and user
name are specified in this functional modules. BDC_INSERT - It is used
to insert the data for one transaction into a session. BDC_CLOSE_GROUP
- This is used to close the batch input session.


What are the things to keep in mind when you SAP startup problems in
Windows?

Developer Traces:-- dev_disp Dispatcher developer trace-- dev_ms Message Server developer trace-- dev_wp0 Work process 0 developer trace The "services" file, which contains TCP and UDP services and their respective port numbers. This plain-text configuration file is located
under %winnt%/system32/drivers/etc. Windows Task Manager (TASKMGR.exe). Dispatcher Monitor (DPMON.exe), which is located under /usr/sap//sys/exe/run. Database logs. EventViewer (EVENTVWR.exe). For a central SAP instance to start successfully, both the message server and the dispatcher need to start. If one of them or both fail to start, users cannot log in to the system. The following scenarios will illustrate possible causes of why an SAP instance might not start and the reason of the message:"*** DISPATCHER EMERGENCY SHUTDOWN ***".

What would you do when the dispatcher would not start due to port
conflict? What are the symptoms for the same?

The symptoms in a windows environment might be No work processes (disp+work.exe) exist in Task Manager. Dispatcher shows status "stopped" in the SAP MMC. Errors found in "dev_disp": Use, netstat -p TCP, check the services file in the windows and check what port your appropriate sapdb us running. If instance number is 00

What guarantees the integration of all application modules?

The R/3 basis system guarantees the integration of all application modules. The R/3 basis s/w provides the run time environment for the R/3 applications ensures optimal integration, defines a stable architectural frame for system enhancements, and contains the administration tools for the entire system.One of the main tasks of the basis system is to guarantee the portability of the complete system.

What are the central interfaces of the R/3 system?

Presentation Interface.

Database Interface.

Operating system Interface.

Which interface controls what is shown on the p.c.?

Presentation Interface.

Which interface converts SQL requirements in the SAP development system to those of the database?

Database Interface.

What is SAP dispatcher?

SAP dispatcher is the control agent that manages the resources for the R/3 applications.

What are the functions of dispatcher?

Equal distribution of transaction load to the work processes.

Management of buffer areas in main memory.

Integration of the presentation levels.

Organization of communication activities.

What is a work process?

A work process is where individual dialog steps are actually processed and the work is done. Each work process handles one type of request.

Name various work processes of R/3 system?

Dialog or Online (processes only one request at a time).

Background (Started at a specific time)

Update (primary or secondary)

Enque (Lock mechanism).

Spool (generated online or during back ground processing for printing).

Explain about the two services that are used to deal with communication.

Message Service: Used by the application servers to exchange short internal messages, all system communications.

Gateway Service: Enables communication between R/3 and external applications using CPI-C protocol.

Which work process triggers database changes?

Update work process.

Define service (within R/3)?

A service is a process or group of processes that perform a specific system function and often provide an application-programming interface for other processes to call.

What are the roll and page areas?

Roll and page areas are SAP R/3 buffers used to store user contexts (process requests). The SAP dispatcher assigns process requests to work processes as they are queued in the roll and page areas.

Paging area holds data from the application programs.

Roll area holds data from previous dialog steps and data that characterize the user.

What are the different layers in R/3 system?

Presentation Layer.

Application Layer.

Database Layer.

What are the phases of background processing?

Job Scheduling.

Job Processing.

Job Overview.

What components of the R/e system initiate the start of background jobs at the specified time?

The batch scheduler initiates the start of background job. The dispatcher then sends this request to an available background work process for processing.

Define Instance.

An instance is an administrative unit in which components of an R/3 systems providing one or more services are grouped together. The services offered by an instance are started and stopped at random. All components are parameterized using a joint instance profile. A central R/3 system consists of a single instance in which all-necessary SAP services are offered. Each instance uses separate buffer areas.

From hardware perspective, every information system can be divided into three task areas Presentation, Application Logic and Data Storage.

The R/3 Basis software is highly suitable for use in multi-level client/server architectures.

What are R/3 Basis configurations?

A central system with centrally installed presentation software.

Two-level client/server system with rolled out presentation software.

Two-level client/server system. Presentation and Application run on the same computer.

Three-level client/server system. Presentation, Application and database each run on separate computers.

What is a Service in SAP terminology?

A service refers to something offered by a s/w component.

What is Server in SAP terminology?

A component can consist of one process or a group and is then called the server for the respective service.

What is a client in SAP terminology?

A S/W component that uses the service (offered by a s/w component) is called a Client. At the same time these clients may also be servers for other services.

What is a SAP system?

The union of all s/w components that are assigned to the same databases is called as a SAP system.

What is the means of communications between R/3 and external applications?

The means of communication between R/2,R/3 and external applications is via the CPI-C handler or SAP Gateway, using the CPI-C Protocol.

What is the protocol used by SAP Gateway process?

The SAP Gateway process communicates with the clients based on the TCP/IP Protocol.

Expand CPI-C.

Common Program Interface Communication.

What is a Spool request?

Spool requests are generated during dialog or background processing and placed in the spool database with information about the printer and print format. The actual data is places in the Tem Se (Temporary Sequential objects).

What are different types of Log records?

V1 and V2. V1 must be processed before V2. But, we can have more than one V2 logs.

What are the types of Update requests?

An update request can be divided into one primary (V1) and several Secondary update components (V2). Time-critical operations are placed in V1 component and those whose timing is less critical are placed in V2 components. If a V1 update fails, V2 components will not be processed.

Dialog work process

Dialog work processes perform only one dialog step and then available for the next request.

Explain what is a transaction in SAP terminology.

In SAP terminology, a transaction is series of logically connected dialog steps.

Explain how SAP GUI handles output screen for the user.

The SAP front-end s/w can either run on the same computer or on different computers provided for that purpose. User terminal input is accepted by the SAP terminal program SAP GUI, converted to SAP proprietary format and sent to the SAP dispatcher. The dispatcher coordinates the information exchange between the SAP GUIs and the work processes. The dispatcher first places the processing request in request queues, which it then processes. The dispatcher dispatches the requests one after another, to the available work process. The actual processing takes place in the work process. When processing is complete, the result of a work process is returned via the dispatcher to the SAP GUI. The SAP GUI interprets the received data and generates the output screen for the user.

What is your system landscape?
What are you roles and responsibilities in your company?
What are versions of SAP & R/3, Oracle you are using?
Patch numbers of SAP kernel & Oracle you are using
if a user wants to execute a background job immediately but there is no Background work process available. How u will do?
What are common Housekeeping background jobs that run in your system?
What are common transport errors u faced while transporting?
How you will do client copy? If SAP * user is not available at all in your system then how u will do client copy?
How u will apply OCS patches?
What is the database backup strategy in your company?
What is upgrade process? And how u will do that?
How u will give new authorizations?
How to adjust user master records? If user masters record doesn’t adjust what will you do?
How to check Kernel, tp versions?
Briefly explain a recent problem you faced, which u felt proud by solving that? And ho u solved?
How you will rate yourself in SAP, Oracle from a scale 1 – 10?
What are your daily activities in your company?
What are you roles and responsibilities in your company?
What are common background jobs that will run in your system?
If a background job runs more than the time it should be completed normally then what actions will u take?
How to schedule background jobs at OS level?
How to add authorizations, how you will maintain profiles?
What are common transport errors and their codes?
Transport request types and its syntax.
Where will u find transport error logs?
How to do transport at OS level?
How to transport objects from Production to Development?
How to define instances and operation modes?
What are Homogenous system copy and Heterogeneous system copy and how you will do that?
What is oracle Architecture?
At OS level in which directory oracle alerts are stored?
If a lock entry is holding more than 24 hours then what will you do? If another user wants to share that lock but the user using that lock haven’t released lock he went for holiday what will u do? This user wants lock ASAP then what will u do?
What will you do if u got Update failure?
What will you observe in System log (SM21)?
How to increase tables space, resizing, backups and when will you do?
Various client copy methods and how you will do them?
How you will get help from OSS notes?
What is the need of having Development system?
Difference between Application server and Central Instance?
How you will check whether database is active or not from OS level?
What is Transport domain and Domain controller?
What is Consolidation route and delivery routes?
How to lock a client? How to delete a client?
How to login in to SAP from command level?
How to define Logon groups? And what is Logon load balancing?
How you will rate yourself in SAP, Oracle from a scale 1 – 10?
What are you roles and responsibilities in your company?
How you will do client copy?
If SAP* is not available then how u will do?
After client copy is table space and database sizes will be increased or not?
How to do client copy fast?
What are various profiles available for client copy?
How to do transports between Production and Development?
How to apply OCS Patches?
What are you roles and responsibilities in your company?
How to do client copy?
How to do transports from OS level?
Where the transport data files will be placed?