Is there a way to change the transport request number to start with a number that I choose?
Assuming your release is 4.6, user SAPR3 is owner of the database. Call the last transport number by issuing “select * from sapr3.E070L.”
Change the transport sequence number by issuing:
"Update sapr3.E070L set TRKORR='<sid>K9xxxxx'."
If your SAP release is higher than 4.6, replace SAPR3 with the owner of the database.