cancel
Showing results for 
Search instead for 
Did you mean: 

developing new Z report to scrap

Former Member
0 Kudos

Hi Gurus,

Please help me to develop a new report to scrap the materials.

The report should bring all the materials unrestricted stock w.r.t plant, but it should not bring any purchase (M.type-101) less than a year of stock and the same material should not have any sales (M.type-601) since one year, these parts can be a scrap.

Also suggest me what input parameters can be given to get the required o/p.

Thanks in advance,

Chandra Sekhar

Accepted Solutions (1)

Accepted Solutions (1)

JL23
Active Contributor
0 Kudos

if the report "should bring all the materials unrestricted stock w.r.t plant"  then it is obvious that the plant is an input parameter.

especially for test purposes, or as well for individual analyses I would use the material number as input parameter too.

you mentioned one year as threshold, make it flexible, provide it as input parameters, default it as a year but let the user decide if they want execute it with a different residence time.

you said "unrestricted stock w.r.t plant" , this means you have to select based on MARD table (and aggregate it yourself to plant level) . In my opinion this is a very limited view as it would mean that you scrap only unrestricted stock, but do not scrap blocked stock.  There are many many more stock tables that may have to be considered to get a full picture.(please search for wiki, blog and documents - there are several in SCN which list all the stock tables)

And once you have read the stock, you need to check the movements in the given residence time. Movements are stored in table MKPF and MSEG.

Former Member
0 Kudos

Hi Jurgen,

Thanks for your reply,

As you said i can go ahead with the above i/p parameters but user might not be knowing about the material to give as i/p, however it will be useful to get a material specific report if i provide.

But my concern is how to fetch this "should not bring any purchase (M.type-101) less than a year of stock and the same material should not have any sales (M.type-601) since one year" condition in the MSEG and MKPF tables.

Please brief me the logic in sequence.

Thanks & Regards,

Chandra Sekhar

JL23
Active Contributor
0 Kudos

I will certainly not write the ABAP coding here.

it is ABAPer work how he achieves the details. if he reads everything into an internal table and deletes there what does not meet the criteria, or if he writes the valid records into a second table before it is issued to the user.

I already said you have to start with the stock, and then you check the movements..

Answers (0)