Skip to Content
avatar image
Former Member

deleting records

kindly give me the procedure of deleting the records of a transperent table in sap

regards

sami

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Aug 16, 2007 at 09:55 AM

    I have a solution that might work for you too.

    Go to SE11. enter your table name and press display(F7).

    Then press (CntrlShiftF10) for contents of table.

    enter the fields that might help you select your records else leave them empty and press F8.

    Now the records are displayed in list.

    Checkmark the records you want to delete.

    Then press Display(F7).

    Now in Command Bar enter '/h' and press ENTER. the system wud give a msg that debugging has been started.... Now press ENTER once again it will go into debugging.

    In debugging mode there is a variable CODE which will be having value SHOW, change that value to DELE and press the pencil button in the extreme right to that field.This changes the contents of CODE from SHOW to DELE. Now press F8.

    Now in application toolbar 'Delete entry' button will appear with navigation keys.

    So now buddy you need to delete that record by pressing that button and navigate to next record and delete that and so on,one by one. after you have deleted all the required record press the BACK button, you again come back to list display of records, press refresh and all the deleted records will disappear. Keep on eye on the Message bar while deleting.........

    or

    in debugging mode, u will see 'code' written on the screen, double click it, it will appear in 'Field names' which shows the contents of the field, the content of CODE will be SHOW,

    you have to change that to DELE (see that its in capital letters), now just to the right of the field where in 'Field names' you'll see a button of magnifying glass and next to it is the pencil button(Chang Field contents) i was talking bout. but remember that after you have written DELE, do not press ENTER or press any other button other than the pencil button(Chang Field contents) as the field contents will revert back to previous values....

    regards,

    srinivas

    <b>*reward for useful answers*</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 09:43 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 09:45 AM

    hi,

    u need to write a code for deleting records.

    but i recommend u to delete the records from corresponding transaction. if that is not possible then only use the delete code.

    PARAMETERS p_carrid TYPE sflight-carrid.

    DELETE FROM sflight

    WHERE carrid = p_carrid AND

    fldate = sy-datum AND

    seatsocc = 0.

    reward points plz

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 16, 2007 at 09:45 AM

    If you wanna delete it through code refer the link -

    delete-table-contents

    Otherwise directly delete the records either from Se11 or Se16 if you have access.

    Regards,

    Amit

    Reward all helpful replies.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 09:47 AM

    Hi

    delete from ztable where salary lt '1000'.

    reward points to all helpful answers

    kiran.M

    Add comment
    10|10000 characters needed characters exceeded