topic Re: Delete data with table maintenance generator in Application Development and Automation Discussions

Delete data with table maintenance generator

Former Member — Fri, 02 Jul 2010 13:41:15 GMT

Hi All,

I have created custom table ZXXX and table maintenance generator.

I need to maintain data but delete them too. I can update and modify data but how can I delete them ?

Thanks for your answers !

Best regards,

Sandrine

Re: Delete data with table maintenance generator

Former Member — Fri, 02 Jul 2010 13:51:43 GMT

Hi,

use the Table mantiance generator or Code in the PAI of the maintaince generator.

With Regards,

Sumodh.P

Re: Delete data with table maintenance generator

Former Member — Fri, 02 Jul 2010 14:07:13 GMT

select the row you want to delete and press the delete ICON.

Re: Delete data with table maintenance generator

Former Member — Fri, 02 Jul 2010 14:12:27 GMT

If you have created table maintaince for the table.. Then go to SM30 transaction

Give the table name ie : like ZXXX ( name of the table ) and click on maintain.

Now you will enter into overview screen

Here select the record which you want to delete and hit the delete button ( 4th button )

The records gets deleted from the table

Let me know if you need further information.

Regards

Satish Boguda

Re: Delete data with table maintenance generator

kesavadas_thekkillath — Fri, 02 Jul 2010 14:38:19 GMT

Hi,

Breakpoint has told the exact way.

Do check the maintenance status read,change,delete,insert is marked for the maintenance view

Re: Delete data with table maintenance generator

Former Member — Mon, 05 Jul 2010 07:19:43 GMT

Hi,

Sorry I hasn't been clear. I would like to maintain the content of the table in the program.

I've used "Delete ZXXX" but it didn"t work.

Maybe there is another command or parameter ?

thanks,

Sandrine

Re: Delete data with table maintenance generator

SuhaSaha — Mon, 05 Jul 2010 07:28:12 GMT

Do an F1 on the DELETE keyword, read the online documentation: [http://help.sap.com/abapdocu_70/en/ABAPDELETE_DBTAB.htm]

Re: Delete data with table maintenance generator

Former Member — Mon, 05 Jul 2010 08:20:18 GMT

ok, I found ..

I created an internal table to delete the content of my table ZXXX :

DATA : ws_zxxx TYPE zxxx OCCURS 0 WITH HEADER LINE.

select * from zxxx into CORRESPONDING FIELDS OF TABLE ws_zxxx

DELETE zxxx from table ws_zxxx.

commit work.

it works !

thanks all !

Re: Delete data with table maintenance generator

Former Member — Mon, 05 Jul 2010 08:21:52 GMT

ok, I found ..

I created an internal table to delete the content of my table ZXXX :

DATA : ws_zxxx TYPE zxxx OCCURS 0 WITH HEADER LINE.

select * from zxxx into CORRESPONDING FIELDS OF TABLE ws_zxxx

DELETE zxxx from table ws_zxxx.

commit work.

it works !

thanks all !