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: 

Report on MM

Former Member
0 Kudos

Hi Friends,

I need to write a "Material Master Details Report" Inputting Material(MATNR) and Plant(WERKS) as select-options. Output list will have total Quantity by material group and Plant. Material type as parameter.

what r the fields for total quantity ,mat grp,mat type.

Can U please suggest me what what tables i need to take and if possible with the basic code.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

MARA-MTART

mara-MTPOS_MARA or mara-MATKL

mard-labst

regards

Nicole

4 REPLIES 4

Former Member
0 Kudos

Hi,

MARA-MTART

mara-MTPOS_MARA or mara-MATKL

mard-labst

regards

Nicole

kesavadas_thekkillath
Active Contributor
0 Kudos

wat is the total qty u r meaning.....???

material type - >mara-mtart.

material grp -> mara-matkl

plant - marc-werks.

Former Member
0 Kudos

Hi

use the Tables MARA,MARC and MARD

take the quantities (stocks) from MARD table

MATKL is the Mat group amd MTART is the Material type in MARA table

You can join all these 3 tables and write a single select

and display

Regards

Anji

kesavadas_thekkillath
Active Contributor
0 Kudos

first from marc get the list of materials passing werks and lvorm = space.

then use for all entries in mara , pass material type and material grp.

the list of parts are obtained.....

Then i didnt get wat u r meaning abt qty...do let me know