cancel
Showing results for 
Search instead for 
Did you mean: 

How to findout last sale transction date of perticular material

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member187989
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

former_member183879
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

I want just check sale transaction have been done or not of particular material , in VBRK or VBRP table all details has been display. We want just required the report where we enter the item code & system will be display last sale transaction date.

BK GAIKWAD

Former Member
0 Kudos

hi,

Since i am clear on the on which transaction

Check in MD04- If your check at stock level

VA05- Report for the sale with Material Vs Customer.

SD01- Order with Time period.

V.26- Sales order by object status.

Pls let me know if need more informaion

Rdgs,

Mauryan

Edited by: Mauryan on Sep 8, 2010 7:29 AM

Former Member
0 Kudos

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