on 04-09-2009 10:01 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.