Get variantclass from KMAT in report

[Former Member]

Hello Community,

I want to program a "F4-valuelist-function" in my zreport where the user can find

all dependent characteristics from the variantclass (type 300) of the

KMAT. The KMAT is the select-option in my report. So the program

should find the right class and then use a bapi to list all characteristics,

so the user could choose the chosen characteristic for his request.

I can't find the association between KMAT (MARA) and CLASS in SAP.

Can anybody guide me?

Thanks

Markus Pawlinka

[Former Member · Accepted solution]

Hello Markus,

For a KMAT , you can get the link via the following tables and fields

Enter materials number as OBJEK in table INOB. From that you can get CUOBJ.

With that CUOBJ , please check table KSSK. Enter KSSK-OBJEK as INOB-CUOBJ.

You will get CLINT from table KSSK. Which is the class ID.You can the access the characteristics from table KSML.Please be carefull with overwritten characteristics.

As for the object values , you can simply use BAPI BAPI_OBJCL_GETDETAIL_KEY or BAPI_OBJCL_GETDETAIL.

Also please review note 1547034 - How are characteristic values updated in table AUSP?

It has detailed information on how the characteristics are saved,

Thanks

Amber

[Former Member]

Hello Amber, hello Tamas,

thanks a lot for your hints.

I'll check your approaches and report my solution.

Best regards

Markus

[former_member214775]

Hi Marcus,

please check these tables:

KSSK - class assignment

KSSK_INOB - INOB_OBJEK for the class

KLAH - class header (CLINT = INOB_OBJEK from the previous table, KLART = class type, CLASS = class name)

Best regards

Tamas