List of materials with specific characteristic value

[Former Member]

Hi,

how can I obtain a list of the materials that have a specific value of a characteristic? I think that maybe I'd use table AUSP, INOB, MARA, but I don't know how...

Thanks

[Former Member]

To obtain a list of materials with a specific value, you can make a batch search.

This is done by using the T codes CL30N,CL6BN

If that is not enough, then request a programmer to create a program for you where these BADI's can be useful:

• BAPI_CLASS_SELECT_OBJECTS to get the objects for a class
• And for the characteristics, by using BAPI_CLASS_GET_CHARACTERISTICS.
• Check also FM CLFM_SELECT_AUSP

BR\Erik

[former_member197616]

Hi,

Check the T codes CL30N,CL6BN .Thease would be helpful.

Regards,

[Former Member]

Check the report BMBC , it may help you

[Former Member]

You can create SQVI query by joining these tables and get the result as you want.

[JL23]

your question is not specific enough. from the listing of the tables it could be understood that you are an ABAPer and need to create a report.

If that is the case then just use those 3 table names in the search field on top right, you can get about 99 disussions and wikis where this is already explained.

It is standard functionality in F4 search help to find materials by characteristic values, which is CL30N as extra transaction

[Former Member]

I'm not an ABAPer. I'd like to know if there's a standard and massive method to know which materials have a specific value in a characteristic (for example the colour "Black"). I've mentioned that tables because in other discussion I've found them referred to similar problems, but I've not found the perfect answer for mine

[JL23]

Color is probably the characteristic, "Black" its value

A characteristic is not directly assigned to a material.

A characteristic is assigned to a class, and the class to the material.

The report can be called with CL30N transaction, But here you have to start with the class, in the next screen you see all characteristics of the chosen class and you enter your black and you start the search by clicking "search in initial class" button

It will list all material in the window on the right.

To know the class, you can goto CT04 enter your characteristic , hit enter, and ithen chose from environment the Where-used list