Skip to Content
avatar image
Former Member

How to findout last sale transction date of perticular material

Hi Experts,

Please tell me how to find out last sale transaction date of particular material, we have already gone through MCBE, MB51 & & MSEG table here all details has been display we have required only last sale transaction date.

Regards

BK GAIKWAD

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Sep 08, 2010 at 05:00 AM

    hi

    please confirm which sales kind tranzaction

    if you just want last / latest SALES ORDER for material then check table VBAP

    if last billing document then check table VBRP

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi

      check MCBE

      Prese F6

      there you can select the columns

      Last consumptn.

      Last gds issue

      Last gds mvmt.

      Last Receipt

      you will get dates but not the TRANSACTION

  • avatar image
    Former Member
    Sep 08, 2010 at 05:41 AM

    You can easily get that in VBAP by putting the material number for MATNR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2010 at 10:09 AM

    very much u can find in

    VA05- Report for the sale with Material Vs Customer -point and click the all sales order

    -after select the documnet number and click on -sort in descending order- action button

    in DOC date u can see the latest created date

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2010 at 12:06 PM

    Use either

    VA05 - last order for material

    or

    VF05 - last invoice for material

    In both reports enter the material number in the initial screen, then order the lines in the report by date.

    But all the above variants are also ok.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2010 at 05:38 PM

    In MB51 selection,enter movement type - For ex.601 or relevant issue movement type,enter material no.,enter plant.

    Execute.

    In report lists all material documents by latest posting date for mvmt type For ex. 601,

    Top most record is latest sales transaction happened.

    or

    Develop a query based report using billing tables VBRK,VBRP.

    Add comment
    10|10000 characters needed characters exceeded