Material Classification Table

[Former Member]

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

[Former Member]

Hi,

Try out:

KLAH,AUSP,CABN,CAWN tables.

Thanks,

Krishna

[Former Member]

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.

[Former Member]

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

Regards,

Revathi

[Former Member]

Not get any solution

[facundo_carmena]

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.

[former_member536533]

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'.