SAP Basis Notes: June 2008

Implementing SAP ERP Sales and Distribution free download

implementing-sap-erp-sales-and-distribution

This book is designed to help you in implementing the mySAP ERP Sales and Distribution (SD) module. It is a compilation of notes, tips, and tricks I have learned in various implementations while on assignment in over 17 countries. After completing these projects I found myself with a whole spectrum of knowledge, gleaned from day-to-day investigations and tasks as well as from the wonderful individuals I have had the pleasure of working with. This, coupled with the new functionalities released by SAP since the first publication in 2000, as well as the numerous requests by associates friends and colleagues forced me to compile this new version of how to implement the Sales and Distribution module of SAP

Download from Rapidshare or Mediafire.

SAP Netweaver Installation free download

Contains Audio and PDF File

Audience

SAP NetWeaver developers with little or no Basis experience
Basis beginners or experts
Newbies taking their first steps into SAP NetWeaver
Prospective or recent SDN Subscribers

Goals and objectives

Make a complicated process straightforward
Explore concepts to the level necessary for an SDN Subscription Installation
Note differences between an SDN Subscription and a trial version

Download from Rapidshare or Mediafire.

XI - Create Message Mapping

XI - Create Interface Mapping download

XI - Create Interface Mapping

XI - Assign Interface Mapping to Interface Determination

Beginners SAP XI Material free download

Beginners SAP XI

Download part 1

Download Part 2

High Availibilty guide - SAP XI Material free download

Download here

How to configure message level security in SAP XI Material free download

Download here

SAP Solution Manager E2E Root Cause Analysis : Diagnostics Agent Setup Guide free download

Download from Rapidshare or Mediafire.

SAP Virsa Guides free download

Virsa Access Enforcer™ (User Guide, Configuration Guide, Installation Guide, ABAP Component Installation)
Virsa Compliance Calibrator™ (User Guide, Installation Guide, Security Guide,
Virsa Firefighter™ (User Guide, Installation Guide for WAS 6. 4 & 7.0, ABAP Component Installation)
SAP GRC™ Access Controls (Product Migration)
Virsa Role Expert™ (Installation Guide for WAS 6. 4 & 7.0, Configuration and User Guide, ABAP Component Installation)

Download from Rapidshare or Mediafire

UPDATE: Check OSS Note 865109 for Installation Instructions.

How to create hierarchy in SAP BW

Before you can create a hierarchy for an infoobject, say cost center, you must first ensure that the infoobject supports hierarchy. So in the infoobject change screen, choose the hierarchy tab and select "with hierarchies":

Save/Activate etc usual stuff. Now, go back to the infobject catalog directory, right click on the infoobject and choose create hierarchy:

And walla. You'll get to the hierachy screen, and can add nodes and such. But to make things much easier, I recommend using flat files upload to load your hierachy from excel.

How to Patch SAP JAVA Applications ?

This is deployed using the tools SDM. (/usr/sap/SID/instance/program/RemoteGui.sh) The default password for the SDM tool is “sdm”. In Offline Deployment, the Java instance has to be stopped before SDM is started while in online deployment it can be deployed online.

Sometimes the files come with the extension filename.sca.zip just rename the file as filename.sca (or sda) and then deploy.

JAVA Application Server sometimes requires SAPINST tool to apply the patches, Then
1. Stop all instances of SAP except the CI
2. Deactivate all server process except one (server0 should alone be active)
3. Make the instance in SAFE mode from Config Tool.
4. Start Patching using the sapinst tool, possibly by keeping the instance in SAFE Mode.
5. Start Patching the Java application in CI.
6. Start Patching applications for other server nodes.

SAP NetWeaver Installation Steps (NW 640)

1. Before that download the installation guide from the http://service.sap.com/instguides and read it properly before the installation is started.
2. Prepare the OS as described in the installation Guide.
3. Install ABAP Central Instance (CI)
4. Install Database (chose the number of parallel process at an optimal level (which can be maximum up to 8, default is 3). It depends on the system resources (processors and memory in the Server).
5. Install additional Dialog Instances ABAP
6. Client Creation (using Tx Code SCC4) (UID/Password : sap* / pass)
7. Client Copy from 000 to a new client. (There will only be 2 clients initially after a fresh installation. 066 and 000).
8. Install an Add-on Java to Central Instance (CI) to the newly created client (java has no client concept in JAVA Stack), here it will install the Central Service (CS) instance (MS, ES) and also will install Dispatcher, Server process and SDM.
9. Install Add-on Java to other ABAP Dialog Instance (It will install only Dispatcher and Server process) also note that only one Server process (server0) will created when the instance is initially installed, for scaling up a new server process (server1) can be added separately after installation.
10. Decide on the Option of User Management, it could be either centrally or distributed.
Central – can be handled in the ABAP stack. (using Tx Code SU01 / PFCG) and distributed would use Java’s User Management Stack (UME) for user management.
11. Changes to JVM parameters to the Java Stack (dispatcher, server process(es)) are made after installation. The first step in the post installation steps is to run the template Configurator. It will set the SAP recommended JVM parameters setting for Java Stack.

Template Configurator is found in the path :
(/usr/sap/SID/SYS?global/TemplateConfig/cfgtemplategui.bat) or http://hostname:javaport/nwa -> Deploy and Change.
It is done individually for each of the instances immediately after the ABAP installation.

Is it possible to add a Java Stack alone, without ABAP in a ABAP+JAVA installation scenario. ?
In an ABAP+JAVA stack combined (java add-on to ABAP stack) installation, it is not possible to install java stack (individually, without ABAP stack) in any instance or in any host. So any additional instance of Java Stack can only be installed as an add-on to a fresh ABAP stack .i.e. both have to be installed together. For scaling up java stack a further server process can be added, BUT ABAP stack alone, without JAVA Add-on, can be installed.
A new Server process can be added by Logging into “ConfigTool” “Current Instance” -> Select the Option “Server” -> “Add”

Difference in 6.40 and 7.00 installation steps.
In 7.0 we have to choose a particular installable component during initial steps based on the Client requirement (installation scenario). ie. If the client’s requirement is of installing EP, the nEP alone will be selected for installation. Since EP requires only NW Java Stack, it will install only Java Stack with EP component. Further it will combine CI and DB installation in one step, while 6.40 had two separate steps for CI and DB installation. In ABAP+JAVA Stack installation, In NW 7.0 it will automatically create three clients 000, 066 and 001 and java stack will be automatically added to 001 client. While in 6.40 ABAP will be installed first then a fresh client has to be created and then JAVA stack is installed as an add-on to the fresh client.

Kindly note that In 7.0 after installation if the Client to which Java Stack is added as an add-on, has to be changed, then it is possible by making a few changes. The changes can be made by using Visual Administrator to change the Client Number.

SAP JAVA Add-on Installation Error

Problem:
During Installation of SAP Java Add-on in an ABAP+JAVA SAP Installation on a Windows Platform, the below error is quite common.
Error:
ERROR 2007-12-04 12:09:34
FSL-02107 Path component contains reserved character (’”‘): “G:

ERROR 2007-12-04 12:09:34
FSL-02106 Path contains reserved character (’”‘):
“G:\usr\sap\SID\

Solution :
Run REGEDIT from
1. Check for the entry “G:\usr\sap\SID\” in the REGEDIT and remove the ‘”’ (quotes).
2. Expand the Tree (My Computer -> HKEY_LOCAL_MACHINE -> ControlSet001 -> Services -> SAPSID_nn (SID = System ID, nn=Instance Number)
3. Change the values “G:\usr …” by removing the ‘”’ Quotes.
4. restart the Installation.

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 ??

Well, actually SAPLPD package on SAPGUI for Windows is duplicate Linux’s LPD flow. It is using same architecture and working method. Since Linux already had it LPD (and CUPS), it doesn’t need SAPLPD anymore. You can use LPD (and CUPS) to replace SAPLPD function.

SAPGUI for Java on Linux can use U : Print Using Berkeley Protocol acces method. Fill the Host printer column with name of your printer defined on your Linux PC. Use simple name and no space. On Destination host, fill with IP address of your Linux PC where your printer attached.

After that, open your inetd.conf file and add this at the end of lines.

printer stream tcp nowait lp /usr/lib/cups/daemon/cups-lpd cups-lpd

and you need to restart your inetd daemon or reboot your PC.

If you are using xinetd.conf, please add this at the end of lines.

service printer
   {
       socket_type = stream
       protocol = tcp
       wait = no
       user = lp
       server = /usr/lib/cups/daemon/cups-lpd
   }

Restart your xinetd daemon.

Before you print your SAP R/3 documents, please make sure your LPD (and/or CUPS ) daemon is running well.

Now, you can test your SAP R/3 documents printing. It should work.

Let me know if it doesn’t work. I’ll try my best to update this tutorial.

Daily SAP Basis job log to be monitored Using DB14

SAP provides an excellent DBA tools (for Oracle DB) which is called BRTOOLS. BRTOOLS is a compilation tools range from BRBACKUP (tools to maintain backup database), BRARCHIVE (tools to maintain archive files backup), BRCONNECT (tools to maintain checking database, updating database statistics, etc), BRRESTORE (tools to maintain database restoration), and some specific and useful tool.

When SAP Basis running one or more tools from BRTOOLS, it will create a job log to provide SAP Basis some information about BRTOOLS activities whether it succeed, succeed with warning, or failed. We can access those log from SAP R/3 through SAPGUI.

SAP provides DB14 tcode for SAP Basis to access those database logs. Through this article, I’ll show you how to monitored your database logs.

First, type DB14 on your SAPGUI screen. You’ll have this screen :

To check your BRCONNECT logs, just click BRCONNECT button.

You’ll see some logs. The one which coloured grey is BRCONNECT job that had run well or successfully. The other one which coloured yellow is BRCONNECT job that had run but ended with warning. If your BRCONNECT job hadn’t run well then it will show you red coloured log. To see what’s really happened, justdouble click one of i logs.

For more detailed information, click Detail Log button.

For BRBACKUP job log, you can click BRBACKUP button.

For more information about BRBACKUP activities, double click on one of its log.

To get more detailed information, click on Detail Log button.

For BRARCHIVE log activities, click on BRARCHIVE button.

For detailed information, just double click on one of its lines and you’ll get this screen.

For detailed information, you have to click Detail Log button.

SAP through Going Live Check event will check this log to make sure that your SAP production system is ready to go live. They will mention and warn you if something wrong with your backup configuration. So, make sure that you’ll have this log check every day to make your system has high availability and minimize your SAP production downtime.

Extending your SAP R/3 tablespaces

I am glad that a lot of Basis visiting my blog, asking me about Basis activity, tips, etc. Based on comments and email about how to extend SAP R/3 tablespace, I try to post this little notes. On this little tutorial, I am using Windows based SAP R/3 and Oracle 9.2. You can do it on UNIX based. Of course using different user. When you using UNIX based R/3 system, you have to use ora[sid] user.

Type BRTOOLS to enter BRTOOLS menu.

Choose menu number 2 by typing 2 and then ENTER.

There are many menus on SPACE Management including Extend tablespace, Create tablespace, etc.

Type 1 to Extend tablespace. To get information about tablespace list, you can use DB02 on your SAPGUI screen. For this tutorial, I want to extend PSAPIDS tablespace.

Type c to continue this step.

On this screen, you can see information about last added tablespace including datafile size, datafile name, etc. I use default (datafile size about 2470 MB). Type C to continue.

If you want to add more datafile, you can specified now by typing y. Right now, I just want to add 1 datafile so I type c.

Extending tablespace process is running.

Tablespace PSAPIDS has been extended successfully. Type c to continue.

Back to BRTOOLS menus. Type 9 and ENTER to exit BRTOOLS program.

To check your new datafile has been added to your tablespace you can use DB02 and then press REFRESH button.

Now, you can extend your tablespace easily and have a nice day.

NB : You don’t need to shutdown your SAP R/3 system or Oracle DB to extend tablespace. You can do this online while your SAP R/3 system and Oracle DB running.

Simple Table Reorganization for SAP R/3 using BRSPACE

SAP R/3 are ERP software that relied on database performance to support its performance. High performance database directly effect on SAP R/3 system performance. One of activity that effect on its are table reorganization. Reorganization improves the structure of the database and can result in improved database performance. BRSPACE performs the reorganization using the new Oracle feature, online table redefinition. The following graphic shows some of the reasons for reorganization:

One of the reason to reorganization are that large disk and RAID system with large and secure memory buffers reduce I/O hotspot. You can check more about reorganization for SAP R/3 here.

I’ll use my Windows box and use [sid]adm user. For Unix box user, use ora[sid] user. Let’s do simple table reorganization here. Open your MS-DOS prompt.

Type > brspace -f tbreorg -t MSEG

Explanation :

-f means function to do table reorganization
-t means refer to table name. On this tutorial, MSEG table.

Type ENTER.

Additional option available for table reorganization. Just accept default option. Type C to continue.

Table reorganization is running.

Table reorganization has been completed succesfully. Type C to continue.

Now you can try to reoganization simple and little table. This tutorial only show you simple and online reorganization. Be carefull when you are using it. Test it first on your Develop system or Test system.