Skip to Content
author's profile photo Former Member
Former Member

Prod storage location

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????

Add a comment
10|10000 characters needed characters exceeded

Related questions

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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 14, 2009 at 10:14 AM

    Hi 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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted 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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted 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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted 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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.