reports

[Former Member]

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]

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

[Former Member]

hi,

Check the value in v_matnr.

Is it satsfying any condition..

Regards

Azad.

[Former Member]

hi

<b>delete from mara where matnr = v_matnr.</b>

<b>modify mara.</b>

regarsd

ravish

<b>plz reward if useful</b>

[Former Member]

Use this code.

delete mara where matnr = v_matnr.

Manoj

[Former Member]

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