BASIS TIPS AND TRICKS

Executing an OS command
Use report RSBDCOS0

Using Transaction variants
Change SAP standard screens by hiding fields, screens, tabstrips, changing field properties, ... read on
Show all users per Application server
Transaction AL08

To log a user off via an ABAP
CALL 'SYST_LOGOFF'.

Advanced SM04 program
The following program displays the Ip address , workstation name , Nt user name etc. Plus you can send instant messages to users just by clicking on the user name. It will show a red band for users who exceeds session limit. ( That you can adjust ). Created this for R/3 4.6C and above. (Submitted by Joy Ramachandran) - Click here to download zuser.txt

Changing the SAP Logo on the top right of the SAPGui
Change file sapalogo.bmp in directory C:\Program Files\SAP\FrontEnd\SAPgui\themes\default (SAP 4.6C)

Changing the Logo on the Right Hand Side ( Courtesy of: http://sapr3.tripod.com )

Transaction code - SMW0X - Binary data for WebRFC applicationHit EnterClick ExecuteClick Settings -> Maintain MIME typesClick the Create buttonFill in :- TYPE : image/gif EXTENSION : .GIFClick SaveClick Back to the Binary data for WebRFCClick CreateFill in :- Obj. name : ZXXXX.GIF Description : Company LogoClick Import and specify the filename where your GIF file is located.File type is BIN. Finish press the Transfer button.If successful, your logo will be shown in the Binary data for WebRFC.Transaction codeSM30 - Table/View - SSM_CUSTClick MaintainClick New EntriesName Value to be setSTART_IMAGE ZXXXX.GIFRESIZE_IMAGE NOLogoff and Login again
Automated transports

1. Create table ZTRAN in the data dictionary. The program will write the log in this table.Name ZTRAN Transparente Tabelle
Kurzbeschreibung Tabelle für Protokollierung Auto-Transportaufträge
Letzte Änderung DZVONYAR 22.10.1997 Mastersprache D
Status aktiv gesichert Entwicklungsklasse ZZDZ
--------------------------------------------------------------------------------
AusliefKlasse A Anwendungstab. (Stamm- und Bewegungsdaten)


Feldname Key Datenelem. Typ Länge PrüfTab Kurzbeschreibung
ZAUFTRAG TRKORR CHAR 10 * Korrektur/Transportauftrag/Com
ZZIELSYS TARSYSTEM CHAR 10 * Zielsystem der Korrektur
ZZIELMAND MANDT CLNT 3 * Mandant
ZSEND_NAM SO_SND_NAM CHAR 12 Sender: Name.
ZDATUMBEG ZDATUMBEG DATS 8 Datum vom Anfang des Autotrans
ZTIMEBEG ZTIMEBEG TIMS 6 Zeitpunkt vom Anfang des Autot
ZDATUMEND ZDATUMEND DATS 8 Datum vom Ende des Autotranspo
ZTIMEEND ZTIMEEND TIMS 6 Zeitpunkt vom Ende des Autotra
ZRETCODE ZRETCODE CHAR 4 Returncode des Transportes
2. Create the next programs in the system.
Program ZZDZTRAN
Include ZZDZTRA1
3. Create user TRANSPORT
4. Schedule program ZZDZTRAN to run periodically under user-id TRANSPORT as shown:
Job name
AUTOTRANSPORT_C30
AUTOTRANSPORT_P30
Job class
A
A
Job frequency
10 Min
10 Min
Program name
ZZDZTRAN
ZZDZTRAN
Parameter
C30
P30
C30: Test system
P30: Production system
5. Send a mail in the following format to user TRANSPORT :
Title
Must be started with the next string: @4A@
(It will be displayed later as the transport icon.)
Body Zeitpunkt SS:MM <- Hier evtl. Zeitpunkt eingeben!

Auftrag Ziel ! DIESE ZEILE NICHT ÄNDERN!
System Mand ! DIESE ZEILE NICHT ÄNDERN!
--> BEGINN ! DIESE ZEILE NICHT ÄNDERN!
xxxK90xxxx xxx xxx Kommentar
xxxK90xxxx xxx xxx Kommentar
...
xxxK90xxxx xxx xxx Kommentar
<-- ENDE ! DIESE ZEILE NICHT ÄNDERN!
Zeitpunkt SS:MM = Time hour:minute ( The request will be imported later than hour:minute)
Auftrag = Change request
Ziel = target
Mand = Client
Kommentar = Comments
DIESE ZEILE NICHT ÄNDERN = DO NOT CHANGE THIS LINE
Fill out SS:MM and all the x-es as required.

The program will read the mail and import the change requests into the target systems.
Peter Dzvonyar
To find out transports released from a specified system in the last specified number of days using in the specified transport directory.
Command line parameters are:Number of days: $1Source system : $2Transport dir : $3 (if different from /usr/sap/trans)#!/bin/sh
if [ $# != 4 ]
then
echo "Incorrect usage. Usage: $0

"
exit 0
fi
NUMBER_OF_DAYS=$1
SOURCE_SYSTEM=$2
DIR_TRANS=$3
OUTPUT_FORMAT=$4
echo "Listing the transports released from ${SOURCE_SYSTEM} in the last ${NUMBER_OF_DAYS} days"
DATADIR=${DIR_TRANS}/data
LOGDIR=${DIR_TRANS}/log
COFILEDIR=${DIR_TRANS}/cofiles
TEMPFILE1=/tmp/tempfile1
TEMPFILE2=/tmp/tempfile2
find ${DATADIR} -name "*.${SOURCE_SYSTEM}" -mtime -${NUMBER_OF_DAYS} -print awk -F'R' '{print $2}' awk -F'.' '{print $1}' > ${TEMPFILE1}
if [ ${OUTPUT_FORMAT} = 'E' ]
then
echo "Transport Source system Exported on Import date Import time"
echo "--------- ------------- ----------- ------------- -----------"
fi
cd ${LOGDIR}
for TP in `cat ${TEMPFILE1}`
do
echo ""
var1=`ls -l ${DATADIR}/*${TP}* awk '{print $6" " $7" " $8}'`
if [ ${OUTPUT_FORMAT} = 'W' ]
then
echo "${SOURCE_SYSTEM}K${TP} Exported out of ${SOURCE_SYSTEM} on ${var1}"
echo "-------------------------------------------------------------------"
fi
ls -1 ${SOURCE_SYSTEM}I${TP}* > ${TEMPFILE2}
for LOGS in `cat ${TEMPFILE2}`
do
var2=`ls -l ${LOGS}* awk '{print $6" " $7" " $8}'`
if [ ${OUTPUT_FORMAT} = 'W' ]
then
echo "Imported to `echo $LOGS awk -F'.' '{print $2}'` on ${var2}"
else
#echo "Transport ${SOURCE_SYSTEM}K${TP} Exported from ${SOURCE_SYSTEM} at ${var1} & Imported to `echo $LOGS awk -F'.' '{print $2}'` on ${var2}"
echo "${SOURCE_SYSTEM}K${TP} ${SOURCE_SYSTEM} ${var1} `echo $LOGS awk -F'.' '{print $2}'` ${var2}"
fi
done
done