Material list having a given value of a given characteristic in SAP

[former_member473962]

I want to find the list of material numbers which have a particuar value of a given characteristic.

eg:- If my char is A and its value is B, then all the material nos. which have the value of its characteristic A maintained as B.

I know the following tables but unable to download the required list:

CABN                    Characteristics ( o.a. batch/vendor)    

CABNT                    Characteristics description

CAWN                    Characteristics  ( o.a. material)

CAWNT               Characteristics description

AUSP                    Characteristic Values

Class types and objects :

TCLAO                 Several class types for object

TCLA                    Class types ( vb. lfa1 => v10 en 010)

TCLAT                  Class type text

Klah

     INOB                    Link between Internal Number and Object

     KLAH                     Class header data  

     KSSK                    Allocation Table: Object (vb.matnr) to Class 

     KSML                    Characteristics for a class (internal number)

Please guide me as I need this list pretty urgently.

Thanks

PR

[Former Member]

No need to go that techy.

You can use Transaction CL30n. You have to run it by Class and Class Type. it will give you all Materials with the given Characteristic values.

There may be other transactions that can give you what you need as well.

And please don't say you need it urgently. I hate when people say they need it urgently.