cancel
Showing results for 
Search instead for 
Did you mean: 

Variant Table - No value is assigned when any one value is blank

Former Member
0 Kudos

Hi All,

We created a Variant table, where the single value CHARS are inferred to a Multi-Value CHAR called "OPTION"

For example, below are the CHARS, where Material_Number is Key.

Material_Number

Option1

Option2

Option3

A table is created called MAJOR_CODE, and a procedure is used as follows

TABLE MAJOR_CODE

MATERIAL_NUMBER = MATERIAL_NUMBER,

OPTION1 = $self.OPTION,

OPTION2 = $self.OPTION,

OPTION3 = $self.OPTION)

OPTION is a multi-value charcteristic.

Now, if there is no value for any of the Options 1,2, or 3, in the variant table, then no value is set for Multi-Value characteristic.

How to avoid this scenario, whithout giving some dummy value to all charcteristic?

Regards,

Aby

Accepted Solutions (0)

Answers (2)

Answers (2)

Rachel_Tang
Advisor
Advisor
0 Kudos

there is restrictions of using variant tables in dependency:
http://help.sap.com/erp2005_ehp_07/helpdata/en/92/58c5b3417011d189ec0000e81ddfac/content.htm?framese...

Restrictions

To process tables in dependencies:
•Only use single-value characteristics in tables
•Do not use intervals in tables
•Only enter one value per table cell (otherwise inconsistencies occur when using the Sales Configuration Engine) If you enter more than one value in a cell, you can get the system to multiply out the values by choosing Table → Standardize.

Former Member
0 Kudos

Hello Rachel,

Thanks for the reply.. But we have a business scenario, where all CHARs may not have values in the Variant Table..

So in this case, only otpion is to give some dummy value for these CHAR?

Regards,

Aby

Rachel_Tang
Advisor
Advisor
0 Kudos

Hi Aby,

To my understanding, the variant table is a place to the combinations among characteristic values, so it should have values to set up the combinations, therefore you may have to have some dummy values for the characteristics.

Regards,

Rachel

Former Member
0 Kudos

Hi Rachel,

Ok.. Thanks for the input.

I am closing this thread

Regards,

Aby

Former Member
0 Kudos

Hi All,

Any suggestions?

Regards,

Aby