Material Ageing Report

[Former Member]

I want to develop material ageing report based on FIFO method for given date.

Logic.

The user will provide the list of material, plant and Date for ageing report. System should fetch up the stock as on given date i.e. 500 Nos, then system should check the last receipts of the said material and calculate the ageing between date of receipt and given date. i.e. there are last three receipt are 200 nos + 150 nos + 150 nos, the system will check the receipt date of said three receipt and calculate the ageing of said material.

I want to know the tables and field or any other details which i can use for preparing the functional specification.

Regards,

Pranav

[Former Member · Accepted solution]

Hi,

There is a standard report - T Code - MC46 for the Material Ageing Report. It will display the material based on the consumption.

Regards,

Bijoy Kumar S.P.

[former_member252335]

This message was moderated.

ZMM_STOCK_AGEING_REPORT.txt.zip

[ositoconmiel]

use MCBE or MC.9 Tcode

[pralhaddesai]

@Nikunj, There are 3 includes in the program please share those also.

[former_member619089]

Hi,

If standard does not fullfill your requirement then you can devlop a report for the same by using table MBEWH.

[jpfriends079]

You can use following SDN threads for understanding/reference:

-

-

-

Thanks & Regards

JP