want material list

[Former Member]

i want a material list , where there have been no sales activity in a specified period, instead of sales view maintained.

[Former Member]

Hi,

Sorry for ma preceding anwser.

In fact, can you specify "no sales activities" ?

No sales activities : no sales order ? no deliveries ? no invoices ?

A solution is to create a little report for a date selection / material code + code to read VBAP (or VBRP).

If the system founds data for the selection, update nb of items (or other field). If not, 0 for the date.

Another solution mentioned in preceding anwer, it's to use Tcode in Stock IS : MC46, MC50

Regards,

Lionel

[Former Member]

MC46 and MC50 will not provide any solution for your problem.

For example,

1. All material, irrespective of, the sales view created or not appear in these reports.

2. The use such as consumption of the material during production process is also considered. Where as you want only the "sales activity".

You have to go for customized report.

[Lakshmipathi]

Dear Ashiish

By giving sales organization in both the reports, do you think that even the materials for which sales view is not created will flow. If I am correct, in material master, normally we dont create sales view for ROH Having said this, can you please reconfirm your statement is correct ?? My understanding is that in the above reports, for whatever material, sales view is created, that only will flow. Correct me if I am wrong.

thanks

G. Lakshmipathi

[Former Member]

Dear Laxmipathi,

Even after restricting the selection with sales organization, it will take the material that are not created for the particular sales org.

Thanks.

Ashish

[Lakshmipathi]

Thanks for the updation Ashish

[Lakshmipathi]

Dear RajKiran

MC46 - Slow Moving Items

MC50 - Dead Stock

thanks

G. Lakshmipathi

ps:- If you feel your question is answered, please close the thread

[Former Member]

USE TCODE " MM60 "

i believe this is what u are looking for

plz tell me if this solves

regds

anil

Edited by: anil singh on Jun 25, 2008 7:20 PM

[Former Member]

hi ravi it is my post. i have tried every thing can you suggest anything or any tables which can show this

[Former Member]

hi,

did u Use me2m and mb51

I think its giving wt u want.

Thanks,

Raja

[Former Member]

hi

YOU can get the list of material from MB51 tcode.just enter the plant for which you want material.

OR

if you want table then USE MARC table use plant as a selection field then you will get the list of material for that plant

reward points if helpful

regards

chetan

[former_member184555]

Hi

Please check the below thread...this may be useful to you..

Thanks,

Ravi

[Former Member]

how can you use to mm50, i want material list with no sales activity eventhough sales veiw is maintained

[Former Member]

Hi Ravi,

Use me2m and mb51

they will tell you date wise status of the material.

Hope this will help.

Reward Point if helpful.

Thanks,

Raja

[Former Member]

Hi,

Try Tcode MM50

Regards,

Lionel