topic Re: Delete a Table entry in Application Development and Automation Discussions

Delete a Table entry

Former Member — Wed, 06 Feb 2008 06:03:57 GMT

Hi , A blank entry got created in table t77ua through modify statement . Now i am unable to delete this entry through SM30.

Is there any tcode to delete that blank entry apart from DELETE statement ?

Thanks & Regards,

John.

Former Member — Wed, 06 Feb 2008 06:15:57 GMT

john,

you can do one thing, run sm30 select that perticular record by row selection ( select Box).

then start debuging an give any user command ( eg, select Save Button).

when debuging starts, check sy-ucomm and write 'DELE' forcefully then run program.

this is just tricky but .....it will definatly works...

reward if useful,

Sandeep

Former Member — Wed, 06 Feb 2008 06:41:24 GMT

Hi, John.

Go to SE16N.

Enter the table no.now before pressing F8 key, write &sap_edit in tcode area.

Then press F8.

Now in tool bar, the system will show one button to delete the option.

Select the row and press that button.

Reward if it helps.

Regards,

Sunny

Former Member — Wed, 06 Feb 2008 06:49:40 GMT

Hi,

SE30 will be the right action to delete the table entries, if there is table maintenance generator for that table.

Reward if found helpfull,

Cheers,

Chaitanya.

Former Member — Wed, 06 Feb 2008 07:05:07 GMT

U can write a small abap pgm. in that write a query

DELETE dbtab where condition

Reward if useful

Narendra