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';