topic Article / Material Classification Table in Application Development and Automation Discussions

Article / Material Classification Table

Former Member — Wed, 23 May 2007 06:21:25 GMT

Dear All,

I would like know the table name where I can know the classification assigned to articles.

All helpful answers will be rewarded.

Regards

Renjan

Former Member — Wed, 23 May 2007 06:24:12 GMT

better use the following BAPI's: for material classification

BAPI_OBJCL_GETDETAIL

BAPI_OBJCL_CHANGE

or use the fun module:

CLAF_CLASSIFICATION_OF_OBJECTS.

related Tables are

CAWN, CABN, AUSP etc.

Reward points if useful

Regards

Anji

Former Member — Wed, 23 May 2007 06:26:03 GMT

Hi,

Can u be more specific.. r u looking for the Classification view details .. like class & characteristic tables...

Thanks,

Manjunath MS

Former Member — Wed, 23 May 2007 06:30:38 GMT

Hi Manjunath,

See... We are assigning a classification to articles using the transaction CL20N...

I need to filter those articles for which this classification is not assigned. For that, I need to know to which table the data is getting saved...

Regards

Renjan

Former Member — Wed, 23 May 2007 06:33:38 GMT

Hi,

Check out these Tables KLAH,AUSP,CABN,CAWN tables.

Reward Points if it is Useful.

Thanks,

Manjunath MS

Former Member — Thu, 22 Jul 2010 19:25:23 GMT

Hi...

this code list all clases for specific materials


SELECT kssk~objek
into corresponding fields of table ITAB
from KSSK join KLAH
ON
     kssk~clint = klah~clint
where
     kssk~objek in it_matnr.

hope it works for you