My requirement is to find the materials which dont have production stor loc maintained in the material master MRP2 view..
I have got a list from MARC table by filtering the prod storage location field.. I have got 19000 materials without the production storage location..
I am sure that these 19000 materials need not necessarily be production related..
Can anybody give me an idea of how to get a list of materials that are production related..
i.e I want to get a list of materials for which production orders will be created and also for which are going to be issued to production orders...
( I have an idea to get the list of all the materials that are having backflush indicator coz in this plant all the materials are backflushed and for header materials >those which have BOM and routings)
anyother idea from u experts????
5 Answers
-
Posted on Aug 14, 2009 at 10:08 AM
Dear,
Table is MARC and field LGPRO.
So go to MM17 select the MARC and filed LGPRO execute it by putting the materials code relevant for production you will get all the list of material master with production storage location and without.
Regards,
R.Brahmankar
Add a comment
-
Former MemberPosted on Aug 14, 2009 at 10:14 AMHi SAP 125 ,
1 check material LISt with material type HALB & FERT in MM60
2 Check BOMof material through Table MAST in SE16
3 Check Routing in Table MAPL (Plant wise)
now combine three list u will get the material (Finish & semifinish ) whose BOM and Routing is created these r production usable mayterial
Regards,
Girish
Add a comment
-
Former MemberPosted on Aug 14, 2009 at 10:17 AM
Hi,
This can be done by developing a report by pulling data from standard tables.
Pull materials with Procurement key as 'X' or 'E'. This field is BESKZ in table MARC. Also pull material list from STKO (BOM header details). The materials common is both lists would be the material that could be manufactured.
For BOM companents, same way you can pull materials from table STPU and STPO. Along with the materials having procurement key (MRP 2 View) as X or F. The common materials would materials which would be issued by 261 Movement.
Hope that helps.
Regards
Rohit.
Add a comment
-
Former MemberPosted on Aug 14, 2009 at 10:17 AM
hi,
As per ST scenario all the materials related to production will be used in BOM may be as a header material or as a component material,So from table MAST & STPO tables find out the list of materials used tables and consider only those materials.
Or based on material type you can do the filteration.Mainly the RM, PM and FG & FSEM are user in prodduction.So you can have filter on both.
Hope this will help.
regards,
kaushik
Add a comment
-
Former MemberPosted on Aug 17, 2009 at 05:14 AM
Hi!,
Though you have already identified a suitable logic but still I would like to add some improvisation to it by introducing some more fields to confine the selection. Also I would suggest to use SQVi so that you can use table join and create your own query.
Go to SQVI and create an query by joining tables MARA, MAKT, MARC. There you can select fields like MARA-MATNR, MARA-MTART (Material type), MAKT-MAKTX (Mat description), MARC-BESKZ (Proc type), MARC-RGEKZ(Backflush ind), MARC-LGPRO, MARC-SFCPF.
I think here the filter on the basis of mat type will greatly reduce the number of relevant materials.
I hope this will help in resolving your problem. Please revert back in case of any further issue.
Regards,
Uday
Add a comment
Add a comment