Archive for March, 2014

MASS User Creation for SAP

MASS User Creation for SAP
March 31, 2014 | No Comments »

If you need to create a lot of users in one time period on SAP system then you can follow the quick steps below ;

Goto tcode SU10 and input the user names which you want to create in one time

CG3Z and CG3Y UPLOAD and DOWNLOAD files to/from SAP

CG3Z and CG3Y UPLOAD and DOWNLOAD files to/from SAP
March 30, 2014 | No Comments »

We can DOWNLOAD any files from SAP system and UPLOAD any files to SAP system with easly via GUI screen.

Let’s check how can we do this ;

Leave Transport Request in Queue for Later Import

Leave Transport Request in Queue for Later Import
March 29, 2014 | No Comments »

If you import a SAP request via STMS with option “Leave Transport Request in Queue for Later Import” then you will see a yellow triangle in your STMS queue and it’s mean that you can transport this request again when ever you want…

Checking the Password Status of Standard SAP Users with SAP Report

Checking the Password Status of Standard SAP Users with SAP Report
March 28, 2014 | No Comments »

For AUDITING operations , passwords are very important issues especially for SAP standart users..

We can use the following report for checking the SAP standart users situations

LOCK or UNLOCK SAP Users from Database Level via SQLPlus

LOCK or UNLOCK SAP Users from Database Level via SQLPlus
March 27, 2014 | No Comments »

If we can reach the SAP system from database via SQLPLUS tool then we can lock or unlock any SAP users without the SAPGUI

Let’s look a little bit closer with some examples ;

STMS “NO_IMPORT_ALL” Option

STMS  "NO_IMPORT_ALL" Option
March 26, 2014 | No Comments »

If you want to eliminate some possible accidents while using STMS system like importing all waiting requests to PROD system then we should activate “NO_IMPORT_ALL” parameter immediatly..

How to Reset SAP* Logon Password

How to Reset SAP* Logon Password
March 25, 2014 | 2 Comments »

If we don’t know any user’s password even SAP* , then we have to open “SAP* logon option with DEFAULT password” to logon related SAP system and Client.

To do this follow the steps below ;

BR0970W Database Alert type: CRITICAL_TABLESPACE : MAX EXTENT

BR0970W Database Alert type: CRITICAL_TABLESPACE : MAX EXTENT
March 24, 2014 | No Comments »

After DB13 – CHECKDB operation we could see the message like below ;

“BR0970W Database administration alert – level: WARNING, type: CRITICAL_FILE, object: N:\ORACLE\SID\SAPDATA3\ROLL_3\ROLL.DATA3, value: (max_extn) 146021 KB (> 111239 KB)”.

SAP Transaction Status is : LOCK or UNLOCK ?

SAP Transaction Status is : LOCK or UNLOCK ?
March 23, 2014 | No Comments »

As you know that we can LOCK/UNLOCK a transaction via tcode SM01 easly …. but if want to see which transactions are in LOCK or UNLOCK situation then we should run the following report to get this information.

Sending “Private Message” to users on SAP system

Sending "Private Message" to users on SAP system
March 22, 2014 | 1 Comment »

If you want to send a private popup message to specific user then you should use TH_POPUP function on SAP system.

CREATE and DROP TEMPFILE from ORACLE Database

CREATE and DROP TEMPFILE from ORACLE Database
March 21, 2014 | No Comments »

In this section you will find how can we CREATE and DROP tempfiles from ORACLE database

For an example , what we can do if a TEMPFILE was deleted wrongly from the operating system level ?

Password was not used for a long period and therefore deactivated

Password was not used for a long period and therefore deactivated
March 20, 2014 | 2 Comments »

If you exceed the parameter value for your logon period for the SAP system which you activated the parameter “login/password_max_idle_productive” , then you will get the logon message like below ;

Check Version Information of Oracle Database

Check Version Information of Oracle Database
March 19, 2014 | No Comments »

We can easly find our ORACLE database version via SAPGui like below ;

SAPGUI –> System –> Status

SAPGui HISTORY Problem

SAPGui HISTORY Problem
March 18, 2014 | 7 Comments »

If a user complain about his/her history problem for commands , programs or transaction codes on SAPGui, then we should control the following steps..

1 – SAPGUI –> Options –> Local Data –> History

SMTP Configuration for SAP Systems

SMTP Configuration for SAP Systems
March 17, 2014 | 2 Comments »

Here are the simple steps for SMTP configuration on SAP Systems…

1 – Activate the following profile parameters on SAP system via RZ10 tcode

Create “SAP Service” Manually on Windows Systems

Create "SAP Service" Manually on Windows Systems
March 16, 2014 | No Comments »

Lets check creating SAP Service manually on windows systems..

1 – run “sapstartsrv -t” command where your SAP EXECUTABLE  files located.

Adding TEXT to SAP LOGON Screen

Adding TEXT to SAP LOGON Screen
March 15, 2014 | 4 Comments »

We can eliminate a lot of wrong operations with adding the information texts to SAP LOGON screens.

We just need to do following steps for this….

SUSPEND and RELEASE SAP Background Jobs

SUSPEND and RELEASE SAP Background Jobs
March 14, 2014 | No Comments »

If you would like to suspend all SAP background jobs for some reason for example maintenance on the system or upgrade project, then you can use the following steps easly …

Oracle Database Backupmode Control

Oracle Database Backupmode Control
March 12, 2014 | No Comments »

We can check our database’s tablespace or datafile status is in BACKUPMODE or Not with the following sql syntax ;

Activate “Paramater Change” Option for TCODE : RZ11

Activate "Paramater Change" Option for TCODE : RZ11
March 11, 2014 | No Comments »

As you know RZ11 tcode just for display the system parameters and we cannot change any parameter on RZ11 but we can activate “Parameter Change” option for RZ11

“RFC Server Program” Registration on SAP

"RFC Server Program" Registration on SAP
March 10, 2014 | 2 Comments »

We will see how we can register a “RFC Server Program” on our SAP system.

We can register an RFC Program via SAP GATEWAY mechanism and this mechanism always stay active for receiving “RFC Call Requests”

Unlock J2EE_ADMIN User

Unlock  J2EE_ADMIN User
March 09, 2014 | 2 Comments »

If  J2EE_ADMIN user is in locked situation what can we do ?

First of all we should check our system is “Dual Stack” or “Single Stack”

PING Operation Over the SAP System

PING Operation Over the SAP System
March 08, 2014 | 2 Comments »

We don’t need to connect SAP system over the Operation System level for any PING operation.

We can do this process on SAPGui with steps below.

1 – Go to tcode ST06 and choose “Detail Analysis Menu”

Blogroll