How to Modify SAP Transport Number Range

Posted on by

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

pic-2

Leave a comment