Skip to Content
author's profile photo Former Member
Former Member

PO history -Urgent

Hi,

I am looking for a table that gives me all the 102 movements that were carried out within a time period with Qty and mat doc?

I need to generate a report very urgently, so some quick replys will be very helpfull!!

Thanks

Kelly

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 12:41 PM

    u can get this by MB5B

    go to se16

    first go to MKPF put the posting date from to

    table name mseg

    put movement type 102 u will get all the details

    this two tables will give u the details u need

    MKPF and MSEG

    also u can use EKBE

    reward if usefull

    Message was edited by:

    Umakant Bhangale

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 12:47 PM

    Hi

    You can use Table EKBE with Movement type selection as 102 , In this table you can have the selction of date range also.

    Thanks & Regards

    Kishore

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 12:52 PM

    Hi Kelly,

    You can go with table MSEG which will give all the details as per your requirement.

    rgds

    Chidanand

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 06:20 PM

    Hello Kelly,

    I agree with the last posting. You should be able to utilize MB51 to view both the 101 and the relevant 102 based on the PO reference. The report can be executed by posting date and by plant. This report can be executed in the background if there are performance issues. If there are not any performance issues, then you can select the ALV view to download the information into Excel for further analysis.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 06:24 PM

    Hello Kelly,

    One additional report you can utilize is the ME80FN report. This report works well if your input is from the PO side. The MB51 is driven from the inventory side. Similar results however the good thing about this report output is that you can view the PO history view of the PO line item for each PO selected based on y our criteria. In addition, you can also utilize the movement type and reference document to sort/subtotal based on the original materials document which should be the same as that on the 102 reversal.

    Just another option.

    Hope this helps.

    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.