I tried deleting a record from standard table but not working

[Former Member]

I need to delete a record from standard table scarr using this syntax but the record is not deleted please check it ,is it possible to delete the record from standard table or not help me in doing it .

data: wa_scarr type scarr.

wa_scarr-CARRID = 'SQ'.

wa_scarr-CARRNAME = 'Singapore Airlines'.

delete from scarr where carrid = wa_scarr-carrid and

carrname = wa_scarr-carrname.

if sy-subrc <> 0.

write: 'record not deleted'.

endif.

[Former Member]

Hi,

yes we can directly delete the record from that std table.

Thank You,

santhosh

[Former Member]

hi

change this code as below

data: wa_scarr type scarr.

wa_scarr-CARRID = 'SQ'.

wa_scarr-CARRNAME = 'SINAGAPORE AIRLINES'.

delete scarr from wa_scarr where carrid = wa_scarr-carrid and

carrname = wa_scarr-carrname.

if sy-subrc NE 0.

write: 'record not deleted'.

endif.

Edited by: venu gopal on Oct 16, 2008 9:51 AM

[Former Member]

Hi anjali,

you can delete from the standard table , check after deleting sy-subrc .

sy-subrc = 0 = deleted

sy-subrc <> 0 = not deleted

regards

naveen

[Former Member]

Hi,

You might be having issue with 'SINGAPORE AIRLINES' and 'Singapore Airlines'. Acutally u dont have to use that field. you just have to specify the key for the table.

u can use

delete from scarr where carrid = 'SQ'.

regards,

Anoop Panackal

[Former Member]

thank you all

i got it