SAP BASIS Interview : 5

SAP ERP BASIS Interview : 5

SAP BASIS INTERVIEW QUESTIONS

SAP BASIS INTERVIEW QUESTIONS

why we configure the domain control  in production why sap recommended? what is the use of 001 client?

Ans : 1.production system is highly available system

2.there may no huge modifications in the production system

3.the production system server is protected at high level

Or

backup of 000 client

If you see the same parameter value in all instance profiles what will you do ?

Ans : Put the parameter in Default.pfl and remove it from remaining profiles

How to make security authorization reports?

Ans : SUIM Reports-> Authorizations.

What SAP tools you use to install SAP patches?

Ans : SPAM is used to install SAP patches and SAINT is used to install SAP Add-ons

What JAVA tools to install JAVA Patches?

Ans : Sdm Was used to Apply Patch to Java  new version 700 Systems uses JSPM to apply Patches.

What is early watch report?

Ans : The SAP EarlyWatch Report gives you detailed information about system status, performance, configuration, system operation, database administration and trends.

Why https is considered safer than http?

Ans : https is an encrypted communication channel using SSL.So when any information is via https, it is sent via an encrypted tunnel.So basically the only people who should see the unencrypted data are the people on either end of the tunnel.So, https is safer.

ABAP Service Pack level can be found in SPAM, but how to find the Java Stack Level?

Ans: Java STack Level can be found from

http://:

How to install multiple Central Instances on the same physical machine?

Ans: Create a separate the filesystem and SAP mount points for each CI under the folder  for which installation is going to be done and start the installation.

Or

Assign different instance numbers, and listener name.

What is the relevance of the Deletion Flag/Indicator in the archiving process?

Ans: Deletion Flag is for running the delete program. The sequence for archiving is:

  1 Data declaration component

  2 Customizing settings

  3 Programs 1) Write 2) Delete 3) Read

After write program is executed (Where we select write indicator) we schedule/execute Delete program by choosing this indicator

In-short, this indicator signify the program which has to run.

Can SAP Patches be installed when other users are online?

Ans: SAP Patches cannot be installed  when userss are online.When users are online they may access DB/Tables which may be related to the patch being applied. Therefore it is advisble to apply pacthes when there are no users online.

What is the importance/need of Virtual system?

Ans: You may not want to install all the SAP Systems you have planned for your system landscape at the same time.However, you can use TMS to configure SAP Systems as virtual systems in the transport domain so that you can model the transport routes of your whole system landscape.

This is the need of Virtual System.

Or

With the help of Virtual System you can collect all your transports/development in the Virtual System buffer for future use.

How to transport users from one client to another?

Ans: SCC1 is to transport within one system....

You need to use client copy (SCCL - for local copy and SCC9 for remote) with profile SAP-User.

What happens when in background when we shutdown SAP (Both central & Database) & where is the log stored. Also when we apply the Patches, what exactly is running in background.. Kindly help me with this answer..

Ans: When you shutdown SAP, the log is stored at the UNIX levelstartsap.log, stopsap.log in the home

directory. /home/adm/...

I assume you are refering to SAP Patches and not DB. The patches are usually a Code sets, or you can say kind of Transports. And those need RDDIMPDP scheduled and running as a backup job. RDDIMPDP is a CTS deamon.You can see the log /usr/sap/trans/log.

You have to check the timestamp on ULOG, SLOG and do a "more" on the file.

i want to know that how a transport request will be transported after being released . how it had to be carried to production system ?

Ans: After creating a TR ,first we have to release TR and then

transport.

To tranport the TR:Logon to STMS--logon to domain controller

(source system)--->find the request number--->select the

request and click on request-->forward--->system---->give

the target system--->noe select target system --->import---

>give client

Import done

How to take backup of system & restore it again?

Ans: By using the BRTOOLS

who will schedule the background jobs?

Ans : Basis people.

i have t-code su01 in crm and r3 in a financial org.i can create sap ids , unlock /lock sap ids , assign t-code, roles & assignment to users . what else can be done ? more importantly am i eligible for a job in sap basis since i am doing this job for last 2 years ?

Ans : SU01--1.You can reset the passwords to the users.

2.Lock/Unlock th epasswords

3.Role assignemnts/Deassignments

4.You cannot add transactions to user,only we can add transaction to role

5.we can restrict the validity period to role.

i can also check SAP compliance callibrator in r3p for SOD conflict and simulation tool in addition to id creation , roles assognments , what job i can expect ?

Ans: You can use SAP Compliance calibrator tool for

1. To find SOD conflicts for an user

2. To find SOD conflicts for roles

3. SOD conflicts from Simulation of roles with user

Note that this tool can not be used for User id creation and role assignments.

how can i check the user login details activity in a month?

Ans : STAD.

what is the full name of SAP Default user DDIC.?

Ans : DDIC stands for DATA (D) DICTIONARY(DIC)- DDIC

Where to check for system logs of Sap application at os level?

Ans : One more hint.. always check the db logs

at /oracle/SID/saptrace/backgroun/alert.SID.log

and work process traces are as mentioned above /usr/sap/SID/DVEBMGS/work/ (trace files).

Or

/usr/sap//DVEBMGS00/work.

How to restrict particular Tcode in Role. while these not assignsed in role?

Ans: As the Tcode is not needed in the role. simply remove it.

If SM01 is use it will lock the Tcode in the SAP instance

and it will affect all the roles in the instance.

I have created a role for user. Now i want to unauthorize to user for particular TCODE. Now, what i'll do for this?

Ans: Goto SUIM then select User by coplex selection

criteria, then U can give that t code or role name.. U candelete that place,,orelse

If u know particular user role,, then U can

display that role and remove that T-code

Or

To unauthorize user for a particular TCode one should goto profiles and Parameters and can remove the Tcode and can transport the same to User.

how to increase table space in brtools?

Ans: Goto BRTOOLs in OS level then  select the

extended table maintanence , then choose which table occupied greater than 90% then select that no and choose new and add 1 GB or 2GB.

Why is java Required while installing SAP?

Ans : without java Sapinst.exe can't start the GUI

While applying support packages, the error Table space overflow is occured? What could be done?

Ans: u mean spau and spdd.in this case take the printout of spau

and spdd and send it to functional consultent.after getting confirmation u can apply support packs.

what is the difference with oracle 9i and 10g?

Ans: oralce 10g is higher version of oracle 9i, oracle 10g has

added a follwoing features

Transparent Data Encryption

Async commits

CONNECT ROLE can not only connect

Passwords for DB Links are encrypted

New asmcmd utility for managing ASM storage

Grid computing - an extension of the clustering feature

(Real Application Clusters)

Manageability improvements (self-tuning features)

Performance and scalability improvements

Automated Storage Management (ASM)

Automatic Workload Repository (AWR)

Automatic Database Diagnostic Monitor (ADDM)

Flashback operations available on row, transaction, table

or database level

Ability to UNDROP a table from a recycle bin

Ability to rename tablespaces

Ability to transport tablespaces across machine types (E.g

Windows to Unix)

New 'drop database' statement

New database scheduler - DBMS_SCHEDULER

DBMS_FILE_TRANSFER Package

Support for bigfile tablespaces that is up to 8 Exabytes in

size

Data Pump - faster data movement with expdp and impdp.

How to apply SNOTE can anyone explain step-by-step?

Ans : use the tcode SNOTE TO APPLY

IT WILL ASK U THE NOTE NUMBER PUT THE NOTE AND APPLY IT.

What is the spool request and output request and difference b/w them?

Ans: Spool Request data only readable at Spool WorkProcess.after creating it will go to Spool Wp. But Output Request will be create at Spool WP. It will be sent to Operating Spoolar. After that it will print at os level.Spool Request contains Raw data which is readable at Spool Wp. Output Request contains data which is to be print at os level.

What is TMS, TDC, CTS, STMS and difference among them?

Ans: TMS --> Transport Management system

STMS is an transaction code for TMS

TDC --> Transport domain controller , it acts like cetntalsystem to transfer data from one system to another ,Normally always Development system will be configure as TDC

CTS --Change Transport System --This one will use to release a transport requests (request number)

Which type of Backup and Redo log backup is performed daily? And which type of Backup and Redo log backup is performed Weekly in the organization?

Ans: Daily;online backup,archive backup Weekly;offline backup.

Shall we have to restart sap system after configuration of operation modes?

Ans: No. There is no need to restart sap system afterconfiguration of operation modes the t-codes used for operation modes are RZ04, SM63, RZ03.

How to solve if more swaps are occurred?

Ans: Swapping occurs when your physical memory is inadequate and

thus your application is forced to dump data from RAM to the

HDD and load it back to the RAM from HDD whenever needed.

Increase in the application usage could be a cause of this.

Increase the amount of RAM and also the pagefile.

I guess you would also have to change the allocation of

memory for your database.

As a basis consultant what we have to do if a background job is cancelled?

Ans: When a background job is cancelled, as a basis consultant, fiest you need to conclude whether it is programmatic error or something else that caused the error. If it is programmatic error you leave it to ABAPer or else look into the issue. It could be Memory issue, GUI issue, RFC conn

issue, Time out issue etc. Depending on issue, search for sapnotes for a solution and proceed accordingly.

how to create list of users available in a client?

Ans: SE16,Enter the table name usr02 and execute.

Enter * in the bname field and again execute to get the list of the user in the client.

how to find out long running jobs?explain clearly....

Ans : Using Tcode SM50 and it will display all the jobs from here we can kill the jobs which is running for long time.

what u will observe in system logs(sm21)?

Ans : SM21 : system log provides information about the warnings, errors, user errors and system messages.There are 2 type of files in which the data is stored.LOCAL LOG: all the application server data is written here. These files get overwritten.CENTRAL LOG: logs of the selected application server is written here.

what r errors u faced while appling patches..?

Ans : 1. Object Locked !!!!!

 This was because one object was loacked in one Request.you need to unlock the object through SE03.

2. Back ground job not scheduled!!!!!

   Schedule the back ground job, RDDIMPDP by using program,   RDDNEWPP.

3. Cannot determine the EPS Parcel  :

   This is because, the SPAM Version cant read the EPS Pracel. Just Upgrade the SPAM Version

4. TP_CANNOT_CONNECT_SYSTEM

Upgrade tp and R3trans.

WHAT U WILL DO IF U GOT UPDATE FAILURE IN SM13?

Ans: First of all che check whether the Update is ACTIVE or NOT?

Tcodes SM14 & SM13.

Check the Status of Update work Process.Check the Table spaces (Free Space).Check OS level Space.Check the Object Locks (SM12)

HOW TO TRANSPORT SAME REQUST TO MANY CLIENTS?

Ans: Use scc1 for transporting to other clients.

Suppose one A User has tcode SU01.When A try to execute tcode su01,not able to execute.but next day User A can able to execute the same tcode SU01. Which not done user comparision next day too but how come User A can able to execute tcode SU01?

Ans: There is a field in the role assignment screen of su01 by which "Start Date and "End Date" of a role can be set.So During the first attempt of the user A the role may already be present but  inactive because of the "Start Date" condition and it became active the next day so he was successfull.

In which table support pack store....? 2. wht r things happing in back ground during DB backup..?

Ans : 1.Support package location PAT01 and PAT03.

2.First of all it will read the control file and the profile init.ora ,then it will take the backup of controlfiles and the data files.

How to delete a table from Database level.

Ans : Doing so would put the database at an

inconsitent state.

if your installation is under unix and the db is oraacle, then login as the database administrator.

1) su - ora

2) sqlplus "/ as sysdba";

3) drop table .tablename;

You can only drop the table if you own it. There are many such restrictions imposed so that the user does not delete / drop any table inadvertently.

What are the diffrent types of table buffering ? Is it "rollin , rollout ".

Ans : there are 4 types of table bufferrings,

Full bufferring(100%)---T000

Generic Bufferring---T001

Single Record bufferring---USR02,TSTC,TADIR

No Bufferring---Transactional Data is not bufferred..like mara tabs.

Can any one tell me about SM58 transaction code , Why we use this T-Code ?

Ans: SM58 is used to see the transactional rfc log.

what is SOLUTION MANAGER?

Ans : SAP Solution Manager during the implementation of your SAP

solutions, and during ongoing support and operations.

SAP Solution Manager and outlines the benefits of using Solution Manager and the ASAP methodology tools provided to aid in the implementation, operation, and continuous improvement of SAP solutions.

As your project moves into the planning stage, project team members of need a high-level overview of the SAP Solution Manager. Since the project will include multiple solutions consisting of potentially complex system landscapes, it is imperative to provide consistent and persistent documentation of the existing systems and the planned systems. Understanding the benefits of a central repository

is essential.

Wat s SAP? Hw u ll council a person who dont know anything abt it..

Ans: Before we tell him about the abbreviation for SAP. We should

let him about ERP. ERP - Enterprise Resource Planning

A xxxx company has many department like labour, production,

sales & distribution, HR, Finance, Raw material, etc.

ERP is a software which bundle up all this puts it into a

single system.

Then tell him about all the modules and how they work.

SAP stands for System Application and Products in

DataProcessing.To Council a person related to SAP one

should explain what actually SAP means and what are the

Functions of SAP and how SAP is more reliable when compared

with other ERP Packages available in Market,how many

modules it supports .

what is the difference b/w ECC5.0 & ECC6.0?

Ans: The only difference between ECC5 and ECC6 is that additionalcomponents like mySAPCRM, mySAPPLM, mySAPSCM, mySAPSRM are added in ECC6.0. HR was already a part of ECC5.0.

what is the difference b/w UNIX systems logs and Windows sytem logs?

Ans: In unix logon, you can use the userID Ora and the UserID adm. But in case of Windows you can use  adm and SAPService to log on.

In both the cases, you can log on to the system via a common user adm.

How to check SAP Memory status?

Ans: check in st02.

what is logistics in SAP and purpose?

Ans: Logistics is a chapter in SAP Basis and its full name is Software Logistics and this chapter describes about Transport Layers in SAP Basis.

what is the difference among spool request, ouput request, and print request?

Ans: Print request is the request that is given by the end user and it mainly contains data which user wants to print.Spool request contains information regarding Printer and is also responsible for the fomatting of the data which is going for printing. It is stored in Spool Database.Data is

also stored in the Spool database but it is stored under TemSE(Temporal sequential object ) area.

When spool request is processed by spool work process it is converted in to output reqest and is passed to host spool system.

How TRANS (:\usr\sap\trans) directory is configured, what is the maximum size of TRANS directory, how to see? briefly....?

Ans: 1. Make the transport directory available.

2. Configure the transport domain controller and define the

domain.

3. Configuration of the transport program (tp) is done

automatically and must not be done at OS level.

4. In the TMS:

- Include all remaining systems in the domain

- Define the transport routes

- Define QA approval procedure

5. Set the system change options according to the role of

the R/3 System.

6. Create clients and set the client change options for the

production system,development system, and so on.

what is cross client customizing?

Ans : Customizing which is reflected to other client's throughout the system is called as cross client customizing. Also called as client-independent data.

what is the difference b/w repository & data dictionary objects?

Ans : The Repository, the central store for all ABAP workbenchdevelopment objects, is also cross-client. It contains all Dictionary objects (tables, data elements, domains), and also all ABAP programs, menus and screens. Repository objects are grouped together to form packages.

ABAP Dictionary is a central component of the ABAP

workbench. It contains both business and technical

definitions and descriptions of SAP data. The ABAP

Dictionary enables all data definitions used in the SAP system to be described and managed centrally.

The tasks of the ABAP Dicitonary can be subdivided into:Database object definitions (tables, views, and so on)Type definitions (structures, tables types, and so on)Services definitions (F1 help, F4 help, lock objects and so on.

Explain Post Installation Activities??

Ans : 1.SICK/SM28 :TO FIND THE INCONSISTENCY BETWEEN OS KERNEL ,DB KERNEL

  AND FIND INCONSISTENCY BETWEEN PATCH LEVELS

2.SE06 :a.STANDARED INSTALLATION ,b.SYTEM COPY OR MIGRATION.SELECT STANDARDED INSTALLATION  AND CHECK  PERFORM  POST INSTALLATION  ACTIVITIES ,SET CTS  AND PERFORM MODIFIBLES,SET MODIFIBLES.

3.SE03(MODIFIBLE AND NON MODIFIBLE)

MODIFIBLE ALOW IN ONLY IN DEVELOPMENT SYSTEM.

NON MODIFIBLE ALOWS IN PRDUCTION AND QUALITY SYSTEMS.

4.TRANSPORT MANAGEMENT CONFIGURATION.

5.CHECK STANDARDED BACKGROUNDJOBS.

6.BY DEFAULT IN PRODUCTION SYSTEM ALSO CONTAIN SAP*,DDIC USERS WE HAVE TO CREATE SUPER USER, AND CHANGE THE STANDRDED PASSWORD.

     SET THE PRAMATER

        login/no_automatic_user_sapstar=0(In Rz10)

7.PERFORM CLINT COPIES

IN  DEVELOPMENT  CUSTOMIZING(CUST),SANDBOX(SAND)

QUALITY TEST ,PRE TEST (PTST)

PRODUCTION   PRODUCTION (PRD).               

8.IMPORT THE PROFILE PARAMETRERS OS LEVEL TO SAP LEVEL.CHANGE THE WORK PROCESS PARAMETERS,MEMORY PARAMETERS,

  LOGIN PARAMATERS AND BUFFER PARAMETERS.

9.SGEN  SAP Load Genetar.

10.PRINTERS CONFIGURATION.

11.INSTALL SAP LICENSE.

12.SAP ROUTER CONFIGURATION.WE NEED TO COINFIGURE SAP ROUTER PRODUCTION 

SYSTEM

13.CONFIGURING SAP LIBERARY.

14.BACKUPS (REGISTRY) OS and  SAP.

15.CHECK THE USER OPERATIONS PASSWORD NEVER EXPIRES IS SET FOR SAP ACCOUNTS

        ADM

        SAP SERVICE

16.START AND STOP SAP SYSTEM.

17.CHECK THE SYSTEM LOGS.

Explain SAP Buffers, Types, and Parameters?

Ans: Nametab (NTAB) Buffer contains data derived from tables

DDNTT(table definitions) and DDNTF (field descriptions),

stored in four individual buffer areas. These four buffers

are also known as the Repository buffer or the ABAP

Dictionary buffer. TTAB, FTAB, IRBD, SNTAB

NTAB:   rsdb/ntab/entrycount

FTAB:    rsdb/ntab/ftabsize

SNTAB:                rsdb/ntab/sntabsize

IRBD:    rsdb/ntab/irbdsize

The NTAB buffer: If the quality of these buffers falls below

95% , you should try to identify reasons for this decrease

in hit ratio.

Program Buffer (PXA) abap/buffer_size

The program buffer is used for storing ABAP program loads

before they are executed within individual work processes.

It is also known as the ABAP buffer. The PXA should show hit

ratios of 95% or more otherwise you will see, for example a

high load and generation time on your SAP instance.

Generic Table Buffer

The quality of the generic key buffer should be greater than

95% and can be upto 99%. This buffer is also known as the

generic key table buffer or the generic buffer.

CUA Buffer rsdb/cua/buffersize

The CUA buffer stores objects used by SAP GUI, including

menus and button definitions. The CUA buffer is also known

as the Menu buffer. Usually this buffer plays no significant

role concerning the performance of your SAP instance.

Roll and Paging Buffers rdisp/ROLL_SHM and rdisp/PG_SHM

The parameters rdisp/ROLL_SHM and rdisp/PG_SHM are used to

allocate the roll and paging buffer in 8KB blocks.

Screen Buffer zcsa/presentation_buffer_area

The screen buffer or Dynpro buffer stores generated screens,

the so-called Dynpro load. Usually this buffer plays no

significant role concerning the performance of your SAP

instance.

Calendar Buffer zcsa/calendar_area

The SAP calendar buffer stores all defined factory and

public holiday calendars.

OTR Buffer

The Online Text Repository (OTR) buffer contains texts used

by Business Server Pages, Exception Builder and HTTP

Services. Usually this buffer plays no significant role. concerning the performance of your SAP instance.

Export/Import Buffer

The Export/Import buffer is used to store data that must be

available to several work process. The system fills or reads

the buffers using the ABAP command. EXPORT TO / IMPORT FROM

SHARED BUFFER. Usually this buffer is only of interest for

individual processes, such as in some SAP APO functions.

Exp./Imp.SHM

The Export/Import-Shared-Memory-(ESM)-buffer contains data

put there by the using the ABAP statement EXPORT TO SHARED

MEMORY. This buffer might become a performance bottleneck

when you see heavy swapping activity for this buffer. If you

see no swaps, the buffer is perfect.

Explain Parameters for SAP Memory Management?

Ans: ztta/roll_first

Defines the first part of the roll area that is allocated to

a dialog process.

ztta/roll_area

Defines the total roll area per work process

rdisp/ROLL_SHM

Defines the size of the roll buffer

rdsip/ROLL_MAXFS

Defines the size of roll buffer and roll file

em/initial_size_MB

Defines the fixed size of extended memory

ztta/roll_extension

Defines the user quota for extended memory

abap/heap_area_dia

Defines the limit for the amount of local memory allocated to dialog work process

abap/heap_area_nondia

Defines the limit for the amount of local memory allocated

to non-dialog work process

abap/heap_area_total

Defines the limit for the total amount of heap memory allocated to all work processes.

In what sequence does a dialog work process allocate the different memory areas (according to SAP recommendations)?

Ans: 1. Roll Memory upto ztta/roll_first reached

2. Extended Memory upto  ztta/roll_extension or EM exhausted

3. Remainder of roll area is used ztta/roll_area

4. Heap Memory upto abap/heap_area_dia or HM exhausted

How are expensive SQL select statements recognized?

Ans : High database request time caused by many buffer requests on the databaseHigh database request time as part of the response time.

What are the port nos of Dispatcher,Gateway, Message Server, Printer in windows,niping,Router ?

Ans: Dispatcher 3200,Gateway  3300,Message Server 3600,Printer in windows 515,nipping 3298,Router 3299

what is the syntax of niping command?

Ans : The syntax of niping command is "NIPING -t",it will selftest its own system and will give an output as testok whether the r/3 system is installation was successful.

Explain Client Import in SAP?

Ans: After client export, Import the client export requests intothe target client with TMS. Log on to the target client and activate post-import processing with SCC7.

how can we activated profile parameter for disable multiple logon? i have already tried parameter: login/disable_multiple_login_gui=1. but its not affect to sap system. pls give me some step.

Ans: You can specify the list of Excepted Users for Multiple Logons using Parameter:

"login/multi_login_users"

Enter User name as the value.

Note: This function applies to dialog logons only. It does not apply to system logons that occur using the Remote Function Call (RFC) or to logons via the Internet Transaction Server (ITS).

when i did run cccleaner, i had lost my sapmmc console tree.i can see sapr/3 system option under console root.so i am not able to start my server.how can get resolve of this problem. please any one suggest get rid outoff this.

Ans: as of i know (iam not sure just try for this ok)goto usr\sap\sid\sys\exe\run from there sapstartsrv.exe run this one u will get one window there fill the information (sid, instance no, profile:give startup profile user:hostname\sidadm pass word:pass word of sid adm).

just try for this.

What is the size of oracle redo log file and what is the use of oraarch directory in oracle?

Ans : oracle redo log files do not dynamically grow when more space is needed for redo entries; they have a fixed size (on SAP systems,typically 50MB). When the current online redo log file becomes full, the log writer process closes this

file and starts writing into the next one. This is called alog switch.

oraarch

Offline redo log files are written to the oraarch directory; their names are specified with help of Oracle instance configuration parameters, so the name arch1_.dbf is just an example. Moreover, offline redo log files should be stored on a mirrored disk to prevent loss of redo information. A RAID system can be used for this purpose. If u loose a disk containing offline redo logs and data files,complete recovery is no longer possible. Therefore, offline redo

logs and data files should be on different disks!

How many types of Work Process.and types of roles. how will assign the role to the user.

Ans : Dialog, Background, Update, Spool, Enqueue, Message Server & Gateway are the types of work processes.

Types of Roles - SIngle & Composite.

Assigning ROle to User

Way 1 : - Goto SU01 -> Enter User ID -> Goto Roles Tab -> enter the role name.

Way 2 : - Goto PFCG -> Enter Role Name -> Goto Users Tab -> Enter User ID.

What is RFC. why will use RFC.

Ans : As per my knowledge rfc is a programming interface for making remote calls between programs located on different sap system;functions which are developed or exist in a system can be remotely called by another local programs.Rfc is a protocol which helps for data manipulation and load balancing between the systems and we can check or create rfc of sap System through sm 59 t-code.

how we can logon on 800 client if user sap* and ddic is lock by sap admin. but client 000 is login successful. is there any other way? from 000 client.

Ans: Please logon to database, expand table flied, search for USR02 Table than delete SAP* User ID from 800 client & try to login in SAP with default SAP* password (pass), and reset DDIC password from Su01.

if someone lock standard user such as sap* and ddic in client 800? and client 000 is working fine so how can i log in client 800? is there any other standard user with standard password?

Ans: here u have to delete sap* from database level.(usr02 table)and log in to 800 client with sap* and password pass.

i m try to disable multi user login with same user and password in same cleint for example client 800. so how can i do it? pls give me in details steps.?

Ans: Go to RZ10 transaction and set the parameter

Login/disable_multi_gui_login=0

How to find out who has deleted a client in the system.

Ans: SCC3.

All the background jobs are in released state and there is a delay time and the background work processes are in wait status. What could be the reason why the jobs are not in ready or active state and the solution?

Ans : when Jobs are in release status and still unable to run.it is due to mechanism  in Background dispatcher.Some times background dispatcher reserve bg work process for Class A jobs till they are not finished and they will not be allocated to other low priority jobs that's why it shows time delays

Or

There is some priority given to the background jobs. A,B,C. usually there are some background WP's whch are allocated to A and so they will not be allocated to the other background jobs. It will wait till the other WP's are completed their jobs. this could be the only reason for delay.

Can we run CIC Webclient without installing Web Application Server? If Yes, then what are the basic settings which we have to do to run webclient. If No, then is it possible to install Web AS on the same server where our SAP CRM is installed?

Ans: If No, then is it possible to install Web AS on the same server where our SAP CRM is installed answer is Yes. we can install web as on the same server.

how can i integrate ecc6.0sr3 with bi7 or netweaver 7 into single sap system.? pls give me some step. i know installation.

Ans: If you want to integrate between BI to R/3, follow the belo steps

1.Create logical client for both systems

2.Install BI Content in BI System

3.Maintain BW Support packs levels in both systems

4.Replicate the server Using RSA1 tcode in BI System.

Or

while giving the inputs in the installation we can select the usage types 1.AS ABAP  2 AS JAVA  3 BI 4 BI-JAVA.

                        

how can i create multiple user only for ABAP/4 ? once i create user so it access key for second user also.

Ans: You can create developer ID but u can’t apply same key to more then one user legally ,Every user u has to request developer key in service market

place.

role of RFC connection in project scenarios?

Ans : Its depends on Project to Project. But the RFCs is provide the usual communication between same system or diffrent systems.

WHEN I M TRYING FOR CREATING ROLE OF ECC6.0 IDES SO IT SHWOING DUMP ERROR: THERE IS NO MORE SPACE MEMORY BUT I HAVE INSTALLED ON 500GB HDD. PLS GIVE ME SOLUTION PLS IT'S VERY IMPORTANT & URGENT FOR ME.

Ans: When its refering memmory , its refering ram only, you need to have more ram, Also it also depends on os, you need to set your virtaul memory 3 times the ram, also if its 32 bit server os , it will recogonize only 4 g b ram at the max if you want more enable /3g option in boot.ini, Sap recommends 64bit os. Hope this helps.

somebody deleted my TMS configuration unfortunatly how to restore the same.

Ans: Logim with client no. - 000, and user DDIC. from their give the t-code stms, make all the required field and save it.This will create the domain controller.

why TMSADM user is used for? and can I change the password of the same if yes how to do that? If not why shouldnt we?

Ans: you want to reset user TMSADM to the default, or if the configuration of this user was damaged, then:Procedure

Log on to the SAP System in which you want to reset user

TMSADM.

Enter Transaction STMS.

Choose Overview ® Systems. The system overview appears.

Choose Extras ® Reset user TMSADM.

Result

The CPIC user TMSADM is regenerated with the default

authorizations.

Or

we are not created TMSADM user and password is default created during TMS Configure.

which is the t- code for system landscape?

Ans: The T code for System LandScape is STMS.

How do you handle the lock entries?

Ans : Lock entries are handled through SM12

Or

in SAP enque will maintain lock process to maintain data consistency means for example one user is trying to update a object in data base no other user can update the same object concurrently.Some of the times we will show some errors like lock table over flow .Because all the lock entries for enque is maintained in a table at database, if this table filled up because of huge locking.so first find out which object/Jobs locking the objects and trouble shoot further.

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,