Change transport number range of SAP system

In this article You find short instruction how to change transport number range after system copy, restoring system. It’ll also useful at the moment if two systems running in parallel with same SID during upgrade.

Procedure

1. In table E070 You can check request IDs – here You verify Your last transport number.
2. To modify the transport request number You should change the TRKORR field value in the table E070L. The change request numbers will continue to increment from the number entered in this field.
3. Remember that customer transports start with <SID>K9 (anything else is reserved for SAP).

Useful SQL commands:

-- Example:
select * from sapsr3.e070l;
update SAPSR3.E070L set TRKORR = 'SIDK918100' where lastnum='TRKORR';