topic Re: Material Ageing Report Through ABAP( MC46 Tcode Wise) in Application Development and Automation Discussions

Material Ageing Report Through ABAP( MC46 Tcode Wise)

Former Member — Thu, 11 Mar 2010 07:16:47 GMT

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

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

manthanraja — Thu, 11 Mar 2010 11:53:18 GMT

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

Manthan.

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

Former Member — Thu, 11 Mar 2010 11:57:44 GMT

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

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

Former Member — Sun, 14 Mar 2010 12:16:40 GMT

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

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

Clemenss — Sun, 14 Mar 2010 13:41:01 GMT

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

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

Former Member — Sun, 14 Mar 2010 17:34:40 GMT

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

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

Former Member — Wed, 17 Mar 2010 04:00:35 GMT

problem solved self.

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

Clemenss — Wed, 17 Mar 2010 08:39:14 GMT

Hi nav,

thank you very much for not sharing the solution.

Regards,

Clemens

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

Former Member — Tue, 03 Aug 2010 04:34:24 GMT

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

Re: Material Ageing Report Through ABAP( MC46 Tcode Wise)

Former Member — Fri, 01 Apr 2011 12:53:34 GMT

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