Transport Export

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

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)

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

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

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!

Save SAPGUI Password

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

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

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

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

BOR Objects - Business Object Repository

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

• 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.

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

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

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

• Run program RSADRCK2 in se38 to resolve.

Another list of useful transaction codes

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

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

• 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

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

• 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

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

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