SAP Basis Cafe

SAP Basis Cafe – Exploring SAP R/3 Basis World

Paid SAP Basis Consulting Services

Hi guys,

I am offering Remote SAP Basis Support and Service to your company. No matter your company have dedicated SAP Basis or not, we can help you. Your company could hire me as Remote SAP Basis.

You can check here for futher information.

November 17, 2008 Posted by | CCMS, Database Administration, Installation, SAP, SAP Printing System, SAPGUI | , , , | 7 Comments

Paid Support : Cheap SAP Print Management using Linux Client

My deepest regret that I have to do this in order to support me maintaining this blog since I have to maintain my internet connection. I need to charge to you if you want to get this simple information.

I am offering paid support to Basis who want to implement Linux Migration on workstation so that by using SAPGUI for Java on Linux can print smoothly as well as Windows-based SAPGUI client. On SAPGUI for Windows, you can easily print SAP documents. But you can’t do that when you’re using SAPGUI for Java on Linux.

Sign up for PayPal and start accepting credit card payments instantly.

If you are interested in this solution, please call me on YM : devratt.

September 26, 2008 Posted by | Linux, SAP, SAP Printing System | , , , , , , | 3 Comments

Print SAP documents using Linux

A lot of people keep asking me how to print SAP R/3 documents using printer attached on Linux PC.

SAPGUI for Java is already installed on my Linux PC but I was unable to print any SAP documents ? We can’t use Frontend Printing (F acces method) since there was no SAPLPD program on it. Tell me how ??

Continue reading

August 23, 2007 Posted by | Linux, SAP Printing System, SAPGUI | , , , , , , , , , , , , , , , | 65 Comments

Installation and Configuration of SAPGUI for Java on Linux

Based on many questions in my email inbox, asking how to install and configure SAPGUI for Java on Linux, here I’ll explain it briefly.

Prepare these stuffs before you can proceed to installation :

  1. You have to make sure that your Linux system has been installed with JRE (Java Runtime Environment) from SUN Microsystem ( If you don;t have it, just download it from here. Some of linux distros such as Fedora, Ubuntu, OpenSuSE etc using JRE from GNU called GIJ (GNU for Java). We can’t use this JRE. We need to replaced it. I’ll show you how to changed it later.
  2. Continue reading

August 22, 2007 Posted by | Linux, SAPGUI, Unix | , , , , , , , , , , , , , , , , , | 84 Comments

Oracle 11g Extended Statistics for SAP Tables

Extended Statistics is an attempt to fix one of the flaws in CBO–values of different columns are not correlated.

Let us take an example of two columns in a table. One of the column contain department code and the other contains employee name. Let us assume that there are 10 departments and 3000 employees in our example. In a real life scenario, all the employees do not belong to all the departments, but CBO assumes that is the case and hence it assumes that there are 3000*10 = 30000 combinations of employee name and department code that exist. In reality, it can be between 3000 and 30000 (assuming employee belongs to at least one department and can clock for multiple departments).
Continue reading

November 8, 2013 Posted by | AIX, Database Administration, Linux, Oracle, SAP, Solaris, Unix, Windows | , , , | Leave a comment

Brief Description of SAP Executable

Here is a list of SAP executables that you may find on your SAP systems. If you know of SAP exe files missing in from list, please leave a comment:

R3check                     This is a tool that can check Cluster-Tables for errors.
R3ldctl                        The tool for exporting all table structures to the file system during an OS/DB-Migration.
R3load                        The table import & export tool of SAP during Installation, Upgrade and Migration.
R3szchk                     The tool for determine the sizes of the different tables in the target database during the import in an OS/DB-Migration.
R3ta                             Split large tables for export and import
R3trans                      This is the tool, that does the real work for tp. tp controls the import and export of changes and r3trans does them using scripts, that were generated from tp.
R3trans_164-20000978.SAR     R3trans_164-20000978.SAR’ is a compressed archive with the latest version of R3trans from the SAP Service Marketplace, used when we patched the kernel.
SAPCAR                         SAP Compression and Archiving program Continue reading

November 4, 2013 Posted by | AIX, Change and Transport Management, Database Administration, DB2, HPUX, Installation, Linux, Oracle, Remote Connection, SAP, SAProuter, Solaris, Unix | , | Leave a comment

Blink 182′s song lyric on SAP standard report

Check this on your SAP system (use SE38).

If you’re interested in the lyrics of Blink 182′s song “Obvious” (I am not), have a look at the SAP report RDDPUTJZ_REQUEST_COMP_CHECK3 and scroll down to the bottom :

comm1 = ‘DO NOT CHECK!’.

loop at screen.
if screen-group1 eq ‘CH0′.
screen-input = ’0′.

modify screen.

* Blink 182
* Obvious Continue reading

October 28, 2013 Posted by | SAP | , , , , | 1 Comment

Enable password saving in SAP Logon for Windows

Even though password saving, in SAP Logon for Windows is disabled by default, this can be enabled following the steps listed below:

  1. Open the command prompt by navigating to Start → Run and by typing “cmd”.
  2. Go to the \SAP\FrontEnd\SAPgui directory (in Program Files), through the command prompt.
  3. Create the necessary value in Windows registry by typing:
    sapshcut -register
    An information message will appear.
  4. Open the registry editor, in order to access Windows registry, by navigating to Start → Run and by typing “regedit”.
  5. Go to the HKEY_CURRENT_USER\Software\SAP\SAPShortcut\Security registry key.
  6. Change the value data of “EnablePassword from 0 to 1.
  7. Close SAP Logon and open it again, in case it was open during the whole process.

Relevant SAP Notes: 146173, 103019

October 7, 2013 Posted by | Remote Connection, SAP, SAPGUI | , , , | Leave a comment

Access to SAP ERP via TeamViewer VPN

Accessing a SAP ERP system using TeamViewer VPN, for establishing a virtual private network (VPN) between a local computer and a remote server (partner), is a relatively simple and cheap method. The major prerequisite for the use of TeamViewer VPN is that TeamViewer is installed on both sides with the option “Use TeamViewer VPN“.
Continue reading

October 5, 2013 Posted by | Remote Connection, SAP, SAPGUI | , , , , , , , , | Leave a comment


Get every new post delivered to your Inbox.

Join 652 other followers