material master detail report...

[Former Member]

hai

can any one explain

what this report will do.. how the o/p will be,..

"<b>Input of material and plant as select-options and material type as parameter. Output list will have quantity by material group and plant.</b>

what r the tables used ?

thanks in advance..

[Former Member]

Check these tables ,

MARA , MARD and MARC

Regards,

Senthil N S

[h_senden2]

MARC - plant specific material master data

regards,

Hans

Please reward all helpful answers !!!!!

[Former Member]

Hi,

tables mara&marc has all these fields.

tables:mara,marc.

select-options:i_matnr for mara-matnr,

i_WERKS for marc-WERKS.

parameters:mtart like mara-mtart.

data:plant like marc-werks,mat_grp like mara-matkl.

select b_{werks a}matkl into( plant,mat_grp ) from mara as a inner join marc as b on a_{matnr = b}matnr where a_{matnr in i_matnr and b}werks in i_werks and a~mtart = i_mtart.

write:/ plant,mat_grp.

endselect.

rgds,

bharat.

[Former Member]

Hi,

Check MARA,MARC.

Regards

Kannaiah

[Former Member]

Hi,

This is code structure:

report z_mmdetail.

"This are tables used.

tables: mara, "Material master

makt "Materiald description.

"select-options and parameters

select-options: s_matnr ffor mseg-matnr,

s_werks for mseg-werks.

parameters: p_mtart type mara-mtart.

"Now fetch data from mara

[Former Member]

Hi,

Check the following link:

http://www.sapbrain.com

Regards,

Bhaskar