Skip to Content
Technical Articles
Author's profile photo Gayathri Venugopal

From Database how to fetch the configuration values of Variant Configuration

Generally we use function modules like VC_I_GET_CONFIGURATION_IBASE to get the values of

configuration of order/quote. But this will not always work as these functions are not released yet (or)

in case if we need to create a SAP query joining the database table or if we are working on

improving the performance of the report  where in we are asked by the quality team to use the table instead of functions.

 

This Blog post would be helpful for writing SAP queries or for performance optimization in fetching configuration values in Variant Configuration using database.

Here I have shown the link of tables involved in storing the configuration values and how to fetch it.

Step1:

Get the configuration values using table links using SAP tables:

Input: Sales order number and item number

Pass the Sales order number to VBELN and Item to POSNR and get the field CUOBJ(Internal number) from the table VBAP as below.

No alt text provided for this image

Step 2 :

Input : CUOBJ(internal number) from step 1

Pass CUOBJ to INSTANCE field in table IBIN and get the IN_RECNO(record number) as output as shown below.

No alt text provided for this image
Step 3:
Input: IN_RECNO(record number) fetched in step 2
Get the SYMBOL_ID from IBINVALUES table as shown below,
No alt text provided for this image
Step 4 :

Input: SYMBOL_ID from Step 3

Pass SYMBOL_ID and get the fields ATINN(Characteristics internal number), ATWRT(characteristics value) from table IBSYMBOL as below.

No alt text provided for this image
Step 5:

Input: ATINN( Characteristics Internal Number ) from Step 4

Pass ATINN and get the ATNAM (characteristics Name) from table CABN as below,

No alt text provided for this image

Step 6:

Input: ATINN( Characteristics Internal Number ) from Step 5

Pass the ATINN and get the characteristics description from table CABNT as below,

No alt text provided for this image
Step 7:
Input: ATINN( Characteristics Internal Number ) from Step 6

By passing ATINN get the characteristics value description from table CAWNT as below,

No alt text provided for this image

 

Following the above steps you will get all the configuration values of the sales order with characteristics description along with characteristics value description without using any Function Modules.

Wherever you think you cannot use the function module you can use these database links to fetch the configuration values .

Hope this blog post helps!! and write out to me in comments section for any queries / doubts or any Variant configuration related issues. Please do share your feedback to me .

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ramesh Babu Modem Venkata
      Ramesh Babu Modem Venkata

      Super Gayathri, It is very useful

      Author's profile photo Sivashankar B
      Sivashankar B

      Thank you Gayathri for explaining in simple steps.

      Author's profile photo Xiaoguang Li
      Xiaoguang Li

      VBAP-CUOBJ
      VBAP-CUOBJ=IBIN-INSTANCE
      IBIN-IN_RECNO=V_IBIN_SYVAL-IN_RECNO
      V_IBIN_SYVAL-SYMBOL_ID、
      V_IBIN_SYVAL-ATINN、
      V_IBIN_SYVAL-ATWRT