Skip to Content

View Materials by plant and material type

Hi,

I need to view the list of materials filtered by material type and plant, i couldnt find aa table for it, nearest option I found is Tcode MM60 but it does not show me total of materials there.

Do you know how to achieve it?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 07 at 01:58 PM

    Hi,

    Table MARA, MVKE, MARM and MARC has the requirement through SQVI or through an Abaper information can be fetched.

      SELECT matnr werks
             ladgr
             prctr
             steuc
             ekgrp
             disgr
             dismm
             dispo
             disls
             eisbe
             beskz
             mtvfp
             strgr
             fhori
             lgpro
             mmsta
          FROM marc INTO TABLE it_marc
          FOR ALL ENTRIES IN it_mara
          WHERE matnr = it_mara-matnr.
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 08 at 05:12 AM

    In MM03 itself, you have the option to list Material Type wise and Plant wise as shown below


    mm01.jpg (69.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 08 at 04:09 PM

    Just cross check report S_P00_07000139

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.