topic Re: delete table from DB table in Application Development and Automation Discussions

delete table from DB table

Former Member — Fri, 09 Oct 2009 07:08:59 GMT

HI,

when i try do delete table (itab) from DB table for instance for 10 records and one of the record not found in the DB

i get sy-subrc = 4.

How i know that the all the delete is not success or just one record is not in the table ,just do compering for sy-db count ?

Regards

Nina

Former Member — Fri, 09 Oct 2009 07:11:11 GMT

sy-dbcnt can be one option.

from sap help itself if you press F1.

>The statement DELETE sets sy-dbcnt to the number of deleted rows.

so..

describle table itab lines gv_lines.

now use the delete statement.

now check if sy-dbcnt NE gv_count.

Edited by: Soumyaprakash Mishra on Oct 9, 2009 12:42 PM

SuhaSaha — Fri, 09 Oct 2009 07:12:06 GMT

just do compering for sy-db count

So what exactly is your question?

BR,

Suhas

Former Member — Fri, 09 Oct 2009 07:17:05 GMT

better you go to database table and give the key field values which you want to check and execute it.