How to find the Class with Material Number (MATNR) or Configuration (CUOBJ)?

[floydausten]

Hi all,

I am looking for a way to find the class of a configurable (KMAT) material with class type 300, based on the material number (MATNR) or the configuration (CUOBJ). Note the the characteristics have do not yet have any values assigned in the material master.

The material number and CUOBJ are retrieved from the sales order item (table VBAP).

I have tried the following tables:

• KSSK
• INOB
• AUSP
• CABN
• KLAH

But I could not find any results for the material number or CUOBJ.

Any tips on how this can be achieved? Which tables can be linked?

Thanks in advance,

Floyd

[Lakshmipathi · Accepted solution]

How the linkage works would be

Material master (MARA/MARC) A KMAT material is flagged as configurable (MARA-KMAT = 'X'). The material is assigned to a class of type 300 in table KLAH (class header) and KSSK (object–class assignment). → For KMAT, the object number in KSSK is not the material number directly, but the internal object number (OBJEK).

Configuration object (CUOBJ) When you create a sales order with a KMAT, the system generates a configuration instance (CUOBJ in VBAP). This CUOBJ points to the instance in table INOB (object dependencies). INOB links the CUOBJ to the object number (OBJEK) used in classification.

Characteristics values (AUSP) If values are assigned, they are stored in AUSP. But since you said no values are yet assigned, you won’t see entries there.

So the linkage of tables would be

• From VBAP, take MATNR and CUOBJ.
• Use INOB with CUOBJ → get OBJEK.
• Use KSSK with OBJEK and KLART = 300 → get the class assignments.
• Use KLAH with CLASS and KLART = 300 → get the class header (name, description).
• If you need characteristics definitions, use CABN (characteristics) and CAWN (characteristic values).

[floydausten · Accepted solution]

Hi Lakschmipathi,

Thanks again for you quick response!

What you suggested, is what my ideas was as well. However, I am already stuck on the first step. Because entering CUOBJ in INOB, gives no results. Including the leading zeros makes no difference.

• Use INOB with CUOBJ → get OBJEK.

Enter value in INOB:

Result:

Any ideas why I am not getting results?

[Lakshmipathi]

Your INOB seems to be not working because of input parameters. When you want to link a material (MATNR) to its classification/configuration:

OBTAB tells you what kind of object it is. For materials, OBTAB = MARA.

OBJEK is the internal object number used in classification tables like KSSK and AUSP. This is the field you join to KSSK (with KLART = 300).

MATNR in INOB is a convenience field — it mirrors the material number when OBTAB = MARA. You can use MATNR directly if you want to search by material number. But for classification joins, you should use OBJEK.

[floydausten]

Hi Lakschmipathi,

Thank you again for your response!

I find it a bit that when I do not enter any user parameters and retrieve all entries, I don't find anything in INOB.

However, when I enter KLART = 300 and OBTAB = MARA, I do find the entries.

In the end, I managed to find results. Thank you!