matnr in mara

[Former Member]

hi,

i want to bring all materials(matnr) present in MARA into my internal table.

please suggest.

[Former Member]

data: begin of typ_mara,

matnr type matnr,

end of typ_mara.

data: itab type stanadrd table of mara.

select matnr into table itab from mara.

write:itab-matnr.

endselect.

[Former Member]

Hi,

Types:begin of t_mara,

matnr like mara-matnr,

end of t_mara.\

data:i_mara type standard table of t_mara,

wa_mara type t_mara.

Use

select matnr into table i_mara from mara.

now you have all the materials in your intrnal table i_mara.

thanks.

[Former Member]

Hi,

Try the following syntax,

SELECT MATNR FROM MARA INTO CORRESPONDING TABLE ITAB.

[Former Member]

Hi Srinivas,

Use "Select matnr from mara into itab."

Performance could be an issue in this when the number of materials is too high.

Regards,

Pankaj

Message was edited by:

Pankaj Sharma