Delete data with table maintenance generator

[Former Member]

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

[Former Member]

Hi,

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

With Regards,

Sumodh.P

[Former Member]

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

[Former Member]

Hi

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

[kesavadas_thekkillath]

Hi,

Breakpoint has told the exact way.

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

[Former Member]

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

[SuhaSaha]

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

[Former Member]

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 !

[Former Member]

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 !