How to delete a table entry

[Former Member]

Hi,

I need to delete one record from table SXC_ATTR.

I tried by debugging and changing the okcode to 'DELE'

But i could not delete it.

Please help.

[Former Member]

Hi,

If you change the code to DELE. It will show you the record and the delete button on the same, You need to press that delete button to actually delete the entry.

Regards,

Atish

[former_member404244]

Hi,

It will show you the record and the delete button .U need press on that delete button and the record will be deleted.

Reward if helpful.

Reagrds,

Nagaraj

[Former Member]

PARAMETERS p_carrid TYPE sflight-carrid.

DELETE FROM sflight

WHERE carrid = p_carrid AND

fldate = sy-datum AND

seatsocc = 0.

else

GOTO SE16

Enter the table name SXC_ATTR

Hit Enter key

Enter the primary key for which you want to delete the record

EXECUTE

Double click on the record

in the command prompt type /H

& hit ENTER

Change value of CODE = DELE

SAVE

Ensure that the display parameter in SE16

GOTO => USER PARAMETERS is selected as SE16 standard list

[Former Member]

First check the record u want to delete

then press /h to debug

Then press F7

Then change the value of variable 'code' to DELE

Then click on <b>Pen icon</b> in front of that box where u change the value

This will do it..

reward if this helps

[Former Member]

hi geetha,

to delete the record of a table u need to check that record press shift+f2 .u will get the delete screen click on delete entry .come back and refresh it.

your entry will be deleted.

regard's,

sohi

[Former Member]

There is another way to edit,add and delete table enteries in standrad table.Note the following instructions.

1. Call transaction SE16N and enter the required table name to be edited(ex. KNA1).

2. type &sap_edit in the command window and press enter key. The message 'SAP editing function is activated' will display.

3. Click on the execute online button (F8). Now the table will be in edit mode!

hope its useful.

happy hacking ;D

[tholuganti]

This message was moderated.