SAP NW Newbie

Let us say you have a table (myemployeetable) containing employee names, IDs etc and you are writing a script carrying a variable meant to hold the total number of employees. You can get the total count of employees by running a sql file and assigning the output to this variable. This is however not that straightforward. A sql command outputs a lot of information that has to be excluded when the result value is assigned to the variable. First, you don't want to print column names, so turn the heading off. set heading off Next, in the output, you do not want messages like "x records selected". To do this, turn feedback off. set feedback off Suppress all headers, page breaks, titles etc by setting the page size to 0. set pagesize 0 If you are using a SQL variable, you have to suppress how a variable is substituted before being sent to execution. This is done by turning verify off. set verify off The output of sql command shows "SQL>", this can

SAP Admins have to constantly log in to the server at OS level to carry out their every day tasks. A normal setup of SAP landscapes involves tens and hundreds of servers and logging on to these servers using passwords is error prone or slightly delayed by requiring to access password vaults. A simple solution is to use public-private keys to authenticate the users. You generate a key pair. Keep the private key a secret and upload the public key on the server. Then use the private key while logging on through PuTTY. Because you are keeping Private Key a secret, server accepts connections via the Private Key to recognize you. To set this up we first need to create the key pair Download PuTTYgen  and start it Click on Generate button to generate public and private key pair Move the mouse cursor to generate randomness Save the private key and copy the public key (or save the public key) We now have the key pair Place the Public Key on the server Log on to the s

When you choose to upgrade an SAP system, it may break functionality on connected SAP systems. For example, when you upgrade your R/3 system to ECC, connectivity with SAP XI will not work as it was earlier. Similarly MDM upgrade will have issues if you use SRM-MDM catalogues. A quick check can be made using SAP Upgrade Dependency Analyzer to check if any additional changes are to be made on connected SAP systems.