What is SAP BASIS?
A relational database management system (RDBMS): Basis overlaps with many aspects of traditional database administration. A graphical user interface (GUI): The GUI is the interface through which the Basis administrator interacts with SAPsystems. A development environment: This is where Basis development takes place.
Few Important SAP Basis Interview Questions:
- When you define operation modes, you need to maintain instance definition. List the steps to change the definition.
- What is the purpose of SAP Early watch client? What is specific about its configuration?
- Can printing be restricted through authorizations? How this can be configured?
- How a table should be configured, so to be able to maintain entries in the quality and productive environments?
- You want to deploy SAPGUI along with a default list of SAPLogon sessions. Which scenarios should be followed?
- What are the classes into which background jobs can be divided? What are their features?
What Are Steps To Install Sap ?
Install os load the VGA and LAN drivers after increase the SWAP Memory 3 timesof physical RAM and Assign IP Address .
Install Kernel patches and java files
Install dialog and central instance (Start à Programs SAP system setup of install DialogandCentral and Database instance .
C11a install central and database instance.
2.Number of parallel process
5.Central Transport host
6.Data base name
7.Sap data.. Up1 to Data six locations.
What Is The Folder It Will Ask To Install Oracle ?
What Is You Allocate Disks To Different Areas In Sap ?
Disk1,Disk2,(Raid 1 min 4 GB)à winnt, Saparch.
Disk3,Disk4( Stripe Min 4 GB)à swap.
Disk5 (min 4 gb) Origilog A, Mirror log B, TRANS:
Origlog B , Mirror log A, SAPREORG.
Sapdata1, Sapdata2 ,Sapdata3 , up to Sapdata6.
How Much Swap Memory Should Be In The System ?
Three times of main Memory – at least 2GB.
What Is Meant By The Terms L And F Access?
An L access method refers to local printer. It is local to the SAP server, not the user.
An F access method refers to front end printer. This uses the users Windows printer.
How Many Types Of Work Processes?
There are 7 types:
( Dialog , Enque , Update , Background,Spool,Message server,Gateway)
What Is Difference Between Central Instance And Dialog Instance ?
Central Instance have message server installed on it where as Dialog Instance do not have message server.
How To See The Work Process Status ?
How Many Types Of Printer You Have Configured ? How Do You Differentiate Between Them ?
4 types of printers
Production Printing , Mass Printing ,Test Printing, Desktop Printing .
Where Printer Port(lpt) Is Running On The System ?
Network and Desktop printers.
What Is The Transaction Code For Creating Roles And How To Users And What Is Method You Will Follow ?
PFCG , then we generate the profile after that assign roles to users.
Have U Applied Patches What Is The Transaction Code ?
What Are The Two Files Present While Importing Patches From Os Level To Sap Level ?
On Which System You Have Applied Patches ?
DEV and QA.
How Many Types Of Client Copies And Which Method Do You Prefer ?
We prefer mainly remote Client Copy.
What Is The Difference Between Remote Client Copy And Client Export ?
RemoteCopy Using RFC connection we will perform remote copy. ClientExport Using TMS configuration we will perform client export and then we have to import client to copy the client – STMS has to be created first for doing Client Export.
How Mucn Time It Will Take To Copy A Client Of Size 650gb?
More than 17 hours.
What Is The Job Of Application Server?
It takes the request from the user and if the request requires data than it connects to database server and gives output.
What Are The Daily Activates?
Background job logs, Spool Logs, Work Processes Overview , Users Overview, All Application Servers active or not.
What Will You Observe In St06 ?
CPU, SWAP , Memory , Hard Disk Space.
What Is St03 ?
What Is The Difference Between St06 And St03
ST06 is OS Monitoring.
ST03 is used for – Monitor OS and Database and SAP System.
What Will Observe In St03?
Hit Ratio and Buffer Fillers and Roll Memory and Swap memory .
Have You Configured Operation Modes?
Where Will You Change The Parameters In Three Profiles?
Instance Profile ,RZ10.
Can You Change The Profile Parameter In The Os Level? Which One Is Advisable Why ?
We can change the profile parameter from OS level. Its not recommended.
What Is Development Class ? Why To Create The Development Class ?
Group of requests under one logical name is development class. When ever we change in R3 repository it should be assigned to development calss and it internally assigned to transport layer .
Do You Know About Oss What Do You Do With Oss?
Yes it is online system service.
Do You Know Logon Groups At Which Situation Will Be Created Logon Group ?
Yes, If we find load on application server then we have to create logon group (If the production department users are more than we have to create logon group for that department ).
How Many No Of Users Have Been Connected To That Particular Logon Group ?
100 to 150 users.
What Is The Purpose Of Enqueue Processor ?
Enque work process makes sure that database in consistent state.
What Are The States Of Back Ground Job ?
If A User Complaints That He Could Not Execute Some Of The Transaction Codes Then What Will You Do ?
Use T-code SU53 , This will show which authorization is missing in his profile.
What Are The Daily Transactions ?
What Are Patches You Applied ?
What Are The Different Types Of Sap Profiles?
There are 3 types of profiles in SAP.
DEFAULT.PFL (known as System Profile)
What Is Purpose Of Logon Load Balance?
To distributed the workload between application servers.
Which Tcode Is Using Logon Load Balance ?
I Am Having Two Application Servers The Logon Load Balance Is There ; If The User Wants To Connect To Application Server Which Will Connected First.
Messages server is will assign the Application server automatically.
How Do You Distribute The Load.
Depend upon the load, according to module we have to configure logon groups.
How To Analysis Abap Dumps ?
By seeing ABAP dump error we come to know that whether the error or developer technique.
If belongs to insufficient memory dump error display at which stage the transaction terminate and how much memory requires. So that we have to increase the memory (Through Instance profile).
If belongs to table space error it displays the table name so that we increase the table space through the SAPDBA.
If belongs to program error we have analysis the ABAP program through se30.
If belongs to developer technique cancel the ABAP program.
Each And Every Work Processor Is Full Even Though The User Wants To Execute The Program. Then What's The Solution ?
If you don’t have second applicaitno server than we have to cancel te particular work processor (through SM50).
If u have second application server than we have to configure the logon groups.
At What Stages We Need To Transport The Requests?
Whenever we need the change the objects and need to transport we have to perform transports like user request , client transport etc..
How To Perform The Transport?
Through STMS_IMPORT or through FTP.
What Is The Procedure To Applying Patches ?
first we will download the patches from the service .sap.com to Trans Directory . In the trans Directory extract the patches using CAR command after that using SAPM we have to import patches into sap level and apply.
How To Configure Tms ?
Select all systems in a landscape and select for domain controller and type stms and give domain name and go to remaing systems and configure the same and come to dc and select configure and distribute option . Create transport route and paths .
If Your Sap Landscape Is Composed Of A Dev Server And Prd Server And You Need To Transport A Change Request From Dev Client 111 To Dev 131 (i.e. Transport In The Same Server). How Can This Be Accomplished?
We Have Recently Experienced Some Internet Outages Caused By Our Isp. Although We Have Resolved Our Isp Problems, The Users Refuse To Believe That Losing The Internet Connection Was To Blame For The Sap Problems. How Can We Ensure That This Was An Internet Problem And Not An Sap Problem?
Open a maintenance window, connect to the machine and kill the ISP connection and see if this kills your connection. Repeat at will until they believe that the ISP was the problem.
What Is An Ok Code? What Are The Differences An Ok Code To A T-code?
An OK Code is used by a program to execute a function for example after a pushbutton has been clicked. A transaction code is a “shortcut” that helps a user run a program.
Where Are T-code Name And Program Values Stored? How Can I Find A List Of All The T-codes In The Sap System?
You can use transaction st11 to view Table TSTC. You can define a new t-code using transaction se93.
How Can One Disable The ``import All`` Button On Stms For The Queues?
Login to your Transport Domain Controller. Run STMS->Overview->System. Choose the System you want to disable import all. Go to Transport Tool tab. Add/Create Parameter “NO_IMPORT_ALL” set its value to 1.
What Are The Different Types Of Work Processes In R/3?
Dialog (D), Update (U), Enqueue (E), Background(B), and Spool(S).
Why Can Web Help Be Considered Easier To Install Than Chm, The Standard Delivered Sap Help?
Web help is easier than trying to get every remote user connected to a network share. If you don’t want to use SAP’s help site, you can setup your own website to do it. The best route depends on your business’ network structure.
What Is The Difference Between A Client Copy And Client Refresh?
Some times these are the same, For example, if you are performing a copy to an existing client for the express purpose of updating the data, then it is called Client Refresh.
If you are copying to a newly created client then it is more appropriate to say “client copy.”
Another way of thinking about this is that a client copy from production to a QA server or from production to DEV server is really a client refresh.
What Is The Purpose Of Table T000?
Table T000 contains a list of defined clients, which you can maintain with transaction SCC4.
What Is The Purpose Of Table Usr02?
This table stores User IDs and passwords.
What Is The Purpose Of Table Tadir?
Table TADIR contains object directory entries.
What Is The Purpose Of Table Tdevc?
Table TDEVC contains development classes and packages.
How Can You Get A List Of The Users With Development Access On A Particular System?
Where Can You Find A List Of Object Keys Included In A Transport?
E071K Object keys contained within transports.
How Can You Tell If A Transport Entry Is In The Process Of Being Imported?
Check table TRBAT.
How Can You Find A List Of Objects That Have Been Repaired In The System?
ADIRACCESS List of repaired objects and their access keys.
What Is The Difference Between Tp And R3trans
TP controls the process and calls several tools, like r3trans but also e.g. DDIC-Activation.
Is There A Difference Between User Ddic And Sap_all/sap_new ?
Yes, DDIC is hard coded to do some things other IDs cannot. But you should be able to activate tables in SE11 using a SAP_ALL user.
What Is The Purpose Of The Unix File /etc/passwd ?
/etc/passwd contains valid user passwords, accounts, default login directories, and user security permission levels.
Is It Possible To Install Ecc 5.0 As A Test System And Not Production, Without Installing Solution Manager?
During the installation you will be asked for a key, which can only be generated by the solution manager.
We Are Trying To Install Java-add An Abap System As Part Of An Xi 3.0 Installation. At The End Of The J2ee Installation, While Trying To Start Sap J2ee Engine, A Timeout Error Occurs. How Would You Fix This?
Increase paging space to 20 GB.
I Received 2 Transports (k And R) To Be Imported From An External Vendor. We Need To Import These Into Our Qa System. I Have Moved The Transports To The Cofiles And Data Subdirectories. What Do I Need To Do Next?
Increase paging space to 20 GB.
I Received 2 Transports (k And R) To Be Imported From An External Vendor. We Need To Import These Into Our Qa System. I Have Moved The Transports To The Cofiles And Data Subdirectories. What Do I Need To Do Next?
Follow pathway STMS -> Overview -> Imports.
Double-click on QA’s SID. Next, follow path Extras -> Other Requests -> Add. Finally, type transport number and import as you would normally transport.
We Have A Sap R/3 47x200 (unix/oracle) The Sapdba Program No Longer Exists Since We've Upgraded From 6.20 To 6.40. Where Can I Download Br*tools Gui For Oracle Dba -gui After Installing Kernel 6.40?
You can still use SAPDBA from version 6.20.
You must however combine it with BR*Tools 6.40.
We Are Planning An Upgrade Of The Os From The Existing V5r2 To V5r3 Of Our I-series Server Which Hosts Sap Application. We Are Currently On R/3 Release 4.6c At Support Pack Level 50. After We Do An Upgrade We Plan To Migrate All Applications To A Power 5 I-series 550 Server. Our Current Kernel Is Ascii 46d Patch Level 1977. Should We Consider A Sap Kernel Upgrade?
Before upgrading OS , database or SAP version, Always update your kernel to latest level.
The Job ``sap_collector_for_perfmonitor`` Is Being Continuously Being Cancelled In Our Quality System Bw. I Keep Receiving An Error That Says The Load Program Is Not Found. What Should I Do To Resolve This?
The problem is in the support package. The Solution is you need to delete the SWNC* reports and insert RSSTAT83 and RSSTAT87 into TCOLL.
Is There A Way To Change The Transport Request Number To Start With A Number That I Choose?
Assuming your release is 4.6, user SAPR3 is owner of the database. Call the last transport number by issuing “select * from sapr3.E070L.” Change the transport sequence number by issuing:
”Update sapr3.E070L set TRKORR='<SID>K9xxxxx’.”
If your SAP release is higher than 4.6, replace SAPR3 with the owner of the database.
I Want To Change Five Dialog Work Processes Into Batch. Where Can I Do This?
You can configure work processes through parameters in RZ10. Use “rdisp/no_wp_dia” for dialog and “rdisp/no_wp_btc” for background. Or you can configure operation modes for that through RZ04.
How Would I Setup Table Maintenance For Customized Table Z1?
Use Transaction code SE11.
The Temporary Spooling Table Space Is Approximately 5gb In One Of Our Customer's Production Systems That Runs 24 Hours A Day. We Would Like To Reduce This Over Time. What Strategy Would You Have For Reducing This Tablespace?
You could schedule report RSPO0041 for deleting the spool (TEMSE) objects. Schedule it as a daily background job in order to minimize impact on your system.
I Installed The Kernel Patch 6.40 Level 098 And Now The Transport System Is Not Working Properly. The Job Rddimpdp Is Not Starting, Although I Start It Manually. I Keep Receiving Error Messages. How Should I Solve This Problem?
First go into SE38 in both client 000 and your working client. Run program RDDNEWPP. This will schedule program RDDIMPDP with proper parameters. Then, check if any “TP” programs are running . If this is the case, check in /usr/sap/trans/log and look for the most recent files contents.
Is There Any Report Or Table In Which User Log Off Time Is Stored In Sap?
There is no standard report. However, you can find out about the user’s last transaction time in table USR02 and field TRDAT, which is close to logoff time.
Is It Safe To Delete Old Background Jobs Using The Program Rsbtcdel While Users Are Working In The Prd Server?
Yes. It is safe to run this program while users are working since this only deletes jobs that were completed or aborted, not active jobs.
We Are Currently Running 4.7 Enterprise On Oracle 18.104.22.168, On Solaris 9. I Am In The Process Of Upgrading Production Which Has A Central Instance Server And 3 Application Servers Where The Sapmnt Directory Is Shared Out From The Central Instance Server. I Upgraded The Kernel On The Central Instance With No Problems, But When I Try To Start Sap On The App Servers I Receive An Error Message Stating The Database Must Be Started From A Remote Server. I Have Changed All Environment Variables But I Still Receive The Error Message. What Could Be The Issue?
Ensure that the Oracle client is properly installed on each of the application servers. Also, make certain that you are using the latest versions of all of the kernel, associated files (R3trans, tp, startdb, stopdb, etc.) and the DB library.
What Is Meant By The Terms L And F Access Methods?
An “L” access method refers to local printer. It is local to the SAP server, not the user. An “F” access method refers to front end printer. This uses the user’s Windows printer.
I Am On Sap 4.7, 6.20 Hp Ux Oracle. When We Complete Our Weekly Offline Backup, Application Is Not Coming Up And The System Goes Down. Which Log Will Give Some Input As To What Is Wrong With The System?
Start with the alert log. It is usually found in oracle/SID/saptrace/background/alertSID.log.
Will A Client Copy Transfer The Background Job Schedules And All Client Dependent Data?
SAP_ALL will copy all client dependent data including schedules to the new client. Remember that ABAP programs are always client independent. Only the masterdata (variant) is client dependent.
I Have An Abap+j2ee Instance On Xi 3.1. Is It Necessary To Stop Web As And J2ee To Apply The Support Packs For J2ee?
Any J2EE patches are applied while system is up and running but no activities. The only patch applied while system is down are binaries (ABAP kernel).
When I Check Transaction Sm37 And I Want To See The Spool I Get A Message That Says ``no List Available.`` Why Is This?
There are several possible reasons. The spool is sent to a printer and deleted. The spool is too old and the housekeeper deleted it. Also, some test reports simulate a calculation then rollback. It works fine online. When a background job does a rollback then it rolls back the spool as well.
I Have Some Housekeeping Abaps That I Have To Create Variants For. There Are Cases When I Have To Specify A Time Interval For The Abap In The Variant. If I Explicitly Enter A Start And End Date They Will Remain At That Current Date Continuously. Is There Any Way To Dynamically Enter Dates In The Variant?
In transaction SE38 enter the variant name and choose the attributes radio button. Here you can set the field to “selection variable.” Then, under selection variables button, you can define that it is SY -DATE+7.
Some Transactions In Sap Are Seen As Customizing, For Instance Ovrf (updating Routes). In Some Systems This Is Set As Master Data And Can Be Set Open. Where Do You Do This?
That depends on each transaction. Sometimes it is determined by other configuration and sometimes it is set according to system function, production or test/develop/demo/etc.
We Are Running Win 2003, Oracle 9i, Sap 4.7. We Are Having Performance Issues Around Tx Miro Which Updates Table Rbkp. Table Rbkp Has Five Indexes In Sap, But Only Three Of Which Exist In Oracle. Why Is This?
In SAP there are many predefined indexes.
You can see these indexes via DB02->checks-> database ->ABAP dictionary ->display. Under optional indexes you see all indexes of which the definition is created in the dictionary, but not created at database level.
I Need To Do A System Copy From Prd To Tst. I Cannot Follow Sap Documentation, But Must Do It Manually. When I Run ``@/tmp/tstcntrl.sql,`` Will It Change All The Prd To Tst In The Restored File Names? Would The Restored Files Be Recognized As A Tst System?
You must first open the DB as PRD on your new system. Second, apply redo logs. Next, run your script to change SID. This will change SID but will not change tablespace names if using WAS 6.10 or above.
Will Restarting The Prd Server Every Week Affect Server Performance?
When you restart the server, the SAP ABAP program buffer and other buffers are emptied. As far as performance goes, the reports runtime will be a bit longer during the first run. You can restart the system every week without harm. The only reason against it may be the SLA/users demand.
I Am Attempting To Complete A System Copy Of Bw. When I Try To Go In To Rsa1 Afterwards I Get The Error Message, ``entry In Inbound Table Already Exists.`` What Should I Do To Solve The Problem?
Read the homogenous system guide and follow all directions under “subsequent steps” section. Check transaction codes BDLS and SALE as well.
One Of My Btc Jobs Fails When I Try To Run It, Giving Me An Error Message Stating ``lock Table Overflow.`` It Recommends To Modify The Enqueue / Table Size Parameter To Solve This Issue. I Do Not Have This Value In My Default Or Instance Profile. How Do I Solve The Problem?
Run ABAP RSPARAM program. It will give you the real value of the SAP parameter and where they have been set up. The lock table can hold 10,000 entries, which is more than enough for the average system. It is possible that the program is not written properly and the developers should modify it.
I Am Working On A Backup Strategy To Disk. I Want To Perform A Copy_save_delete Equivalent On Various Disks. This Function Does Not Work For Disk Saves But Ideally I Would Like To Have Two Copies. Is There Another Function I Can Use?
In your init<sid>.SAP file log on to another drive/server to store another copy of your archive log.
While Doing Sap Installation Of Db Instance On A Different Box Other Than Ci, The Input We Have Given In Sapinst Of Db Instance Is Wrong In System Number Of Ci Instance. How Can I Change This Entry After Installation?
You must reinstall the CI instance with the right system number.
Are Direct Updates On Sap Tables Allowed?
You can call SAP functions directly to update data (RFC calls) but it is not recommended to try and manipulate data directly at database level (sql scripts, jdbc).
When Sending An Email From Transaction Sbwp I Wish To Enter The User's Login Name Only, Not An Email Address. Also I'd Like Sap To Look At The User Details Email Address And Communications Method Held In Su01 And Send The Mail To This External Email Address. Can This Be Configured?
Yes. Follow pathway SO16-> Tab Mail Sys group-> bottom radio button.
In My Development Server When I Perform St02 The Program Buffer Shows A Value Of 1056 In Red Under The Swap Category. Users Are Getting A Shortdump With The Pxa Buffer Error Message. What Should I Do?
Use “my links” in “my signature” and use the keywords: PXA Buffer.
When We Install Sap R/3 Enterprise 4.7, There Are Several Error Messages In The Sapview.log. What Does This Mean?
This means that one of your load jobs did not run successfully.
I Am Installing A Sap J2ee Engine At Crm. When It Reaches Phase 22 It Halts For More Than 10 Minutes And Gives Up Starting The System. What Should I Do?
A restart is often the solution. If it is an add-in and you have restarted your ABAP then you may be missing the profile parameters. If this is okay and a restart does not help look in the work directory and check dev_icontrol. If the J2EE engine software is the problem, applying a patch will solve the problem.
How Do You Configure The Internet Email Gateway In Sap Netweaver 04?
Starting with version WAS 6.x, SMTP comes built in to kernel. Go to transaction. SCOT and configure it there.
We Setup A Saprouter In Dmz So That All Sap Requests Can Be Routed In And Out From That Machine And The Sap Application Servers Are Not Necessary To Be Exposed To The Internet User. However, The Saprouter Does Not Handle The Bw Web Reporting Application Requests. We Do Not Have E.p. Are There Any Tools Which Can Help Us To Route Web Reporting Requests The Way Saprouter Does?
You need a SAP Web dispatcher. It acts like a SAP Router but routes SAP ICM traffic. BW Web reporting is a BSP that sits on the ICM. You can look for sapwebdisp.exe in the kernel directory or do a self-generated profile using command option “bootstrap.”
After A Recent Upgrade Of Kernel 6.20 To 6.40, While Doing A Transport I Received Several Warning Parameters Although Everything Looked Okay On Sap T-code Stms, What Should I Do About The Warning Parameters.
You can delete these parameters from TPPARAM.
We Have A J2ee + Abap 6.40 Instance Running A Portal 6.0. It Seems 1gb Of Memory Is Not Enough And J2ee Has Problems If We Assign More. What Can Be Used To Balance The Load In The Servers?
You can create a second server process using config-tool. Also, load balancing is possible through SCS.
When I Release All Of The Requests To Dev It Is Not Being Displayed In An Import Queue On The Qa System (t-code Stms). When I Check The Log Of Transport Request Overall Status Is Successful, But A Message Appears Saying ``continue: Other Transport Group.`` Why Is This Message Appearing?
The transport group for QA is misconfigured. Go to STMS, then Overview. Double-click QA and choose communication. Next enter the correct transport group and save.
I Need To Schedule A Background Job To Run For 3 Consecutive Days And Would Like To Use Db13. How Can I Schedule A Report To Run From Db13 And Not Sm37?
There is no way to schedule a report to run from DB13 other than pre-configured DBA jobs. Instead, use SM36 and make the jobs event driven.
Is There A Way To Find Out What Was Entered In A Particular Transaction Code Screen?
No, but you can analyze tables associated with the transaction code and see if there is a username field that traces what this user has done.
I Want To Let Sap Skip Printing Cover Pages During Printing For Any Kind Of Report. How Can This Be Done?
Find the source for the cover page. It will either be from SAP itself or the OS spooler. Take the appropriate action.
I'm Trying To Send Email From Sap To Microsoft Outlook. When I Attempted To Configure Sapconnect It Failed. On Unix Level I Try To Run Command ``mlunxsnd`` And ``mlosmadm`` But Found That It Doesn't Exist In Unix. How Should I Solve This Problem?
In versions with basis release 6.20 or higher, you don’t need to use sapconnect. Directly put your mail server in the SMTP node in SCOT.
In Our Dev System We Have Opened The Client With All Options ``changed Without Automatic Rec,`` ``changes To Repository And Cross Customization Allowed,`` And ``protection Level-0 No Restriction`` In Scc4. The Developers Complain That They Get An Error Message Saying The System Is Non-modifiable. What Should We Do To Fix This?
In a DEV system, set the global system change option (SEO6) to modifiable for all namespaces/objects. The developers must have the ability to change any, including SAP, namespace/object. Change client options (SCC4) to “changes allowed for repos and cross-client cust” and radio button to “auto. save changes.” Next, enable CATTS sessions.
If Sapconsole Telnet Screen Size Is Too Big How Do You Make It Smaller?
Go to the control panel, and then to the SAP console administrator and general tab.
Is There A Way To Perform Sapgui 640 Roll Out Using A Centralized Server?
Look for SAPADMIN and SAPSETUP on the installation CD. Then, use a utility such as Microsoft’s SMS to distribute this program or use a login script to call the SAPSETUP program.