Skip to end of metadata
Go to start of metadata

Friends, 

Many times i come across post asking information on how to fetch data for characterstic value out of configurable material from
a sales order item, material variant, or all characterstic values for an specific material etc

There are many tables which stores this relationship , and in variant configuration its not one way to fetch this information. 

I tried to list down al tables related to variant configuration in my previous post. List of Tables for VC 

Here i am trying to show linkages using a eaxmple from material master, how all classes, characterstic & there respective
values can be fetched step by step. 

Based upoon your requirement you can provide this table-field information to developer and a report can be written using this
logic.

Lets start,  I am using Material BIKE as and example here

 

Classification View

 

Table INOB, input – OBJEK = Material Number (BIKE) , get CUOBJ

 

INOB – CUOBJ = KSSK – OBJEK 

KSSK input OBJEK and get CLINT, ADZHL, and ZAEHL

 

Go to KLAH, Input CLINT captured from KSSK

  

 

Go To SWOR, input CLINT from KSSK

 

  

To get characteristic associated with class 

Go to KSML, Input CLINT and get internal characteristic number, IMERK

 

To know name of characteristic go to CABN, input IMERK or ATINN, Get ATNAM

 

 

To fetch all possible values of characteristic go to CAWN, input ATINN

 

 To fetch value description , go to CAWNT , input internal characteristic number & internal counter

  

For getting characteristic values maintained in classification view at material master level 

Go To AUSP, input OBJEK which is CUOBJ from INOB

 

Hope this information  will be useful.

 

  • No labels