cancel
Showing results for 
Search instead for 
Did you mean: 

No routing

Former Member
0 Kudos

Hi All,

I want to know that for a plant , how many material does not have routing maintained. Is there any way to find out or we have to go for a customized report.

Kindly suggest.

Regards,

D.Dutta

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

You can have this by following :

Go to MM03----> Choose F4 Help -


> Select Option Material by material type E and execute so you will get list .Save the list to excel with right click download option.

Similar exercise follow again in MM03 with selection option material by task list and download to local file as in previous file.Compare both list i.e. the materials having material type E and doesnt exist in material list with task list arent having task list.

Hope this helps.

Regards,

Tejas

former_member184655
Active Contributor
0 Kudos

Dear Debasish,

Check out this,

First get the list of materials with procurement type E from the table MARC for the plant and download

this report to an excel sheet format.

Execute CA51,for task list type N and this shows the list of materials which has a routing ,you can

download this and using a Vlookup you can compare and find out the list of materials not having routing.

If you have configured the working area in OP77,then the T code CEWB can also help you.

Regards

Mangalraj.S

Edited by: Mangalraj.S on Apr 9, 2009 2:45 PM

former_member199502
Active Contributor
0 Kudos

Hi,

Download the Materials in MARC and MAPL,just compare these data in excel sheet put VLOOKUP and take the materials which are not having routing

Former Member
0 Kudos

Go to SE11...Give table name MAPL(Routing data).... Select the contents icon.....(blue symbol)

In the Field WERKS give ur plant name.... The materials(MATNR) which have blanks in the field PLNAL are those which dont have routing..

PLNAL is the field name for Group counter...

U can also check PLKO

PLPO

CRHD

CRCO

karthick

former_member196398
Active Contributor
0 Kudos

Karthick,

If Routing is not existing for a Material you wont get any entry in MAPL table, so that's a wrong suggestion.

As suggested by other members, you can do this by Vlookup in excel for the table contents of MARC and MAPL

or

A simple query using SQVI, the only care which needs to be taken in the query design is that you need to make a Outer Left Join between tables MARC and MAPL, instead of Inner Join. And here in the output if PLNNR field is blank against a material then it makes clear that the material does not have a routing.

Regards,

Prasobh

former_member335796
Active Contributor
0 Kudos

Hi,

There is no standard SAP report to check this..

You can create a Query with the Tables MARA, MARC & MAPL to check for your requirement..

Regards,

Siva