topic Re: delete in Application Development and Automation Discussions

delete

Former Member — Wed, 27 Sep 2006 03:50:17 GMT

hi i am trying to delete records from Z table using the statement.

delete ZES_RFQ_SVC from table it_rfqsvc.

but it returns sy-subrc 4.

Please correct me

Pratyusha

Re: delete

Former Member — Wed, 27 Sep 2006 03:53:23 GMT

Hi, Check the syntax to delete from database table.

Deleting from a Database Table

- DELETE FROM dbtab. or

DELETE FROM (dbtabname).

- DELETE dbtab FROM wa. or

DELETE (dbtabname) FROM wa.

- DELETE dbtab FROM TABLE itab. or

<b>DELETE (dbtabname) FROM TABLE itab.</b>

- DELETE dbtab. or

DELETE *dbtab.

- DELETE dbtab VERSION vers. or

DELETE *dbtab VERSION vers.

Regards,

Senthil

Message was edited by: senthil kumar

Re: delete

Former Member — Wed, 27 Sep 2006 03:58:54 GMT

Check this

DELETE FROM Z08V3_UZ_PRINTED WHERE FKNUM = '2020000120'.

I have use in one of the case.

Check similaraly it may help u.

Regards

Re: delete

Former Member — Wed, 27 Sep 2006 03:59:06 GMT

Hi,

If you are using the from table IT_RFQSVC..Then the internal table should contain values for all the primary key fields including the MANDT.

Check in the internal table if all the key fields are populated..

THanks,

Naren

Re: delete

Priti_PM — Wed, 27 Sep 2006 03:59:10 GMT

Hi,

sy-subrc is set to 4, when you don't have any matching record in db table for values in internal table. Please first check if primary key fields of db table have the same contents as that of your internal table row.

Regards.