material classification table

[Former Member]

which table can i use to view the classification and characteristic of a material.

have tried MARA/MARC but was not successful, so is there any table in SAP that i can enter the material number to find out all it's classification and characteristic?

thanks.

[Former Member · Accepted solution]

Hi

The classification information is found in tables :

- cabn

- cabnt

- cwant

- klah

- cwan

To know the classification values go to MM03 transaction

In that, choose classification tab, then you can get the values according to the product.

The characteristics are stored in table CABN

In table AUSP you find the CHAR type values of the characteristic.

While the numeric type values of a characteristic are stored in table CAWN

Regards

Anand

[kesavadas_thekkillath]

Hi ,

The easiest way is get the object number of material from mara.

Pass it to KSSK. get the class & class type from KSSK.

Then pass this values to function module CLAF_CLASSIFICATION_OF_OBJECTS.

or

You can also just pass the material to parameter object and class type to parameter CLASSTYPE to function CLAF_CLASSIFICATION_OF_OBJECTS in se37 and just execute it. This function must be handled correctly in the programs because it causes performance issues( Not only this function , when accessing from tables also creates the same performance issue ).

[Former Member]

remove

[Former Member]

seems like there is no available table where i can retrieve the classification/characteristic using material number?

[former_member533946]

Hi dear,

You can also use below program to fetch class and characteristic of a material.

[To get material class and characteristics|http://wiki.sdn.sap.com/wiki/display/Snippets/FetchmaterialClassificationsandcharacteristics]

[Former Member]

hi deepak,

the report to fetch material classification and characteristic was interesting,

but do you know of any program that we can use to mass materials update of classification and characteristic as well?

thank you.

[Former Member]

Tables are AUSP, INOB, KSML

KSSK