cancel
Showing results for 
Search instead for 
Did you mean: 

material classification table

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (4)

Answers (4)

kesavadas_thekkillath
Active Contributor
0 Kudos

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
0 Kudos

remove

Former Member
0 Kudos

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

former_member533946
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

Tables are AUSP, INOB, KSML

KSSK