deleting entries from a custom table

[Former Member]

How can we delete entries from a custom table?

[Former Member]

delete from ztable . "for all entries

delete from ztable where kunnr = 'SomeNum'. "delete some entries

Do an F1 on the DELETE command for more info

[Former Member]

Hi

If you don't want to create a program by trx SE16.

Max

[RichHeilman]

You can blow away your data quickly using transaction SE14, enter the table name, select the radiobutton for delete data, and click activate and adjust.

Regards,

Rich Heilman

[Former Member]

Hi

The Rich solution is right, but in this case you'll delete the data from all clients because the system deletes and creates again the table from database, so BE CAREFUL.

Max

[Former Member]

Thanks for the prompt replies.I knew we can do it by creating a program but i was looking for some other way. I need to delete specific entries. I tried se16 but its not working .

[Former Member]

You need to change the Delivery/maintainence of the table then.

Go to this tab in SE11 for the table and change Data Browser Maint to "Display/maint Allowed". This will generate a transport if the table has been released to a higher TST/PRD system.

[ferry_lianto]

Hi,

You can use standard program RADCVBTC to delete all contents of a custom table.

Please pass the following parameters.

OBJ_NAME = <custom table name>

OBJ_TYPE = 'TABL'

FCT = 'MDF'

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

Hi,

If you want to delete all the entries from a table use SE14..Delete data..

If you want to delete specific entries try using SE16 if you have authorization.

Otherwise use DELETE statement in your program to delete the records...

Thanks,

Naren

[Former Member]

Hi,

If you have table maintenance screen for the custom table..use SM30 to delete specific entries..

Thanks,

Naren

[Former Member]

Hello,

You can delete data from the table by,

- delete * from table.

- delete * from table where condtion. "specify condition in where clause

- using se14

Regards,

Shehryar Dahar

[jcutinho]

If you want to delete only a selected/multiple entries from a Custom or Standard Table i would suggest, first switching the SE16 output screen to ALV list. Then once you see the output of the rows in ALV list viewer then select the entries you want to delete using the check boxes and then start the debug mode by entering /H in the command box, now click on any toolbar icons preferably the display icon, now you can see the debug screen, enter the SY-UCOMM in the debug console and change the value to 'DEL5' and then execute the same. 

[sameer_gemini]

best option i just learnt:

Use SE16 and select the mass records in the ALV to be deleted. Go to debugging and replace the ok_code with DEL5. And the pop will ask you if you really want to delete. And thats it.

Cheers:

Sameer