on 09-10-2007 2:16 PM
Hi,
I have a strange requirement. Recently I have updated VPRS condition in my sales order for COGS determination in the Profitability report.
Now the client wants the data for July till date into the report.
In my opinion I dont think I can determine material cost for my previous orders when the VPRS condition typ was not incorporated.
Does anyone has any idea about the best possible solution?
Regards
Ashish
Ashish,
Check MBEW Table in SE16...
Award points if u finds this as useful...
Regds
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I can give you a manual solution, but do not know whether this will serve your purpose or not. Anyway,
You can use the table MBEWH - Material valuation(History) to get the MAP value/ Std value of the Material per
Material + Valuation area(Plant) + Valuation type + Fiscal Yr + Period(Mth) = MAP/SP value
From VBEP table get a download of all the Sales order line items from July to till date. From there you will get the data for Material, Qty, Plant, Date( Yr and Mth).
Use this data to finally get your material cost for the respective periods for the corresponding sales orders of that period/Yr.
Hope this will resolve your issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
VPRS is picking from the MMR. so check the MARA table from July in SE16.
I dont know whether this is a perfect solution.
Try this.
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
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.