topic Re: dele record. in Application Development and Automation Discussions

dele record.

Former Member — Sun, 24 Feb 2008 14:21:11 GMT

Hi All,

I deleted a record from the internal table which is it_scarr, this worked fine and sy-subrc = 0. Now I want to delete the record from table scarr from internal table and checked sy-subrc. Record is not deleted from the table and the value of sy-subrc = 4.

my code is:

delete it_scarr index 3.

if sy-subrc = 0.

endif.

delete scarr from it_scarr.

if sy-subrc = 0.

endif.

Please help me on this.

Thanks

Re: dele record.

Former Member — Sun, 24 Feb 2008 14:23:46 GMT

After you DELETE from DB table.....

Delete scarr from table it_scarr.

if sy-subrc = 0.

commit work.

else.

rollback work.

endif.

Thanks,

Deepak.

Re: dele record.

Former Member — Sun, 24 Feb 2008 14:30:19 GMT

Hi, Thank you. Here, I am first deleting the record from the internal table which worked fine. Later deleting the table record, which is not working and sy-subrc = 4. in the econd case.

Re: dele record.

Former Member — Sun, 24 Feb 2008 14:32:43 GMT

If you INSERT or DELETE records from DB table you have to COMMIT IT as I have gave you a piece of code.

Thanks,

Deepak.

Re: dele record.

Former Member — Sun, 24 Feb 2008 14:33:09 GMT

Hi,

what is scarr ?

is it a field in internal table it_scarr?.

Regards

Re: dele record.

Former Member — Sun, 24 Feb 2008 15:03:34 GMT

Scarr is table given by SAP.

Thanks.

Re: dele record.

Former Member — Wed, 27 Feb 2008 19:43:16 GMT

I figured it out what the problem is.