Friday, March 30, 2012

Report RSBTCDEL2 to delete old jobs

The job SAP_REORG_JOBS is a standard job which runs a report RSBTCDEL2 to delete old, canceled, inconsistent, non-deleted jobs from the system. But the SAP systems older than release 4.7 used RSBTCDEL report to delete the old jobs. But in those systems, after upgrade it may not run and create a dumpTSV_TNEW_PAGE_ALLOC_FAILED as the old jobs get accumulated and cause memory problem.
Solution: So in those systems we need to schedule a job with report RSBTCDEL2 and variant which specifies the time range after which the jobs need to get deleted from the system. To create a new variant for the report RSBTCDEL2 we need to know the time range after which the jobs need to get deleted from the client.

1. Create a new variant in Transaction SE38 specifying the number of day’s range after which the jobs need to get deleted from the system.

2. Change the job from released to scheduled and delete the old RSBTCDEL report. Schedule it with the new job RSBTCDEL2

click on save
The job will now work fine since the program and Variant have been replaced.

Thursday, March 29, 2012

SAP Security related activities in Upgrade

The SAP system profile parameter auth/no_check_in_some_cases has the value
“Y”. If the profile parameter is set to .N, the value must be changed. (This ensures better security).

If roles were already used in the source release, they must be updated. Transactions that were selected in the menu of existing roles can be protected using additional authorization objects in the target release. This means that tables USOBT_C and USOBX_C have to be updated as well as the existing roles.

The SU25 tcode is used for to fill the customer tables of the profile generator the first time the profile generator is used, or update the customer tables after an upgrade.

1. SU25
Step 2A

Compares the new USOBT and USOBX tables with USOBT_C and USOBX_C.
This compares the Profile Generator data from the previous release with the data for
the current release. New default values are written in the customer tables for the
Profile Generator

Step 2B
Add any new transactions/updates to tables USOBX_C and USOBT_C.

If you have made changes to the check indicators or field values in transaction
SU24, you can compare these with the new SAP defaults. You can see the values
delivered by SAP and the values that you changed next to each other, and can make
an adjustment, if desired.

Steps 2A and 2B make changes to the customer tables of the Profile Generator.
If you want to transport these changes, choose step 3 in transaction .SU25. Before implementing any changes in system, take corresponding business approval for all role changes. The step 2C and 2D step will clearly identify the roles affected and new tcodes introduced in new systems.

Step 2C

This step guides you through all the roles that are affected by newly added authorization checks and that have to be changed to correspond. The corresponding authorization profiles need to be edited and regenerated. You can jump directly to role maintenance.

SU25, 2C step also contains the new SAP roles introduced.

If you go to one by one role, there are some authorization objects that are got affected during upgrade. We can categorize these authorization objects as below:-

1. Standard New – These are new authorization objects that are introduced in new system for corresponding tcode.

2. Manually new - It shows the authorization objects which were manually added in old system. Some of the values got updated for this also.
3. Standard Updated - Updated means, in old system if you have kept the standard values as it is, SAP has updated these standard values (u can check this one in SU24 check indicators).
4. Maintained New- Some of the organizational values introduced as field in authorization object.

After maintaining all new authorization objects, you can save it and generate the profile. If you get back to SU25 2C step shows all the roles with green signal. Means all roles saved and generated.

SU25, 2C step also contains the new SAP roles introduced.
After generating all profiles in SU25 2C step, you can jump to 2D step.

Step 2D
If you execute this step, it will show the list of roles and old tcode and corresponding new tcode.
If business wants to use new tcode, then u can replace old tcodes by new one by clicking on automatically adjust menu. Otherwise go to manually adjust menu and generate the profile.
The new tcodes are introduced in 2D step, this doesn't means the old tcodes are no longer exists in new system. We have to check manually for each and every tcode.Some tcode does not exists in new systems. FOr e.g. RZ02 is replaced by RZ20 in ECC6. RZ02 no longer exists in ECC6.

This step transports the changes made in steps 1, 2a, and 2b. Tailoring the Authorization Checks .This area is used to make changes to the authorization checks.

Changes to the check indicators are made in step 4. You can also go to step 4 by calling transaction-SU24.

You can then change an authorization check within a transaction.

1. When a profile to grant the user authorization to execute transaction is generated, the authorizations are only added the Profile Generator when the check indicator is set to Check/Maintain.
2. If the check indicator is set to do not check, the system does not check the authorization object of the relevant transaction.

Review Items:-
Security Related Parameters
You can compare and check security related parameters from old release to current release.
Review users (via SU01) to check for any new or changed fields on the user masters (Check especially background user-ID for authorizations, to avoid cancellation of batch jobs).

Wednesday, March 28, 2012

Time Zone conflict between 000 client and other clients in SAP

While executing the transaction code ST03N in SAP some time problem comes that there is a conflicts in Time Zone between 000 and other clients in the same system.


1) Execute the transaction code stzac in both of the respective clients.

2) Check whether System Time Zone and User's Default Time Zone are same in both the clients.

3) If not the maintain both the Time Zone i.e., System Time Zone and User's defaults Time Zone Same in both the clients.

While Saving it will create a Transport Request.

Again check with the Transaction Code ST03N you will find conflict has been resolved

Tuesday, March 27, 2012

How to disable Import All option from STMS in SAP

How to Remove Import All Option from STMS in SAP

Any changes made in the development server needs to be transported to the Quality server for checking and then finally in Production server.

So Importing the Transport Requests is the critical. Sometimes by mistake if one click on the button Import All in the production environment all the Transport Request which is in released status or already Imported to Production can be directly Imported to the production environment (Which may not be required in the Production). This will create great impact in the production Server.

To avoid such situation, IMPORT ALL Icon should be disabled in STMS.

Procedure to Disable IMPROT_ALL Icon in STMS:-

1) Go to STMS Tcode

2) Go to Menu Option Overview

3) Select System

4) Choose SAP SYSTEM

5) Go to Transport Tool Tab

6) Create Parameter "NO_IMPORT_ALL" with value 1 (True)

7) Save it.

Once it is done the Import_ALL icon will be Disabled from STMS.

Monday, March 26, 2012

How to Clear SCOT Error from Production Server

How to Clear SCOT error form Production Server

1) Execute SCOT transaction

2) Go to Utilities

3) Overview of Send orders

4) Go to SOST transaction and Select all error messages . You can use Tab send status for this and by using the respective tick marks.

5) Select Error Data and Repeat Data

6) Go to SM37, select the respective Jobs , Copy the Jobs and Release with an authorized user or your ID.

7) Check with SCOT transaction all error data has cleared.

Friday, March 23, 2012

How to Execute OS Level command from SAPGUI

Step by Step Procedure to Execution of OS Level command from SAPGUI

1) Execute Transaction Code SA38/ SE38.

2) Write the report name RSBDCOS0

3) Execute the Report

4) Type any OS Level Command and do work from GUI

Thursday, March 22, 2012

How to Disable Multiple Logins on SAP

To disable multiple user logins within the same client implement this parameter in the instance profile:
login/disable_multi_gui_login = 1
If you do not use this parameter in your system, users have the ability to ignore the warning window at the time they try to login to the same client. Activating this parameter in your system will make you look good if you get audited.
In case you’re wondering how to allow multiple logins for certain key users you can implement parameter login/multi_login_users. You can list the user IDs that should be ignored if the parameter above is active in your system.

Wednesday, March 21, 2012

SAP Basis Info Toolkit

In these documents you will get tips and tricks of Basis Operations on Windows,UNIX and Linux.Besides you will get answer to those questions;
what do I need to backup?
how often do I need to backup?
what are my backup options?
Client Tasks
add a client?
add a logical system ID to be assigned to a client?
change a client?
copy one client to another in the same R/3 system?
copy one client to another in different R/3 systems?
copy only user master data from one client to another?
delete a client?
lock a client so configuration changes cannot be made?
verify that a client copy ran successfully?
view all past client copies for a client?
Communications Tasks
add a RFC connection?
delete a RFC connection?
modify a RFC connection?
verify one R/3 system is talking to another?
Database Tasks
perform Database Stats, Check Database, and Backup Jobs – MS SQL Server?
perform Database Stats, Check Database, and Backup Jobs – Oracle?
Job Tasks
change the start time/date for a scheduled job?
clean out old job logs?
delete a scheduled job?
delete a running job?
schedule a new job to run?
verify that a job has run successfully?
Printer Tasks
add a printer?
create a new Frontend aka Local aka Desktop Printer?
reprint a document that has already printed?
reroute a printer output request?
reset the cache for a printer?
view a list of all printer output requests?
view a list of the output requests for one printer only?
Security Tasks
attach a role to a user?
attach a user to a role?
copy an existing role to a new role?
create a user role?
delete a user role?
grant a transaction to a user?
modify a user role?
move roles from one client to another?
revoke an authorization from a user?
revoke a transaction from a user?
Support Package and Binary Patch Tasks
apply a SPAM/SAINT update?
apply kernel patches?
apply other SAP binary patches?
apply support packages?
check for New SPAM Updates, Support Packages and Kernel Patches?
download a kernel patch from SAP Marketplace?
download a SPAM/SAINT Update?
download a support package from SAP Marketplace?
download other SAP binary patches?
find your Current SPAM Update and Support Package Level
know when SAP releases new fixes for our SAP software?
ready a kernel patch for application?
find SAP’s most current patches?
find your Current Kernel Patch Level?
find your Current SPAM Update and Support Package Level?
know when SAP releases new fixes for our SAP software?
ready a kernel patch for application?
ready a SPAM/SAINT update or Support Package for application?
ready other SAP binary patches for application?
System Tasks
add a system parameter?
apply a SAP (OSS) note?
check that the system parameters are valid?
delete a system parameter?
generate a developer’s key for a programmer?
generate an object key to change a SAP-owned object?
how do I make server files viewable from SAP?
keep all users out of a transaction?
modify a system parameter?
open a service connection for SAP to come into my system?
reclaim system space from obsolete temporary objects?
recompile all ABAP programs in a R/3 system?
send a message to all connected users?
send a message to one connected user?
start R/3?
start saprouter (OSS Link)?
start the OS collector?
stop a SAP work process?
stop R/3?
stop saprouter?
stop the OS collector?
stop the R/3 subsystem?
verify that our link to SAP is up?
verify that R/3 is up?
verify the status of saprouter?
view a short dump received by a user?
view all processes currently running?
view all system locks?
view all table locks?
view all update locks?
Transport Tasks
add a change request to a transport queue?
add a new SAP Instance to an Existing TMS Domain?
automate the Transport Process?
configure TMS – Transport Management System – for the First Time?
configure TMS to Use SAP’s Quality Assurance Functionality?
re-Transport One or Several Change Requests at Once?
transport a change from one R/3 system to another?
transport several change requests at once?
verify that the transport system is up and running?
view a history of what changes have been transported?
use Target Groups to Transport to Mulitple Clients to Different Instances?
User Tasks
add a user?
add an ITS user?
change a user’s password?
change several users at once?
copy an existing user to a new user?
delete a user?
delete an ITS user?
drop a connected user?
get a list of all users in a client?
lock a user?
lock all users at once?
modify a user?
modify an ITS user?
produce various user reports?
start an audit trace for a specific user?
view a list of all users currently connected?
Web and Internet Tasks
start and stop the SAP IGS Server?
Working with the SAP Marketplace
apply a SAP License Key the new way?
apply a SAP License Key the old way?
check the status of a request License Key?
find your Hardware Key?
generate a Developer’s Key for a Programmer?
generate an Object Key for a Programmer?
open a Problem via SAP Marketplace?
open a Service Connection for SAP Support to allow SAP access?
request a new License Key?
request a SAP Marketplace User ID aka “S” Number aka OSS User ID?

Tuesday, March 20, 2012

Useful Procedures on SAP R/3

Below you will find some tips and tricks which are for commonly used procedures in SAP and that will save your time. Mainly the topics are;
  • User File Capture of SAP Print Spool Output
  • Determining Where a Field is Used
  • System Access to Logical Databases
  • Listing Standard SAP Reports Listing Reports by Group
  • Listing the Reports Tree
  • Make a Text File of an ABAP Program
  • Exporting a Report Writer Report

User File Capture of SAP Print Spool Output
  1. Run an SAP program that creates a report and spool the report output
  2. Examine the spool retained files
  3. Save the spool file to local storage
  4. The “Print Preview for Local Printer” screen displays
  5. Select the “System / List / Save / Local File” menu item
  6. Select “unconverted” in the “Save List in File…” dialog
  7. Enter a file name in the “Transfer List to a Local File” dialog, i.e., “C:\SAPworkdir\PA0001.txt”
  8. Click the Transfer button
Determining Where a Field is Used
  1. Locate the field definition via the Data Dictionary (T/C SE16, SE11 or SE84)
  2. Click on the Where-used list icon
  3. Select the type of structure in the Where-Used List Data Database Tables dialog (i.e., DB tables)
  4. Click the Execute button
  5. The list of tables/structures using the field is displayed
System Access to Logical Databases
  1. Log on to the SAPGUI
  2. Follow the menu path; or use T/C SE36:
    Tools – ABAP Workbench – Development – Programming Environment – Logical Databases
    to open the “Logical Database Builder” screen (T/C SE36)
  3. At the Logical Database Selection screen, enter a logical database such as “PNP”
  4. Select the “Structure” or “Database program” subobjects and click Display. In this instance, select “Structure”.
  5. In the “Display Logical Database PNP” screen, select a data line (Node type = Table) such as “PERNR”
  6. Click the Display structure button. Review this screen.
  7. Now follow the menu path: Utilities – Runtime object – Display. Review this screen.
  8. Return to previous screen. Reselect the data line PERNR and choose the Source Code button and review this screen.
Listing Standard SAP Reports Listing Reports by Group
  1. Log on to the SAPGUI
  2. Enter T/C SA38 — or follow the menu paths below
  3. From the main SAPGUI page (T/C S000), follow the menu path:
    System – Services – Reporting
  4. The “ABAP: Execute Program” screen appears (T/C SA38)
  5. Follow the menu path:
    Utilities – Find Program. The “ABAP Program Directory” screen appears
  6. Enter “RP*” in the left Program entry box (enter an extra character plus the wildcard, such as “RPL*” for List Reports)
  7. Click the Execute icon
  8. The “ABAP Program Directory” screen appears
  9. To save the list, follow the menu path: System – List – Save – Local file
  10. Select an output format (such as “Spreadsheet”); click the Continue icon
  11. Enter the local file name and Save the file
  12. You can also view any available documentation and/or execute the report
  13. Select “RPLCMP01″ (Display Pay Grade Structure)
  14. Check its documentation and then execute the report
  15. Return to the “ABAP Program Directory” screen and enter “GP4QL*” and Execute
  16. Select the first line and click on the F7 key
  17. Review the list of includes for this program
Listing the Reports Tree
  1. Log on to the SAPGUI
  2. Enter T/C SARP to search for specific report trees
  3. Return to the main SAPGUI screen (T/C S000)
  4. Enter T/C HR00
  5. The Level 0 hierarchy of HR reports are displayed
  6. Navigate the tree by clicking on the outline graphics
  7. Double click a report name to run the report
Make a Text File of an ABAP Program
  1. Log on to the SAPGUI
  2. Enter the T/C SE38
  3. The “ABAP Editor: Initial Screen” displays
  4. Enter the ABAP program name in the Program line
  5. Click the Display button
  6. Instructions continued below…
Copy the ABAP Program Source File to a Local Text File(Continued from previous tip)
  1. With the ABAP program source code in view within the ABAP Editor, follow the menu path:
    Utilities – More utilities – Upload/Download – Download…
  2. A standard Windows “Save As” pop-up window appears
  3. Enter a local text file name (i.e., “C:\SAPworkdir\RPARlW00.txt“)
  4. Click the Save button
Exporting a Report Writer Report
  1. Log on to the SAPGUI
  2. Enter T/C GR37
  3. Enter the appropriate Library, i.e., 1VK
  4. Enter the appropriate Report name, i.e., 0F-PER
  5. Under the Further details section, select “Export to presentation server”
  6. In the Export file line, enter a local text file name (i.e., “C:\SAPworkdir\0F-PER.txt“) or use the drop-down arrow and select an location and file name
  7. Click on the Execute button