Skip to Content

Count of material documents

Dear all

I need a following statistics of material movement download.

For a single SAP user ID, Movement type wise, material document count needed.

for example

User BD1122101

Movement type : 101

Count of material document : 1353

Like that i have to take for all user ID's . Is there any standard reports available or any other workaround, Please help us.

Currently the same i am taking from MB51 transaction and it was more time consuming.

Madhan

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2011 at 11:37 AM

    Hi,

    Use Pivot table for the same in excel, group your data by material document / Location and add user id in Sum values ,you will get then count list of users.

    Regards,

    Sandesh Sawant

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 20, 2011 at 12:17 PM

    Hi Madhan,

    If you are only interested in GR documents with reference to purchase orders (mvt 101, 102, 122, 161), then searching the table EKBE can be much more efficient - it contains only PO history records (and contains all you need in one single table). Just use trs SE16N to list all the documents (limit to the fields that you need, like the user ID) and download to Excel to produce counts per user.

    If you need other material documents as well, there's a database view WB2_V_MKPF_MSEG2 containing all the fields that you need from MSEG (mvt) and MKPF (user, date) in one single table. Again, use trs SE16N to download the neccessary fields to Excel and do statistics there.

    BR

    Raf

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Madhan,

      I am not a big expert in Excel, so I don't know if you can let a pivot table count only unique occurrences of the material doc. number. But you can definitely ask it to remove duplicates of material document number before you create the pivot table - Excel 2007 has a pushbutton for this on the "Data" tab.

      BR

      Raf

  • Posted on Aug 20, 2011 at 12:35 PM

    Hi

    You can get the document details in Table MSEG & User detals in Table BKPF

    You may connect these 2 tables in by SQVI & get the desired details.

    Thanks

    Sachin

    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.