topic Re: delete line en table in Application Development and Automation Discussions

delete line en table

Former Member — Thu, 21 May 2009 14:39:45 GMT

Hello Friends,

I' need manulement removes online contents in table in minisap .

Thanks en Advance,

Regards

Said el fannassi

Re: delete line en table

Former Member — Thu, 21 May 2009 19:01:27 GMT

I am not able to understant you Qus. Ask your Qus with clear.

Edited by: RavivarmanP on May 22, 2009 12:31 AM

Edited by: RavivarmanP on May 22, 2009 12:32 AM

Re: delete line en table

gautam_totekar — Fri, 22 May 2009 04:46:23 GMT

You can manuaaly delets rows from a table using T code SE16n. Although it is not advisable to delete entries because there could be dependencies in the databse.

goto SE16N

enter table name.

Type &sap_edit in the box where you type T code and press enter and then execute.

Delete whichvr line you want.

Re: delete line en table

Former Member — Fri, 22 May 2009 05:18:20 GMT

HI,

To delete the line , you have first select the line then you can delete it like this

IF mark EQ 'X' .

DELETE itab FROM workarea.

END if

Regards

Sathish

Re: delete line en table

Former Member — Fri, 22 May 2009 13:22:31 GMT

you can delete line from se16 transection from table but for that you want access key from fuctional person or check below link

http://www.sapdb.info/sap-hacks-change-database-tables-directly/

Edited by: anurag daate on May 22, 2009 3:26 PM

Re: delete line en table

Former Member — Fri, 22 May 2009 18:54:50 GMT

Hi,

if you are referring to a Database table created in SE11 transaction then delete the entries in the following ways;

Using SE11 -> table name -> change -> utilities -> table contents -> create entries -> select the entry and delete it (this will work if you have created the Table maintanance generator with 2 steps).

Using SM30 -> again you should have created a table maintanance generator.

Using SE16N -> give the table name and then type &SAP_EDIT in the transaction box and then execute it and select the entry and delete it.

incase you are referring to an internal table that we create in a program, then you can use the DELETE statement to delete it within a loop or you can do a F1 on DELETE and check the different ways to use it.

Regards,

S.Dakshna Nagaratnam.