Thank you very much

Thank you very much!

Steps for Creating Package

How to create transport package in R/3?

Steps for Creating Package:

1. Run the SE80 T-code in the R/3 system.
2. Click on Edit Objects option on the top of the window.
3. Select "Development Coordination" in the Object selection window.
4. Select "Package" radio button and provide the package name(like any name: "BIDEV").
5. Click on "Create" icon.
6. Fill the required details ( Short description, Appli.Component, Software Component)
7. Select "SAVE" Icon.
8. It will generate the10 digit New Transport Request: " BI7K900005"
9. Click on Continue.

Menu Path:
Go to SE80 -> Edit Object (button) -> Development Coordination Tab -> Enter Package name and then press the create button

Transport a SAP Object From Dev to Pro

What is the steps to transport an object using se01 or se09?

After creating a transport request. To Transport a request go to

SE09 (Workbench Organizer) or SE10 (Customizing Organizer)

In the intial screen Check the boxes

1) Modifable (Which are yet to be released)
2) Released (Already Released)

Then press enter

Now in that screen check for your created request by pressing Ctrl+F .
In that request check if it is having any child nodes or not. If it is having any child node then first release it and then only you will be able to release parent node

Releasing a Transport Request:

Put your cursor on Child node and then press F9 or you can see a truck symbol which means for transport in SAP click on that. In the same way after releasing child node release the Parent node also then ask your basis person to transport that request from Development to Quality or Production.



SE09 - Transport Request Release

Transporting from Development to other servers:

Go to the tcode STMS to where you can transport the request from one server to another server. Usually, only the basis person can do this.

SAP Installation Procedure on WIN 2k Adv Server

INSTALLING HARD DISK ( IF U ARE TRYING TO
LOAD SAP ON A SEPARATE HDD)

Connect HDD with cable
Win 2000 installation.
1. Go to bios set up by pressing continuously clicking del on start.
2. change the first bootable device to CD.
3. insert the CD and RESTART system.
4. click any key to boot from CD.
5. click ENTER
6. click ENTER again
7. Click on C ( to continue)
8. click on F8 ( to agree)
9. partitions C: 4197Mb, D 12000Mb, E 6000Mb
10. select C drive
11. click ENTER to install
12. click ENTER again to continue
automatically restarts, set up continues.
13. click on NEXT
14. click on NEXT
15. click on NEXT
16. key RBDC9-VTRC8-D7972-J97JY-PRVMG
17. click on NEXT
18. TYPE no of concurrent connections 9
19. click on NEXT
20. TYPE COMPUTER NAME 46IDES
21. click on NEXT
22. remove IIS (deselect)
23. click on NEXT
24. enter date & time
25. click on NEXT
26. finish

WINDOWS CONFIGURATION
Creating partitions for new disk.
STARTà PROGRAMMESà ADMIN TOOLSà COMP MANAGEMENTà DISK MANAGEMENT
1. right click on unallocated space.
2. click on CREATE PARTITIONS,
3. click on NEXT
4. click on NEXT
5. type 11320 (partition size)
6. click on NEXT
7. click on NEXT
8. type file system NTFS
9. click on quick format
10. click on NEXT
11. click on FINISH
12. again right click on unallocated space
13. repeat the exercise from point 5 but for complete size
note
C drive contains operating system
E/D drive contain 46C software
S drive contains SAP software..

PERFORMANCE
MY COMPUTERà propertiesà advanced à performance optionsàchange,
1. Select S drive.
2. type initial =1600& max =1652
3. click on SET
4. click on OK
5. click on OK
6. click on OK

NETWORK SETTINGS
STARTàSETTINGSà CONTROL PANELà ADD/REMOVE HARD WARE,
1. click on NEXT
2. click on NEXT
3. select ad a new device
4. click on NEXT
5. select (now I want to select from Hardware list)
6. click on NEXT
7. select network adaptors,
8. click on NEXT
9. select MICROSOFT
10. click on NEXT
11. click on NEXT
12. click on FINISH
13. close all windows
14. right click on MY NETWORK PLACES,
15. go to properties,
16. right click on local area connections
17. should be able to see Microsoft loopback adaptor on the screen.
18. select properties
19. select TCP/IP
20. click on properties
21. select ( use the following IP addresses)
22. type IP addresses 198.1.1.1
23. subnet mass 255.255.255.0
24. click on OK
25. select show icon on Task bar
26. click on OK
27. close all windows.
HOST FILE CONFIGURATION
1. go to WINDOWS EXPLORER
2. select C drive, WIN NT, system 32 , DRIVERS, etc
3. double click on HOSTS
4. open with note pad
5. go to end of the page
6. type IP address 198.1.1.1
7. press TAB once
8. type 46cides
9. press TAB twice
10. click on SAVE
11. click on EXIT
12. RESTART sytem
Software contains three folders
1. 46cides ( a. KERNEL, b. ORACLE 817, c.ORACLE PATCHES
2. DB EXPORT
3. SAP GUI

ORACLE INSTALLATION
1. 46CIDESàoracle 817à NTài386àsetup run the set up by double clicking
2. click on NEXT
3. source path …………
destination path : S:\oracle\ora81
4. click on NEXT
5. click on NEXT
6. click on NEXT
7. type GLOBAL DATA BASE NAME : ORACLE
8. click on NEXT
9. click on INSTALL
10. click on OK
11. click on EXIT
12. click on YES
13. close all windows
14. startà programsàadmin toolsà services
15. select ORACLE SERVICES
16. select all ORACLE releated services ONE BY ONE.

ORACLE PATCHES
46CIDESà ORACLE PATCHESàPATCHà DISK1à INSTALLà WIN 32
1. set up (double click)
2. click on NEXT
3. click on NEXT
4. click on INSTALL
5. click on INSTALL
6. click on EXIT

KERNEL INSTALLATION
46CIDESàKERNELàNTà I386à MMC
1. double click on IMMC
2. click on NEXT
3. I agree
4. click on NEXT
5. click on NEXT
6. click on NEXT
7. click on FINISH
46CIDESàKERNELàNTà I386à NT PATCH
1. double click on R3DLLINS
2. click on Ok
3. close all windows
4. RESTART
46CIDESàKERNELàNTà COMMONà
1. double click on R3 SET UP
2. type SAP SYSTEM NAME IND
3. click on NEXT
4. click on NEXT
5. click on NEXT at 85%
6. click on NEXT automatically logs off
7. login and control+alt+del

CENTROL INSTANCE
Startàprogramsàsap system for INDà install CENTRAL INSTANCE
1. click on NEXT
2. type instance no OO,
3. click on NEXT
4. click on NEXT
5. click on NEXT
6. click on NEXT
7. click on NEXT
8. click on NEXT
9. click on NEXT
10. click on NEXT
11. click on NEXT
12. type LOCATION OF KERNEL CD E:\46cides\kernel
13. click on NEXT
14. password AAA
AAA
15. click on NEXT
16. password AAA
AAA
17. click on NEXT
18. select NO LDAP SUPPORTS
19. click on NEXT
20. click on NEXT
21. click on NEXT
22. click on NEXT
23. click on EXIT when finished

DATA BASE INSTANCE
Startà programsà SAP set up system for INDà install database instance
1. click on NEXT
2. click on NEXT
3. click on NEXT
4. click on NEXT
5. click on NEXT
6. click on NEXT
7. click on NEXT
8. click on NEXT
9. click on NEXT
10. click on NEXT
11. click on NEXT
12. click on NEXT
13. click on NEXT
14. click on NEXT
15. click on NEXT
16. type location of CDS for KERNEL : E:\ 46cides\KERNEL
for EXPORT : E:\DBEXPORT
17. click on NEXT
18. password AAA
AAA
19. click on NEXT
20. click on NEXT
21. click on NEXT
22. click on NEXT
23. click on EXIT at 32%
24. log off
25. log in
26. user à ind adm
27. passwordà AAA
28. OK
WINDOWS EXPLORERà C:\USERS\IND ADM\INSTALL\R3 SET UP FILE
1. double clik on R# set up file
2. select database R3S
3. open
4. type pass word AAA
AAA
5. click on NEXT
6. at 91% password AAA
AAA
7. at 93% start MMC
8. click on NEXT
9. at 100% EXIT
10. click on STOP MMC
11. restart system

POST INSTALLATION
E:\apgui320\gui\windows\win 32\setup(double click)
1. click on NEXT
2. click on INSTALL
3. click on FINISH
4. click on SAP logon
5. select NEW
6. type DESCRIPTION : 46CIDES
7. type application server : 46CIDES
8. type system no : 00
9. start MMC


10. close MMC
11. log in SAP
12. client 000, user sap* password 06071992
13. txn code SM28
14. ENTER ( TO CHECK ERROR)
15. RESULT : NO ERROR REPORTED ( in installation)

STMS
Description à Student
Click on SAVE
Go to overviewà transport routes
Select display change mode (second icon)
Configurationàstandard configurationà single system ( main menu)
Click on Enter
Configurationàdistributeàactivate
Click on Enter
F3 (to go back)

RZ 10
Utilitiesà import profiles of active servers
Click on Enter
Click on F3 (to go back)
Profile click on F4
Select INDà DVEMGS00à46CIDES
Select EXTEND MAINTà change
Select create paramaeters9 icon)
Type paramter name : rdisp/max-wprun-time
Type parameter value ; 3000
Copy icon
Go back
Click Yes

CREATE PARAMETER
Paramater name : abap\ field exit
Value ; YES
Select COPY icon, go back à YES
Create parameter
: login/system-client
: 800
select copy iconàgo back à yes
create parameter
:eu/iwb/installed/languages
:EN
select COPY icon – go back à YES
again go back
click on YES
click on SAVE
click on YES
click on ENTER
click on ENTER

(USER CREATION)
TXN : SU01
user : sapuser
select : create icon

address logon data
title go on clicking ENTER no of times
first name initial password : abc
last name repeat pass word : abc

DEFAULTS
Logon language : En
Output device ; LP01
Select : Out put immediately & decimal

PROFILES
Type 1. SAP – ALL
TYPE 2. SAP – NEW
SAVE
Log off from SAP
Login to SAP

type user : sapuser password : abc
new password : abap
repeat password : abap

txn : SALE
IMGàerror handlingàbasic work flow settings
Select AUTOMATIC CUSTOMIZING icon
Go back
Txn 00w4
Select DISPLAY CHANGE MODE icon
Create icon

CREATE
Prefix no 978
System ID IND
Client 000
Click on Save
Local object
Cancel X


CREATE
Prefix no 972
System ID IND
Client 800
Click on Save
Local object
Cancel X

TXN SE 38

Program name : Z FIRST
CREATE
ACCESS KEY : 36687663221261278694
TITLE : DEMO
TYPE : EXECUTOR
Click on SAVE

LOCAL OBJECT
Log off from SAP
Log into SAP
Client : 800
User : sap
Pass word : 06071992

RUN txn SU01 for 000 client


Log off from SAP
Log into SAP
Client : 800
User : sap
Pass word : abc
Click on ENTER
Enter new password : abap
Logoff
Stop MMC

SAP 4.7 Enterprise Install Failure "FRF-00007

SAP 4.7 Enterprise Install Failure "FRF-00007 Unable to open RFC connection"

During the Install of SAP 4.7 Enterprise the installation fails with "FRF-00007 Unable to open RFC connection" when you are prompted to enter the DDIC password.

The solution I found was that you need to stop the install then log ito SAP with the User SAP* with password - "06071992" then change the DDIC password to whatever you want.

Once done restart the install and continue to the stage where you need to install the DDIC password, enter the changed password and the installation will continue without errors.

The only OSS notes related to this was "Press the continue button" and the installation may continue, or restart the installation.

SAP Maintenance transport requests work flow

An example of a basic principle and flow is:-

1. A request for a change is submitted to support team

2. Change is done in DEV (if approved) and tested by support team (limited testing only due to lack of productive data)

3. Change is transported to TST

4. User testing takes place

5. User approves or rejects (giving reasons)

6. System manager approves the change to go into PRD

7. Change is transported to PRD

All transports are done by the support team.

If a change is urgent it is transported straight away, if not they are batched up and done once a week.

The Workflow can be controlled by a software like a Lotus Notes database so you can have a record of approval at every step.

Note :-

The system manager is the manager of the support team. The system "belongs" to him i.e. it is his responsibility and he has the final say on what goes into the PRD system. 99.999% of the time he will approves the change, this is mainly a way of keeping him informed of what changes are happening in the system.

Many companies uses the core modules MM, PP, FI, CO. The problem with transporting single transports is that if it is a program, the complete program buffer is reloaded therefore giving a performance hit. Therefore you tend to leave them and just have one performance hit per week (although most weeks there are no program changes). When you are in production the number of transports will settle down to a reasonable figure. Maybe about 10 transports a week, and most of those are material groups (which, although they are user data, they are classed as customising). This rises if you are doing any modifications or changing business processes etc, but 10 is about quite normal for most.

How To Lock SAP Client

1. How to lock the client from logon
2. How to see the all the users connected per day (with the activities they have done and resource utilization)

I cannot answer the first straight away, but the second questions, there are many available SAP transactions.

use STAT very useful and many options available if you use them correctly.


1. I don't know how how to lock the client, but you can lock the system with "tp locksys " and unlock it with "tp unlocksys ". You can also stop the service, but then noone can login including yourself. However, I had problems with tp locksys when applying some Hot Packages and exporting client. It wouldn't work with system locked. I didn't try, but a simple ABAP that locks and unlocks all the users in table usr02 (with exceptions of yourself, SAP*, DDIC... - ofcourse) might be an interesting idea.

2. STAT transaction


You can lock the system thro "tp locksys" (Transport Utility).
Check the other options of "tp" command for locking the specific client under the system thro "tp help".


With this solution I can lock the whole system, but not specified by client.
Send me in more detail....


There's no way to lock a client.
You have to lock all users from loging in of this specified client.
The way you do is by user administration setting the lock.


We can lock a client using SCCR_LOCK_CLIENT and unlock SCCR_UNLOCK_CLIENT functions.

Once we run this functions with a client as input , that client will be locked/unlocked. Actually this function set flag '' Client is locked temporarly for client copy" in client maintanance menu. And the client will be available for users other than DDIC and SAP*. If you try to login in that client as any user , system gives message that ' Client locked temporarly'..


Is there any t-code to lock a client?

There is no direct tcode to lock a client. the easiest way to lock a client is
1. run tcode SE37
2. type function module name - SCCR_LOCK_CLIENT
3. enter the Client No.
4. execute the function module.

Copy users from DEV to PRD

1. Login to the client in your DEV system from where you want to copy.

2. Execute scc8. Select the profile sap_user.
Specify the target system.
Click on 'schedule as background job'.

3. Specify the background server name i.e. the server name where your DEV system is available.

4. Click on 'schedule job' button.
Verify the things and click on 'continue' button.

5. You will have options to specify the start time.
Specify to suit your convenience.
You can see the log in scc3.

6. Login to the destination client and execute scc6.
Specify the request number which was created during scc8.
You need to specify only one request number. Other(s) will be taken automatically.
Click on 'Prepare import'.

7. Specify the target client and click on 'Import'.
Log can be checked in scc3.

Copy a Client into a Stand Alone System

How to copy a client into a stand alone system?

The scenario is I have a 2 system landscape. I want to copy an existing client from DEV to a standalone system for some demo purposes.

There is an option for Client TRANSPORT which will help you perhaps:

A client transport differs from a remote client copy in that it does not use RFC. Like a remote client copy, however, a client transport is used to copy data between different R/3 Systems.

A client transport consists of two steps. First, a client export extracts client data from the source client to files at the operating system level. Second, the data is imported from the operating systemfiles into the target client.

To perform a client export, proceed as follows:

Log on to the source client. From the R/3 initial screen, choose:

*Tools *(r) *Administration *(r) *Administration *(r) *Client Admin. *(r) *Client Transport*(r) *Client Export*. Select the data to be copied using a profile.

Indicate the target system to which the client will be copied. (The target system must be defined in TMS as part of the transport domain.)

Begin the client export. As copying is a lengthy process, use scheduled background processing. The client export performed in the source system , exports the client data asynchronously bycalling the transport program tp at the operating system level. This export process will generate up to

3 data files at operating system level:

. RT<>; this file contains client-specific data

. RO<>; this file contains Cross-client data

. RX<>; this file contains SAPscript texts

Depending on the type of data selected through the client transport profile, the client copy command

files added to the buffer of the target system are

KOr>; this file is for cross-client data

KTr>; this file is for client-specific data

KXr>; this file is also for client-specific data

The client export change requests are not imported when an Import all takes place. Therefore, you must import these requests into the target client using TMS. You must import the data in the following order: first cross-client data, then client- specific data.

After the import process has completed, post-import activities are required possible for object generation steps. After completing the import, log on to the target client. From the R/3 initial screen, choose:
*Tools *(r) *Administration *(r) *Administration *(r) *Client Admin. *(r) *Client Transport *(r) *ImportEditing*

To display client transport logs, use the Transport Organizer.During client transport, a Repository consistency check can be performed by clicking the RFC system check button in Transaction SCC8. If inconsistencies are detected, a list of the ABAP Dictionary tables definitions missing in the target system is generated. This will help your recognize in advance formal problems that may occur during the import of the source data.

Steps For SAP Client Copy / System Refresh

Before doing a client copy, you need to prepare the following :-

1. Find the source client space with the client size custom program which can be implemented using the rel. note:
Find the space of the client - '0118823'. This will give you the size of the source client.

2. If your are on Unix OS, adjust all the file systems according to PRD file system to fit the PRD client in DEV
client based on space requirements also.

3. You can do the client copy by remote or export/import client.
Remote method is not preferred if you are doing a large client copy.
Do a client export/import.

4. To speed up the export/import, use R3trans export/import for the clustered tables.
Please find the rel. notes related to performance improvements for cluster tables in OSS.

5. Do import and post processing.
Note: Export may take 10 to 20 hr. for 50gb of data
import may take 4 days and post import will take 8 to 15 hr. for 50gb of data. And it all depends on
your system performance.

Please refer OSS rel. notes for the few RZ10 parameters which needs to be set for cluster tables to speed up the process.

Note :-

If it is a fresh installation, do this --

1. SCC4 --> Create client no. and fill other details.
2. Logon to the newly created client with SAP* and PASS as password.
3. SCCL --> choose any profile (preferably SAP_ALL), source client 000 and target client .
4. Preferably do a test run initially to check if it can go well.
5. As a care check space in databases.

What are step and procedure to create a client & to take a client copy from source to target.

By: Kavitha.G

If you are copying from same system then flow the below steps:

1. Create the client in Tcode scc4.
2. Before that create a logical System in BD54.
3. Login in the newly created client with
user Name : sap* and password : pass
4. Use the Tcode sccl to copy the client.if you are not familiar with the client copy. Try a test run and then schedule it in background.
5. You can select the needed profile.
6. To view the log files use the tcode scc3.

If you are using different system then create a rfc connection in sm59.test the connection and then continue from the 1st step
You can also import and export a client. Use scc7 for importing from the client and scc8 fro exporting from the source client

What is system refresh when and why it is done?

System refresh and client copy can be the same thing. Normally when you want to refresh a system this normally means refreshing the clients using a client copy like SCCL or SCC8.

A system "copy" is very different as this is far more involved than a simple "client refresh"

Imagine you have a DEV and a PRD system and after 6 months the data in DEV is very old so you would perform a client copy SCC8 from PRD to DEV using a profile that copies the application data from PRD to DEV - it actually deletes the data and replaces it with data from PRD. If however your DEV system died and needed to be completely rebuilt, you would use "Homogeneous System Copy" - you install the OS, Database and SAP and then process the system copy - which makes a complete copy of PRD (all clients)

Client copy - a single client refresh from PRD to DEV - can be just application data, or user data, or configuration or any combination you choose system copy - all clients 100% copied PRD to DEV

The system refersh is nothing but the deletion of the client and replacing the data from other client. For example : you have clients 100, 200 and 300. Suppose when you want to refresh the client 100 you remove the client 100 and replace it with 200 0r 300 as per your reqiurement. Mostly the refresh of clients will be happen at the time of development stage.

System Refresh is a simplified term to Client Copy. Client Copy means copying the production client on to the quality to test the real data. As recommend by SAP this need to carried out every 3 months.

The process to carry out the same is as follows:
1. Create a client on quality system using txn scc4
2. Create a RFC between Production system and Quality System (need to create on quality system)
3. Login to the newly created client using sap* and pass as a password
4. Txn sccl to start the client copy. You can test the client copy by selecting the test run option. (test run will estimate the time taken for the activity).

Post Installation Task after successful R/3 46c

Generally you need to :-

1. import profiles (default, instance, start) into SAP R3
1.1 add/modify instance parameters such as
rdisp/max_wp_run, abap/timeout,
zcsa/system_languages, and so on...

2. update the R3trans and tp tools with the last ones available on sapnet

3. configure TMS (systems,layer and routes).
You can do it with virtual systems if you have only one SAP system

4. update SPAM/SAINT

5. check via Tcde db02 (with refresh option) the available space for TS other
than SYSTEM TS.( for the others %used must be less than 90)
5.1 check to see critical objects (table/index)
5.2 extend (via sapdba tools -> option TS administration) all TS which
shown critical objectsfor example:
PSAPPOOLD + 200M
PSAPPOOLI + 100M ...
You can get necessary via Note 195446 (for language import) and Note 118823 (for client copy)
5.3 refresh again in db02 and check the %used space

6. import language other than the default (DE & EN) if necessary

7. Client copy

8. configure printer (SPAD)

9. create user

10. change system user password such as SAP* , DDIC, and so on ...

Error you might encounter at the end of client copy :-

"there is a window "change and transport system not configured" Status is cancelled.

To rectify the errors :-

You need to configure CTS via tcde STMS for your SAP system.

If it's your only sap system, then:
- configure it as domain controller: run Tcde STMS and accept the default proposed domain
controller which is your system
- define one or two virtual system (Menu overview-->system then Menu
SAP system-->create-->virtual system)
- Menu Environment --> transport routes then press F5 and Menu Edit
Transport layer to create a "Z" layer for example "ZDEV"
Create a transport route between your real sap system and the virtual system
by using the two layers: "Z" layer and "SAP" standard layer
- save and distribute the TMS configuration

That is the main action you have to do to setup CTS.

Problems with Multi-clients in one SAP Production instance

You are working on group of companies. They don't want to share any data between companies, simply no integration required, therefore mgt wants to have one client for one company that end up having multi-clients in prod instance. However, one of the SAP local guy told you not to continue with this lanscape.

Some of the potential problem of using multi-clients in one prod instance are:

1. problems affecting one client immediately affect all other clients.
an eg.: 1 client runs a job that fills up a tablespace or file-system.

2. a system problem (system crash) affects all clients immediately. e.g. an Oracle archive stuck will affect all clients.

3. programs/tables are client independant. Invidual customers cannot make changes to common programs/client without affecting the others.

4. Poorly written ABAP's will cause bad response throughout the SAP system, affecting all clients. I shudder to think of a situation where the programmer for 1 customer stuffs up and the other customers demand blood!

5. Taking all of this into account, your change management will turn into a NIGHTMARE! especially considering that each customer probably does no care about the other customers, so EVERY change of theirs is the most important one.

The above are some of the problems if you have multi-client in one SAP instance and there are many more arguments.

What is the best way to refresh QA from PRD?

How to make a system copy:

1. Take offline backup of both the server (source and target servers)

2. Verify the backup is successfully done.

3. Run the following command on source system.
a. Login as adm
b. svrmgrl
c. connect internal
d. alter database backup controlfile to trace;
e. exit;
f. Above command will generate a .trc file in /oracle/P01/saptrance/usertrace directory.
g. Copy the text from CREATE CONTROLFILE until the (;) and paste it in to any new .sql or controlfile.sql file.
h. Copy the controlfile.sql to target system.
i. Edit the file and replace the entire source SID to target SID.
j. Edit the reuse database command with the set database command

4. Copy the aft generated during the backup file from the source system to target system. (/oracle//sapbackup)
a. Change all the source to target .
b. Only don't change the backup volume name it must be target system .
c. Copy the above aft file name line from the source back.log to target.log file.

5. Shutdown the target server instance.

6. From this onwards all the command on the target system only.
a. Login as adm
b. run the SAPDBA
c. select J (Restore/Recovery)
d. select B (Full restore and recovery)
e. select A (Select backup of type)
f. Select the offline backup which you want to restore.
g. It will take some time to restore.
h. Once the database is restored login as adm and run the
i. svrmgrl
j. connect internal;
k. startup nomount (if the database is already mounted shutdown it using the shutdown command)
l. run the following command
m. @controlfile.sql (file name of the control file contains the CREATE CONTROLFILE statement)
n. After the run the above command it should give the "Statement Processed)
o. alter database open resetlogs p. shutdown
q. Start the database and SAP services using startup.

7. After this you have to reconfigure the STMS.

8. All the jobs also you have to reconfigure and reschedule.

9. Reconfigure all the printers.

10. If you want to change the Client number then use the local copy tool and remove the original client after successfully import to new client.

Proper way to delete a SAP client

Here goes:

1. log into the client to delete
2. go into SCC5 and delete client
3. log into another client and delete entry with SCC4
4. reorg database to recover database space.

Actually, if you check "on" the little "Delete Entry from T000" checkbox, you can skip step 3.

One other way of deleting a client which could give significant performance gain and save time is at OS level using - R3trans

To delete a client 200, you have to create a command file "del200" with following entries

Clientremove
Client = 200
Select *

Place the command file in /usr/sap/trans/bin

$ cd /usr/sap/trans/bin

$ R3trans –w -u 1

e.g $ R3trans -w del200.log -u 1 del200

To check the progress...

$ tail -f del200

How To Provide All Rights To The User

I have created user id & password by SU01 and menu, roles,authorization. I gave tcode se38 to the user in menu (by PFCG). Now when I tested by giving newly created user id password and when I enter the tcode : se38
and gave the program name and clicked display, it show "no display authorization", how to provide all rights to the user.

Following are the solutions for your queries:

1.) Transaction code SE38 is to created program in SAP, the programs are created or customized only by Developers/Abapers who have Developer Key and an Object key which are called as Acces key,without which no one can write a program in SAP,there is a option to write a program, i.e by login with the user SAPUSER which is default user of SAP which can create a program, because this reason you are not able to display the things with the Tcode-SE38.

2.) All rights to the user can be given by assigning SAP_ALL to the user in the profiles while creating the user.

3.) To assign SAP_ALL to the user, hit tcode SU01 to create a user.

a.) Give the name for the user and select create tab.

b.) First tab Address the Lat name only is mandatory else fill all the details.

c.) Select Logon tab in which Password is important, hence give the password.

d.) Select the Profile Tab-->Give SAP_ALL & SAP_NEW,and save the user.Now the user can access all the tcodes with SAP_ALL profile.

Creating New User With Authorizations

I want to create new user for SAP module. I am having user id as sap* (someone has said that this is super user id); when I login with this id and go to IMG for configurations. A message is displayed that I am not authorised to change the details with sap* user.

What is the procedure for creating new user which have all features define under SAP* user and which could allow me to make the configruations.

Creating new user with superuser authorizations.

1. Goto SU01 --
username : sapuser
|-->Create.

2. In default settings, give
:Mr
first name : sap
lastname : user

3. Goto next tab,
give initial password :1234
repeat password : 1234

4. Goto profiles.
type- sap_all (say enter)
sap_new (say enter)
Then save....
See the message in status bar, (user created successfully)

5. Login with the new user. change the password. now this user contains all superuser authorizations.

How To Compare The Roles

How to compare the roles where created or defined in two different systems?

For role comparision both the roles must be in the same system, in same client

Transaction code SUIM -> Comparision-> Roles

If the roles are in different system, then tranport the role into one of the system and do comparision. If no transport connection defined then, you can use the upload and download option in the PFCG

Steps for Role Comparing:

1. Run the t-code SUIM

2. Go To Comparison and select the option of roles

3. Click on Across systems option it will give option to select the sys name under Remote Comparison there enter the SYS ID between which system you want to do comparison and put the role name in compare role section then execute it will give you the result.

4. If there is any difference b/wn the t-codes it will b in red colour otherwisein yellow.

Query About Tcode PFCG

1. How to check the name of all users who has been authorised to use a particular transaction? I am trying to find through SUIM, but failing to find the name or total number of users of a particular t-code say SPRO.

2. I know that a particular transaction say SPRO is available in a particular role and I want to remove that t-code from that role. But I am unable to find that node through PFCG. If I am using the search for a t-code inside menu tab after putting the edit mode it is not coming in PFCG, but through SUIM its existence is coming in that role. That particular role contains a lot of t-code and reports, say about 2000.

1. Goto SUIM and select USER node, then select USERS BY COMPLEX SELECTION CRITERIA node then execute BY TRANSACTION AUTHORIZATION report then give the Tran. code and it will return you the number of users having that trans with relevatn details.

Follows these steps :-

- Go to SUIM .
- Choose Roles --> By Transaction assignment.
- Enter Transaction : "SPRO"
- Choose execute.
- Double click on a role in which you want to remove "SPRO" authorisation.
- Click on pen mark to change into change mode.
- Go to tab "Authorization"
- Choose change authorization data.
- Choose Utilities --> Technical names on .
- Choose --> cross application authorization objects-->
- Expand the selection for Object "s_tcode" , under the corresponding profile look the values maintained for "TCD" and remove value "SPRO" from the list to eliminate the authorization.
- Don't forget to regenerate profiles.

2. You should able to find this via menu tab otherwise try to do this in authorization tab --> change authorization data by search.

Frequently Asked Questions on Authorization

What is the difference between role and a profile?

Role and profile go hand in hand. Profile is bought in by a role. Role is used as a template, where you can add T-codes, reports..... Profile is one which gives the user authorization. When you create a role, a profile is automatically created.

What is the use of role templates?

User role templates are predefined avtivity groups in SAP consisting of tyransactions, reports and web addresses.

What is the different between single role & composite role?

A role is a container that collects the transaction and generates the associated profile. A composite reole is a container which can collect several different roles

What profile versions?

Profile versions are nothing but when u modify a profile paarameter through a RZ10 and generate a new profile is created with a different version and it is stored in the database.

Is it possible to change role template? How?

Yes, we can change a user role template. There are exactly three ways in which we can work with user role templates
- we can use it as they are delivered in sap
- we can modify them as per our needs through pfcg
- we can create them from scratch.
For all the above specified we have to use pfcg transaction to maintain them.

Personalization Tab Within PFCG

Please expalin the personalization tab within a role.

Personalization is a way to save information that could be common to users, I meant to a user role... E.g. you can create SAP queries and manage authorizations by user groups. Now this information can be stored in the personalization tab of the role. (I supposed that it is a way for SAP to address his ambiguity of its concept of user group and roles: is "usergroup" a grouping of people sharing the same access or is it the role who is the grouping of people sharing the same access?)

How to insert missing authorization? Ways?

su53 is the best transaction with which we can find the missing authorizations.and we can insert those missing authorization through pfcg.

Table of authorisation field settings

Is there a table for authorisations where I can quickly see the values entered in a group of fields?
In particular I am looking to find the field values for P_ORGIN across a number of authorisation profiles, without having to drill down on each profile and authorisation.

AGR_1251 will give you some reasonable info.

Table with deleted users

Someone has deleted users in our system, and I am eager to find out who. Is there a table where this is logged?

Debug or use RSUSR100 to find the infos.

Run transaction SUIM and down its Change documents.

How can I make T_Code SPRO Read Only

I have a requirement to make SPRO read only. As you know it has a tree like structure and to make it read only seems like impossible.

You cannot make SPRO 100% display only by ANY setting. The SCC4 option only turns configuration tables to not-modifyable but still allows the non-config delivery class tables (or those configured to be changeable) to be modifed. It does nothing for the tcodes that are NOT table maintenance and not controlled by S_TABU_DIS. These will still allow configuration. All the tcodes in the SPRO are in several tables CUST_ACTOBJ (spelling?) is one.

You only real option is to create a role with all the tcodes in them that are in the SPRO , remove the create and change to display ( generally by changing the last nunmer on the 4 digit tcodes to 3) and removing all the Create and change access in all the activities and allow only the display.

PFCG allows you to create a role from a SPRO project so the usermenu will come close to the SPRO menu, which your changes it will be display.

Mass Delete of Old Roles

How can i do a mass delete of the roles without deleing the new roles.

There is a SAP delivered report that you can copy, remove the system type check and run. To do a landscape with delete, enter the roles to be deleted in a transport, run the delete program or manually delete and then relase the transport and import them into all clients and systems.

It is called: AGR_DELETE_ALL_ACTIVITY_GROUPS.

To used it, you need to tweak/debug & replace the code as it has a check that ensure it is deleting SAP delivered roles only. Once you get past that little bit, it works well.

How to Check Missing Authorisation for User

How to check the missing authorisation for the user not having the option "/nsu53 ?"

You can use the following procedures to determine which authorizations a user requires to carry out a transaction:

You can use Trace function, ST01, you can trace the user activity and from the log you can see the authorization missing.

Start an authorization trace using the ST01 transaction and carry out the transaction with a user who has full authorizations. On the basis of the trace, you can see which authorizations were checked.

This procedure generally works well. However, sometimes the result is very surprising because certain programs can and do ignore some authorization checks by using preliminary checks and buffered results. In such cases, these methods are not very effective. You can recognize these cases because certain fields of the corresponding programs are specified with * or DUMMY at some point of the authorization check.

Analyzing authorization problems in an unknown program

The most frequently used method to analyze authorization problems in an unknown program involves you setting the Debugger breakpoints to the AUTHORITY-CHECK and MESSAGE commands. Then execute the program and analyze its behavior.

Determining all the authorizations a user has for an authorization object

When troubleshooting, it is often helpful to find out all the authorizations a specified user has for a specific authorization object. A simple method of reading these authorizations as raw data from the user master record is to execute the GET_AUTH_VALUES function module in the SUSR function group. Use the SE37 transaction or SE80 in test mode to do so. The result table is not formatted for output, but is very compact and easy to understand for authorization experts.

Analyzing an authorization problem that occurs for only one user

It is often the case that a certain authorization problem occurs for only one specific user. This kind of authorization problem generally affects users with no Debugging authorization. If you want to assign a user Debugging authorization without changing the HR authorizations, you can add the S_A.DEVELOP authorization profile (if available) to the user’s authorization profiles. In production systems, note that changes such as these to authorizations enable users (with relevant knowledge of the development environment) to access any system data easily (especially in other clients).

Evaluate ITS Server Speed issues

You have 10 users accessing sap via an ITS server (6.20) and it is soooo slow !!! access via sapgui is fast - any ideas what to look for ??

We tested several options for deploying the SAPGUI :-

Tivoli packages
ITS
Citrix MF XP

Tivoli was already built and in house so all we had to do was create a SAPGUI package and deploy it to the field (3000+ users) - pain in the butt because we had to find out all the users workstation id's for the users in 900+ locations. So far we have deployed 35% and our Go-live is 10/01!

ITS - We had an ITS consultant come in and review our setup. We were able to enhance the performance to some extent (20%). But, that was still unacceptable in comparison to the WINGUI that the users are now accustomed to. In short, we scraped the ITS project because of the problems with latency/performance. Our connection between our test locations and the Data Center was 100MB. The other locations were 10MB.

ITS Tuning in relating to performance of the ITS Server

1. HKEY_LOCAL_MACHINE\Software\SAP\ITS\2.0\\Programs\SAPjulep\StaticTemplats
To simulate the test, the parameter for Static Templates was changed from 0 to 1

Recommendation : Development system = 0 ; Production System = 1

2. ITS Parameters / Recommended / Ours

a) Worktreads and Sessions
MaxSessions 400 400
MaxWorkThreads 64 40 (can be reduced)
MinWorkThreads 64 40 (can be reduced)

b) Caching
Caching 1 1
CacheSize 16384 16384
FileSize 1048576 1048576
TimeToLive 31 31
StaticTemplates 1 0
CacheInvalidateHour
CacheInvalidateMinute
Staticflows 1
ProductionMode 1 0
StaticBor 1 0

c) Timeout Parameters
TimeoutPercentage 75 75

d) Debugging Parameters
~rfcDebuggingOn 0 0
~rfcTraceOn 0 0
AdminEnabled 0 0
localTraceLevel 0 0
SAPDebuggerDelay

e) Miscellaneous
MinRespSize 32768 32768
MaxRespSize 2097152 2097152
MaxServiceContextSize 20480 20480
~http_compress_level 7 7
~http_use_compression 1 1

2. Load Balancing and Multiple Agates
IncAGates 1 (Do not modify this value.)
MinAGates (Do not modify this value.)
MaxAgates (Do not modify this value.)
IncWorkThreads 1

3. Windows Environment Settings

4. SAP R/3 Parameters
rdisp/gui_auto_logout >= ~userTimeout

3. Check the following internet option settings.
Under "Advanced", make sure both HTTP 1.1 settings are on
Under "Security", "Custom Level" under the point "micellaneous" make sure these are ENABLE:

a) access the data sources across domains
b) Launch programs and files in IFRAME
c) Migrate sub-frames across different domains

4 Verify Compression. These values were changed in the global.srvc file
~http_use_compression 1
To increase the transmission speed and reduce the overall network load we reduce the size of the data sent from the server to the web browser by using compression. The values are 0 to disable compression and 1 to enable compression.

~http_compress_level 7
The compress level can be set between 1- 9 where 1 is the lowest compression level and 9 is the highest. The higher the value set for ~http_compress_level, the better the compression achieved.

The Level 1 achieves the lowest compression level/ fastest procession speed and Level 9 achieves the highest compression level/slowest procession speed

5 ~navigationenabled : Enables / Disables Drag & Relate functionality in the SAP GUI for HTML.
Using Drag & Relate in the SAP GUI for HTML requires a callback from the R/3 System for nearly every request / response cycle. This is an unnecessary overhead for many applications. Hence we disable Drag&Relate by setting this parameter to 0 in the webgui.srvc file on the Agate.

Citrix proved to be just too expensive an option for right now. The SAP 4.6d protocol proved to be quite thin, with the bandwidth requirements tracking only slightly greater than ICA. However, on a number of occasions over the test period, it was observed that SAP could demand a considerable amount of bandwidth for short bursts. This traffic was primarily outbound, targeted at port 4803. However, even with the thin nature of SAP, ICA still provided a bandwidth advantage.

To better understand this and develop conservative figures, a trend analysis of the data was performed. This analysis allowed for a weighted smoothing of the statistics, lessening the impact of the burst type activities. Based on the trend figures, the following observations where made:
SAP showed an overall Kbps trend average of 2.5 Kbps
ICA showed an overall Kbps trend average of 1.7 Kbps

Overall, ICA showed a 30% improvement in bandwidth utilization when compared to SAP, based on the trend analysis of the data. This margin jumps to almost 70% when averages are analyzed.
The maximum SAP burst activity exceeded the maximum ICA burst activity by 70%.
Both SAP and ICA displayed extremely limited network utilization. Over extended periods, ICA displayed consistently low inbound traffic, trending towards .8

If all you have is 10 users, what's wrong with deploying the SAPGUI?

The ITS environment was initially created with very minimal customized configurations (2 servers Dell 2650's). Most ITS performance parameters were accepted as default. We tested over dual T1's (1.5MB) as well as Ethernet 10/100MB max.

For each request by the webserver, a separate request is made to the backend - so what you get is a constant request/send, even though each one is milliseconds adding hundreds of requests through the WGate to AGate to R/3 you can see there just isn't much you can do to improve the speed.

To help diagnose the network or measure network metrics, we used a program from SAP called “NIPING”. Niping is a test program for the network interfaces (NI) layer. It provides connection and performance test with the same mechanisms that the SAPGUI uses. To test the network, the niping tool runs a continuous test. It generate and evaluate a network trace simultaneously from the ITS server and the front end. We ran several niping tests and the following results were produced.

Since the communication between the client and the Web servers is over the HTTP protocol, SAP-ITS also makes the SAP transactions accessible to distant locations via the Internet, enterprise networks, and virtual private networks. These networks are typically very complex and have many users. As the distance between the nodes and the complexity of the network increase, application performance becomes an important issue. The performance of a network depends mainly on two
different factors - the bandwidth (throughput) and the latency (delay).

Bandwidth is the most commonly known factor affecting performance of a network. Network bandwidth defines the amount of data that can be transferred at a given time. Networks with higher bandwidth provide better performance.

The second factor relating to performance of a network is latency. Latency can be defined as the delay in processing data within the network. A network with lower latency performs better than a network with high latency.

In addition to the individual effects on bandwidth and latency within the network, their combination can also affect the quality of communication, hence determining the overall network performance (network speed).

How does the SAP ITS work?

When an Internet user requests an ITS service by clicking on a URL hyperlink or keying in a URL address in a Web browser to run a IACEWT, the request is processed as follows:

1. The Web browser passes the request to the Web server.

2. The Web server calls the server-specific ITS extension WGate - WGate is the link between the ITS and the Web server. WGate is a Web server extension that encapsulates the various supported HTTP server interfaces such as: CGI (Common Gateway Interface), NSAPI (Netscape Server Application Programming Interface), ISAPI (Internet Server Application Programming Interface) in a transparent manner that passes the requested data to the ITS AGate component.

3. WGate forwards the request to the ITS server process called AGate (which may or may not reside on the same machine.)

4. AGate is the link between the ITS and the SAP R3 application server. AGate is the core processing component of the ITS. It receives Web browser request from WGate and communicates with the SAP R3 application server via the DIAG or RFC protocol.

5. AGate then processes the requests, and sends all relevant details (including logon information) to the SAP R3 system, which either starts the first dialog step of a new transaction of submits further data for the next dialog step of a transaction already started.

6. SAP R3 starts the transaction for the service requested and sends the screen output to AGate.

7. When the dialog step has finished, AGate retrieves the result from SAP R3, and is responsible for session management, including mapping of SAP R3 screen or function modules to HTML, web session timeout handling, SAP R3 connection management and generation of HTML documents that are sent back to the Web browser client.

8. AGate forwards the formatted HTML page to WGate.

9. WGate forwards the formatted HTML page to the Web server.

10. The Web server sends the formatted HTML page to the Web browser, where it can be viewed by the user.

The ITS is downward compatible, therefore the ITS release must be the same or higher than the SAP R/3 kernel release.

There are three restrictions to this approach:

1. The SAP R3 release must be at least version 3.1I or higher.

2. You can only use those Internet Application Components that were shipped with the SAP R3 release you are using.

3. ITS 6.10 should only be installed in front of an SAP E3 kernel release 6.10 (e.g. CRM 3.0)

*** ITS 4.6D Server Platforms ***

>>Wgate
Microsoft NT 4.0 Server
Microsoft Web Server (ISAPI)
Netscape Web Server (NASPI)
Apache HTTP Server (Apache Module)
Any CGI Web Server (CGI)
Microsoft windows 2000 Server
Microsoft Web Server (ISAPI)
Linux/Intel
Apache HTTP Server (Apache Module)

>>Agate
Microsoft NT4.0 Server
Microsoft Windows 2000 Server
SAP@Web Studio
Microsoft NT 4.0 Workstation
Microsoft Windows 2000 Workstation

*** ITS 6.10 Server Platforms ***

>>Wgate
Microsoft NT 4.0 Server
Microsoft Web Server (ISAPI)
Netscape Web Server (NASPI)
Apache HTTP Server (Apache Module)
Any CGI Web Server (CGI)
Microsoft windows 2000 Server
Microsoft Web Server (ISAPI)
Microsoft XP Server
Linux/Intel
Apache HTTP Server (Apache Module)

>>Agate
Microsoft NT4.0 Server
Microsoft Windows 2000 Server
Microsoft XP Server
SAP@Web Studio
Microsoft NT 4.0 Workstation
Microsoft Windows 2000 Workstation
Microsoft XP Server

Understanding SAP ITS - Internet Transaction Server

The SAP Internet Transaction Server (ITS) is the essential link between the SAP R/3 system and the Internet. It enables Internet (and Intranet) users to communicate directly between R/3 system to run R/e transactions, remote enabled function modules and reports as Internet applications components. The ITS is one of the cornerstones of SAP's mySAP.com offerings and strategy and integrated into the SAP 6.10 Web Application Server release. The ITS is the key technology behind the following products: Workplace, Employee Self-Service (ESS), Enterprise Buyer Professional (EBP), BW 2.0 Interface, Online Store and Retail Store, and the APO Interface. There are many other SAP products and applications that are based on ITS technology to interface from the Web to SAP R/3.

SAP ITS can handle complementary Web technologies to access data from SAP R/3:

- SAP GUI for Html: SAP transaction screens are dynamically converted to HTML pages

- Web transactions: SAP transactions that can be called from an HTML page (template based mode)

- Web remote function call (RFC): SAP R/3 function module that can be called from an HTML page

- Web reporting: Mechanism for linking to SAP reports and regenerated lists from an HTML page. Web reporting is implemented as a special-case RFC.

- ITS Flow Logic: Events, statuses, and modes used to model the dialog logic of a Web application in "flow files" on the SAP ITS.

SAP R/3 data is accessed via BAPI or RFC. Access to external data providers is also possible.

SAP's Internet applications are known as Internet Application Components (IAC) or Easy Web Transactions (EWT). Both are complete business solutions that allow Internet and Intranet users to access business information in the SAP R/3 system by starting transactions, function modules, and reports from a Web browser. All IACs or EWTs are based on a common infrastructure consisting of two essential components.

SAP Internet Transaction Server (ITS) - The ITS is the interface between the Internet and R/3 and is the runtime engine that links Web server to the R/3 Application server.

ABAP workbench tool - Web Application Builder and/or SAP@Web Studio - WAB is an R/3 ABAP workbench tool and SAP@Web Studio is a PC tool for creating, modifying and managing all ITS objects on which IACs or EWTs are based. These objects include service files, HTML Templates and HTRC language resource files.

The ITS solution to developing Internet applications is based on the premise that there is already a suitable business application solution, which has a stock of transactions, function modules and reports, as well as its own integrated development environment. All that is needed to enable Internet users to access and run these applications is an interface to the Internet. Apart from the general advantages derived from making SAP R/3 business information available over the internet, the ITS solution has many benefits.

These include:

• Ease of development - Programmers can develop IACsEWTs using a business application system (R/3), development environment (ABAP Workbench) and a programming language (ABAP), with which they are already familiar. There is also integrated data dictionary support from the ABAP Dictionary and appropriate transaction handling.
• Ease of deployment - The ITS solution supports internationalization of applications.
• Ease of use - ITS based IACs and EWTs have the same look and feel as any other Web site.

The separation of programming tasks from the visual design aspects is desirable, because both require different skills. In the ITS scenario, the ABAP programmer develops the application in ABAP using the ABAP Workbench in the SAP R/3 system and the user interface specialist handles the design and navigation aspects of the application with design languages like HTML and SAP's HTML Business in either the SAP@Web studio or ABAP Workbench tool, Web Application Builder.

The aim is to create applications that send documents back to the Web browser client in plain HTML format, since this format can be handled by all major browsers. This is important in an environment like the Internet where there is often little control you can exert over client software such as Web browsers. Fit can be controlled; you can also use Dynamic HTML, Java applets, JavaScript, and VBScript in you HTML templates, because the script language is transparent to the ITS.

Perform the Backup for each Client Separately

I have 2 clients in one server. The database is SQL.
Would like to perform the backup for each client separately so that I can restore per client.
So far, I've only found information saying that we have to do the entire backup for the database and that individual client backup is not good.

Can anyone advise me on how to perform individual client backup and how's the data integrity.

Sharon

It little confusing with your statement when you are saying that "I have two clients in server".
Or is it rather you want to say that you are having two database instaces on one server.

Scenario 1:
You have One server hosting more that one client as you say. Lets assume it to be Developement & Test client on single databse. Here please note that any SAP DB instace always have more than two clients. The Defaulta clients are:
* Client 000 : SAP AG Konzen
* Client 066 : SAP Early Watch Client.

In addition you have your client specified as
* Client XXX : This will be your production / dev / test client

You can have as many client as you want in a system. Well that really depends on amount of workload and the hardware capacity of the server.

Scenario 2:
You have more that one Database instance on single server. Here you have a choice of having same programs files with multiple databases and or having two different databse instaces with saperate program files. Like in case of oracle you can have two oracle instances Oralce 8i and other with Oracle 9i or any combination you like.

Now your question "Can I take backup of the single client ?"
Ans : Well its possible but then this is not a normal scenario. Its not call as a backup though. You can use the fuctionalities such as client export or client copy procided by SAP.

Second Question : " What about the data integrety ?"
Ans : The option of Client Copy or Client Export are used for specific purpose. You are required to do changes / configure required by the specific fuctionality.

Important Points:
In case of database failuer you would need the complete backup of the database and not just particultal client.
SAP Database does not contain only data but also contains the programs as well. And some of these infomation (Data as you would call) is shared across multiple client in one databse instance.
Hense it is important to restore the complete databse to retain the integrity of the system.
In case of having different DB instances on server you can perform backup of the individual databases. That is sufficient to bring the individual system up after the database failuer.

Evaluating Online Re-Organization Tools

We are evaluating online reorg tools for an Oracle SAP database which is soon to be of 1 Terra Bite size. I would like some guidance for online reorg.tools and experiences of using some of them.

I use SAP 4.6C under Oracle 9.2 under AIX 5.1 on Risc6000 medium-performance machines.

I experienced some reorganizations SAP online, due to the PRD system that must always be up.

Fisrt, consider that the entire reorg is not possible when SAP is online, because of permanent tables (system tables and so on) that could not be exported/imported while running.

An entire TABLESPACE reorganization is no more suitable because of the long runtime between 2 offline backups.

So you can reorg only some tables/indexes or single objects. Be sure that the objects should not be accessed during the reorg, so it will fail. For a particular case, for example a BIG table, I experienced serious perf problems :

JVTLFZUO table : 10 Gb data + 17 GB indexes = 37 GB to be reorganized.

When SAP is online, it took about 13 hours (4 procs, 8 GB RAM)
When SAP is not available for users, it took less than 5 hours !!!

So my advice is :
- don't reorg too big tables with SAP online.
- don't reorg system tables with SAP online.
- you'd better to perform a reorg by night or in a lower user activity.
- you'd rather to reorg with SAP down for perfs point of views.
- always perform an OFFLINE backup before reorg, because the reorg is not always successful.

An example of a DB Backup Strategy

Our SAP DB Backup strategy:

• Full Online Backup on 00:00 from Tuesday to Saturday.
• Redolog on 06:00 from Monday to Saturday
• And Once a month full offline backup

Is this good enough or need improvement?

An example of a DB Strategy is as follows:-

• Full online SAP backup every day at 20:00 (including weekends)
• Full OS filesystem (minus SAP data) every weekday.
• Continuous archive logging from 15:00 to 11:00 next day (weekdays) and 15:00 to 14:30 (weekends).
• Archive log deletion at 14:45 every day.
• We perform a parallel backup on 2 tapes using 3 x 5 DLT tape autoloaders using a 7 day rotating tape cycle. OS backup onto single DAT.
• The tapes are stored offsite and brought in every weekday. On Friday the Friday,
• Saturday and Sunday tapes are brought in.

The only problem I can see with the strategy is if the system crashes at 05:55 on Monday and needs a restore, you could lose a lot of data as you are missing backups on Sunday and Monday, and archive logs from Sunday.

With this strategy if this happens you will be restoring the data from 00:00 Saturday and the logs from 06:00 Saturday. This means you could lose 48 hours worth of data.

Is your operation 24 x 7 or 24 x 5? If 24 x 5 it shouldn't be too bad unless you run weekly jobs over the weekend.

Do you have single tape drives or multiple autoloaders?

Is there anyone there to change the tapes over the weekend?

My own personal suggestion would be to forget the offline backup as you do not really want to restore data which could be a month old so why bother shutting the system down every month to back it up. I would perform a daily online backup every
possible day and continually archive the redo logs with a window for changing the tapes. If nobody is there over the weekend to change the tapes, run your archiving continually through the weekend i.e. start on Friday and finish on Monday.

Warehouse Management Or SU Is Active Or Not

How to know Warehouse Management is active or not in the system?

I have found Table TCURM and Field LVS_CUS to know WM is active or not. If this field LVS_CUS is 1 means WM is active and other than 1 means WM is not active. I have tried to run scenarios in WM by making this field is in active but all scenarios are running properly.

So, what is the use of this and how to control this ?

Check SPRO -> Enterprise structure -> Definition -> Logistics execution -> Assign warehouse number to plant/storage location

Check on this one and check the Plant and WM relation.

or

You have to check T320 table. This table shows assignment of IM storage location to warehouse number

In WM in SPRO, "Define Control Parameters for Warehouse Number" is mandatory to enable "SU management active"?

What is the purpose of this flag?

SU means storage units. It's a different concept in WM wherein you maintain materials in containers (boxes, pallets...etc). These containers are numbered and have SU IDs, they have their type (the sizes of container) which is SU Type, all these terms are integrated in SU management. Only if your business scenario invloves such type of units you need to maintain SU active.

SU management check box is NOT recommended to be activated for interim storage types.

You can make a whole Warehouse as SU managed or you can define it by Storage type too. Once you make a storage as SU managed, along with the Bin, the stock also gets updated on a Storage unit.

If you have a warehouse with pallets, you can define one pallet as a SU and the palletization data will be defined in the Material Master (Warehouse view 2).

SAP WMS - Decentralized Warehouse Management System Integration Setup

You can operate the SAP Warehouse Management System (WMS) as a stand-alone decentralized system that is independent of a central Enterprise Resource Planning (ERP) System.

You make the necessary settings for the ERP (Enterprise Resource Planning) system within the WMS component (Warehouse Management System).

The steps are set up as a checklist and guide you through the process of configuring the system parameters.

Checklist (For those with the Table Views used transaction code SM30).

1. Customizing for "Enterprise Structure"

- Create storage location in OX09 (if necessary).

- Define warehouse number in Views V_T3001.
(you should not copy the warehouse number in the ERP system)
Activities within a warehouse, like goods movements and physical inventory, are assigned to a specific
warehouse number.
The physical warehouse where these activities take place is identified by the warehouse number.

- Assign plant/storage location to warehouse number in Views V_T320.
(Valid if the component MM-IM (Inventory Management) is implemented.)
Fields : Plant + Sloc + WhN

2. Customizing for "Decentralized WMS integration", section "Central processing" -> Application

- Activate decentralized WMS in Views V_T340DM.

- Define interface to Inventory Management in Views :-
V_156S_WM - Assign WM movement type references to IM movement types
V_T3211 - Delivery-Relevant Parameters for Reference Movement Type
V_T340DL - Delivery-Relevant Data for Warehouse Number

- Exclude stock in decentralized WMS in Views V_T321B
(if the decentralized WMS is not an SAP R/3 system)

- Finally do a consistency check for decentralised WMS in transaction OL20.

3. Customizing for "Application Link Enabling (ALE)", section "Basis Components"

Maintaining Logical Systems in Views V_TBDLS.

Assign logical system to client in Views T000.

4. Make basic settings for RFC in transaction BD97.(if necessary)

5. Customizing for "Application Link Enabling (ALE)", section "Maintain Distribution Model"

You can define the Reduce message types and Activate message types in transaction BD53.

SAP recommends that you use message types :
"MATMAS" (material master tables) and
"DEBMAS" (customer master) as a template.

Be aware that only those fields that are absolutely necessary are transferred from the master data tables in
the ERP system to the decentralized WMS.

6. Customizing for "Decentralized WMS integration", section "Central processing" -> Distribution

Use transaction OL19 to generate distribution model. As far as the application is concerned, when the model
is generated, application-specific Customizing parameters are modified or set (for example, activate
decentralized WMS).

Display or check distribution model

Generate partner profile in transaction BD82.
(you can also perform this activity using ALE Customizing)

Distribute distribution model in transaction BD64 (model view) using menu item "Edit"

If both the ERP system and the decentralized WMS are SAP R/3 systems, the distribution model should be
distributed on a central basis only, that is, via the ERP system.

7. Customizing for "Application Link Enabling (ALE)", section "Maintain Distribution Model" (transaction BD64)

Activate the change pointers for master data distribution using transactin BD61.

If necessary, reduce the message types concerned with transaction BD53.

8. Customizing for

"Logistics - General" - "Material Master" - "Tools" - "Data Transfer : Material Master" -
-> "Define required-field check for ALE/Direct Input" (Views V_T130S)

Define whether an error message should be generated in the receiving system for required fields
from the material master.

Physical Inventory In SAP WM and IM

Physical Inventory:

Physical stock is actual stock available in the plant / storage location & is the figure (Nos) after physical counting is done.

Logical stock is the stock shown in the system at any point of time.

Following is the process of how to match the stock.

1. Creation of Physical Inventory document for which you want to match stock ( T code MI01)

2. Entry of the physical count in the system (T code MI04)

3. Posting of inventory difference ( T code MI07)ea

AFTER POSTING INVENTORY difference THE QTY & VALUE BASED STOCK IS UPDATED.STOCK ACCOUNTS ARE UPDATED.

You can do PI in IM as well as WM also.

Inventory Preparation:

MI31 Create Physical Inventory Documents in Batch

MI24 Display Physical Inventory List

MI02 Change Physical Inventory Document

MI21 Print Physical Inventory Documents

Process Inventory Results:

MI04 Enter Count Results

MI06 Display Count on individual Physical Inventory Document

MI05 Change Count on Existing Inventory Documents

MI11 Create Recount Document

MI20 Physical Inventory List/Post Differences

MI20 Inventory Completion Check

MI20 Print List of Inventory Differences

MB21 Reconciled Inventory Report

During the inventory you compare the physical (real situation) of your stocks (qty, batch, location, etc) to the stock situation of your system. Maybe you have to do inventory once a year because it is prescribed in the law but of course you can do inventory monthly, or any time you feel it is necessary.

If you use WM the process may differ a little bit from the inventory process mention in messages above.

Basic steps:

LI01N - create / activate inventory doc

(LI02N - activate)

LI11N - enter count result

LI20 - clear differences WM

LI21 - clear differences IM (please use interim storage type 999)

You have information on stocks in SAP - it's one thing.

Other side of the coin is that mistakes (wrong bookings, etc) can happen: some material may have been moved from one bin into another if WH staff haven't kept the rules, someone may have stolen something, you may have received a box with a label on it: 100 pcs and you later find out that the box contains only 98 pcs, etc.

So you may have several reasons why your stock level accuracy and the exact location of your stock, etc may differ from the information stored in your system (SAP).

That's why sometimes it is necessary to make inventory to examine what is the reality and what is the theoretical situation in SAP...

Or as I mentioned you may be forced by the law to make inventory once a year...

If your WH operates very well, then these kind of mistakes don't exist or the amount of these mistakes are of very low level.

Remove and Types Of Blocking Storage Bins Location

Check this path and if blocked, remove the block (can remove the setting of the blocking indicators for both putaway and picking tasks).

SPRO->LE ->WM ->Master data ->Storage bin

There are 4 types of blocking for storage bins check if the following are one of those:

Blocking Bins in the Warehouse

Occasionally you need to block storage bins. For example, you might want to block the storage bins that are being counted for an annual inventory or bins that have been damaged or are being renovated. When the activity is completed, then you must unblock the storage bins so that they can be used again by the system. You use the same tasks to block and unblock bins.

In addition to blocking storage bins, you can also block materials. You can block or unblock storage bins * Selectively * On the basis of rows * As a block in bulk storage You can also block an entire storage type.

Blocking Bins Selectively

You generally block bins selectively when bins have been damaged or are being renovated.

1. Choose Master data.

2. -> Storage bin -> Block -> Selectively from the WM menu bar. Enter a warehouse number and either a single storage type and storage bin or a range of storage types and bins. To start the blocking process, choose Execute.

3. Mark each storage bin that you want to block or unblock.

4. To block the selected storage bins, choose Block; to unblock, choose Unblock.

5. In the blocking dialog box, select the type of block and enter a code for the blocking reason and choose.

6. ENTER . Save the changes to the database.

Blocking a Range of Storage Bins

If the material conveyance system is out of order or being repaired, you use this function to block the affected bins. To block a range of storage bins

1. Choose Master data

2. -> Storage bin -> Block -> Range of bins from the WM menu bar. Enter the selection criteria on the initial screen and choose Execute. The system displays a screen listing the number of storage bins that meet the selection criteria and how many of these bins are already blocked.

3. To block the selected storage bins, choose Block; to unblock, choose Unblock. The system displays a blocking window.

4. Select the type of block, enter a code for the blocking reason and choose 5. ENTER . Save the changes to the data base.

Blocking Bins in Bulk storage

To manually block storage bins that are in bulk storage

1. Choose Master data

2. -> Storage bin -> Block -> In bulk storage from the WM menu bar. Enter a warehouse number, storage type, and either a single bin or a range of storage bins.

3. To start the blocking process, choose Program -> Execute. Blocking a Storage Type If it is necessary for you to block an entire storage type, choose

Mmaster data -> Storage bin -> Block -> storage type from the WM menu bar. For each storage type that you select, you can set or remove the setting of the blocking indicators for both putaway and picking tasks.

How to Unblock a Storage Bin With an Inventory Active Flag

I have a storage bin that shows as being blocked by an Inventory active flag, but the inventory document has been canceled. I can't even view this document since it was canceled. Anyone have any suggestions?

You should be able to click on the bin master data (click on bin # and go to inventory tab) and take the recent inventory doc # then go to li02 and delete the inv. doc. That will solve your problem.

You could also try LX22: Edit > Deactivate.

Blocked storage bin for physical inventory

A particular bin is blocked and showing as inventory active. Looking into the Inventory tab of the bin display transaction, I would see 3 materials, out of which there is a material XX25 which is no stock in that bin. While the other 2 materials X216 and X336 are not in Inventory active status. Hence, the only reason why the bin is still showing as blocked is due to material X025.

Also, the day when the counting took place , that is, on 11.08.2009 , the same day a TO was created and confirmed and the entire stock was moved from that bin to Pre-weigh bin ( evident from t-code LT22 for that particular st. bin). Hence, we don't have any stock in the bin any longer as it has been consumed.

I tried using LS06 to unblock the particular bin, but was unsuccessful in doing so.

Storage bin blocked must not necessarily mean that it is blocked by another inventory.

A bin can be blocked (and unblocked) individually with LS02N transaction.

or blocked with mass transaction LS11

or all bins in a storage type are blocked with LS12

LS08, LS07,LX05 are further transaction that can block/unblock quants and bins.

Can you see the PI document in LX22?

If so, delete the document using LI02N

Warehouse Management : Storage bin 45XXXXXXX blocked for stock removals

I am facing the following error message while converting the transfer requirement into transfer order.

Step 1) GR was made for purchase order

Step 2) Transfer requirement created automatically

Step 3) While converting TR to TO ( Transaction code LT04), the error message "Storage bin 4500092091 blocked for stock removals". ( Message number Message no. L3179)

The bin 4500092091 is an interim storage bin and there are no block at the bin level.

Please check this setting:

Warehouse Management --> Interfaces --> Inventory Management -->

Goods Movement (IM) Not Allowed for Storage Types

- LS02N for the bin > "Status" section > "Stock Removal Block" indicator

- You can also use LS08

- Please check whether you have open inventory document (LX22)

Storage Bin Frequent Asked Questions

Bulk Storage

We have one bulk st.type 101 with capacity check table t337b, which means every bin has the max qty based on the specified material. For my understanding the Capacity check method should choose 3:Check based on maximum quantity per bin in storage type. but someone argues that it could leave blank (means no capacity check) and it seems no problem actually. why??
Also, we defined SUT as the piling height, e.g. 4 layers. so I think we should tick SUT check active. but it still seem no problem if blank.

Capacity check is activated in strategies B, I, and F during additions to existing stock even when you don't check the activate capacity check and set a method. When you follow any other strategy for bulk SU managed storage type, it is recommended to set capacity check with method. If you don't set this, If the system cannot use the bin found, the bin search ends with an error message. If the capacity check is active, the check is integrated in the bin search.

The bin search process, therefore, cannot end with the error message regarding insufficient capacity. If the bulk storage type is SU managed, I would recommend you to use capacity check method 5: Usage Check Based on SUT instead of 3 because bin capacity alone is not sufficient check for SU managed storage types.

It seems no problem even when you don't activate capacity check due to above reason. But when there is a problem, system cannot proceed further for identification of an alternative and throw an error.

Is it possible to define storage bin in SLOC in the framework of inventory management without lean WM and WM?
Requirement is to have the spares maintained at bin level, system should ask for bin entry at the time of goods receipt and issues and the stock reports can be seen at bin level.

There is a Storage bin field in material master (Plant view 1 MARD-LGPBE) which is text field and independent field. This field can be used for reporting purpose i.e. stock overview. However it will not work same as WM bin functionalities means system will not suggest bin for put away or picking.

Without using WM/Lean WM you cannot maintain your inventory at bin level.

Can we find storage bin while doing delivery, If we have Warehouse Configured in our system?

Yes.... you may see the ware house details in the delivery.

Go to the delivery --> Item --> Picking tab --> Warehouse. You can see the Warehouse Number, Storage bin, Storage type, Plant ...etc.

Can you explain how to create storage bin?

Spro -> logistics general -> Warehouse management -> Master data -> storage bins -> define storage bin structure
- Define storage bin structure
- Double click that structure
- Environment Tab -> Create bins -> Inside that there is one option called "Create storage bins online"

Based on the structure you defined number of storage bins created.

In addition, you need to have details about storage bin type for creation of storage bin.

When you create storage bin automatically have the template, structure, starting value, Ending value, increment value for the bins. With all these details only then you can create bins automatically.

For creating Storage bin :

- LS01N - Through manually.

- LS10 - Automatically through background job.

- LX20 - Storage bin for interim storage area.