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

deleting entries from a custom table

How can we delete entries from a custom table?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2006 at 06:32 PM

    Hi,

    If you want to delete all the entries from a table use SE14..Delete data..

    If you want to delete specific entries try using SE16 if you have authorization.

    Otherwise use DELETE statement in your program to delete the records...

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 14, 2006 at 06:32 PM

    Hi,

    You can use standard program RADCVBTC to delete all contents of a custom table.

    Please pass the following parameters.

    OBJ_NAME = <custom table name>

    OBJ_TYPE = 'TABL'

    FCT = 'MDF'

    Hope this will help.

    Regards,

    Ferry Lianto

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 14, 2006 at 06:30 PM

    You can blow away your data quickly using transaction SE14, enter the table name, select the radiobutton for delete data, and click activate and adjust.

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You need to change the Delivery/maintainence of the table then.

      Go to this tab in SE11 for the table and change Data Browser Maint to "Display/maint Allowed". This will generate a transport if the table has been released to a higher TST/PRD system.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2006 at 06:27 PM

    delete from ztable . "for all entries

    delete from ztable where kunnr = 'SomeNum'. "delete some entries

    Do an F1 on the DELETE command for more info

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2006 at 06:29 PM

    Hi

    If you don't want to create a program by trx SE16.

    Max

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2006 at 06:48 PM

    Hi,

    If you have table maintenance screen for the custom table..use SM30 to delete specific entries..

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2006 at 10:58 AM

    Hello,

    You can delete data from the table by,

    - delete * from table.

    - delete * from table where condtion. "specify condition in where clause

    - using se14

    Regards,

    Shehryar Dahar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2016 at 07:30 PM

    If you want to delete only a selected/multiple entries from a Custom or Standard Table i would suggest, first switching the SE16 output screen to ALV list. Then once you see the output of the rows in ALV list viewer then select the entries you want to delete using the check boxes and then start the debug mode by entering /H in the command box, now click on any toolbar icons preferably the display icon, now you can see the debug screen, enter the SY-UCOMM in the debug console and change the value to 'DEL5' and then execute the same.

    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.