Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

material master detail report...

Former Member
0 Kudos
235

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..

6 REPLIES 6

Former Member
0 Kudos
104

Check these tables ,

MARA , MARD and MARC

Regards,

Senthil N S

h_senden2
Active Contributor
0 Kudos
104

MARC - plant specific material master data

regards,

Hans

Please reward all helpful answers !!!!!

Former Member
0 Kudos
104

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 bwerks amatkl into( plant,mat_grp ) from mara as a inner join marc as b on amatnr = bmatnr where amatnr in i_matnr and bwerks in i_werks and a~mtart = i_mtart.

write:/ plant,mat_grp.

endselect.

rgds,

bharat.

Former Member
0 Kudos
104

Hi,

Check MARA,MARC.

Regards

Kannaiah

Former Member
0 Kudos
104

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
0 Kudos
104

Hi,

Check the following link:

http://www.sapbrain.com

Regards,

Bhaskar