SAPGui Favorites for SAP Users

SAPGui Favorites for SAP Users
April 28, 2014 | No Comments »

We can add our frequently using transaction codes to “Favorites” group for our SAP User.Also we can “Download” this favorites to our computers or “Upload” to our SAP system.

UPLOAD and DOWNLOAD Locations for SAP Users

UPLOAD and DOWNLOAD Locations for SAP Users
April 27, 2014 | No Comments »

Before we have worked on SO21 tcode to “configure working directory” but now i would like to share with you how can we change upload and download working directory for another SAP user.

ORACLE DB Startup Modes

ORACLE DB Startup Modes
April 26, 2014 | No Comments »

Let’s remember the ORACLE database startup options.

NOMOUNT : If we choose “nomount” option to start our ORACLE database , system first read “init.ora” file to get database configuration and related parameters thus database can start background processes.

Send SAP Spool Output via E-Mail

Send SAP Spool Output via E-Mail
April 25, 2014 | No Comments »

We can send “SAP Spool Output” by e-mail to related colleagues…It’s so easy and it’s very useful especially for backgroud job’s spool outputs.

To configure this option we can follow the steps below ;

Oracle Datafile Resize

Oracle Datafile Resize
April 24, 2014 | No Comments »

Sometimes we get a message from DB13 “Check DB” operaion like ;

BR0970W Database administration alert – level: WARNING, type:
TABLESPACE_FULL, object: PSAPSR3DB, value: 95.46% (> 95%)

DB13 “Checkpoint Not Complete”

DB13 "Checkpoint Not Complete"
April 23, 2014 | No Comments »

If you  get “Checkpoint Not Complete” message from your “Alert.log” via DB13 tcode,  it means that probably your REDOLOG file sizes are smaller than the oracle db needed.

DB13 tcode show us following screen in case of situation ;

SAPGui SAP Menu and User Menu

SAPGui SAP Menu and User Menu
April 22, 2014 | 1 Comment »

I would like to share some informations about MENUs which located on SAPGui

- We can activate the USER MENU from left side of the SAPGui screen shown below..

SQL Quick Viewer

SQL Quick Viewer
April 21, 2014 | 2 Comments »

SQL Quick Viewer is the part of SAP system which is not very much known by the Basis admins but it’s also very helpfull tool for getting the table entries with any kind of patterns which you want…

Let’s check this tool with an example ;

Compare Two Different SAP Systems or SAP Clients

Compare Two Different SAP Systems or SAP Clients
April 20, 2014 | No Comments »

Sometimes we need to compare two different SAP system or SAP client, then we can use transaction SCU0 for this process.

Let’s make an example how we can use SCU0 for a compare operation.

STMS Message “requests do not match the component version of the target system”

STMS Message “requests do not match the component version of the target system”
April 19, 2014 | No Comments »

Sometimes we should see a STMS icon, different than the usual icon types in the STMS queue…

Zero Administration Memory Management

Zero Administration Memory Management
April 18, 2014 | No Comments »

“Zero Administration Memory Management” handles the SAP MEMORY management dynamically on windows systems.“Extended Memory” value can be configured with parameter “PHYS_MEMSIZE” via SAP profile parameter.

What is the Difference Between “Static” and “Dynamic” SAP Parameters

What is the Difference Between "Static" and "Dynamic" SAP Parameters
April 17, 2014 | 3 Comments »

SAP has two type of “SAP Profile Parameters”

1 – Static Parameters

2 – Dynamic Parameters

All static parameters needs “SAP System Restart” before it’s activated, but we can change all Dynamic parameters without SAP system restart , these type of parameters get activated when they changed via RZ11

What is WorkProcess? What are the Types?

What is WorkProcess? What are the Types?
April 16, 2014 | No Comments »

SAP workprocesses are part of the application server which can handle maximum one presentation server request at one time.SAP workprocess contains “ABAP interpreter” , “Screen Interpreter” , “Task Handler” and “Database Interface” sections.

Who Locks the RFC User ?

Who Locks the RFC User ?
April 15, 2014 | 1 Comment »

Sometimes RFC users getting LOCK status and you have to find who or which process locks this user ? If you can’t find the reason why your RFC user always getting lock status then your RFC connections won’t work because of RFC user lock issue…

Then let’s investigate who , what or which process locks this RFC user…

How to Delete a SAP Client

How to Delete a SAP Client
April 14, 2014 | No Comments »

If we want to delete a SAP client on our SAP system,  then we can check the following steps and do it easly…

1 – Logon the related client which we want to delete with the user who has SAP_ALL authorization .

Example : Client No : 010

SAP User List Who Has “Access Key” for Our SAP System

SAP User List Who Has "Access Key" for Our SAP System
April 13, 2014 | 1 Comment »

If we want to display a list of users who has “Access Key” for our SAP systems then we can use related section of service.sap.com…but also there is another simple way to get this list over related SAP system.

Just display following SAP table via SE16

Get TCOLL Error After RTCCTOOL Report Runs

Get TCOLL Error After RTCCTOOL Report Runs
April 12, 2014 | No Comments »

After running RTCCTOOL report while working EWA (Early Watch Alert) configuration,  you can get TCOLL error like below ;

Short Dump : SPOOL_INTERNAL_ERROR

Short Dump : SPOOL_INTERNAL_ERROR
April 11, 2014 | No Comments »

Sometimes you can get an error like “Short Dump : SPOOL_INTERNAL_ERROR” under ST22 or SM21 Tcodes , usually the reason is ; “Spool Request” number reached the default value 32.000

Change SAP Object Without “SAP Object Key”

Change SAP Object Without "SAP Object Key"
April 10, 2014 | No Comments »

Normally if you want to change a SAP object, first you have to get an “Object Key” from service.sap.com

But you can try with following steps without getting the “Object Key”

ORA-12560: TNS:protocol adapter error

ORA-12560: TNS:protocol adapter error
April 09, 2014 | No Comments »

Usually we get this error if Oracle Client dosen’t know which database to connect according to “TNS Alias” information.

To control to status firstly we should check the connection manually over SQLPLUS with the related Oracle user.

RFC Connections , Definations and Status Report for SM59

RFC Connections , Definations and Status Report for SM59
April 08, 2014 | No Comments »

This report helps us too much to get all SM59 RFC entries definations and detail informations even “Connection Test” results

To get this report just we need to do following steps ;

Getting Error While Importing “Client Dependant” Requests

Getting Error While Importing “Client Dependant” Requests
April 07, 2014 | No Comments »

Is it possible to get an error like below while you trying to import client depending requests to your SAP system via STMS mechanism.

“The request’s target Q13.100 is client dependant but the target system cannot handle that”

ORA-01123: cannot start online backup; media recovery not enabled

ORA-01123: cannot start online backup; media recovery not enabled
April 06, 2014 | No Comments »

Sometimes when we trying to start “Online Backup” on our ORACLE/SAP system we get an error like “ORA-01123: cannot start online backup; media recovery not enabled”

For Oracle Version 10g and 11g please use the following syntax on SQLPlus ;

SO21 – SAP Working Directory

SO21 - SAP Working Directory
April 05, 2014 | 4 Comments »

If you going to choose your working directory everytime while transfering the files between SAP sistem and your computer and if its bored you too much , then you can fix your working directory easly with following procedure

Blogroll