Enterprise Resource Planning Portal ERPGenie.COM Enterprise Resource Planning Portal

   Advertise | BLOG

Web ERPGenie.COM

Home | Vote for us |

ERPGenie.COM -> SAP Technical -> The Home to SAP R3 Basis -> Basis Tips and Tricks

The R/3 Basis system is the platform for all other applications (financial accounting, logistics, human resources management) in the R/3 System.

Quick Links

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 - SMW0
X - Binary data for WebRFC application
Hit Enter
Click Execute
Click Settings -> Maintain MIME types
Click the Create button
Fill in :- TYPE : image/gif       EXTENSION : .GIF
Click Save
Click Back to the Binary data for WebRFC
Click Create
Fill in :- Obj. name : ZXXXX.GIF Description : Company Logo
Click 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_CUST
Click Maintain
Click New Entries
Name                     Value to be set
START_IMAGE      ZXXXX.GIF
RESIZE_IMAGE     NO
Logoff 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: $1
    Source system  : $2
    Transport dir      : $3 (if different from /usr/sap/trans)
    #!/bin/sh
    if [ $# != 4 ]
    then
    echo "Incorrect usage. Usage: $0 <Number of days> <Source system> <DIR_TRANS> <Output format [E]xcel/[W]ord>"
    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 
    From http://www.basisguru.com/ 
    Contributions also by: SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips
    webmaster for http://www.sap-basis-abap.com

    Contact Us | Polls | Add URL | Contribute | About | Privacy | Terms | Feedback | Help!

    Message Board | Discussion Forum | BLOG | Consultants: Post your resume | Companies: Advertise on ERPGenie.COM | Post Job