03-11-2010 7:16 AM
Hi,
I want to develop report for Material Ageing Report which is similar to the Tcode MC46 but the problem is functional consultant told me about this tcode only and there is no such information regarding the specified tables which are to be used. I had searched in SDN also but i did not got the desired information.
Edited by: nav009 on Mar 11, 2010 12:31 PM
03-11-2010 11:53 AM
refer program RMCBLH30 and there you will be able to see the tables linked to it .. (via check object list)
also you can refer 0IC_C03_Q0012 stock overview standard report
and Inventory Ageing 0IC_C02_Q0021
BR
Manthan.
03-11-2010 11:57 AM
Hi,
After comparing the tcodes MC46 and MC50,i am able to trace out that data is coming from the MBEW table but the problem is the ageing logic works on As On Date and the data to be *picked Less Than Equal to Posting Date *.
There is no such field present on which i can made this logic succesful.. i tried to develop the report through different tables also(BSIM,MSEG and MKPF) but the quantites and the amount is coming accurate after comparing it with the above mentioned Tcodes.
Is there any other table through which this problm can be solved....?
Edited by: nav009 on Mar 12, 2010 5:42 AM
Edited by: nav009 on Mar 14, 2010 12:21 PM
03-14-2010 12:16 PM
Hi
Use following blog to get the tables involved in any transaction code ( In our case t-code MC46).
[Get Name of Tables used in T-Code|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17775] [original link is broken] [original link is broken] [original link is broken];
Hope this helps.
Regards,
Chandravadan
03-14-2010 1:41 PM
Hi nav,
if you want to develop report for Material Ageing Report which is similar to the Tcode MC46, then why don't you just copy the report RMCBLH30 into a Z-record and then modify it to fulfill your consultants requirement.
From your posting it is not clear what your custom report will have in common with MC46 and what kind of difference is expected.
As On Date and the data to be *picked Less Than Equal to Posting Date *
is not really very clear. Could you give a complete example of what data should give what kind of result?
Regards,
Clemens
03-14-2010 5:34 PM
H Clemens Li ,
Thanks for your response. Actually i want to develop the report on the basis of the Ageing Bucket i.e. 0 to 30,31 to 60,61 to 90,91 to 120 etc.. and the user should enter the date i.e. As On Date and the user can see the see amount and quantity in the respective buckets ..
I tried to make the logic through the tables BSIM but the amount is not matching.
Is there any way of doing it except copying the standard program.. because the quantity and rate it is present in the different transactions i.e. MC46 and MC50......
Edited by: nav009 on Mar 16, 2010 10:08 AM
03-17-2010 4:00 AM
03-17-2010 8:39 AM
Hi nav,
thank you very much for not sharing the solution.
Regards,
Clemens
08-03-2010 5:34 AM
Hi,
Can u share your loginc with me for making stock ageing report as i am not able to make it or a source code.
Thanks in advance.
Dinesh
04-01-2011 1:53 PM
Dear Sir,
Myself is also having the same requirement for Aging of Inventory Stocks as like you.
Can you share the abap code
Regards
K.Natarajan