Translate

Monday, July 19, 2010

edit table entry

Mates,

There could be times when we might have to change some data for testing purpose

There are multiple ways of editing table entries forcefully

word of cuation,its not advisable to enter r append data directly to tables

1.&sap_edit(* But be aware of this SAP Note 1420281, If this note applied in your systesm then you can't perform the above activity . So we have to go with debugging option from SE11 and change entries. -http://saplocker.blogspot.com/2010/08/edit-table-entries-without-coding-or.html*)

2.How do we append data directly in tables?

Multiple ways


2. using the debugger

Please find the steps below

Im trying to append data in any ztable

1. SE11->Data dictionary ->






2. Choose the table entry


3. After choosing the table entry ,enter /h to start the debugger sssion(debugger switched on) message will populate in the status bar. after you enter /h and message gets populated, press enter one more time



4.place a breakpoint in end form.to place breakpoint,just double click and red button pops up near the line .to remove just double click or shift+f2



5.now double click on the line which says code=show and it will move to the variable on the right hand side



6.now click on the pencil and icon will change to view




7.now if you want to insert choose INSR or DELE based on what you are trying to do with table entries.i m trying to insert values.



8.now click f8

And you wll be able to enter values The other work around is ,should &sap_edit function doesnt get activated,to use UA16N or just N,enter the table name sat t527X and then enter &sap_edit tcode in coomand field kindly refer to the link ,thanks to contributor http://home4sap.com/Blog/2010/11/edit-sap-tables-you-sap-security-admins-nightmare/

No comments:

Post a Comment