topic Re: Material Classification Table in Application Development and Automation Discussions

Material Classification Table

Former Member — Wed, 30 Sep 2009 04:35:40 GMT

Hi all,

Now I have a requirement to select the "Class" specified in the classification tab of MM03 tab, I have a requirement to select the fields

MATNR - Material Number and

CLASS - Class Maintained in the Classification view of Material master view (class header table KLAH)

please give the Table name to select this fields

Regards

Nausal

Re: Material Classification Table

Former Member — Wed, 30 Sep 2009 06:37:26 GMT

Hi,

Try out:

KLAH,AUSP,CABN,CAWN tables.

Thanks,

Krishna

Re: Material Classification Table

Former Member — Wed, 30 Sep 2009 11:04:49 GMT

Hi,

MARA-MATNR

KLAH -Contains both fields KLART (Class type) and CLASS (Class number)

Tables with MATNR - MARC, MAKT, etc.

Tables with KLART - CUCO, AUSP, TCLC,etc.

You can use repository info system for finding it out.

Regards,

Revathi.

Re: Material Classification Table

Former Member — Wed, 30 Sep 2009 11:17:53 GMT

Can use se15 (repository info system) for finding it out

Regards,

Revathi

Re: Material Classification Table

Former Member — Thu, 01 Oct 2009 05:15:31 GMT

Not get any solution

Re: Material Classification Table

facundo_carmena — Tue, 28 Aug 2012 15:50:04 GMT

Hello, I now the question is really old but maybe the answer is usefull for someone else.

1) go into KLAH

complete the Class Type and/or the Class.

Here you get the Internal class number.

2) Then go to KSSK and input internal class number and the object
The object is the material or customer with the following format:

- material number (0000000000000XXXXX)

- customer number (XXXXXXXXX)

Done.

Re: Material Classification Table

former_member536533 — Thu, 31 Oct 2019 09:45:28 GMT

The below SQL works for me ,

SELECT
mara~matnr,
ausp~atwrt
FROM mara
LEFT OUTER JOIN inob ON ( inob~klart = '001' “class type
AND inob~obtab = 'MARA'
AND inob~objek = mara~matnr
)
LEFT OUTER JOIN cabn ON ( cabn~atnam = 'Z_xxxx_MATE' ) “char. value
LEFT OUTER JOIN ausp ON ( ausp~objek = inob~cuobj
AND ausp~atinn = cabn~atinn
AND ausp~klart = '001' “class type

)
INTO TABLE @DATA(itab_clas)
WHERE mara~matnr = '000000000001000xxx'.