2007 Jul 20 6:21 AM
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..
2007 Jul 20 6:29 AM
Hi
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.
<b>Reward points for useful Answers</b>
Regards
Anji
2007 Jul 20 6:26 AM
hi,
Check the value in v_matnr.
Is it satsfying any condition..
Regards
Azad.
2007 Jul 20 6:26 AM
hi
<b>delete from mara where matnr = v_matnr.</b>
<b>modify mara.</b>
regarsd
ravish
<b>plz reward if useful</b>
2007 Jul 20 6:29 AM
Use this code.
delete mara where matnr = v_matnr.
Manoj
2007 Jul 20 6:29 AM
Hi
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.
<b>Reward points for useful Answers</b>
Regards
Anji