topic regarding table modification in Application Development and Automation Discussions

regarding table modification

Former Member — Mon, 18 Jun 2007 09:23:08 GMT

Hai,

Debug SE16 to allow record changes

If you are not authorised to change table entries or the table has been create without table maintenance

allowed (all SAP tables), you can still change entries via data browser (SE16) by means of debugging. The

process is as follows:

1. Display record entries for desired table via SE16 or SE11.

2. Select record which requires updating by highlighting it and pressing the display icon (glasses, F7).

3. Type /h in command box and press enter.

4. Now press enter again and you should enter debugging mode

5. Change the value of code from ‘SHOW’ to ‘EDIT’, remember to press the ‘change field contents’

icon (pencil) in-order to store new value.

6. Press F8 (execute) to leave debug.

7. You should now have change access to the selected record.

8. Hit ‘SAVE’ to save any changes.

9. Remember there is a reason why you can’t do this without debugging it, one reason being that it could

introduce inconsistencies in the table data.

Is it possible actually i tried this but i unable to get result

i found out it in

<a href="http://www.sapdevelopment.co.uk/abap/bypass/bp_updtable.htm">http://www.sapdevelopment.co.uk/abap/bypass/bp_updtable.htm</a>

if anybody know about this please provide solution.

regards,

surya.

Re: regarding table modification

former_member150733 — Mon, 18 Jun 2007 09:28:48 GMT

This is possible.

You need to have authorisation for debugging.

You need to have authorisation for replace in the debugging mode

You cant simply put inconsistent data where a foreign key check exists.

Please explain the step wherein you are stuck up so that i can guide you further.

Regards,

Anish Thomas

Re: regarding table modification

Former Member — Mon, 18 Jun 2007 09:51:11 GMT

Hai,

please provide detailed explanation

Thanks,

surya.

Re: regarding table modification

Former Member — Sun, 24 Jun 2007 12:54:50 GMT

hi Surya,

Ya that is correct ... by the above explained fashion you must be able to change or insert new records on to your table ... if you are unable to do that may be you many not be having authorizations .... the other way to change the same is ... develop a small report and use modifiy statement to change the existing record this is how you can modify programatically... try out this way it works in your case ..

Regards,

Santosh

Re: regarding table modification

Former Member — Mon, 25 Jun 2007 05:30:42 GMT

Hai santhosh,

Thanks for ur reply,

By using reports also not possible to modify predifined table with out knowing access key

is there any other option for this.

regards,

surya.