topic Re: Delete entry from the table in Application Development and Automation Discussions

Delete entry from the table

Former Member — Tue, 21 Oct 2008 08:55:03 GMT

Hi All,

I need to delete one entry from table STXH. I am not having authorization for this. I am able to delete this in debugging mode.

But this is not suggested. Is there any program or any other way by which I can delete the table entry from this table. I need to delete only 1 entry not all.

Thanks & Regards,

Mamta Gupta.

Re: Delete entry from the table

matt — Tue, 21 Oct 2008 08:59:23 GMT

What is the nature of the text you are wanting to delete. You should not delete directly from the table. You should find the correct transaction. e.g. SO10.

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 09:07:23 GMT

To update the data of any table, go to transaction SE16N, type u201C&SAP_EDITu201D. It will activate SAP editing function.

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 09:07:31 GMT

It is not advised to delete any entries from Standard tables...

But still u can do this by

1. Go to SE16n

3. in the command field write '&sap_edit' press enter

4. Give the table name and press F8

5. Now u can change or delete entries...

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 09:23:35 GMT

We are having one blank record in this table, before saving the PO, this text is coming from this table and after saving the text will go. It's happening because of this blank record.

input:-

TDOBJECT = EKKO

TDID = F01

TDSPRAS = E

Output:-

TDOBJECT TDNAME TDID TDSPRAS EKKO F01 E

Here, TDNAME is empty. We don't want this blank record.

Thanks & Regards,

Mamta Gupta.

Re: Delete entry from the table

rainer_hbenthal — Tue, 21 Oct 2008 09:31:04 GMT

If you do not have authorization for that look for some one who is allowed to do that.

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 09:35:10 GMT

Hi Mamatha,

U want to delete table entry in standard table right?

Then double click that entry first, the fields will display vertically.

Now Start the debugger (/h). In side the debugger select for filed Code = 'DELE' option and save.

Now Select the entries and delete.

Hope this will work out.

Regards,

Shake sha vali.P

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 09:42:31 GMT

My recommendation not to delete by debugger as other suggested.

may be you can leave it as it is, i don't think it will any harm to your SAP.

else try to overwrite this entry from ME22N and see if it overwrites or not.

Re: Delete entry from the table

matt — Tue, 21 Oct 2008 12:54:37 GMT

Agreed. Once more

Do NOT delete data directly from SAP tables If you do and it all goes horribly wrong, your employer/client will have to pay SAP a lot of money to fix your system. You may invalidate your entire support agreement, and you may have violated your license conditions.

matt

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 13:50:21 GMT

Has no one heard of FM DELETE_TEXT

Rob

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 13:54:13 GMT

duplicate

Edited by: Rob Burbank on Oct 21, 2008 9:56 AM

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 13:54:13 GMT

duplicate

Edited by: Rob Burbank on Oct 21, 2008 9:57 AM

Re: Delete entry from the table

Former Member — Tue, 21 Oct 2008 13:54:19 GMT

duplicate

Edited by: Rob Burbank on Oct 21, 2008 9:57 AM