topic Re: Delete rows from Ztable in Application Development and Automation Discussions

Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 07:45:40 GMT

I have a ztable in which there r 5,000 records in production system. User entered some wrong entries. Now i have to delete those rows physically. How can this be done with out effecting other rows. My Ztable is having maintenance sm30. how can i solve this problem. I can't write code for using delete statement as the rows r placed at different places so tht i can't put table index & proceed. thanks in advance

regards

Ram

Re: Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 07:49:33 GMT

Go to SM30 ..... enter your Ztable name and select maintain.

Now select the enteries u want to delete .

go to edit, select delete.

Regards,

Gaurav

reward points if useful

Re: Delete rows from Ztable

former_member194669 — Thu, 16 Aug 2007 07:49:37 GMT

Hi,

Using SM30 you delete a row from table

aRs

Re: Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 07:58:25 GMT

you can write delete statement with some where condition, if you doesn't know the row number.

Try this.

Re: Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 08:04:01 GMT

The field of date they did not enter properly. from sm30 after selecting particular row & from edit if i click delete it is giving this messeage Enter date in the format __.__.____. How to solve this

regards

Ram

Re: Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 08:27:42 GMT

I have a solution that might work for you too.

Go to SE11. enter your table name and press display(F7).

Then press (CntrlShiftF10) for contents of table.

enter the fields that might help you select your records else leave them empty and press F8.

Now the records are displayed in list.

Checkmark the records you want to delete.

Then press Display(F7).

Now in Command Bar enter '/h' and press ENTER. the system wud give a msg that debugging has been started.... Now press ENTER once again it will go into debugging.

In debugging mode there is a variable CODE which will be having value SHOW, change that value to DELE and press the pencil button in the extreme right to that field.This changes the contents of CODE from SHOW to DELE. Now press F8.

Now in application toolbar 'Delete entry' button will appear with navigation keys.

So now buddy you need to delete that record by pressing that button and navigate to next record and delete that and so on,one by one. after you have deleted all the required record press the BACK button, you again come back to list display of records, press refresh and all the deleted records will disappear. Keep on eye on the Message bar while deleting.........

Reward points if useful, get back in case of query...

Re: Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 08:42:57 GMT

HI,

Go to SE11,

Give table name

press display

Display all the existing entries of the table

select the entries to delete

go to the menu TableEntry

And select Deleteall option from that menu list..

This will help u.

Re: Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 08:50:26 GMT

Hi Tripat Pal,

I followed ur procedure but i am not able to change the show to dele how can this be done it is in display mode & i could not find pencil button in the exteme right to that field. kindly tell me in detail. thanks in advance

regards

Ram

Re: Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 09:11:27 GMT

in debugging mode, u will see 'code' written on the screen, double click it, it will appear in 'Field names' which shows the contents of the field, the content of CODE will be SHOW,

you have to change that to DELE (see that its in capital letters), now just to the right of the field where in 'Field names' you'll see a button of magnifying glass and next to it is the pencil button(Chang Field contents) i was talking bout. but remember that after you have written DELE, do not press ENTER or press any other button other than the pencil button(Chang Field contents) as the field contents will revert back to previous values....

Reward points, get back in case of query....

please read clearly both my posts....

Cheers!!!

Re: Delete rows from Ztable

Former Member — Thu, 16 Aug 2007 09:36:32 GMT

Hi Tripat Pal,

Its done. Thanks a lot. I ll reward u 10 out of 10 points. Once again thanks a lot

regards

Ram