Variant Configuration tables

[Former Member]

Hello gurus,

Do you know in which tables/data elements relating to sales order line-item the system stores the characteristic values assigned?

TIA

Adark

[Former Member · Accepted solution]

Hello Meny,

Easiest is to use transaction CUTABLEINFO. You can enter sales order and Item number and all  the configuration related tables will be exploded. Characteristic values are stored in table IBSYMBOL and IBINVALUES. All configurable items are stored with instance number. You will find the instance number and the symbol id in table IBSYMBOL and you can IBINVALUES with that symbolid..

Hope that helps

Regards

Amber

[Former Member · Accepted solution]

Hi Amber,

I have a question related to this. Let me explain my question a little bit....

Say...I have a sales order item with the value assigned like the screenshot. There are 4 characteristics:

1. Color and Box length are manual assigned.

2. "Requested delivery date" is a characteristic referenced to VBAK-VDATU.

3. The value of "Frozen date" is calcuated by a procedure-type dependency assined to the configuration profile.

Now, I want to get the value of "Frozen date" and come up with a report. I've tried several function modules, like "VELO01_GET_CONFIGURATION" and "CUCB_GET_CONFIGURATION". I've also tried CUTABLEINFO. All I can get is the value of "Color" and "Box length", like the screenshot below:

Could you please help me out of here and guide me how I can get the value of "Frozen Date"?

Thank you!

Regards,

Felix

[sjeevan · Accepted solution]

Try the FM: BAPISDORDER_GETDETAILEDLIST make import field CONFIGURE = X and enter the sales order number and check the output table ORDER_CFGS_CUVALS_OUT.

Also check fm VC_I_GET_CONFIGURATION

[Former Member · Accepted solution]

Hi Jeevan Sagar,

I've tried both FM you suggested.

They can only get the maually assigned values, like the other FMs I tried.

Thanks anyway for your help...It seems very hard if I need drag the other 2 values out.

[Former Member · Accepted solution]

Hello Felix,

VC_I_GET_CONFIGURATION process the dependencies so you should get the value in this Fm. Is the value correctly stored on the database ? Do a trace via CUTRC transaction and see if the value is getting set. Do you retrieve this value from a sales order or are you trying to access it via runtime ?

[Kareem-Hany]

How to Get Material Variant Values >>

Get Material Variants from table MARC > MATNR WERKS STDPD

Get Instance from table IBINOWN > INSTANCE (COMPONENT) Object Key = MATNR+WERKS

Get Record Number from table IBST > RECORD NUMBER INSTANCE (COMPONENT)

Get SYMBOL ID from table IBINVALUES > RECORD NUMBER SYMBOL ID

Get Characteristics with Values from table IBSYMBOL > SYMBOLID CHARACTERISTICS VALUES FROM TO

Re-arrange Characteristics according to table KSML > Internal Class Number Internal Characteristics Item number

[Former Member]

Hi Meny,

We can get the Configuration Object number from VBEP-CUOBJ.

For getting the characteristic values, You may try the Function module VELO01_GET_CONFIGURATION

If you are specifically looking for the tables, you can refer to the previous post throug the link below

http://scn.sap.com/thread/984436

Thanks

Senthil

[S0008252477]

Hi Sentil, thanks for the post. Even though this is an old thread, my guess is that CUOBJ is from VBAP-CUOBJ and not VBEP.