Changing SAP Transport Request Number Range in SAP landscape

There could be a requirement in your client side to change SAP transport request number range and they would ask you to change/block certain range of transport request number in your sap landscape.

As a basis administrator you must know how to get this done and I will tell you below how to do it.

SAP standard table E070L is the place where your last transport request are stored and referred by sap while creating new transport request.

TRKORR is the filed which contains last transport request of your landscape or in your development system where we will create transport requests.

Say for an example you have requirement to change/block next 1000 transport request in your landscape, so in this case you need to block next 1000 transport requests

Normally transport requests will be like below.

<SID>K90xxxx ex: R47K900015

We should update TRKORR table value to required number/TR value so next time when there is a TR creation request SAP will refer E070L table and TRKORR filed value and it will create next TR based on TRKORR field in it.

Here I will block R47K900015 to R47K901015

After update screen shots:

To achieve this we can follow 3 options since it’s a SAP standard table and it will not allow you to update it directly using table maintenance option tcodes like SE16, SE16N & SM30

1.  Get help from a ABAP programmer to help out on this to update the table value via program
2. Update the table filed value at OS level by small SQL query like how do you lock and unlock SAP* password reset activities
3. This is something backdoor method and its not recommended by sap, to do it go to SE16N tcode and enter E070L table and hit enter then you need to execute &SAP_EDIT in the tcode command box then it will enable edit option directly on table level, but you may face some security audit issues and this option is removed in EHP series

Above steps I performed in SAP 4.7 and used OS level SQL queries

SQL query for ORACLE DB:

update SAPR47.E070L set TRKORR='LEDK901012' where LASTNUM='TRKORR';

SQL query for MSSQL DB:

update <SID>.E070L set TRKORR = 'SIDK905223' where LASTNUM = 'TRKORR';

SAP Post Installation Steps

Below are the steps needs to be performed as part of SAP post installation activities

1. Login to ddic username and execute SICK tcode

2. Goto RZ10 tcode and import the new profiles and add profile parameters according to your requirements

3.Execute slicense and install license for your system

4. Go to SE06 and select Standard Installation option hit execute, Click yes to initialize your CTS settings

5. Now goto STMS tcode and configure TMS

6. You can configure current system as DC(domain controller) or you can include into another domain, in this case I configure as domain controller

7. Now install SGEN i.e SAP load generator

8. Now go to SCC4 tcode and create a new client and perform client copy

9. After you created new client and make sure you copy ddic username and create new admin username and lock SAP* and DDIC usernames

10. Additionally you need to perform SAP Kernal upgrade as well as patching for OS and DB and check official installation guide in market place

SAP Transport management system(STMS) configuration

When you install a new sap system as a basis administrator should configure STMS to newly deployed system as a post installation activities

Below are the steps involved for STMS configuration

Login to your sap system client 000 with DDIC username(STMS must be configured with DDIC username only)

1. Execute STMS tcode and you will get a below screen

2. You have to configure new system as a DC(domain controller) or you can include this system into another domain

3. System will ask you to configure new system as a domain controller and click save

4. You will get above screen “You are logged onto the domain controller”

5. Click systems in the “overview” menu like above and you will get below screen

6. Now click “SAP systems” create to add your future systems as a virtual systems which is going to be included in this landscape

7.Like above you can add your systems which is going to be part of it, here I have added 2 systems as my virtual systems and same configuration will be copied to those systems when they are live

8. Now click “Envieonment” àTransport Routes to configure your landscape transport route

Change to graphical mode to have clear idea about it and switch to change mode

Click “Configuration” à standard configuration à Three systems in group

9. Give your development àquality àproduction systems as per your requirement and click continue

10. Now click save button to activate your configuration and you will get screen like below

That’s it you have successfully configured STMS in your landscape and same way you can add/modify systems in your landscape

SAP Transport Management System Question and Answers

1. How to import a transport request at os level?

Logon to the target system and make sure request is released

Add TR to your buffer:

tp addtobuffer <TRANSPORT-REQUEST> <SID> Client=<CLIENT-NUMBER>
pf=/usr/sap/trans/bin/TP_DOMAIN_<DOMAIN_SID>.PFL
Example:
tp addtobuffer DEV12345 QAS Client=000
pf=/usr/sap/trans/bin/TP_DOMAIN_DEV.PFL
Import the request:

tp pf=/usr/sap/trans/bin/TP_DOMAIN_<DOMAIN_SID>.PFL
import <TRANSPORT-REQUEST> <SID> U128 client=<CLIENT-NUMBER>
Example:
tp pf=/usr/sap/trans/bin/TP_DOMAIN_DEV.PFL
import DEV12345 QAS U128 client=000

2. How to lock TMS?

Login to domain controller

Goto STMS tcode and click system overview

Select a system which you want to lock and goto menu and select lock

Confirm and distribute to activate

3. How to unlock TMS?

Login to domain controller

Goto STMS tcode and click system overview

Select a system which you want to unlock and goto menu and select unlock

Confirm and distribute to activate

How to delete system from TMS?

Login to domain controller

Goto STMS tcode and click system overview

Select the system which you want to delete TMS and click trash button/click delete option in menu

Confirm and distribute to activate

4. How to import Transport request different client within a single system?

Use SCC1 tcode to achieve it

5. How to disable IMPORT ALL option in transport queue?

Go to STMS Tcode in DC

Click systems Overview & click on systems which you want to disable import all

Go to Transport Tool Tab or double click it

Click Change button
Click ADD new row button
Insert the parameter NO_IMPORT_ALL with value 1.

Save it.

IMPORT_ALL icon will be disabled from stms_import tcode for a particular system and you have to do it for all system in the DC one by one

6. How to troubleshoot a TR is running longtime?

Check whether file system is having enough space in sapmnt

Update is activated/deactivated in SM13

Check there is available background work process is available to import TR in SM50

How to terminate a TR which is running for long time?

Check whether are you able to cancel it in import queue or goto SM50 tcode and identify which work process assigned for particular TR

Select the work process and cancel it with core or without core

If you are not able to cancel it in SM50 go to os level and kill the process which is assigned to it

Linux and unix

Kill -9 pid

For windows use taskkill command

7. What are common transport errors?

Return code (4) indicates imported ended with warning.
Ex:
1. Generation of programs and screens
2. Column missing and Rows missing
Return code (8) indicates not imported ended with error
Ex:
1. Syntax error
2. Program generation error
3. Dictionary activation error
4. Method execution error
Return code (12) indicates import is cancelled.
Ex:
1. Import is cancelled due to object missing
2. Objects are not active
3. Program terminated due to job? RDDEXECL? is not
working
Return code (16) indicates import is cancelled.
Ex:
1. Import cancelled due to system down while importing
2. Import cancelled due to user expires while importing
3. Import cancelled due to insufficient roles

8. What is domain controller?

Domain controller is the central place where you can administrate TMS.

It acts as a leader and controls all system in the landscape, where it contains details about all systems in the landscape

9. How to change password of all TMS RFC usernames using a report?

TMS_UPDATE_PWD_OF_TMSADM

10. What is the default authorization profile assigned to TMSADM user?

S.A_SYSTEM