Friends,

Many times i come across post asking information on how to fetch data for characterstic value out of configurable material froma sales order item, material variant, or all characterstic values for a 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,

Material BIKE

/wp-content/uploads/2014/07/snap17_502275.jpg

Classification View

Snap18.jpg

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

/wp-content/uploads/2014/07/snap19_502286.png

INOB – CUOBJ = KSSK – OBJEK

KSSK input OBJEK and get CLINT, ADZHL, and ZAEHL

/wp-content/uploads/2014/07/snap20_502287.jpg

Go to KLAH, Input CLINT captured from KSSK

/wp-content/uploads/2014/07/snap21_502288.jpg

Go To SWOR, input CLINT from KSSK

/wp-content/uploads/2014/07/snap22_502292.jpg

To get characteristic associated with class

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

/wp-content/uploads/2014/07/snap23_502293.jpg

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

/wp-content/uploads/2014/07/snap24_502294.jpg

/wp-content/uploads/2014/07/snap25_502295.jpg

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

/wp-content/uploads/2014/07/snap26_502296.jpg

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

/wp-content/uploads/2014/07/snap27_502297.jpg

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

Go To AUSP, input OBJEK which is CUOBJ from INOB

/wp-content/uploads/2014/07/snap28_502301.jpg

Important note http://service.sap.com/sap/support/notes/1547034

Hope this information  will be useful, Please do comment and rate this document.

Best Regards

Ritesh

References:

all Screens are captured from SAP IDES ( SAP ECC 6.0, release 7.8.01.014 ) , all master data is created by me

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply