topic Re: delete the uploaded record in Application Development and Automation Discussions

delete the uploaded record

Former Member — Tue, 28 Aug 2007 10:26:31 GMT

I uploaded some records thru BDC(any Method) . Now that i want to delete that particular uploaded record from the database . How can i do that??

Re: delete the uploaded record

Former Member — Tue, 28 Aug 2007 10:29:40 GMT

use the delete statement

delete from dbase where cond.

keep the condition on key fields

regards

sandhya

Re: delete the uploaded record

Former Member — Tue, 28 Aug 2007 10:30:47 GMT

hi,

for which transaction u uploaded the records ? check with the functional consultant he might be able to tell u wether there is any other transaction which can reverse the records.

rgds.

reward points if it helps

Re: delete the uploaded record

Former Member — Tue, 28 Aug 2007 10:41:03 GMT

Hi,

If you have the records in an internal table, use the following command.

DELETE ztable FROM TABLE itab.

If you have the records in a Work Area, use the following command.

DELETE ztable FROM wa.

You can directly delete the records if you know the keys:

DELETE FROM ztable WHERE 'condition'.

Award Points if useful.

Thanks, Ankur