topic Re: delete data into table before insert in Application Development and Automation Discussions

delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:17:03 GMT

hi Experts,

how to write a code for delete the data first from ztable before inserting the data into the same table after execution of program.

I have written like

data itab like ztable occurs 0 with header line.

If ztable is not initial.

delete itab.

modify ztable from itab.

endif.

but this code is not working.Plz reply as soon as possible.

Thx in advance.

Regds,

Vipul

Re: delete data into table before insert

viquar_iqbal — Mon, 23 Feb 2009 11:22:02 GMT

you can use refresh itab[].

this would delete all the data from itab.

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:24:22 GMT

do you want to delete all the rows or a particular row?

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:25:57 GMT

i want to delete all the rows but when i put debug it show it skip from the if condition.

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:26:45 GMT

Hi,

Can i have ur reqiurement clear....

ur trying to delete the table entries first then trying to insert the entries to the same table...

so let me know,that the entries ur deleting are same as that of the entries ur inserting.?

if not y u want to delete the table entries first.

Regards,

Rohan.

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:27:01 GMT

Hi,

Your requirement is not clear. Please specify it clearly.

you have deleted itab then modifying ztable from itab. how come data will be there in itab.

thanks,

Srilakshmi.

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:27:06 GMT

use


If ztable is not initial.
clear: itab , itab[]."delete itab.
modify itab from ztable.
endif.


clear: itab , itab[]

Edited by: tahir naqqash on Feb 23, 2009 4:28 PM

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:27:51 GMT

try this:

loop at itab.

delete itab from 1.

endloop.

modify ztable from itab.

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:28:26 GMT

I don't think U can check if Ztable is empty or not ..

remove this statement ..

write as ..

If itab[] is not initial.

clear itab[].

modify ztable from itab.

endif.

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:28:36 GMT

Hi Vipul,

Simply write the following code:-

If MARA is your table.

DELETE from MARA.

This will delete all entries.

If you want to delete only some entries, you can provide a where clause.

And then write the code for inserting the entries.

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:31:05 GMT

Hi,

When you are checking a table whether it is initial or not.

Use

 if itab[] is not initial.....endif

and if you want to delete the data in internal table.

You can always use

 Refresh : itab[].

or if you want to delete only the cirrent line Use.

 delete itab.

Hope this may help.

Regards,

Amitteja

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:31:48 GMT

Hi Vipul,

Could you please give your requirement very clearly?

Regards,

Anil

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:32:19 GMT

try this

delete ztable

insert ztable from itab.

regards

Varun

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 11:40:56 GMT

Thx my problem solved.

Re: delete data into table before insert

Former Member — Mon, 23 Feb 2009 12:09:04 GMT

hi Vipul,

Try doing this.....

DATA: itab type standard tabe of ztable.

select * from ztable into table itab.

if sy-subrc = 0.

delete ztable.

else

modify ztable from itab.

endif.

This will work, I have tried it out.

Thanks and Regards

Suraj