Users Profiles and Password ... 4
Different methods to Lock or unlock SAP users ... 4
Changing the default password for sap* user ... 6
Mass Maintenance of Users Profiles ... 7
How can I create multiple User Id at Random ... 7
How to delete expired roles? ... 8
What are user groups and how can we use them? ... 10
Hide the User Menu ... 10
Function and Role of User Types and DDIC User ... 11
Transports and Upgrade ... 12
Meaning behind those unconditional tp command mode ... 12
Transport guide Tips for Different SAP Objects ... 13
Transport Request within same Server Different Clients ... 15
Upgrade SAP or Installation of SAP R/3 and ECC ... 17
SAP Message : TP_CANNOT_CONNECT_SYSTEM ... 19
Restrict The Transport Access In Production ... 21
Basis - Changing Parameters for the Transport Control Program ... 22
Find transports imported into system by search criteria ... 23
Transporting a Request From OS ... 23
Find Your SAP Transport Request Number Even If You Forgot ... 24
Comparing SAP Objects ... 24
Comparing two SAP clients ... 24
Information on how the OPS$ Users Work ... 25
How To Do the TMS Configuration? ... 27
Where To Find Deleted Transport Request Logs ... 28
Statistics ... 29
Statistics of SAP Application Modules ... 29
Statistical Logs for all the R/3 System ... 30
Finding the SAP Statistics for transactions and programs ... 31
List of Inactive Users Logs ... 31
Incorrect SAP login logs ... 32
How to Find How Much Allocated Memory ... 32
What is the Maximum Memory a good Program Should Request ... 33
Archiving ... 34
Archiving and Reorganization are totally different issues ... 34
Archiving the Material Master ... 35
Deletion of Vendor Consignment Records ... 36
Reasons For Archiving Financial Accounting Data ... 37
System Audit ... 38
The Step required to Audit at the User Level ... 38
Audit of SAP multiple logons ... 39
SAP Security and Authorization Concepts ... 39
SAP Performance Tuning ... 42
SAP Load Balancing and Work Processes Troubleshoot ... 42
Tuning Summary In Transaction ST02 ... 44
Troubleshooting SAP Performance Issues ... 44
Administration ... 45
Tcodes used for Daily System Monitoring ... 46
Monitor and Administrate 4 SAP Systems ... 47
Brief Description About SAP Basis Implementation ... 48
Message ... 48
Basis - Message Class - System Message ... 48
Solution Manager ... 49
What Is The Use of Solution Manager ... 49
Email ... 50
How to test the sending of documents from R/3 applications via fax, paging or Internet mail? ... 50
Creating a SAP mail distribution lists ... 53
Configuring eMail in Case of Alert ... 54
e-Mail The Back Ground Jobs ... 55
Unicode ... 56
Whether a System is Unicode or non-Unicode ... 56
Network ... 57
Bandwidth requirement of ISP to connect to SAP server through VPN ... 57
See from which network IP address and host name a user has logged on ... 58
No System name and transaction code in SM04 ... 58
Jobs ... 59
Suspend/UnSuspend Released ABAP Jobs ... 59
What Is The Job Name EU_REORG Meant? ... 59
Tables ... 60
Reorganization of Single Object ... 60
How to activate the IMG Change Log? ... 60
Basis - Edit, create, delete or adjust your database table ... 62
Finding any of the SAP tables that have been changed ... 62
Transport Tables between Clients ... 62
Copying table entries from client 000 ... 63
SAP Transaction Table ... 63
SAP Tablespace sizes in large databases ... 63
Authorization Objects ... 66
Printing and Fax ... 70
Mass Lock All Printers with SPAD ... 70
Print to an USB printer from SAP ... 71
Parallel printing to all the SAP device printers ... 71
How can I print A3 format in SAP ... 72
Delete multiple spool request ... 74
Auto convert SAP spool output to PDF file ... 74
Printing ABAP Report over LAN and WAN ... 75
Sending faxes from SAP ... 76
OSS ... 76
Apply OSS Notes On My SAP R/3 System ... 76
Manually Applying OSS note on SAP Standard Program ... 78
SPAU and SPDD ... 79
SAP Transaction code to pre-compile all system program ... 80
Transaction Codes ... 80
Changing the Title of SAP Transaction ... 80
Basis Frequently Asked Question ... 81
SAP Administration Questions Answers ... 83 Basis Administration Questions Answers ... 85
Users Profiles and Password
Different methods to Lock or unlock SAP users
I want to lock all the users in SAP during MTP. I know using SU10 we can do it. Any other alternative ways to lock the users.
Is there a way in SAP to unlock a locked user for a limited time, then automatically after x time set the user back to lock status?
You can fill in "valid from" and "valid until", but you cannot say from Monday to Friday from 8 - 12:00 for part time workers.
Can we schedule to lock all users?
If users get locked, from SU01 you can unlock them. Use SU10 to mass lock/unlock the users.
Use address data or authorisation data to get a list of users - select the ones you want and click transfer.
Once this is done click on lock or unlock.
You can also use transaction code EWZ5 to mass lock/unlock the users or
Execute program EWULKUSR in SE38 or
Set a profile parameter (login/failed_user_auto_unlock) to unlock at midnight the locked users. or
Here's an ABAP code, short and simple, isn't it? REPORT zreusrlock.
DATA: time_limit TYPE sy-datum. DATA: days TYPE i VALUE 40. time_limit = sy-datum - days.
UPDATE usr02 SET uflag = 64 WHERE trdat < time_limit.
If you don't want to specify the time in the program, you can use SE38 to schedule it as a daily background job with the date and time.
or
Probably the easiest way would be to write a sqlplus SQL script that sets all the UFLAG fields in table USR02 to 64 EXCEPT for the BNAMEs you don't want locked. When you are done, you can do the same again but change the UFLAG field to 0.
The SQL statement would look like:
update SAPR3.USR02 set UFLAG = 64 where MANDT = <client number> and BNAME != <don't lock user 1>
AND BNAME != <don't lock user 2>;
You can replace != with <> if you want. To run this from an OS command line, you would type: Unix/Oracle 8---> sqlplus internal @<SQLpath+SQLname>
NT/Oracle 8.0---> plus80 internal @<SQLpath+SQLname> NT/Oracle 8.1---> sqlplus internal @s<SQLpath+SQLname> Unix/Oracle 9:--> sqlplus /nolog @<SQLpath+SQLname> NT/Oracle 9---> sqlplus /nolog @<SQLpath+SQLname>
In UNIX you can cron the script to schedule it. In NT you can schedule it as a task. or
This is another method to UNLOCK ALL users.
Start Oracle Server manager (I assume you are on Oracle) connect internal
update sapr3.usr02 set uflag='0' where mandt='399'; When users are locked, the uflag is set to 64.
Finish, just query to check.
select bname, uflag from sapr3.usr02 where mandt='399';
Please note that unlocking users from low level (like Oracle sqlplus) should be used as last resort. Frequent use of low level access may tempt you to use on other things. Highly dangerous and your IS auditors will not be too happy.
Is there a way to set a list of users that cannot be locked, even if we try to lock them manually, and even if they fail connection ( wrong password )?
Increase this parameter in SAP Instance profile:
login/fails_to_user_lock = 6 (max is 99 wrong attempts, i.e, value 99). Currently you have a value of 3.
login/failed_user_auto_unlock (for your midnight unlocking).
Ask users to remember passwords!! If someone is deliberately login-in with different
username/password (thereby blocking legitimate access of that user), check hostname from SM21.
Changing the default password for sap* user
You are trying to change the password for sap* user, however when you go into su01 and enter sap* as the user name, the following message is displayed, user sap* does not exist.
You can delete the SAP* user using ABAP code :-
Delete from usr02 where bname = 'SAP*' and mandt = '***'; Where '***' means your client no.
Then login to your client using password SAP* and password PASS
However, if you delete it, then it will automatically created once again with password PASS The userid, SAP*, is delivered with SAP and is available in clients 000 and 001 after the initial installation. In these 2 clients, the default password is 07061992 (which is, by the way, the initial date when R/3 came into being...). It is given the SAP_ALL user profile and is assigned to the Super user group. When I say it is "delivered" with SAP, I mean that the userid resides in the SAP database; there are actually rows in the user tables used to define userids.
If you delete the userid, SAP*, from the database, SAP has this userid defined in its kernel (the SAP executable code that sits at the operating system level, i.e., disp+work). When this situation exists, the password defined in the SAP code for SAP* is PASS. This is necessary when you are performing client copies for example, as the user information is copied at the end of the process. You can sign into the client you are creating while a client copy is processing using SAP* with password PASS (but you should have a good reason to do this - don't change anything while it's running).
Anyway, if the SAP* userid is missing, you can sign in to the client you want and simply define it using transaction SU01 and, as I stated above, assign it to the SUPER user group and give it the SAP_ALL profile. You define its initial password at this point. If you've forgotten its password and don't have a userid with sufficient authorization to create/change/delete userid,
then you can use the SQL statements to delete it from the database and then you can use SAP* with PASS to sign back into the client you want to define it in and recreate it.
There is also a profile parameter which can override the use of SAP* with PASS to close this security hole in SAP (login/no_automatic_user_sapstar). When this parameter is defined either in your
DEFAULT.PFL profile or the instance-specific profile and is set to a value of '1', then the automatic use of SAP* is deactivated. The only way to reactivate the kernel-defined SAP* userid at this point would be to stop SAP, change this parameter to a value of 0 (zero), and then
restart SAP.
The default password for SAP* is 06071992. (DDIC has 19920706)
Mass Maintenance of Users Profiles
Goto transaction code SU10
Select your SAP User by Address data or Authorization data. With the users you want to change selected, click :-
User -> Change -> Profiles
Filled in the Profiles and click save.
How can I create multiple User Id at Random
We usually created Id though SU01, it only one by one. Can I create multiple user id having same profile at once.
Yes you can, use tcode SCAT. First, make sure your client setting (SCC4) is enabled with ' X eCATT and CATT allowed'. Just in case your Production disabled this.
- Then, you need to create a simulation (test case) of creating new user id by calling tcode SU01 later.
- Test case must start with Z, example ZCREATE_NEW_USER. Create this case, put title and choose component as BC (basis components).
- Save and choose Local if you dont want to transport it or choose a dev. class (example ZDEV) if you want to transport it later.
- Go back and click Change button. Then key -in Object as example SU01, and choose Record button on top. When it prompts to enter Transaction code, key in SU01 (if for roles,
key-in PFCG) and begin recording. As usual in SU01 create 1 user id, dept field, password, roles, group and so on.
- Make sure you press Enter on each field because we want to capture the value/object and SCAT is a bit stupid if you become familiar later....but still useful...indeed.
- You will see a clock on the bottom which means the recording process is on going. Once done, click Back button and press End button to end the recording.
Note - I noticed you said the profiles are all the same. Then this is much easier...no need to enter the roles/profiles, just duplicate this ID and change the name, dept and password only.
Okay..first stage has finished. Then double click the Object to begin inserting parameters. Then you will see an object for each fields that you run from SU01. Choose the right field example user id (BNAME) and choose button 'Insert Import Parameter (F6)' and you may click Next Screen to 'watch' what have been recorded and proceed to choose several other objects like password field
(PASSWORD1, PASSWORD2), roles field (AGR_NAME), group field etc. If you happen to choose the wrong object, then you can reset back (Edit -> Reset Parameterization). You may see so many junk fields captured and this is because SCAT records every steps/dialogs.
Once done, choose Back and save this case. Then you need to click 'Goto -> Variant -> Export' and save it. After that use Ms Excel to open it and begin inserting all other user ids. Save and close. Remember to close this file because SCAT will use it.
Then last one, get back to SCAT and click button execute, processing mode chose Background, choose external file 'the one you created with Excel' and execute. At this moment don't use tcode SU01 bcoz you may interrupt the simulation. Wait for the logs. If you see reds then error was
happening.
How to delete expired roles?
Here are 3 notes you may want to review to see if there is any helpful info, plus some documentation that may be helpful for others....we are going from 40B to 47 and have had a few issues with role deletion
Notes: 312943 504412 & 313587 Additional info
First, the report PFCG_TIME_DEPENDENCY is functioning as designed. It was not designed to remove activity groups.
Second, in transaction SU10 you must have the valid from and valid to fields filled in with the actual dates, 04/08/2002, in order to remove the invalid activity group. You need to be sure that the remove user radio button set in the role tab. But in the profile tab, the add user radio button is selected by default. What you have to do is go to profile tab and select the remove user radio button. You have to make sure both role and profile has the same radio button selected, i.e. remove from users. Only then when you click save, it will allow you to delete the role from user.
In transaction SU10, you need to complete the following steps: 1. Click on the Authorization data button.
2. Entry the users name, latimerc 3. Click on the execute button.
4. Put a check in front of the users name. 5. Click on the transfer button.
6. Now highlight the user. 7. Click on the pencil button. 8. Click on the Activity Groups tab.
9. Enter the profile name (PM_NOTIFICATION_PROCESSOR). 10. Enter the valid from and valid to dates (04/08/2002).
11. Change the radio buttons to remove user from both the Activity Group and Profile Tabs. 12. Click on the trash can.
In another customer message the following was provided by developement:
We don't have a regular functionality for mass deletion of roles. But if you want to avoid the deletion by hand or with an own created report, I would suggest the following:
The attached note 324962 includes the report ZDELETE_RY_T_AGRS which could delete all roles with names like 'T_....' or 'RY....'. The report gives you a list of all these roles and deletes then the selected ones. You can modify the report to get all your roles in the selection list. Therefore you have to change the following:
SELECT * FROM AGR_FLAGS INTO TABLE L_AGR_FLAGS WHERE FLAG_TYPE = 'COLL_AGR'
AND FLAG_VALUE = 'X'. SORT L_AGR_FLAGS BY AGR_NAME.
LOOP AT SINGLE_ACTGROUPS WHERE AGR_NAME+11 <> SPACE AND <<< delete ( AGR_NAME(2) = 'T_' OR AGR_NAME(2) = 'RY' ). <<< delete
LOOP AT SINGLE_ACTGROUPS WHERE AGR_NAME+11 <> SPACE. <<< insert READ TABLE L_AGR_FLAGS WITH KEY AGR_NAME = SINGLE_ACTGROUPS-AGR_NAME
BINARY SEARCH.
Text from an additional customer message as further help: - go on role tab
- select remove from user
- enter ZR.PRD.GENERIC and date : 06/04/2002 12/31/9999 - go to profile tab
- select remove from user - save
- do the same for ZR:HR:ESS from 01/01/2002 to 12/31/9999 and worked
from date for testid was 01/01/2002 and testid2 02/01/2002 and the 2 assignement were deleted And the roles were
removed from the 2 UMR. So it works as designed.
What are user groups and how can we use them?
Your auditer asked you to implement user groups in SAP, but you have no idea what are user group.
Transaction SUGR - have a look. Purpose for example is to give certain system admin rights to unlock / change password only to a given user group. You assign user group to an user id via SU01.
User group can be used for different reasons and in different way.
In the latest versions of SAP, actually two types of usergroup exist, the authorization user group and the general user groups.
Naturally the main reason of user groups is to categorize user into a common denominator.
The authorization user group is used in conjunction with S_USER_GROUP authorization object. It allows to create security management authorization by user group. e.g. you can have a local security administrator only able to manage users in his groups, Help-Desk to reset password for all users except users in group SUPER, etc...
The general user group can be used in conjunction with SUIM and SU10, to select all the users in a specific group. User can only be member of one authorization user group but several general user group.
One of the Primary uses of user groups is to sort users into logical groups. This allows users to be categorised in a method that is not dependent on roles/AG's/Responsibilities/Profiles etc.
User Groups also allow segregation of user maintenance, this is especially useful in a large
organisation as you can control who your user admin team can maintain - an example would be giving a team leader the authority to change passwords for users in their team.
The most important factor identified is that the lack of user groups is an indication that there may be problems with the user build process. This is very "fuzzy" but is a bit of a warning flag.
The Auditors job is to provide assurance that SAP is set up and administered in a way that minimises risks to the financial data produced. If the only thing they have picked up on is the lack of usergroups then you will be fine.
Hide the User Menu
Is there a way of masking or hiding the User Menus as we are using SAP Standard Menu instead of User Based Menus?
To put it simple, when the user logs on to the system he should have only the SAP Standard Menu.
You have two ways to control this :
1. Default hide for all the SAP users.
Goto SM30 and edit the table SSM_CUST and set ALL_USER_MENUS_OFF = YES and transport the same in production server.
or
2. Hide based on individual SAP users.
You can also try SM30 and maintain table USERS_SSM for individual users.
Function and Role of User Types and DDIC User
In "USER MAINTENANCE- SU01" --> in the "logon tab" there are 5 different "user type" 1. Dialog
2. System
3. Communication 4. Service
5. Reference
Kindly mention the function and role of all the above mentioned user types specifically and hows is one user type different from another.
These are as follows:- 1. Dialogue:-
For this kind of users:- GUI login is possible.
Initial password and expiration of password are checked. Multi GUI logins are checked.
Usage:- These are used for GUI logins. 2. System
For this kind of users: - GUI login is not possible.
Initial password and expiration of password are not checked.
Usage: - These are used for internal use in system like background jobs. 3. Communication
For this kind of users:- GUI login is not possible.
Users are allowed to change password through some software in middle tier.
Usage: - These are used for login to system through external systems like web application 4. Service
For this kind of users:- GUI login is possible.
Initial password and expiration of password are not checked. Multiple logins are allowed.
Users are not allowed to change the password. Only admin can change the password Usage:- These are used for anonymous users. This type of users should be given minimum authorization.
5. Reference
For this kind of users:- GUI login is not able.
Initial password and expiration of password are not checked.
Usage:- These are special kind of users which are used to give authorization to other users.
Tips by : Rajeev Sharma
What are the functions of DDIC user in Production system?
There are many functions of DDIC user.
For E.g.. When you configure TMS you won't be able to configure it using sap*. For this you need a user who has access to Data dictionary and ABAP repository Object like DDIC user or user with sap_all and sap_new permission.
2) When we install R/3 in Landscape then we need to configure TMS. With the help of default user DDIC we can configure s_trnsprt and s_cts_admin. We cannot create new user for our client( Client of Company ) as creating new user gets charged.
Transports and Upgrade
Meaning behind those unconditional tp command mode
Content Author: PrakashP
Can anyone tell me what's the meaning behind all those unconditional mode U1 or U126 or U148 or anything?
tp import transportrequest <sid> clientxxx U126 tp import transportrequest <sid> clientxxx U148
The u stands for unconditional force ( how hard you want to force the request into the system - do you want to overwrite without warnings, or softly try to load the objects).
0: Called a overtaker; change request can be imported from buffer without deleting it and then uncoditional mode 1 is used to allow another import in the correct location.
1: If U1 is used with the export then it ignores the correct status of the command file; and if it is used with import then it lets the user import the same change request again.
2: When used with tp export, it dictates the program to not to expand the selection with TRDIR brackets. If used in tp import phase, it overwrites the originals.
3: When used with tp import, it overwrites the system-dependant objects.
5: During the import to the consolidation system it permits the source systems other than the integration system.
6: When used in import phase, it helps to overwrite objects in unconfirmed repairs. 8: During import phase it ignores the limitations caused by the table classification. 9: During import it ignores that the system is locked for this kind of transport. u128 is combination of 128 OF THE above points.
Transport guide Tips for Different SAP Objects
You may be wondering if you can transport certain SAP objects, and if possible, how?
Here are tips for different objects:
1 LSMW There are 2 ways for transporting LSMW data from a system to another.
1.1 Export/import This method gives you the opportunity to select the subprojects or objects you want to transfer. Hence you don't transfer the object a colleague might have created and that should stay in development system. LSMW -> Extras -> Export project
1.2 Transport request With this method, you can transport a LSMW project in full (you can not select the objects you want). With this method, the project will be transported as any other SAP object in a transport order.
2 Program variants
If you have several program variants in a development system that you want to transport, use the following method to transport them:
Execute program RSTRANSP (via se38) and inform the program and/or variant names (you can transport variant of several programs in one shot).
3 Layout In some transactions, one can save layout of the screen (sort, filter, ... criteria).
These layouts can be transported: In the required transaction, when your layouts have been saved, go to Settings -> Layout -> Layout Management. Select the desired layouts and go to Layout -> Transport… There you can add your layouts in existing TO or create a new one.
DB data
In some unusual cases, you might have to transport data of a SAP table.
Go to transaction SE16, select your entries and go to Table entry -> Transport entries. It's only possible for some tables...
If you cannot do it that way, you have to create a Workbench transport order with transaction SE10. When created, click on it, go in menu Request/task -> Object list -> Display object list.
Go in modification mode and add a new line with: PgmID = R3TR
Obj = TABU
Object name = Name of your table
Double-click on the created line and, depending on your need, put '*' in the key field or double-click on it and select the key you need to transport.
4 Queries
Queries, datasets and user groups can be exported/imported between the systems thanks to the program RSAQR3TR.
5 Standard texts
Standard texts used in SAPScript (created with transaction SO10) can be included in transport orders. You have to create a Workbench transport order with transaction SE10. When created, click on it, go in menu Request/task -> Object list -> Display object list. Go in modification mode and add a new line with:
PgmID = R3TR Obj = TEXT
Object name = TEXT,,ST, Example :
R3TR / TEXT / TEXT,YMM_MEDRUCK_MAIN_16_EC,ST,F
You can also copy a Sapscript object (like standard text) with the program RSTXCPFS.
How to transfer a executable report from dev server to prd server? And that report contains one user defined view. I want to transfer *the report and the view* from dev to prd.
At the time of creating the report itself it will ask you to select the PACKAGE.
Here you should select the package instead of $TMP package, which for transporting the objects and create a new request and save it. If you want to give a TCode for the program that you have created just give SE93 in the GUI Window and give the TCode name there and enter the Create button. there you should give the name of the object or program that you have created and save it. After completing this go to SE09 TCode and select the MODIFIABLE Check box and press DISPLAY Button.
In the next screen you have to select the Request that you have created and click the check syntax icon. If no errors are there then you can press the Release Directy icon to transport the request to the Quality system. From there it has to be transported to the Production System.
Transport Request within same Server Different Clients
I have 3 clients under one SID (dev 130,140,150).
And we have more than 400+ transport requests in client 130. How can we transport these requests to other clients of 140 & 150. If I want to use tcode SCC1, that can be done only one tran. request at one time.
Do I need to write a script within unix? SAP 4.6C
Oracle 9.2 AIX 5.2
Mohd Zainizam
Try STMS.
Click on the "import overview" Double click on your target system Click "refresh"
Click on "import all request" or ctrl+F9 Specify the target client
Execute the transport Done...
Ronald Ramos
But this will import all request...thousands of them...
Mohd Zainizam
You can use Extended Transport Control.
Extended Transport Control is another way to set up the Transport Route so that the route is system and CLIENT specific.
In other words, when you release a change request in DEV Client 0XX it will not only automatically be added to the Import Queue for QAS but also 0X1, 0X2, of DEV.
To set this up requires the steps below:
1) Open the file TP_DOMAIN_DEV.PFL (located on your transport domain controller such as the DEV box. The file will be in usrsaptrans/bin)
Edit with notepad for each parameter on each system: DEV/CTC = 0
Change to =1
2) Next you need to create Target Group before creating the transport route. Create a Target Group:
Access the initial screen of the graphical or the hierarchical editor in change mode. STMS > Overview > Transport Routes (the default editor will appear, either Hierarchical or Graphical, to change the default editor : STMS > Extras > Settings > Transport Routes. You can also switch to one or the other from Goto > Graphical Editor.)
> Configuration > Display Change > (or change icon or F5) Edit > Transport Target Groups > Create
In the dialog box, Create Target Group:
Enter a name for the target group /GR_QA/ (The name must begin and end with a forward slash /) ...and a description Targets for Consolidation route
Choose "Insert line"
Enter the required target system/client combinations Use a separate line for each client.
Example: Target System Target Client Client Name DEV 0X1 Sandbox DEV 0X2 Testing
QAS 0XX
Quality Assurance System
The idea is that we want to include the clients that will get an addition to their import queue when we release a change request from DEV.
Choose Transfer
Now you have to change the transport route to include the Target Group you created.
STMS > Overview > Transport Routes > F5 (change mode) Edit > Transport Routes > Delete Now create a Transport Route with Extented Transport Control:
STMS > Overview > Transport Routes > F5 (change mode) Edit > Transport Routes > Create > Extended Transport Control icon at lower left of dialog box. > Consolidation route, enter integration system and transport layer. In Target system/client enter the SID of either an R/3 System and a client or an existing Target Group.
Each System must be specified by System and Client. The Target Group can be used for the consolidation system.
Distribute and activate the changes as usual by choosing Configuration > Distribute and activate NOTE: After you set up Extended Transport Control there might be requests in an import queue that will show a red status in the CTL column. This is because these change requests need a client specified before they can be imported. These are old requests that were already in the queue.
From Import Queue Screen Mark the change request Choose Request > Target Client > Set
Enter the Target Client ID and choose Enter. To change a target client before starting an import:
Import Queue Screen > mark Change request > target client > change > enter target client id and choose enter.
Upgrade SAP or Installation of SAP R/3 and ECC
What is ECC? Where to find the installation steps of ECC 5/6.0 with SQL as database and on windows platform with the steps including Solution Manager installation?
http://service.sap.com/instguides
ECC means Enterprise Central Component.
There are all the relevant installation guides. You NEED SAPNet access because without a registered and licensed SolMan installation number you will not be able to generate the SolMan key for the ECC
installation.
Upgrade to 4.7
Have you gone through an upgrade to 4.7?
What are the difference or changes associated with 4.7.
If you are currently on 4.6C and are inching forward to upgrading to 4.7 then this information might be useful to you.
There is very little difference between 4.6 and 4.7, the only "steps" you should need are steps in SU25 ( skip step 1) Then go through all your role and perform a merge old new to bring in the new
authorization objects
Just to forewarn you of a potential problem which have been encounter at the point of writing. After updating/ modifying roles in step 2C, when going back into 2C to make sure all roles are now green, 70% have gone back to red!
The maintenance done is ok, but there seems to be a problem while trying to go back into the roles again to re-generate.
SAP recognizes them as needing "adjustment", so you cannot pick them up in mass generate in PFCG as they do not come in, even though the authorizations tab is red.
This problem is currently with SAP and it is confirmed that nothing have been done wrongly.
Generally, the work is quite manageable in the upgrade, but don't be surprised at how big the upgrade is when compared to upgrading from 46b to 46c.
If we have full software of 46c and 47E is it possible to upgrade 46c to 47E or there is a seperate 47E upgrade software need to be requested from SAP?
Where I can get the document with upgrade steps on the service market place?
It is of course possible and supported: http://service.sap.com/inguides --> SAP Components
--> SAP R/3 Enterprise --> (choose your version)
at the bottom there is an "Upgrade guide" for Windows and Unix.
For Upgrades it is recommended to read ALL the notes mentioned in the upgrade guide and to make sure one is using
- the correct version of the "tp" program - the correct version of the "R3trans" program - the correct version of the "R3up" program
All that is explained in the upgrade guide and in the corresponding notes.
If this is your first upgrade you should take a person, that has some experience on doing that for the first time.
Installation of SAP R/3
Currently we are going to install SAP on a new IBM server from the existing COMPAQ server. Where can I get the steps for that.
Configuration is : OS - windows 2003 server DB - Oracle 9i SAP 4.7 http://service.sap.com/instguides --> SAP Components --> SAP R/3 Enterprise
--> SAP R/3 Enterprise Core 4.70 / Ext. Set 2.00 (SR1)
--> Inst. Guide - R/3 Enterprise 4.7 x 2.00 SR1 on Win: Oracle
The above url is the SAP Service Marketplace with all the information you need to install, configure and run system. You need to be a valid licensed customer with a user ID and PASSWORD to use that. Without access you won't be able to successfully run any SAP systems because it has notes, patches etc.
SAP Message : TP_CANNOT_CONNECT_SYSTEM
Using spam, trying to import SPAM UPDATE, I get the above message together with TP_INTERFACE_FAILURE.
1. tp works fine when I am doing transports (tp import devk90000 qas client=400 u1 or addtobuffer).
2. niping -t SELFTEST works fine
I worked through notes 44946 and 96907, but could not resolve the issue.
The support packages have been uploaded from the DEV box into the QAS queue. The DEV and QAS boxes are in the same centre on the network, by fibre. I am working on QAS.
I get this message in QAS:-
"SAP system is waiting for the inclus. in transport domain"
When trying to update the config from DEV client 000, I get this message:- System DEV is unknown in the Transport Management System
Diagnosis
An error occurred in the TMS communication layer. System: QAS.DOMAIN_DEV(000)
Function: TMS_CI_CHECK_ACCESSTOKEN Error: UNKNOWN_SYSTEM (DEV)
System Response
The function terminates. Procedure
Log this system on to the Transport Management System.
If this error occurs in the function TMS_CI_CHECK_ACCESSTOKEN, then the TMS configuration was deleted in the R/3 System QAS.DOMAIN_DEV(000).
Configure the TMS in this R/3 System again. You need to:
1. logon to the transport domain controller with admin user in client 000. 2. Run STMS
3. System overview 4. select QAS
5. Menu line option "SAP system" --> "Approve" 6. Distribute configuration
When you are logged on the transport domain server and run STMS --> System Overview. Is QAS listed? If so, select it and perform the checks under "SAP Systems" in menu line.
If they are not successful you might want to try the following to configure the TMS on QAS from scratch.
First delete QAS from system overview on the domain server. Then do the following steps...
In your QAS system in client 000.
Run tcode SE06 --> Database copy or Database migration --> Perform post-installation actions. Then confirm that you want to delete all old CTS/TMS config and type in QAS as source system for the database copy.
Then run STMS again and type in the correct data for the transport domain controller. Logon to the transport domain controller in client 000. Run STMS. Open system overview. Choose the SID of the QAS system and click on "SAP System" in the menu and choose Approve. This will add the QAS system to your TMS config again.
Perform the checks from menu line "SAP Systems" again.
Restrict The Transport Access In Production
How to restrict the transport access in Production?
You can control by 2 way :
1. Limit the authorization object that can limit your transport activity, please use authorization object S_TRANSP and remove the value 60 (import) at your production server
2. Remove the STMS from the role.
List of transports that have been transported over a period
I need to know how we can get a list of transports transported over a period of time. I tried SCC3 but I'm not able to pull up the data. Is there any other way?
Example: List of transport request that have beem transported during Jan, Feb 20xx to production. System Landscape: Dev-->Test--> Production
DB:--Oracle Machine--SUN Appln Servers: AIX
SAP version: 4.6C
Goto STMS --> Import overview --> select the system which you want to see the log of import queue --> select goto--> import history --> there select the data coloum and set the filter as per your
requirement.
You can also execute SE03, Requests/Tasks, Find Requests, in the production system or use SE16 to query table E070.
How to import mass transport request using SCC1 in local client?
We have 3 clients in development system , we need to import multiple requests at a time using SCC1 in another client. Using SCC1 I am able to select mass request at a time but not able to see mass transport menu.
How to do mass transport steps using SCC1 in local clients.
You could try using SCCL and select "Customising" Profile.
What is Role Transportation from development server to Production server. I have also create New role, but how to bring out the role to production server. We have installed IDES 4.7 Server.
In Development: Run TCD PFCG
- Enter the Role to be transported in the text box. - Click on truck symbol left corner of options bar - then series of screens will appear.
- In one of the screen don't select user assignment. It will also ask you the change request no.
After that go to TCD SE10 and release the request.
NOW go to stms and select Quality system and import the request into it. After testing you can import the request in PRD system
Basis - Changing Parameters for the Transport Control Program
Remove the import all request (big truck) button from STMS
To change the automatically generated profile parameters for the transport control program:
Log onto the SAP System functioning as the transport domain controller (the QA or PROD system). Call Transaction STMS.
Choose Overview -> Systems. The system overview appears.
Double click on the SAP System you want to change. In the SAP System, click Configuration -> Change.
The screen Change TMS Configuration: System <System name> appears. Choose the tab Transport tool.
First, all the global parameters are displayed and then all the local parameters. The global parameters are identical for all SAP Systems in the domain.
To change a global parameter to a local parameter, you must delete the global parameter and enter the new local parameter.
The operating system is only displayed if values exist for this field. Finally to remove the import all request (big truck) button from STMS
• click the Insert Line (button) • Tick Global
• Fill in Parameter = NO_IMPORT_ALL, Value = 1. Save your entries.
If you enter a parameter unknown to the transport control program, or a value that is not permitted, the transport control program ignores this entry in the transport profile.
Find transports imported into system by search criteria
Content Author: Ryan Fernandez
To find transports imported in a particlar system log into it, 1. Use transaction se16
2. Table name is E070 3. Table contents
4. Enter your search criteria, by Name, Date, Time, etc.
Good to use if you suspect a problem in your system and want to trace back transports that went in that possibly could have caused the fault.
Transporting a Request From OS
To import a transport request from OS . # cd /usr/sap/trans
# tp addtobuffer <transport request> <SID> pf=<transport profile> # tp import <transport request> <SID> pf=<transport profile>
Find Your SAP Transport Request Number Even If You Forgot
If you happend to be one of those who forgot the transport request number of your abap program. You can easily find it via the Versions Management.
Steps :-
Transaction SE38
Filled in your ABAP program name.
Then click Utilities -> Versions -> Version Management
SAP system will display this sample list :- Versions: Report source ZPROGRAM
Version Cat Fla SAP Rel. Arch Request Date Time Author Version(s) in the development database:
X activ X 46X 01.08.9999 15:21:56 SAP Version(s) in the version database:
X 00002 46X ABCD123456 01.08.9999 15:52:43 SAP X 00001 S X 46X 00.00.0000 00:00:00
Comparing SAP Objects
You can compare the IMG setting between two systems using OY19.
Comparison can be made for individual application components or all the application components.
Comparing two SAP clients
Compares Customizing objects in two logical systems with transaction SCU0. (clients in either the same R/3 System or different ones).
To compare objects, start the Customizing Cross-System Viewer in the logon client (client of the system in which you are logged on) and then logon in the compare client (client to be compared).
The Customizing Cross-System Viewer compares Customizing objects by the following criteria: - Project IMG
This option shows changes in your project. - Application components
This option compares Customizing objects in specified application areas. - Business Configuration Sets
This option concentrates on Customizing settings which are of particular importance for the processes in your company.
- Transport requests
This option shows the objects which would be overwritten by a transport. - Manual selection
In this option, you specify which objects are compared.
The compare client security level must be: 0 (unrestricted), or
1 (no overwriting)
You can set this in the client maintenance SCC4.
You must also create a Remote Function Call link in SM59.
Information on how the OPS$ Users Work
Content Author: Sachin D. J.
Does anyone have information or a good understanding of how the OPS$ users work and operate under an Oracle SAP environment.
I would greatly appreciate some assistance as I have problems with my Brconnect and Brbackup within DB13 due to the OPS$ users.
I need info on how to permanently delete the OPS$ users and then recreate it, due to the fact that I have incorrect OPS$ users in some of the tables affected by the OPS$ users.
Below is the document I have prepared on recreating the OPS$ machanism. It helped me solve all my problem on DB13 and also on Schema owner connecting to database.
Hope this could help you.
Also refer to the following sapnotes:
1. 400241 : Problem withe ops$ or sapr3 connect to oracle 2. 134592 : Importing the SAPDBA role (sapdba_role.sql) 3. 361641 : Creating OPS$ users on UNIX
4. 50088 : Creating OPS$ users on Windows NT/Oracle
5. 437648 : DB13: External program terminated with exit code 1/2 ---
select owner from dba_tables where table_name='SAPUSER'; ## If owner is not the sid you require, then drop the table SAPUSER Drop table "<owner>".SAPUSER;
#or#
Drop table "domain\OPS$SIDadm".SAPUSER;
## IF THE ANSWER IS 0 ROWS SELECTED THEN CREATE THE TABLE SAPUSER # Check whether OPS$<SID>adm user exist, if no then create it
create user OPS$SIDadm default tablespace psapuser1d temporary tablespace psaptemp identified externally;
# if exist then drop it;
DROP USER OPS$SIDADM;
# Grant connect & resource roll to OPS$<SID>ADM; grant connect, resource to OPS$SIDADM;
# Creat table SAPUSER
create table "OPS$SIDADM".SAPUSER ( USERID VARCHAR2(256), PASSWD VARCHAR2 (256));
# update "OPS$<SID>ADM.SAPUSER with the follwoing command
insert into "OPS$SIDADM".SAPUSER values ('SAPR3', 'sap'); #sap = <password>
# Under NT it is required that user sapservice<sid> can also access the SAPUSER table. In order to avoid problems with the data consistency, it does not make sense to create an additional
SAPUSER table having the same contents. You should rather define a synonym. Check if a suitable synonym exists by using the following call:
SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'SAPUSER';
# IF NOT THEN CREAT IT
create public synonym sapuser for OPS$SIDADM.SAPSUER;
# if synonym already exists drop the existing synonym by the following command drop public synonym sapuser;
#If another name <name> is returned as first value: DROP SYNONYM "<name>".SAPUSER;
# AND CREAT it again with above command
# To allow access to the synonym (or the associated table), a grant needs to be executed. The authorization for this has only the ops$ user who is the owner of the actual table - that is ops$<sid>adm. Therefore, you need to log on with the
corresponding operating system user (<sid>adm) and execute the following commands:
CONNECT /
GRANT SELECT, UPDATE ON SAPUSER TO "OPS$SAPSERVICE<sid>"; # Now you can recreate the synonym (not PUBLIC, if possible):
CREATE SYNONYM "OPS$SAPSERVICESID".SAPUSER FOR "OPS$SIDADM".SAPUSER; CREATE SYNONYM OPS$SAPSERVICESID.SAPUSER for OPS$SIDADM.SAPUSER;
# COMMIT AFTER COMPLETION of the activity & restart the DB
How To Do the TMS Configuration?
The SID is XY1 - Development & Quality XY6 - Production
Now we need to configure TMS between these two systems by assigning XY1 as domain controller. I beleive we also need to establish an RFC Connection for this. Also explain how to update the local files of this systems?
How can I make thro it?
First decide which system you would like to define DOMIAN controller. Configure the Domain Controller Steps to configure
---
1. Login to the system with sap* in client 000 2. Goto SE06.
3. Click Post installation activities 4. Goto STMS
5. It will ask for Domain controller name.
6. Enter DOMAIN_<SID> as domain controller name and enter the description. 7. Click Save button
Steps to add the other system with Domain controller ---
1. Login to system with sap* in client 000 2. Goto SE06
3. Click Post installation activities 4. Goto STMS
5. It will ask for Domain controller name. 6. Enter System ID of the Domain controller
7. Enter DOMAIN_<SID> as domain controller name and enter the description. 8. Click Save button
9. Login to Domain controller system 10. Approve the added system.
Where To Find Deleted Transport Request Logs
Is there any way to find out deleted transport requests logs?
If you have deleted from SAP level. Then you need to check at the OS level in /usr/sap/trans/log directory else you can check for the SLOG and ALOG folder also.
If total request has been deleted then you can also do the transport manually at OS level. or
If you have simply deleted the the requests from import queue through "Extras-> Delete imported requests" in transaction STMS_IMPORT and have not deleted the logs at OS level, then you can check in "Goto-> Import History" in the same transaction to view the requests.
Just double click on the request you want and you enter the "Display Object List" screen for the particular request.
Here you can click on the secong "Spectacles" icon to display the transport steps of the request in each of your SAP system.
Just double click on a step, e.g. 'Import', 'Check Version','Export' etc. to display the log for that particular step.
You can also view the logs from operating system in the directory <TRANSDIR>/log. The logs are named in the format:
<Source SID><Step ID><Request no>.<Target SID>, where step ID is a single alphabet denoting a particular transport action.
Statistics
Statistics of SAP Application Modules
The transaction ST07 provide information such as the numbers of users logged on into each of the SAP Application modules.
Double click on the application modules for more information breakdown.
If there are no analysis data is available for the history in ST07, it is because the program
RSAMON40, which generates snapshots of the application monitor data and saves them to the database, has not started yet. If RSAMON40 runs regularly, the data may sometimes be deleted again by a reorganization program.
For releases lower than 31I, schedule the program RSAMON40 periodically (hourly) as a background job.
As of Release 31I, this report is automatically carried out by the performance collector (RSCOLL00). Check the scheduling of RSAMON40 in table TCOLL as described in note 12103.
To prevent the data from being deleted again by a reorganization program, you must still make the following entry in the SAPWLREORG table:
CI ID =
MONIKEY = --<DATE__>+++++++ RESIDENCY = 0
Statistical Logs for all the R/3 System
To check the workload statistics for all the R/3 System, go to transaction STAD.
Why data was not showing in ST03? Problem:
Last one month I face this problem when I am taking full system o/s backup of production server stopping all the oracle automatic serveice with SAPOSCOL & SAPPRD_00 , STOP SAPMMC. When backup was completed, I started all the service. However, after some time data was not showing in ST03. When I stop & start this sap services SAPOSCOL & SAPPRD_00, then data will start
showing for some time but after 2 day same problme comes again. All sap pjobs are running well. What could be the problem in SAP. Details of server:
O/S : Windows 2003 SAP : 4.7 EE
Oracle : 9i
Solution:
1. Ensure that the job COLLECTOR_FOR_PERFORMANCEMONITOR executes the report
RSCOLL00 hourly. Furthermore, the report RSSTAT80 should be executed every hour. You achieve this by maintaining the table TCOLL with transaction SM31. Enter "X" in every hour for the report RSSTAT80 (column "Time of day").
2. The report RSSTAT80 should be executed every hour. You achieve this by maintaining the table TCOLL with transaction SM31. Enter "X" in every hour for the report RSSTAT80 (column "Time of day"). You should then increase the maximum number of statistics records read in each run of
RSSTAT80. You can set this value with transaction ST03, Goto -> Parameters -> Performance database. Press "Modify parameters" and enter at least 10,000 for the value "Max. number of records cumulated per call". You must then save the settings.
3. Using transaction ST03, Goto -> Parameters -> Performance database, pushbutton "Modify
parameters", increase the value of "Max. number of records cumulated per call" to at least 10,000 and save the change. If this or a larger value is already set, please proceed as in point 2.
Finding the SAP Statistics for transactions and programs
When was a program, transaction last used?
How to know which users are using which transaction or executing which program? Which are the most frequently used programs or transaction?
To know how many users are viewing and maintaining a particular transaction use transaction
'ST03', in3.0x :-
• Performance database • Select instance
• Select desired period • Choose Transaction profile
To find the Frequently Used Programs or Transactions in 4.6x :-
ST03 ---> Detail analysis Button --> Under Global - One recent period then select day or week or month ---> Transaction profile Button
In 4.6x, you can also try the new Workload Analysis tcode 'ST03N'.
The SAP standard retention period is 3 months. You can change the Standard Statistics via clicking :-
Goto -> Parameters -> Perfomance Database
To analyze the Statistics by users for transactions and programs use transaction STAT STAT looks at the STAT file created by each SAP Instance.
It is by default 100 MB. Every hour there is a COLLECTOR_FOR_PERFORMANCE job
RSCOLL00 aggregating this data into MONI table. It will truncate STAT file once the specified limit is reached.
So, you can see details for however many days in this 100 MB using STAT, or ST03 to see the MONI aggregated data.
To change the 100 MB limit, ST03 -> Goto -> Parameters -> Performance Database.
List of Inactive Users Logs
To list out all the users who are inactive for the last 6 months, which means they have not logged into the SAP server.
If you have lots of affiliates to your main company, this will result in lots of users. Out of them, there might be lots of inactive users who have left the company.
You may wish to delete those inactive users. Use SA38 to run RSUSR200.
This report is part of the AIS (Audit Information System) and will report users who have not logged on for a specified period of time.
Incorrect SAP login logs
With report RSUSR006, you can check those users that have been locked.
For those that are not locked, the report will list down the number of wrong login that the users have done.
How to Find How Much Allocated Memory
What tcode can I used to find out how much memory is allocated to R/3 in total? I know for Oracle I can get the SGA memory. I am using SAP 4.7 / Oracle 9i on Unix AIX.
Go to ST02 --> Detailed analysis --> Sap memory. This will let you know memory allocated for that app server. You can also find out memory allocated for user (mode list) and Quotas.
You can also use report RSMEMORY to find out how sap alloctes memory to Dia and Non Dia work processes.
I'm afraid that is incorrect. The question is also not a simple answer.
Go to ST02 --> Detailed analysis --> Storage is the correct path. The Virtual memory allocated line shows SAP's allocated memory.
This memory does not include what the DB uses or the OS or other things running on the server. More importantly it does not include heap (private memory) allocated by WP's. It also does not include the executable size of the GW, the ICM and the dispatcher but it does include most of their memory in the shared memory areas.
It also does not allow for additional memory that a Windows system may dynamically allocate to extended memory if the users use it all up.
Question on Shared Memory and IMODE
Can someone tell me about Shared memory (Code Definition) and IMODE?
I have never heard these terms in SAP R/3, Shared momey sounds like its related to Operating System.
All memory is OS memory I'm afraid there is little distinction in that regard.
Shared memory is memory that can be addressed by different processes as opposed to private memory that can only be addressed by the process that creates it. A good examlpe would be the Program Buffer (PXA) this buffer hold the recently used programs in memory for fast access and needs to be read by all work processes. A more impotrant shared memory area is extended memory. In 32 bit processing you need to keep shared memory areas at a minimum because otherwise you limit the amount of space
in the address space that your program can use for its own data. I won't get into a sad chat about all this bat thats hared memory.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
An IMODE is an internal mode. An example may be best, log onto a SAP system, create a new session and leave one at the main menu and with the other go to ST02. In ST02 near the bottom of the screen double click on the extended memory line. In the next screen click on the Mode List button. You will see you have the ST02 session marked with an X for being attached and another session in IMODE 0. With the other session got to SM36 then swap back to ST02, press enter and you will see the session has an IMODE 0 and an IMODE 1 use. Now from the SM36 screen click on the button Job Selection and jump back to St02 and press enter, you will see the session has an imode 0 1 and 2 active.
Imode 0 is not really an IMOde but the main mode that all your information relevant in any transaction is available. As you call transactions inside transactions you need new memory and the old stuff needs to be save for when you green arrow back. This is why you have imodes so that when you green arrow back from the job selection screen above (I mode2) it is no longer the active mode and imode 1 is reactivated.
What is the Maximum Memory a good Program Should Request
There is no thumb rule for maximum memory a good program can consume in the system but based on your experience can you please let me know at least the range ?
I came across with a situation that there is program which is fetching about 2 million records of total size around 190MB. But system could not allocate this much memory so the program
aborted. I suggested them to process only 50,000 records at a time which worked fine. But I want to know if my suggestion was good enough. Can't the system with below configuration allocate 190MB for a program. There was no much load on the system at that time.
Our configuration: SAP 46c on Win 2K RAM: 4GB
Virtual memory: 8GB.
Do you guys know what are all the things to be done to enable ZERO MEMORY MANAGEMENT in 46C ?
You can get an overall estimate by looking in SM04 and switching on the MB size beside the users so so you will see how much memory the current transactions are using. Take into consideration that there is a big difference between dialog transactions (with several steps) and mass processing or lists. The latter two consume usually a lot more memory.
190 MB is not much, our usercontextes can become as big as 2 GB per user (which is the limit on 32bit platforms) several times a day. This is not uncommon on systems that have a lot of data in them, however, it's impossible to give a general advise here since this is VERY different on what
applications you are running, how many systems are connected (BW, CRM, APO etc.) and so on.
Start with note 88416, there is explained in depth what it is and how it works.
For Windows you also should look in note 129813 which will describe the rebasing process since M$ has the start addresses of their DLLs loaded into the PXA. This is one reason why we switched to a non M$ operating system because after each IE patch (in fact after each patch) you need to check if the new DLLs will fragment your PXA/shared memory.
Note 546361 can also be helpfull. If you have "hangs" in the system read note 530871 which will describe the problem (and finally recommend upgrading to Windows 2003).
What is Zero Administration Memory Management?
The zero administration memory management on Windows requires no manual settings and adapts itself dynamically to the memory requirements of the users. Even hardware changes (for example memory enhancement) are detected and the parameters set correspondingly.
The basis for zero administration memory management on Windows is the dynamically self-extending extended memory. An "infinitely" large memory resource is made available with this method. The extended memory is initially set to the size of the profile parameter PHYS_MEMSIZE ([PM]). If more memory is required by the user, the extended memory extends itself in steps of "[PM] / 2" up to the set limit of the profile parameter em/max_size_MB or until the address space in the Windows pagefile is used up.
By setting the standard value for em/max_size_MB to 20000 MB (100000 MB for 64 bit), it is the size of the Windows pagefile that finally represents the actual limit for the extension of the extended
memory. The profile parameter PHYS_MEMSIZE determines how much of the entire main memory is to be used by SAP. The parameter is entered during installation in accordance with the entry. The standard valuefor PHYS_MEMSIZE is the size of the main memory [HS]. Even with zero
administration management, the Windows system should be configured in such a way that it keeps the file cache to a minimum size. Therefore, make sure that indicator "Maximize Throughput for Network Application" is activated under 'Control Panel' -> 'Network' -> 'Services' -> 'Server' -> 'Properties'.
Archiving
Archiving and Reorganization are totally different issues
Archiving is a process when you archive old master/transactional records which are not in use any more from long time. You archive those records keep on some backup device. These records can be displayed, and only Display, can never be reloaded in tables again physically.
This will free up the space in tables from those records which are not in use any more but exist in tables physically.
Reorganization basically removes deleted data from tables. During different transactions you delete some records, which are deleted virtually but not physically. Even Archive process delete those records virtually.
So you run Reorganization to free up the space consumed by deleted records. This make the difference between the two clear.
Now about reorganization.
It depends on which OS and DB you are using. If Oracle, SAPDBA is best tool to reorganise.
In addition to above, you can reorganise the whole database, but it takes time depending upon your database. Some times it can be more than a day or you can reorganise a table suggested in Early Watch system.
It all depends on you.
Archiving the Material Master
Transaction SARA contains all the SAP archiving objects for all the SAP R/3 applications modules. All the SAP archive functions are shown in SARA. Choose the corresponding SAP archive object, hit enter and the archive administration menu will be shown. Provided here will be an example on how to archive the SAP Material Master.
Archive a Material Master Record
When a material is no longer required in a company or plant, you can archive and delete the material master record.
You have to Flag the material master record for deletion. This is known as logical deletion. Before a material master record can be archived and deleted, other objects (such as purchasing documents) that refer to this material must themselves be archived. You can see which objects these are and the dependencies between them in the network graphic.
If a material master record cannot be archived and deleted at a given organizational level, the reason is given in the log (for example, a purchase order exists for the material). The log also contains technical data such as the number of material master records read and the number deleted.
Some of the archive error log message :- • Costing data exists
• Use in routing
• Use in sales and distribution • Use in bill of material • Delivery exists • Costing data exists • Info record exists • Purchase order exists The Archiving steps :-
Archiving object MM_MATNR for archiving material master records. You can display the archived data, but not reload it.
To archive the material master, first goto transaction MM71.
Type in a variant name and click Maintain. (Tick the Test Mode for archive simulation). Save the variant.
Maintain the Start date and Spool parameters and click execute. Click Goto Job Overview to check the archive status.
To do a permanent delete, goto transaction SARA and click Delete button. Maintain the Archive Selection, Start date and Spool parameters.
Click Test Session for testing or click execute to start the deletion program. Click Goto Job Overview to check the delete status.
Now, if you goto MM02/MM03, you will not be able to find the record in the material master.
Deletion of Vendor Consignment Records
Steps for Deletion of Consignment Records:
To delete the Consignment Record, use transaction MSK2 or menu-path:
Logistics - Materials Management - Material Master - Special Stock - Vendor Consignment - Change and select the data of the record you want to be deleted.
To start the archiving:
Process, follow the menu path:
Logistics - Materials Management –Material - Master - Other - Reorganization - Special Stock – Choose to select the records to delete and
Logistics - Materials Management - Material Master - Other - Reorganization - Special Stock - Reorganize to create archive file.
Create Archive File: Consignment Record: Data selection
a) Select Action: Archive and enter a new Variant, for example: Z_CONS_SELE_01, press 'Maintain' b) On selection screen enter the data range (Vendor, Material, etc.) you want to archive.
c) Select the 'Create Output File' if you want the selected records outputted
d) Press the green back-arrow and enter the description of this new variantt on the screen which follows.
e) Save the variantt which brings you again to the selection screen. Press green the back arrow again. f) To start archiving process (batch-job), press the 'Start Date' button and select the time when you want to start this process. Select 'Immediate' for instant processing and press the 'Save' button on the bottom of the 'Start Time' window.
