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

GRN reports with base Value

Hi

Is there any T code which can be used to find all GRN receipts in a particular range of date along with Quantities and Base values. Have tried with MB51 and Movement type but couldnt get base value in it. Can someone suggest a T code

Vallinadh Karamcheti

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Oct 11, 2015 at 06:08 AM

    Hi,

    Refer your required details in report with t.code MB5S

    OR

    Refer your required details in report with t.code S_P00_07000139

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 11, 2015 at 06:32 AM

    What do you mean with "base value"?

    MB51 has the value of the movement, like it is with the other mentioned reports too.

    If you refer "base value" to e.g. a price before any surcharge or discount, then you have to develop your own report.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2015 at 08:24 AM

    Sorry but I cannot imagine how MB5S should be able to display a receipt in the base value (according to your definition of base value). It has no other value for the receipt as MB51, as the value stored is taken from MSEG table where the movement in stored.

    Your base value (before discount) can only be taken from the PO pricing

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 13, 2015 at 02:00 AM

    You have to Develop a Custom report to meet your requirement on Base Value. Tables that will be involved are EKKO,EKPO, KONV and EKBE..

    KONV- Table provide pricing conditions for given line items but you need to get condition number from EKKO table.

    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.