Skip to Content
author's profile photo Former Member
Former Member

Delete entry from the table

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

10 Answers

  • Best Answer
    Posted on Oct 21, 2008 at 08:59 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 09:23 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 09:07 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 09:07 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 21, 2008 at 09:31 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 09:35 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 01:50 PM

    Has no one heard of FM DELETE_TEXT

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 01:54 PM

    duplicate

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 01:54 PM

    duplicate

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 01:54 PM

    duplicate

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.