SAPTechNet

Transport Export

2008-07-01T10:37:00.004Z

If you have released an SAP transport and have had export problems or have (recently) lost the exported cofiles and data files, here's a way to re-export the transports and get a new set of co files and data files.

A simple way is to run tp export on OS level and follow the syntax, the only problem with this is I have found inconsistencies with the target clients. I have not been able to set more than one target client while I might have a target group in my stms config. i.e.: the exported transport from DEV should come up as having 3 or 4 times in the QA import queue with different clients number.

A complicated and a not-so-recommended method is to sqlplus and change the status of the transport to not released in the table E070.

Relevant fields:
TRKORR and TRSTATUS

SAP startup/R3trans errors on AIX/HP-UX/Unix/Linux

2008-07-01T10:22:00.005Z

If R3trans -d returns:
exec(): 0509-036 Cannot load program R3trans because of the following errors:
0509-150 Dependent module libsapu16.so could not be loaded.
0509-022 Cannot load module libsapu16.so.
0509-026 System error: A file or directory in the path name does not exist.

try setting LIBPATH to /usr/sap/'<'SID'>'/SYS/exe/run on AIX or SHLIB_PATH (HP-UX) or LD_LIBRARY_PATH (other UNIX systems)

Useful Notes:
602843 - Environment settings for R/3/Oracle on UNIX

Also look at related notes below the text on this note.

How to find values of Soft Resource Limit Stack and set it (on AIX)

2008-06-20T09:21:00.003Z

While installing SAP on AIX you get a Condition not met error for Soft Resource Limit Stack Size.

You now want to set the Soft Resource Limit Stack to unlimited.

You can see the current values by typing:

ulimit -S -a to view soft limits
and
ulimit -H -a to view hard limits

Example output:
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000

To set the value:

You can either modify the file /etc/security/limits (as root)

Procedure:

vi /etc/security/limits
Add lines:
stack_hard = -1
stack_soft = -1

for the users you want the limits set/unset for.

or follow the smitty interactive procedure.

Type smitty user
Select Change / Show Characteristics of a User
Type User NAME
Press Enter

Set
Soft STACK size [-1]
and
Hard STACK size [-1]

-1 = unlimited

OK and exit.

Restart prerequisites run or continue SAP Install

How to find whether your install is Unicode or not

2008-06-20T09:17:00.002Z

Logon as adm
run: disp+work -version

Look for the compilation mode in the result. Example below

--------------------
disp+work information
--------------------

kernel release 700

kernel make variant 700_REL

compiled on AIX 2 5 005DD9CD4C00

compiled for 64 BIT

compilation mode UNICODE

compile time Oct 29 2006 20:39:06

update level 0

patch number 83

source id 0.083

---------------------
supported environment
---------------------

database (SAP, table SVERS) 700

operating system
AIX 1 5
AIX 2 5
AIX 3 5

libclntsh.a Install error

2008-04-16T16:13:00.003Z

Error:

exec(): 0509-036 Cannot load program /sapmnt//exe/R3load because of the following errors: 0509-150 Dependent module /oracle/client/92x_64/lib/libclntsh.a(shr.o) could not be loaded. 0509-022 Cannot load module /oracle/client/92x_64/lib/libclntsh.a(shr.o). 0509-026 System error: The file access permissions do not allow the specified action.ERROR 2008-04-16 16:53:18 [iaxxbdbld.cpp:574] CR3ldStep::createR3ldTskFiles lib=iamodload module=CR3ldStepMSC-01004 Could not create task file /oracle//sapdata1/dbinstall/SAPSSEXC.TSK

Check/change LIBPATH settings on AIX or LD_LIBRARY_PATH on HP-UX.

Check/change permissions on the lib* files in the lib directory.

Sorted!

How To... Handle caches in SAP XI/PI systems

2008-02-14T15:00:00.004Z

How To… Handle Caches in SAP XI 3.0 by SAP [pdf link to sap.com, requires s-user id] helps you understand where caches are used, how to update/clear caches and troubleshoot problems in SAP XI/PI 3.0

ABAP and Adapter Runtime Cache
SLD Cache
Repository Cache
CPACache

Save SAPGUI Password

2007-03-08T09:36:00.000Z

This is NOT recommended by SAP (or me).

By default, you can't save passwords in SAPGUI shortcuts under SAPGUI 7.10. However, if for some reason you would like the passwords to be saved for shortcuts, you could follow the steps below, and edit the (existing) shortcuts to save your passwords.

You will find the path HKEY_CURRENT_USER\Software\SAP
exists in the registry once you've installed SAPGUI 7.10
(windows cmd: regedit)

Create the following keys under HKEY_CURRENT_USER\Software\SAP:
\SAPShortcut\Security

Create a String Value under Security: 'EnablePassword' and set it to 1

This will allow you to save passwords for SAP Shortcuts.

To reset this to 0, run sapshcut.exe without parameters - this will reset the entry to 0.

SAP_REORG_UPDATERECORDS fails/cancelled

2006-11-07T09:37:00.000Z

SAP_REORG_UPDATERECORDS job in SRM / BW systems fails with job log "Reorganizing update data in the background is prohibited".

This will be resolved by applying kernel patch 254 on Release 640

Read notes:

67014 and 16083 for further information and profile parameter changes.

Installation fails with R3SAPSYSTEMSERVICE_NT_IND

2006-11-02T01:54:00.000Z

If the installation fails during step: R3SAPSYSTEMSERVICE_NT_IND or starting the SAP service ends with an error: The dynamic link library librfc32.dll could not be loaded.

follow the steps below:

Execute R3DLLINS
Follow Note 142100 and run sapstartsrv -t register and start the service

Upload fonts in an SAP System/ Font Maintenance

2006-10-12T15:51:00.000Z

Use SE73 to maintain / upload new fonts in SAP

Transaction SE73

Display/Change Font Families by clicking on the font families button and change/display as required

Display/Change System Fonts by clicking on the System fonts button and change/display as required

To Install a new font, for example Arial:

Click the truetype-font install button (first screen shot)

You will see the following screen

I have added the details of the example font as below:

DO NOT select bold and italic in the screen above if you're uploading the regular font file.
Select Bold, Italic and both while uploading the Arial Bold, Arial Italic and Arial Bold Italic respectively.

You might be asked to reselect the file from the Fonts directory

Next enter the RTF font info

You will also need to create/confirm a transport request number.

The font install should complete in a few minutes and you will be presented with the following screen

If you go to the style selector now you would only be able to use the regular font without Bold or Italic attributes, to be able to use either Bold or Italic attributes, you will need to repeat the procedure of uploading the font again but select either one check box or both for the respective attributes.

Install the same font with a different attribute as below:

(Incorrect screenshot above - the filename should correspond to the correct attribute selected in the checkbox)

Note that the only attribute selected above is BOLD

You will now be asked confirm if you want to install an additional font to the same family

Click Yes

Select the file again from the pop-up, enter rtf info and confirm the transport request.

Repeat this process for italics if needed.

Job Done!

You now have a new font family.

You will also find a number of system fonts added. These are the sizes and attributes that were supported by the .ttf file that we used to add the font to the system.

Also if you create or change a style you would be able to see font and attribute selection options as below

Convert Spool or OTF to PDF

2006-07-18T11:00:00.000Z

RSPO_DOWNLOAD_SPOOLJOB to get an Excel spreadsheet for a Spool request

Convert Spool or OTF to PDF

2006-07-18T10:20:00.000Z

Report RSTXPDFT4 converts Spool or OTF to PDF

Using Process Chains in SAP Business Information Warehouse

2006-06-03T12:55:00.000Z

Using Process Chains in SAP Business Information Warehouse

by
Alexander Peter
Product Management BI, SAP AG
and
Thomas Rinneberg
Development BI, SAP AG

SAP BW Process Chains

2006-06-03T12:54:00.000Z

Good read on SAP BW process chains
covers all aspects of a process chain and for an SAP BW help document the language is easy to understand.
Process Chains
(opens up in a new browser - links to help.sap.com)

How To… Integrate an ABAP program in a process chain

2006-06-03T12:52:00.000Z

A very informative read on How To… Integrate an ABAP program in a process chain
Presentation created by SAP(opens up in a new window in your web browser using Acrobat)

Process Integration – Monitoring

2006-03-28T15:04:00.001Z

A very informative podcast, presentation, online e-class available from SAP, overview and demo by Andreas Stolz (blog entry by Uri Levy) titled Process Integration – Monitoring

Permalink here
Link to
Audio
eBook
Presentation

All material linked here is authored and copyright by SAP AG

BOR Objects - Business Object Repository

2006-03-15T14:02:00.000Z

Business Object Repository (BOR) in an SAP system is a central repository containing all the SAP business object types and SAP interface types along with their respective definitions and methods.

BOR objects can be created/changed/displayed using transaction SWO1 ( Business Object Builder )

Further help and guidance on the Business Object Builder can be found here. [Link to SAP Help]

BOR Objects can be searched for in SAP transports using the following Program ID and object type

PgmID Obj
R3TR SOBJ

A quick how-to on Defining Methods in the BOR Using the BOR/BAPI Wizard is available on the SAP Help site. Click here

Dynamically Configuring RFC Quotas

2006-03-08T15:30:00.000Z

Start the report RSARFCLD to dynamically configure the RFC quotas on the server to which you are logged on.
Double-click on a server name.
Enter change mode and change the values.
The values that can be set here overwrite (until the next restart) the following parameter values (in the same order):

rdisp/rfc_use_quotas
rdisp/rfc_max_queue
rdisp/rfc_max_login
rdisp/rfc_max_own_login
rdisp/rfc_max_own_used_wp
rdisp/rfc_min_wait_dia_wp
rdisp/rfc_max_comm_entries
rdisp/rfc_max_wait_time

Click Save
The quotas for RFC resources have now been set/reset.
The settings made using the report only apply to the instance to which you are currently logged on, and are lost when the instance is next restarted.

Operating BW 3.0 using Process Chains

2006-03-06T12:51:00.000Z

Operating BW 3.0 using Process Chains
by Rudolf Hennecke SAP AG, RIG BI

Covers a lot of ground on automating BW administration, monitoring, modelling and related topics

Set-up Help in SAP R/3 ECC BI XI NW04 products

2006-02-13T14:07:00.000Z

To set -up help variants:

Goto Transaction SR13
To set-up web help from sap follow the steps below or enter your custom server/path details.

Goto PlainHtmlHttp tab
New Entries
Enter variant name
Platform is: WN32 for Windows (frontend)
Area: IWBHELP
Server name: enter your server name where you've copied/set-up the help CD delivered by SAP with your installation package or get a public server name from SAP or try help.sap.com
Enter path: NW04/helpdata for netweaver products (default path)
Language: EN for English
Click the default box if you want this help variant to show up when users click Help -> Application Help on their frontend.

Save and store this information in a workbench transport request and exit.
A cup of coffee wouldn't hurt here...

No address in SAPoffice! error

2005-12-12T10:00:00.000Z

Error: Please inform your system administrator that your user: 'user name' has no address in SAPoffice!

Run program RSADRCK2 in se38 to resolve.

ABAP Examples

2005-09-18T06:34:00.030Z

Run the following transactions for ABAP demo programs and related information

ABAPDOCU
DWDM
BIBS
LIBS

SAP Calculator

2005-09-18T06:34:00.029Z

Try the t-code PTRV_CALC to run Internal Calculator in SAP works on: 4.6B, 4.6C and 4.7

User Interface Design Examples

2005-09-18T06:34:00.028Z

Use transaction BIBS to view different examples of user interface design from SAP.
This transaction provides "Examples of the ergonomic interface setup" according to SAP.
There are numerous examples for screens, menus, prompts, messages and many more elements.

Table Relationships

2005-09-18T06:34:00.027Z

Works in 46c - Not available in 4.7 x110

Run SE49 entering a transaction, program, function, etc.
Execute it and the screen will display table list grouped by actions performed.
Select table and then click the show code button to see how the transaction addresses the table.
Double click on the table and it takes you into SE12 where you see the DDIC description of the tabel, from there you can follow the menu for Utilities / table contents which takes you into SE16 (general table display).

Useful Function Modules

2005-09-18T06:34:00.026Z

A list of useful function modules. However, some of these are not available in 4.7

BP_EVENT_RAISE
Trigger an event from ABAP/4 program.
BP_JOBLOG_READ
Fetch job log executions filling the structure TBTC5.
G_SET_GET_ALL_VALUES
Fetch values from a set filling the structure RGSB4.
POPUP_TO_CONFIRM_LOSS_OF_DATA
Create a dialog box in which you make a question whether the user wishes to perform a processing step with loss of data.
POPUP_TO_CONFIRM_STEP
Create a dialog box in which you make a question whether the user wishes to perform the step.
POPUP_TO_CONFIRM_WITH_MESSAGE
Create a dialog box in which you inform the user about a specific decision point during an action.
POPUP_TO_CONFIRM_WITH_VALUE
Create a dialog box in which you make a question whether the user wishes to perform a processing step with a particular object.
POPUP_TO_DECIDE
Create a dialog box in which you require the user between the two processing alternatives, or to cancel the action.
POPUP_TO_DECIDE_WITH_MESSAGE
Create a dialog box in which you inform the user about a specific decision point via a diagnosis text.
POPUP_TO_DISPLAY_TEXT
Create a dialog box in which you display a two-line message.
RFC_SYSTEM_INFO
Fetch information from the current instance filling the structure FRCSI.
RS_SEND_MAIL_FOR_SPOOLLIST
Send messages from ABAP/4 programs to SAPoffice. The structure SOLI may contain the message.
RZL_SLEEP
Hang the current application from 1 to 5 seconds.
RZL_SUBMIT
Submit a remote report.
SAPGUI_PROGRESS_INDICATOR
Set progress indicator on the left lower corner of the current window.
SD_PRINT_TERMS_OF_PAYMENT
Format terms of payment according to base line date and payment terms.
SO_WIND_SPOOL_LIST
Browse printer spool numbers according to user informed.
SO_SPOOL_READ
Fetch printer spool according to the spool number informed.
SO_USER_LIST_READ
List of all users filling the structure SOUD3.
SPELL_AMOUNT
Return the amount in words filling the structure SPELL.
TH_SAPREL
Gather information from the current system including upgrade activities. It completes fields from the structure KKS03.
TH_SERVER_LIST
Gather information of all instances filling the structure MSXXLIST.
TH_USER_LIST
List of logged users filling the structure UINFO.
TH_USER_INFO
Information about the current user. It completes fields from the structure KKS03.
TH_WPINFO
List of work processes filling the structure WPINFO.
WS_UPLOAD
Transfer files from the frontend to the application server.
WS_DOWNLOAD
Transfer files from the application server to the frontend.
WS_EXCEL
Download files at the frontend in excel format.
WS_EXECUTE
Execute an external program on the presentation server.
WS_FILE_DELETE
Delete file at the frontend.
WS_VOLUME_GET
Get the label from a frontend device.
WS_MSG
Create a dialog box in which you display an one-line message.
WB2_READ_CUSTOMER_NAME
Get Customer names
HAZMAT_MATNR_GET_TEXT
Get material description
MRM_DBTAB_KONV_READ
Read table Konv
RV_ORDER_FLOW_INFORMATION
Read Document flow
CATS_NUMERIC_INPUT_CHECK
Check if a string is a number
RFC_GET_TABLE_ENTRIESRFC_READ_TABLE
Read a table via RFC
SD_ARRANG_BILLING_DOCS_READ
Read billing documents

Last modified: 2005/09/18 - / Author: phpwcms webmaster

About function groups and function modules

2005-09-18T06:34:00.025Z

Function groups are containers for function modules. You cannot execute a function group. When you call an function module, the system loads the whole of its function group into the internal session of the calling program (if it has not already been loaded).

SAPL contains nothing but the INCLUDE statements for the following include programs:

LTOP. This contains the FUNCTION-POOL statement (equivalent for a function group of the REPORT or PROGRAM statement) and global data declarations for the entire function group.

LUXX. This contains further INCLUDE statements for the include programs LU01, LU02, ... These includes contain the actual function modules.

The include programs LF01, LF02, ... can contain the coding of subroutines that can be called with internal subroutine calls from all function modules of the group.

All of the function modules in a function group can access the global data of the group. For this reason, you should place all function modules that use the same data in a single function group. For example, if you have a set of function modules that all use the same internal table, you could place them in a function group containing the table definition in its global data.
Like executable programs (type 1) and module pools (type M), function groups can contain screens, selection screens, and lists. User input is processed either in dialog modules or in the corresponding event blocks in the main program of the function group. There are special include programs in which you can write this code. In this way, you can use function groups to encapsulate single screens or screen sequences.

Access memory variables used by another program

2005-09-18T06:34:00.024Z

Question: If a program (eg.: ZXYZ) calls a function module, can I access memory variables that are available in ZXYZ, but are not passed to the function module?

Answer:Yes!!!

Here is a sample code to access an internal IT_DATA from ZXYZ

===============
DATA: var_name(30) TYPE c VALUE '(ZXYZ)IT_DATA[]'.

TYPES: BEGIN OF st_data,
**** The same definition as IT_DATA in program
END OF st_data.

DATA: wa_data TYPE st_data.

FIELD-SYMBOLS: TYPE ANY TABLE.

ASSIGN (var_name) TO .

LOOP AT INTO wa_data.

WRITE : / wa_data.

ENDLOOP.

===============

Debug a finished batch job

2005-09-18T06:34:00.023Z

To debug a finished batch job

Run tcode: SM37 and select for finished jobs.
Select the job.
In the command field, type JDBG and hit enter.
Do not use /n or /o.

This will simulate the exact background scenario with the same selection screen values as used in the job. SY-BATCH will be set to 'X'.

Another list of useful transaction codes

2005-09-18T06:34:00.022Z

1. Developing

S001 Abap Workbench
SE09 Workbenche organizer (Transports)
SE11 ABAP/4 Dictionary
SE16 Data browser
SE24 Class builder
SE30 ABAP Runtime analyzes
SE32 ABAP/4 Text Element Maintenance
SE35 ABAP/4 Dialog Modules Maintenance
SE36 Logical Databases
SE37 Function builder

SE38 ABAP/4 Editor
SE39 Program Comparison
SE41 Menu Painter
SE43 Area Menu editor
SE48 Call hierarchy
SE49 Program analysis: Table Manipulation
SE51 Screen Painter: Initial Screen.
SE55 Table maintenance dialog
SE80 Repository browser
SE91 Message Classes
SE93 Maintain transaction

SHDB Batch input recorder
SM30 Maintain table views
SM35 Monitor batch input

ST22 Short dump analysis

2. Monitoring

ST05 SQL Trace

ST07 Application monitor

3.System

SM04 User overview ( Possible to end sessions)
SM12 Table lock Entries
SM21 System log for viewing dumps
SM36 Define background jobs
SM37 View background jobs
SM50 Process Overview

SU53 Display Authorization Values for User

SLG1 View application log
SLG2 Delete application log

SPAD Output devices
SP01 See spool

4. SapScript

SE71 Form painter
SE72 Style maintenance
SE73 SAPscript font maintenance.
SE74 SAPscript format conversion

SE75 SAPscript Settings
SE76 SAPscript Form Translation
SE77 SAPscript Style Conversion
SE78 SapScript Graphics Management
SO10 Create standard text module

5. Workflow
SWDM Workflow explorer
SWDD Workflow builder
SWUS Start workflow - Test enviromnent
SWU0 Simulate event
SBWP Business workplace
PFTC_INS Create Task/Task group
PFTC_CHG Change Task/Task group
SWUD Dagnosis
SWI1 Work item selection

6. Enhancements and modifications

CMOD Enhancementprojects
SMOD List SAP enhancements to use in CMOD
SHD0 Transaction variant maintenance

7. Other

ABAPDOCU ABAP coding examples supplied by SAP

AL11 Look at directories on the host system ( With drill down )

LSMW LSM Workbench

OSS1 OSS

SA38 Submit batch job

SE01/STMS Transport system

SPRO Start SAP IMG
SPAM Support packet manage

SU03 Maintain Authorizations: Object Classes
SU51 Display Authorization Data (Can be called after failed authorization)

SWEC Events for change documents

SW01 Business Object Builder
SWO4 Display Businesss Object Types

VOK2 Maintain Output Determination

SNRO Number range object maintenance.

add the following too:

SM66 - Global Process Overview
SM51 - Server details
SM50 - Process Overview
RZ03 - Configure Servers
SP01 - Print Jobs

search_sap_menu
SU01 - user maintenance

PFCG - Role Maintainance
SMQ1 - Outbound Queue
SMQ2 - Inbound Queue
ST03 - Workload Analysis
ST03N - Advanced Load Analysis
ST02 - Tune Summary
ST04 - Performance DB
SM13 - Update Records
STAT - User Statistics
SM20 - Security Audit Log
SLICENSE - SAP License Admin
SE93 - Transaction Code Creation
SM04 - Active Users List
SR13 - SAP Library Admin
SO01 - SAP Office Inbox
SCC3 - Client Copy Log

AL08 User overview on all server in system

VOK3
SM03
SMLG
SE10 - Transport Organizer
SCC1 - Apply transports to clients within same system

SLIN
SPAU
SPDD
ICON
SMARTFORMS (4.6C Onwards)
SMARTSTYLES (4.6C Onwards)
SE18
SE19
BALE
SALE
BAPI

For Enterprise Version

UCCHECK
SCII
SPADE (Client 000 only)

Useful Transaction Codes

2005-09-18T06:34:00.021Z

Compiled here is a list of commonly used transaction codes for SAP-BASIS System Administrators, I am currently working on adding further descriptions and explanations (man pages) to attach to every t-code below. If anyone wants to help out with this, please e-mail me.

AL08 Lists current active users - on all the application servers

AL11 Lists SAP Directories on the OS Level for the application server

DB01 Lists applications waiting in a lock-wait or deadlock situation on Oracle.

DB02 Database performance on Oracle

DB03 Displays configuration: parameter changes in database on Oracle

DB05 Analysis of table with respect to indexed fields on Oracle and DB6

DB6BACKHIST Backup and Recovery: Overview

DB6COCKPIT Diagnostics: System Check on DB6

DB6EXL Lists applications waiting in a lock-wait or deadlock situation on DB6.

DB6PARHIS Displays configuration: parameter changes in database on DB6

DB6PERF Performance: Database Snapshot

DB6SPACE Space: History - Overview on DB6.

DB12 Backup logs on Oracle

DB13 DBA planning calendar on Oracle

DB14 DBA logs on Oracle

OSS1 Logon to SAPNet (OSS)

RZ03 Display Server statuses and alerts (all servers)

RZ04 Maintain operation modes and instances

RZ10 Edit/Maintain profiles

RZ11 Display profile parameter maintenance and current values

RZ20 CCMS Monitor Sets

RZ21 Maintain Monitoring: Properties and Methods

SCAT Computer Aided Test Tool: Initial Screen

SCC1 Client copy according to transport request

SCC3 Displays Client Copy Logs / Transport Log Analysis

SCC4 View clients: Overview/ Change client Details

SCC5 Delete client

SCC7 Client import – post processing activities

SCC8 Client export

SCC9 Client Copy: Copy a client (Remote)

SCCL Client Copy: Copy a client (Local)

SCMP View/Table comparison between remote systems

SCU3 Analysis of changed customizing objects and tables

SE01 Transport organizer (extended view)

SE03 Transport organizer tools

SE06 Post-Install methods for Transport Organizer

SE09 Transport organizer

SE11 ABAP Dictionary: Initial Screen

SE15 R/3 Repository Information System

SE16 Data browser: Initial Screen

SE17 General Table Display

SE38 ABAP Editor: Initial Screen

SE80 Object Navigator

SFT2 Maintain public holiday calendar

SICK SAP Initial Consistency Check

SM01 Transaction Codes: Lock/Unlock

SM02 System messages

SM04 User List on current application server

SM12 View lock entries

SM13 View Update Records

SM21 System log: Local/Remote Analysis

SM30 Maintain Table Views

SM31 Maintain Table Views

SM35 Batch Input: Session Overview

SM36 Define background jobs

SM37 View Background Jobs

SM49 Display/Execute External OS Commands

SM50 Lists Work Process Overview in the current application server

SM51 Lists all the instances on the database

SM58 View Transactional RFC Status

SM59 Display and Maintain RFC Destinations

SM63 Display/Maintain Operation Mode Set

SM64 Trigger Event in Background Processing

SM66 System wide Work Process overview

SM69 View/Maintain External OS Commands

SP01 Output Controller: Spool Request selection screen

SP02 Output Controller: List of Spool Requests

SP11 TemSe: Request Screen

SP12 Administration of Temporary Sequential Data

SPAD Spool administration: Initial Screen

SPAM Support Package Manager

SPAU Modification Adjustment: Object Selection

SPCC Spool: Consistency Check

SPDD Modification Adjustment: Dictionary

SPIC Installation Check for R/3 Spool

ST01 Switch on/off, View: System Trace

ST02 Tune Summary, Buffer Stats

ST03 Workload Analysis

ST03n Load Analysis

ST04 Performance: Database Snapshot

ST05 Trace Requests: SQL, Enqueue, RFC, Buffer trace

ST06 Local OS Monitor

ST07 Application Monitor: User Distribution

ST10 Table Call Stats

ST11 Error Log Files / Developer Traces

ST12 Single transaction Analysis, Performance Traces: SQL, Enqueue, RFC

ST22 ABAP dump analysis

STAT Workload: Display Statistical Records for users/t-codes, etc

STMS Transport Management System

SU01 User maintenance: Display and maintain users

SU01D User maintenance: Display user details

SU02 Manually Edit Authorization Profiles

SU03 Maintain authorizations: Object Classes

SU10 Mass User Maintenance

SU2 Maintain User Parameters

SU22 Maintain Assignment of Authorization Objects to Transactions

SU3 Maintain own user parameters

SU53 Display Authorization Data for the executing user.

TALM Database threshold maintenance

Extending the SAP menu tree

2005-09-18T06:34:00.020Z

Create your own area menu using transaction SE43.
Find out the standard SAP menu you would like to extend. Standard SAP main menu is “S000”, you can display this menu using SE43 and go to the node you are interested and click on “Goto -> Attributes” to find out the menu under which this node exists.
Go to transaction SE43 and enter the standard SAP menu you would like extend and click on change
In the subsequent popup window select Extend, failure to select this will result will result in modification to standard SAP and you will loose your extensions during upgrade/patches
If you don’t have an enhancement ID (Similar to CMOD project) for this, create one by clicking on Create in the popup window. If you already have one, double click on the enhancement ID. This will assign all the additions to the menu to enhancement ID and are protected during the upgrades and patches. If you get any information message on repairs, click continue
Add your menu to the SAP standard menu as displayed on the screen. Here you can either add your own menu or just add the transaction code directly
Click “Save”. Create/enter the transport number

Reset or delete all data in DB13

2005-09-18T06:34:00.019Z

Database maintenance jobs scheduled for future via db13 may fail after a system copy and you might need to delete all the existing planned jobs in db13 and re-submit new jobs.
This can easily be achieved by:

Start transaction SM37 --> delete all jobs starting with DBA:
SE16 --> Delete all contents of SDBAP, SDBAR, SDBAH tables.
Re-submit all jobs again.

Alternatively if all you want to do is delete scheduled jobs. (links to previous logs and job statuses will still be displayed)

DB13--> Double click the line in the calender displaying the day/date details.
Click on the line displaying the job that you'd like to delete in the box that pops up.
Click the trash can icon.
Done!

Code page error during client copy runs or after Upgrades

2005-09-18T06:34:00.018Z

Logon to client 000 as ddic or equivalent user:
Go to SE38
Run rscp0004
Choose option 'Check and change if necessary' and execute
Select (click on) the require codepage.
Click insert

I am not sure if these are all the steps required, but these are certainly the initial steps that are required to sort this out. Please send your feedback if this helps you or if you have an alternate/additional procedure to resolve this.

Daily SAP System Checks - Health Checks

2005-09-18T06:34:00.017Z

Basic List of SAP Daily Checks - (Daily Health Check)

Backup	Check DB12 for last successful backup
Disk space	Run df -k on OS level for amount of free space on volume level
Tablespaces	Check DB02 for Status and usage of Oracle Tablespaces
SAP System Log	Check SM21 for errors
Updates	Check for update records in SM13
Shortdumps	Check for ABAP Dumps in ST22
Enqueue	Check for Enqueues in SM12
Jobs	Check for long running jobs
Workprocesses	Check SM51 SM50 for number of systems/ work processes active

Error “Maximum number of terminals reached” is encountered

2005-09-18T06:34:00.016Z

The error “Maximum number of terminals reached” is encountered when no more logons of the type (RFC or dialog) can be made.

This happens when the value for parameter 'rdisp/tm_max_no' for dialog processes or 'rdisp/rfc_max_login' for RFC type of login's is reached. Increase the value for respective parameters to achieve more logons. Take care of the resource utilization levels though

Notification of unread mails at logon

2005-09-18T06:34:00.015Z

How to get a notification of unread mails at logon

Use transaction SO16 to change the Shared office settings.
Un-check "No notification of unviewed mails at logon".
When the user logs on to the R/3 System a dialog box appears informing them of new messages. The user can go from the dialog box directly to the inbox.

Streamline Role based user Menu's

2005-09-18T06:34:00.014Z

To avoid multiple folders and levels a user's menu appears in(cascaded from several roles) maintain table 'ssm_cust'.
Add entry 'CONDENSE_MENU' with value = 'YES'.

Disable the SAP standard menu for users

2005-09-18T06:34:00.013Z

Maintain table 'ssm_cust'.
Change the value against SAP_MENU_OFF to 'YES' and ALL_USER_MENUS_OFF to blank.

A to Z of SAP Authorizations

2005-09-18T06:34:00.012Z

This section is not yet finished... I am adding content into it as/when I have the time...

Deadline is 19/7/2004. Hopefully I'll meet it.

Change standard SAP fonts for the SAPGUI

2005-09-18T06:34:00.011Z

To change the SAP standard fonts for SAPGUI

Close all the SAP GUI sessions along with the SAPlogon Pad.

Locate the file: theme.xml under the local SAPGUI install directory

e.g: C:\Program Files\SAP\FrontEnd\SAPgui\themes\HighCont

Open this file in a text editor and search for

Change the tag to the new font that you want SAP GUI to use.

refers to input areas while refers to the labels. Other aspects like:

Size, Bold, Charset, Pitch and Italic can be changed too.

Save this file and restart the SAPgui / SAPlogonPad

Generating your own Transport Numbers

2005-09-18T06:34:00.010Z

Change the field TRKORR in the E070L table to one less the new transport request number that you want the system to generate the next time you create a transport.

Sending message to a user

2005-09-18T06:34:00.009Z

Execute SE37

Enter 'TH_POPUP' as the function module name
Execute
Enter Client, User and Message.
Execute
This will pop up a SAPGui message on the user's screen.

Common ABAP Dumps - troubleshooting...

2005-09-18T06:34:00.008Z

Common ABAP Dumps and troubleshooting...

RAISE_EXCEPTION ... CNTL_ERROR
Is a GUI related error.Go for latest GUI version to avoid thie error.

EXSORT_NOT_ENOUGH MEMORY
Memory bottleneck encountered by the program while sorting.

SYSTEM_ROLL_IN_ERROR
Not enough memory for user context.

SYSTEM_NO_MORE_PAGING
Not enough SAP Paging Memory. Set "rdisp/pg_maxfs" to sufficiently large value ( say 32,000 ).If the problem exists even after assigning this value then there could be a fault in the program itself.

STORAGE_PARAMETERS_WRONG_SET
Not enough SAP Heap Memory. This type of error occurs when a work process tries to allocate more SAP Heap Memory than the available address space for program execution.

SET_PARAMETER_MEMORY_OVERFLOW
Not enough memory for SET/GET Parameter (Otherwise known as SPA/GPA Memory ).Try extending the memory area with SAP profile "ztta/parameter_area".

SAPSQL_ARRAY_INSERT_DUPREC
Number range problem, likely document number exist.

EXSORT_FWRITE_FAILED
Is related to disk space. There is not enough disk space for the external sorting process in the sort directory. To avoid this move either the extract files (DIR_EXTRACT) or the sort files (DIR_SORTTMP) to a separate directory with enough space.

Enter dates, Quickly

2005-09-18T06:34:00.007Z

To enter the current date in date fields

Navigate to the date field
Press the F4 key and then the F2 key.

Done.!

List Registered Developers/Objects

2005-09-18T06:34:00.006Z

To list registered developers:

Use tcode SE16
Enter DEVACCESS and press enter.
Execute

To list registered objects:

Use tcode SE16
Enter ADIRACCESS and press enter.
Execute

List all icons available in SAP

2005-09-18T06:34:00.005Z

Use tcode ICON to list all the icons in SAP
Use report RSTXICON to list all icons along with SAP numbers
User report SHOWICON to list all icons in lists.

Easy Authorization Assignment for Transactions

2005-09-18T06:34:00.004Z

Use SU24. Assignment of Authorization Objects to Transactions

Enter a transaction code (or a number of them) and execute.
Click -> Check Indicator
The transaction will return a number of rows displaying authorization objects along with object names required to execute the transaction.

Use this list of objects to add into a profile to authorize for appropriate transactions.

Search transaction codes

2005-09-18T06:34:00.003Z

Use the following transactions to search for SAP transactions:

SEARCH_SAP_MENU
Search transaction codes containing the search text in Standard SAP Menu tree.
SEARCH_USER_MENU
Search transaction codes containing the search text in the SAP User Menu tree.
SM01
Locks/Unlocks transactions, can also be useful for finding out transaction text for a known transaction code
SDMO
Returns a list of transaction codes and description on the basis of text searched for; also takes two texts in an 'OR' argument search.
SE93
Can be used to display/change further details on known transaction codes.

Interactive OS Command Shell from within SAP

2005-09-18T06:34:00.002Z

Run the report: RSBDCOS0 and execute OS Commands. However, be aware that this is logged in the sytem trace and syslog on the highest level along with the commands that have been executed. Might not be appreciated by your systems administrators. Only run after seeking proper authorizations by the administrators/system owner.

Create ABAP Reports, programs without access key!!!

2005-09-18T06:34:00.001Z

Now... You always thought that modifying of creating SAP programs was only possible if you had a developer key... right?

Well, Not exactly true, try the following and find out for yourself, This tip as others is given out without any support. Also, use it at your own risk, this might not be taken very lightly by your management or your audit team if they find out that you've been messing with programs without authorization. All said, here you go....

To create a program

1. Go to SE38 and type in a program program name and hit enter.
2. Switch to debug mode by entering "/h" on the command box.
3. Hit Create button (You will enter into debug mode)
4. Press F6 until you get the developer key dialog box.
5. Now insert a dummy key (99999999999999999999) in the box and hit continue.
6. Hit F5 two times.
7. You will see somethig like this:
CASE OK_CODE.
WHEN 'NEXT'.
LEN = STRLEN( DEVACCESS-ACCESSKEY ).
IF LEN EQ 20.
PERFORM CHECK_KEY USING DEVACCESS-ACCESSKEY <- THIS IS OUR MOVE
8. Double Click near "IF SY-SUBRC NE 0 OR LEN NE 20." to insert a brek-point.
9. Double Click on SY-SUBRC to display its contents (Will Show a "0")
10. Hit F8 (Now SY-SUBRC will show a "1" or something else)
11. Change the contents of SY-SUBRC back to "0"
12. Hit F6 two times, now you will see something like this on the screen:
IF DISP EQ SPACE.
PERFORM CHECK_KEY USING DEVACCESS-ACCESSKEY. <- THIS IS OUR MOVE
IF SY-SUBRC NE 0.
13. Now insert a break-point near to "IF SY-SUBRC NE 0" and hit F8
14. Change SY-SUBRC back to "0"
15. Hit F8 and DONE !!!! You will se the "Program Attributes" dialog box.

Howzzaat!?!?

User-defined text on SAPGui logon screen

2005-09-18T06:34:00.000Z

Use note: 205487 User-defined text on SAPGui logon screen to add text to the default SAPGui logon screen.

Steps:

Go to tcode SE61
Select general text
Create text with name ZLOGON_SCREEN_INFO in your language

Text is limited to 16 lines and 60 columns

Also, You can incorporate graphic icons by inserting icon codes in the text.
Eg.: The following code: @1D@ will insert the STOP ICON on the page.

You can get a list of codes and icons by running report "RSTXICON"