topic Re: Aging stock in Application Development and Automation Discussions

Aging stock

Former Member — Fri, 18 May 2007 11:22:16 GMT

Hi friends,

Please let me know what is the meaning if "Aging Stock"...its not technica...quite functional....please reply me ASAP...

Re: Aging stock

Former Member — Fri, 18 May 2007 11:25:15 GMT

It is functional word and i have done aging stock report.

you need to get the data for diffrent period and diffrent quantity values for material based on purchasing organinisation ,purchasing group.

Please let me know if you need any more information

Reward points if it is useful

Thanks

Seshu

Re: Aging stock

Former Member — Fri, 18 May 2007 11:25:33 GMT

Hi,

Ageing means the time difference from the date the material has come into your stock to till date.

A material was received into stock on 04.01.2007 and as on today the ageing is 5 months.

Based on the stock types you can count this.

Since all fields are clear from LQUA, fetch them into a internal table and update the internal table data into a Z table.

Revert Back if any issues.

Reward with points if helpful

regards,

Naveen

Re: Aging stock

amit_khare — Fri, 18 May 2007 11:25:47 GMT

Check these links -

Regards,

Amit

Reward all helpful replies.

Re: Aging stock

Former Member — Fri, 18 May 2007 11:30:10 GMT

thanks for the reply Seshu,

i just want to know what are the details to be displayed for the report...

Actually i created the report with the following tables:

MAKT

MBEW

MCHA

MARC

MCHB

and the output contains the following selection screens:

Plant,MRP controller,storage location etc...but after entering the plant value i need to get the details of the aging stock...so wht output should come???

Re: Aging stock

Former Member — Fri, 18 May 2007 11:36:50 GMT

I have open my office system and i will get back to you after 2 hours..

Reward Points if it is helpful

Thanks

Seshu

Re: Aging stock

Former Member — Fri, 18 May 2007 13:57:13 GMT

I used below Tables :

tables: mara, " General Material Data

marc, " Plant Data for Material

mard, " Storage Location Data for Mataerial

mvke,

makt, " Material Description

mkpf, " Header: Material Document

resb, " Reservation/dependent requirements

mseg. " Document Segment: Material

Selection-screen :

material #

Vendor

Material type

storage location

Plant

Output is

Material

Material Description

Current plant stock

Expired stock

Effective Availible Stock

Reward points if it is available

Thanks

Seshu

Re: Aging stock

Former Member — Tue, 15 Apr 2014 07:42:04 GMT

Hi seshu

I think you have worked in ageing i am having some queries in ageing please help me

i am having some of the fields how to identify those tables please help me

Last receipt date

Last consumption date

Last goods movement date