material codes- no transactions

[Former Member]

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!

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

sir,

i want those material for which MRP is ND-no planning items.

[Former Member]

If you want to check the materials that have "ND" then this can be done using SE16 or even MD06. However I am a little puzzled about all the reports that are being suggested. If the materials are set up for planning then all you neeed to do is run your MRP list-MD06 and see what needs to be done.

[Former Member]

dear,

my requirement is to have the list of item codes which is not been used at all

no opr and no po perhaps no stock.

codes created but not used at all