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.
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.
If you are interested in this solution, please call me on YM : devratt.
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 ??
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).
Read more »
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 Read more »
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′.
* Blink 182
* Obvious Read more »
How to unlock an Oracle user ?When you want to lock/unlock an oracle user, my suggestion is to user the sql command “alter user” like:
SQL> ALTER USER username ACCOUNT LOCK;
SQL> ALTER USER username ACCOUNT UNLOCK;
In case you need to change the password of an oracle user the recomandation from SAP is to change the password with brconnect.
- Open the command prompt by navigating to Start → Run and by typing “cmd”.
- Go to the \SAP\FrontEnd\SAPgui directory (in Program Files), through the command prompt.
- Create the necessary value in Windows registry by typing:
An information message will appear.
- Open the registry editor, in order to access Windows registry, by navigating to Start → Run and by typing “regedit”.
- Go to the HKEY_CURRENT_USER\Software\SAP\SAPShortcut\Security registry key.
- Change the value data of “EnablePassword“ from 0 to 1.
- Close SAP Logon and open it again, in case it was open during the whole process.
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“.
Read more »