Skip to Content
Technical Articles
Author's profile photo Ritesh Dube

Configuration information flow with an example mode

Friends,

Many times I come across post asking information on how to fetch data for characteristic value out of configurable material from a sales order item, material variant, or all characteristic 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 example from material master, how all classes, characteristic & there respective values can be fetched step by step.

Based upon 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

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Navaneetha Krishnan
      Navaneetha Krishnan

      Hi,

      This is simple, crisp and much helpful.

      Thanks for this article.

      Navaneetha

      Author's profile photo Ritesh Dube
      Ritesh Dube
      Blog Post Author

      Thanks Navaneetha.

      Author's profile photo venu gopal
      venu gopal

      Hi .. very good document

      Author's profile photo Ritesh Dube
      Ritesh Dube
      Blog Post Author

      Thanks venu gopal.

      Author's profile photo Md. Ali Akbar
      Md. Ali Akbar

      very helpful ...

      Author's profile photo Rakesh M Choudhary
      Rakesh M Choudhary

      Very Helpful document. Appreciate it.

      Author's profile photo Gopal Ramlal
      Gopal Ramlal

      Great  document, so much information , thanks for sharing it.