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

material codes- no transactions

dear sir,

i have around 35000 material codes in my plant.

i just wanted to check how many in the same in active or codes for which transaction has not taken place.

1. material code created PR open Po not created

2. material code created PR open Po open

3. MATERIAL CODE CREATED NO PR NO PO.(perhaps no stock even)

i need to check 3rd category

can any body help me!

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 01, 2007 at 05:16 AM

    Hi,

    Check the Consistency of the Planning File ( MDRE)

    Use

    Since the entries in the planning file are permanent, you must check their MRP relevancy regularly. If, for example, a plant is subsequently excluded from material requirements planning, its materials will still be included in the planning file. The same applies for materials that are subsequently flagged with the MRP type No MRP and are thus excluded from MRP. In such cases, you should delete the entries in the planning file.

    Procedure

    Starting from the MRP menu choose Planning ® Planning file entry ® Consistency check.

    The initial screen for checking consistency now appears.

    By using a selection variant, you can either plan the consistency check of the planning file entries to take place at a later date or you can start the process immediately.

    Once the consistency check has started, the system checks each entry for the following information:

    Does the material still exist, that is, does a material master record still exist for the material?

    Is material requirements planning activated for the plant?

    Does the material have a valid MRP type in the material master?

    Does the low-level code still match the one in the material master?

    Result

    If one of these criteria no longer applies, the respective entry is deleted from the planning file.

    If the low-level code no longer corresponds to the one in the material master record, the entry is deleted from the planning file and a new one is created with the current low-level code.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 01, 2007 at 05:40 AM

    there is a work around - though may not be the right approach for you as you have some 35000 material codes. For fewer materials, we may do it like this :

    1. use txn se16n

    2. table ekpo

    3. for field EBELN, choose option as "less than or equal to" and put value zero in "Fr.Value" field.

    4. for field BANFN, choose option as "less than or equal to" and put value zero in "Fr.Value" field.

    5. for field MATNR, input the list of material codes.

    6. Execute

    you can customise the output also. Hope it helps.

    Regards,

    Rajiv..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2007 at 03:36 PM

    Hi Suresh,

    This is a small and very easy requirement for an ABAP developer.

    Ask to check all materials in MARC with field MARC-DISMM eq "ND'.

    Then go and check EKPO and EBAN tables looking for the material.

    If not found in EKPO and EBAN, then list them in a report.

    Run it in batch mode to avoid problems with performance.

    Monica Araoz.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2007 at 08:06 AM

    Dear

    You can check if a matl is ND or ot via

    SE16 - Use Table MARC

    Import whole list of Matls &

    give condition of Procurement Type as ND in input field

    Regarding whether that matl is used or not i dont know

    To know whether is stock for the matls u can use MC.B or MC.9 Wherein u can import the list of matls

    Even MB5L can be used.

    Hope this helps

    To check if PO is created or not u can check EKPO table as already someone has suggested.

    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.