What SAP table houses the Material Classification values?

[Former Member]

I cannot for the life of me figure out what SAP table actually stores the material classification characteristic values. These are the related tables I have found so far but none of them link the information to a material number:

TABLE: CABN

ATINN (characteristic ID)

ATNAM (characteristic name code)

MSEHI (UoM associated with characteristic)

TABLE: CABNT

ATINN (characteristic ID)

ATBEZ (characteristic full name)

TABLE: KLAH

KLART (class type)

CLASS (class name code)

CLINT (class id)

TABLE: KLAT

CLINT (class id)

TXTBZ (class full name)

TABLE: KSML

CLINT (class id)

IMERK (characteristic id)

POSNR (characteristic positional location for class)

TABLE: CAWN

ATINN (internal char.)

ATZHL (int counter)

ATWRT (char. value)

TABLE: CAWNT

ATINN (internal char.)

ATZHL (int counter)

ATWTB (description)

I have also identified these structures, but I am no good at finding where values from a structure actually reside.

STRUCT: RMCBC "I/O field for include screens from classification"

contains MATNR, KLART, CLASS, KLTXT, ATWRT

STRUCT: RMCLF "Classification I/O structure for Assgmt of Object to Class"

contains KLART, CLASS, KLTXT

Can anyone please help me and advise where the actual relationship between material number and classification information is? I'm trying to import this information from MDM to R/3 but I have no idea what to map it to or what Idoc segment to use.

Thanks!

[Former Member]

You will find the values in AUSP...

Search with the corresponding ATINN from CABN.

[Former Member]

You can also user BAPI 'BAPI_OBJCL_GETDETAIL' to read classification for a material.

[former_member212653]

Go to table AUSP.

AUSP-OBJEK = material number

AUSP-KLART = class type

AUSP-ATINN = classification type from CABN table

AUSP-ATWRT = classification value

[Former Member]

OBJEK does not appear to match MATNR from the MARA table. The numbers look similar but do not match.

Edited by: Ryan Hall on Jun 25, 2008 5:31 PM

[Former Member]

Normally they match.

But not every material has got characteristics.

And other objects (e.g contracts etc.) can also have characteristics.

So not every OBJEK is a material.

[Former Member]

Hello Ryan,

check txn CUTABLEINFO, see if it helps U?

I really doubt existence of a single table for material classification values?

Rgds,

Raghu.

[Former Member]

All characteristic values (for various objects) are stored in AUSP.

[Former Member]

Is there a table that maps OBJEK to MATNR?

I went in to MM02 and changed the characteristic value of material (MATNR) 268949 to 9.9997 in. I then searched table AUSP for that 9.9997 value and it came up with OBJEK 134649.

[Former Member]

INOB table contains the link between the Material, Class type and internal object number(CUOBJ).

Use the CUOBJ and hit the KSSK table and find the Internal class number(CLINT).

Now hit the KSML using the CLINT. IMERK filed contains the internal characteristic.

Now hit the CAWNT table to get the Characteristic value. use the above founf Internal Characteristic to get value in WHERE clause of CAWNT..

Regards,

Kiran Bobbala

[Former Member]

Hmmm...we don't appear to be populating the MATNR field in the INOB table.

[Former Member]

Refer the field OBJEK for the Material number not the MATNR.

Regards,

Kiran Bobbala

[Former Member]

But as I said above our OBJEK and MATNR values do not match. I need to find the relation between the two. When I am updating the characteristic values in transaction MM02 on material (MATNR) 268949, I am really updating OBJEK 134649. The only way I could find that relationship was by searching for an obsecure characteristic value that I created.

[Former Member]

Kiran is correct in stating the the INOB table contains the Link you are looking for. The field OBTAB = 'MARA'. The field OBJEK is your Material Number. Remember that the field MARA-MATNR is 18 characters, thus if you have numbers for your part number, the leading zeros are required in the OBJEK field.

[Former Member]

I think I got it now. I was testing this out in our Dev client and we don't appear to be populating some of the values there. I checked in Production and this all seems to link up now. Thank you all very much. Points have been awards.

[Former Member]

This thread is not answered.. INOB table is completely useless in this case.. meaning we DONOT populate the field MATNR from INOB, there is no way to connect MATNR to OBJEK. The field INOB- MATNR is always remains blank for Class type 001. (don't know why!)... Field OBTAB is of no use here...

[laszlohonig]

Have a go with below table joint in SQVI or SQ01:

KSSK (Allocation Table: Object to Class), joint together with KLAH (Class Header Data).

Link will be field CLINT.

Choose the below from KSSK:

Key of object to be classified - KSSK-OBJEK: you will enter the material number here. Watch out - you have to add 10 leading zeros before your material number, eg. number 40524281 will be altered to 000000000040524281.

Class Type - KSSK-KLART: here you can specify the class type which is 001 for material master.

Choose the below from KLAH:

Class number - KLAH-CLASS: this field will return the class number you assigned to your material in Classification view.

HTH,

Laszlo

[laszlohonig]

Issue might have been solved and long forgotten and hope it's been, but if not, or for anyone else's sake suffering with the same, check my method posted just now in response to Prashant Patil, using KSSK-KLAH.

[Former Member]

When browsing table INOB, I have no entries in this table at all!

Is this normal?

What other method can I use to connect MATNR with characteristics?

[former_member186413]

why don't try to use IBIN IBINVALUES IBSYMBOL?!

[eduardo_borgesbarbosa2]

by ABAP code is necessary to convert the class using the FM "CONVERSION_EXIT_ATINN_INPUT", then with the result filter in AUSP.

[former_member467662]

This message was moderated.

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