Posts

Showing posts from March, 2011

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

Image
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

Image
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

Image
** 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

Completed

HOW TO SAP - Change retention settings in ST03

Image
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

Image
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...


Apply

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

Image
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

Image
Go service.sap.comKey & 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

Image
Execute STAD

Enter user ID


Select any transaction


You may now see the respond time as below


HOW TO SAP - Stop a transport

Image
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

Image
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

Image
Execute tcode RSECADMINSelect Analysis tabExecute as ...


Enter Username and check "with log"


Start Transaction

Enter query name


Execute

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


HOW TO SAP - Creating Authorization Object in HR

Image
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

Image
Login with adm.

Create folder SAPWEBDISP in usr\sap\

Download latest web dispatcher from services.sap.com 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.

Hostname:

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…