Delete entry from the table

[Former Member]

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.

[matt]

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.

[Former Member]

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

[Former Member]

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...

[Former Member]

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.

[Former Member]

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.

[matt]

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

[rainer_hbenthal]

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

[Former Member]

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

[Former Member]

Has no one heard of FM DELETE_TEXT

Rob

[Former Member]

duplicate

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

[Former Member]

duplicate

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

[Former Member]

duplicate

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