topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Fri, 20 Jul 2007 05:21:33 GMT

I generated number of records in mara. now i think to delete it without using internal table in reports. I given the statement like this..

delete from mara where matnr = v_matnr.

but it doesnot deleted...give a solution to it.plz..

Former Member — Fri, 20 Jul 2007 05:26:07 GMT

hi,

Check the value in v_matnr.

Is it satsfying any condition..

Regards

Azad.

Former Member — Fri, 20 Jul 2007 05:26:41 GMT

delete from mara where matnr = v_matnr.

modify mara.

regarsd

ravish

plz reward if useful

Former Member — Fri, 20 Jul 2007 05:29:39 GMT

Use this code.

delete mara where matnr = v_matnr.

Manoj

Former Member — Fri, 20 Jul 2007 05:29:51 GMT

generally we don't delete the records from DAtabase tables directly using the DELETE statement.

The statement what you wrote is OK

why can't you use the Internal table

tables: mara.

data: s_matnr for mara-matnr.

data: itab like mara occur 0 with header line.

select * from mara into table itab where matnr in s_matnr.

delete MARA from table ITAB.

Reward points for useful Answers

Regards

Anji