on 09-08-2010 5:58 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can easily get that in VBAP by putting the material number for MATNR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
90 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.