SAP File System backup using DB13 Friday, November 19, 2010

1) Run Tx code SE16N (Or any utility u like) to edit stanard table SDBAC to add the new Action into DB13

Type -->File
DataBase -->*
OP System -->*
Language -->EN
DBA Action -->File System
DBA Action -->File System Backup
Server -->DBHOST
Exec Mode -->EXT

2) Create OS level Script for taking file system backup using any OS utility here XCOPY
File is saved as H:\test\file.cmd with text

xcopy F:\usr\sap\SID\SYS\profile H:\test

3)Edit table sxpgcotabe as below
Command Name -->ZFILESYSTEM
OP.Sys -->External Program
ANYOS -->H:\test\file.bat

4)Go to DB13 you can see new action as File system Backup
5)For testing execute immediately , later on can be scheduled as needed
6)If you want to have offline backup of file system need to edit script to shutdown SAP and start accordignly .

This can be utilized to schedule file system backup for Java systems specially and also XCOPY options can be explored as it support file sync as well.

Gagan Deep Kaushal

Access SAP GUI using Excel Thursday, November 18, 2010

Process to integrate SAP GUI with Excel sheet , so in case you have number of systems to manage you can maintain passwordless login .

We will Use SAP Shortcut to achieve the same.

Enable Password field

1) open regedit
2) go to HKEY_CURRENT_USER\Software\SAP\
3)Right Click on SAP -->New--> Key with name SAPShortcut--> Then using Same above Step create a key name "Security" under "SAPShortcut"
4)Now Right Click on the Security --> New --> String Value Give name "EnablePassword" to this and Set it Value 1
5) Close window

Create Shortcut

6) Login to SAP
7) Got to Customize Local Layout or ALT+F12 , select create shortcut
8) Provide detail(Password etc) and save somewhere in desktop, we recommended to save in some secure folder as using this shortcut any one can login to SAP GUI without proving password

Integrate With Excel

9) Open excel , type SID or ant description you want to give for shortcut
10) Right click and select hyperlink (Select the shortcut you have created earlier)
11) Save file and then try to access , you will be routed to SAP GUI with couple of warnings , to avoid warning follow below steps

Microsoft Excel Warnings

12) Disable hyperlink warnings for 2007 Office programs

""To disable the hyperlink warnings in 2007 Office Programs when an http:// address, notes:// or an ftp:// address is used, you must create a new registry subkey. To do this, follow these steps:
Click Start, and then click Run.
In the Open dialog box, type regedit, and then click OK.
In Registry Editor, locate one of the following registry subkeys:
NoteYou only have to modify one of these registry subkeys. You do not have to modify both of them.
Note If the Security subkey already exists, skip to Step 6 after selecting the Security subkey.
Click the registry subkey, point to New on the Edit menu, and then click Key.
Type Security, and then press ENTER to name the key.
On the Edit menu, point to New, and then click DWORD Value.
Type DisableHyperlinkWarning, and then press ENTER to name the entry.
In the right pane, right-click DisableHyperlinkWarning, and then click Modify.
In the Edit DWORD Value dialog box, click Decimal, and then type 1 under Value data.

Note A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message.
Click OK.
Exit Registry Editor."

Still you will get one more warning to avoid that

Turn off the "Confirm open after download" option for the file type that you are trying to open

"Double-click My Computer.
On the Tools menu, click Folder Options.
On the File Types tab, select the appropriate file name extension SAP in the Registered File Types box, and then click Advanced.
Click to clear the Confirm open after download check box, and then click OK.
In the Folder Options dialog box, click Close.
Method 2: Modify the HKEY_CLASSES_ROOT\WMVFile\EditFlags registry subkey
Use this method if the warning message affects multiple computers. "

Now enjoy wil shortcuts , but dont forget to update shortcut if you will change your SAP password .

Moreover you can put one extra password for excel sheet also .

We recommend not to use this in any critical system as it can be a security issue.

Gagan Deep Kaushal

SAP Webdispatcher Installation and configuration Wednesday, October 27, 2010

1) Download SAP WEBDISPATCHER executables from service market place under SAP NETWEAVER --> SAP NETWEAVER 04 -->Binary Patches -->SAP KERNEL (32/64Bit, unicode/non-unicode) --> -->Database Independent. Here you can download the kernel packet DW.SAR, this contains the SAP Web dispatcher (sapwebdisp).

2) Create a new directory in G:/usr/sap as sapwebdispatcher

3) Copy files sapwebdisp and icmadmin.SAR into this directory from downloaded DW.SAR

4) Extract icmadmin.SAR using SAPCAR

5) Generation of profile for the first time run command

G:\usr\sap\sapwebdisp>sapwebdisp –bootstrap

6) Then provide input as prompted



Instance number for SAP Webdispatcher = 11

HTTP Port number for SAP WebDispatcher=8011

create configuration for Small(S)

7) It will generate Auth file icmauth.txt

8) Note down the user name and password from that window itself

9) Sapwebdisp.pfl,Add another line for redirecting URLs(Example for EP)

icm/HTTP/admin_0= PREFIX/sap/wdisp/admin,DOCROOT=./admin,AUTHFILE=icmauth.txt

icm/http/redirect_0 = /prefix=/, TO=/irj/portal,port 51100,HOST=EPHOST

10) Now start the WEBDISPATCHER using

sapwebdisp pf=sapwebdisp.pfl - auto_restart

Now we can access portal using webdispatcher server

11) Now we can access portal using webdispatcher server


Gagan Deep Kaushal

RFC Destination export/import using R3trans Saturday, September 4, 2010

This can be used to take backup of RFC destinations before systm copy and can be restored once system copy is over.

1) Login to SAP Server with sidadm user
2) create a file with rfcexp.dat with below mentioned data

Select * from rfcattrib
Select * from rfcdes
Select * from rfcdoc
Select * from RFCSYSACL
select * RSECACHK
select * RSECACTB

3) Run command R3trans -w rfcexp.log F:\rfcexp.dat
4) Export should be over with RC=0
5) For import create file rfcimp.dat with following content


6) Run Command R3trans -w rfcimp.log rfcimp.dat

RFCs should be imported

Gagan Deep Kaushal

SSO between 2 SAP's Java Products Friday, April 16, 2010

Dear All,

Today I am going to share info regarding SSO between two java systems.

* Export the public key certificate of the cryptographic key pair that is used for ticket signature generation out of the store that stores it in JAVA1(EP).

* Import this public key certificate into the store in JAVA2(BI) that stores the certificate of all trusted Single Sign-On parties.

1) TO Export Follow:

Log on as user which has the role system_admin assigned. In the top level navigation, navigate to System Administration -> System Configuration and then in the detailed navigation to Keystore Administration. In the appearing iView click on "download verify.der". The browser will download the DER encoded certificate within a zip file. Unpack it and save the certificate in the file system of your desktop computer.

2) TO Import:
Log on as user which has the role system_admin assigned. In the top level navigation, navigate to System Administration -> System Configuration and then in the detailed navigation to Keystore Administration. Click on the tab "Import trusted".

Click the browse button and select the certificate file you exported. Enter an alias of your choice (e.g. cert_from_JAVA1, in order to keep the system administer able choose a name that allows you to recognize afterward from which system this certificate came).

That is all, and its applicable for EP 6.0.

For details of others SAP Products YOu can Check Note 711769

Rock On!!!

Gagan Deep Kaushal

Oracle on Windows Server 2008 Thursday, April 15, 2010

Its Nice to have experience for installing oracle on windows server after long time, more over it was windows server 2008 , so something new was expected ...Here we go

First surprise was we cannot install the Oracle version and then
install patchset or

So what to do now!!! No problem , not a big deal we have to install the Oracle Version It is currently available on the SMP DVD number is 51036975.

Dont forget to read SAP Note 1303262 - Oracle on Windows Server 2008

Hope it will help you .

Sap Pandit

Java systems appear with clients in Solution manager SMSY Monday, April 12, 2010

Dear All,

Recently we have upgraded to Solution manager EHP1, and we faced a issue after this.

Error: After creating a system in SMSY as java component(ABAP+JAVA), we are not able to use the system in logical component if i am selecting java component.

It will show java system with clients,even though no clients exist. We are then unable to use these systems in quality gate management.

Below Note will resolve the problem

Also you need to perform this manual activity

Create messages 90 and 91 in the message class SOLAR_SPROJECT with the following texts:
Message 90: No communication system for system &1
Message 91: No RFC destination for communication system &1
Use transaction SE91 to create messages.

It should be resolved .

Sap Pandit


The articles here are based on my own experiences in using and learning BASIS . All resources related would be mentioned in every article.

Feel free to gave critics, correction, or encouragement. Any comment or question are welcomed.

Gagan Deep Kushal