Skip to Content
author's profile photo Former Member
Former Member

What SAP table houses the Material Classification values?

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!

Add a comment
10|10000 characters needed characters exceeded

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

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2008 at 03:49 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 25, 2008 at 03:18 PM

    Go to table AUSP.

    AUSP-OBJEK = material number

    AUSP-KLART = class type

    AUSP-ATINN = classification type from CABN table

    AUSP-ATWRT = classification value

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 25, 2008 at 03:18 PM

    You will find the values in AUSP...

    Search with the corresponding ATINN from CABN.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 15, 2016 at 07:28 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2008 at 12:58 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 13, 2016 at 06:31 PM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.