Showing posts from March, 2011

HOW TO SAP - Create RFC TCPIP connection and Register Server Program with RFCEXEC

Execute SM59
Expand TCP/IP connections > Click Create

Enter the following details. Ensure connection type is 'T'

Save and click "Connection Test"

You get an error below
Error DetailsError when opening an RFC connection

Error DetailsERROR: program myProgId not registered

Error DetailsLOCATION: SAP-Gateway on host R3DEV / sapgw00

Error DetailsDETAIL: TP myProgId not registered

Error DetailsCOMPONENT: SAP-Gateway

Error DetailsCOUNTER: 40112

Error DetailsMODULE: gwr3cpic.c

Error DetailsLINE: 1871

Error DetailsRETURN CODE: 679

Error DetailsSUBRC: 0

Error DetailsRELEASE: 701

Error DetailsTIME: Tue Mar 29 22:40:17 2011

Error DetailsVERSION: 2

Login to OS level to register the program id to the gateway.

After login, open Command Prompt

Execute rfcexec -a -g -x . Example: Execute rfcexec -a<HPAS2> -g<erpdev> -x<sapgw00>

You will see command prompt hangs in a loop and execute below codes

Now back to SAP. Click "connection test" you will get

HOW TO SAP - Display Output - Condition Records for Billing

Execute VV33
Output type: RD00

Click Key combination
Select Bill.type/Bill To > Execute

Billing type: F2 , Bill-To Party: 101. Execute

Double Click 101

You can then determind the Output Device type from here

In our case, its LP01

HOW TO SAP - Restore MSSQL 2008 R2 Database

** You must have a backup files in order to perform restore.
** We are not recovering up to point in time.
** We do no need tlog files.

Execute MSSQL Management Studio
Right click Databases > Restore database

Enter database name and souce for restore (choose from devices)

Add the *.Bak files. Click OK

Check Restore and click ok

Click Option > Restore the database files as >

Give a path and give file name. REMEMBER:

- 1st first file name must end with *.mdf,
- 2nd and other datafiles are *.ndf
- Log files are *.ldf

Sample as below:

Recovery choose 1st option

Click OK and wait for execution to finish


HOW TO SAP - Change retention settings in ST03

Collector and DB performance > Performance Database > Workload Collector Database > Reorganization > Control

Setting can be change by clicking the "edit pencil"

Standard SAP retention period is 3 months.

HOW TO SAP - Windows 2008 folder unable to delete

You are not able to delete folder/files in Window 2008You have already added your user ID to have "full control"

Right click folder > Properties > Security > Advance > Edit > Replace all existing inheritable permission on all descendents...


HOW TO SAP - Extract Transaction Profile Report with ST03 by month

Execute ST03Change to expert mode and Total > Month > 02/2011

Analysis Views > Transaction Profile > Standard

Transaction Profile for Feb will appear with Transaction name and Background Job

If you want to export the list go > export > local file

Spreadsheet or any format you prefer

HOW TO SAP - Register Developer Key

Go & Request > SSCR Keys

Enter UserID and Installation number

You can find installation number from (SapGui > status > Installation Number)

Once you found your installation number, highlight it and register

You will get your developed key displayed below

HOW TO SAP - Check user performance

Execute STAD

Enter user ID

Select any transaction

You may now see the respond time as below

HOW TO SAP - Stop a transport

STMS > Import Overview >

Select the Queue (SID)

Click Import Monitor (Ctrl+F8)

Right click your transport and delete entry

HOW TO SAP - SAP GUI change color settings

Click customized local layout (alt+12)

Choose Theme "Enjoy Theme". Restart Gui if you are using SAP Logon 720

Click on configure color in system

Change the color and save.

HOW TO SAP - BEX Analyzer authorization check

Execute tcode RSECADMINSelect Analysis tabExecute as ...

Enter Username and check "with log"

Start Transaction

Enter query name


After you see the output, click back twice and view log

HOW TO SAP - Creating Authorization Object in HR

Tcode SU21Browse to HR folder
Create > Authorization Object

Enter the object name and other details from requestor

Click Save

Click Save again and choose package ZBASIS (or ask the requestor)

Then create a new transport and perform transport to QA as needed

HOW TO SAP - SAP Web dispatcher Installation

Login with adm.

Create folder SAPWEBDISP in usr\sap\

Download latest web dispatcher from and save it to above folder

To extract the file > Start > Run > Cmd > Browse to SAPWEBDISP folder

Execute sapcar –xvf sapdispatcher.sar

Create a profile by executing: sapwebdisp.exe –bootstrap

You will be prompted for some details.


http_port : 8100 <-- this might differ, 00 is the instance having a messager server

Unique Instance number: 88 (any number)

Http port number for SAP Web Dispatcher: 80 <-- default port for landing page Create configuration for : medium (default)

Once complete, browse to SAPWEBDISP folder and edit sapwebdisp.pfl

#SAP Web Dispatcher Ports
icm/server_port_0 = PROT=HTTP,PORT=80,TIMEOUT=180, PROCTIMEOUT=3600

# SAP Web Dispatcher Web Administration
icm/HTTP/admin_0 = PREFIX=/sap/wdisp/admin,DOCROOT=./admin,AUTHFILE=icmauth.txticm/HTTP/redirect_0 = PREFIX=/, TO=/sap/bc/gui/sap/its/webgui/!

Manually create a window service to run web dispatch…