Automatic determination of a characteristic based on another characteristic value

[ngiannopoulos]

Good afternoon.

I have a Variant Configuration case when i need to determine the value of one characteristic based on what the value of a second characteristic is. So, i have characteristics ZFILLING and ZFILLING_MAT, and what i want is when i choose a specific value on ZFILLING to have a specific value displayed on ZFILLING_MAT.

We produce batteries. ZFILLING denotes if our battery will be filled with electrolyte or not and ZFILLING_MAT denotes the specific electrolyte which should be used in each case. ZFILLING_MAT depends on the SAP material number itself and the type of cells that male up the battery, therefore i have created a variant table where I have maintained Material Number, Cell_type and ZFILLING_MAT.

What i need is when the user chooses ZFILLING=YES, that the system checks on the variant table and brings back the respective electrolyte material number. Therefore, i assume i need

(a) to create battery material number and Cell Type as characteristics within the class (ie ZMATERIAL and ZCELL), and

(b) write a procedure that when the user chooses ZFILLING=YES, then the system determines the ZFILLING_MAT. I assume that procedure is like

000010 TABLE ZFILL(

000020 ZMATERIAL = ZMATERIAL,

000030 ZCELL = ZCELL,

000040ZFILLING_MAT = $SELF.ZFILLING_MAT )

but i do not know how to trigger this procedure only when the user chooses ZFILLING = YES

And, one more question: is it necessary to create battery material number as characteristic within the class? Can it be done otherwise?

Every help is highly appreciated.

Best personal regards,

Nikos

[ngiannopoulos · Accepted solution]

Solved by using a variant table

[former_member424533]

SOLUTION 1:

TABLE ZFILL(

ZMATERIAL = ZMATERIAL,

ZCELL = ZCELL,

ZFILLING_MAT = $SELF.ZFILLING_MAT )

IF

(SPECIFIED $SELF.ZFILLING AND $SELF.ZFILLING='YES')

SOLUTION 2:

$SELF.ZFILLING_MAT = ' xyx'

IF

(SPECIFIED $SELF.ZFILLING AND $SELF.ZFILLING='YES')

**********

You dont need to create cell type and material number if just some value to populated

in zfilling mat

.. please try this, if now let me know

[Mahendran8888]

ok. Selecting zfilling to yes will add one more material - Electrolyte will be added in the order if you have above mentioned OD rule.

What you are trying to do is you want to have another characteristics which will have one value that need to be shown, extra logic you want to have. This is fine. I have shared what we can do easily by applying simple OD rule.

if you are having high volume of choices or option then you can go with varaint table.

[Mahendran8888]

Zfilling can have two values 1) Fill electrolyte and 2) No fill. It is just an idea. When you are writing the OD rule in BOM for electrolyte material, ZFILLING = 'Fill Electrolyte' in the particular material.

[Mahendran8888]

Still if you are not understand tell where specifically you are not understanding or give your questions.

[Mahendran8888]

Hi,

Once you create Selection OD rule in electrolyte if Zfilling is Yes, then Choose the material number if it is a single material in the option.

Electrolyte - 'n' Unit , OD rule is $self.zfilling = 'YES', If you have the line in the electrolyte material, SAP picks the material. like how you are linking with zfilling_mat using OD rule. Same way.

And also you assumption is like once Zfilling is Yes obviously electrolyte will be selected.

Regards

Mahe

[Mahendran8888]

Above thing will work only one material and if you don't have anyother choices. If you are having n number of catalytes then variant table is best as you said.

[ngiannopoulos]

Hello again

Sorry but I do not understand your answer...

Can you please elaborate?

Best personal regards

Nikos

[Mahendran8888]

Hi,

I have a question. If you are using single material, and if ZFILLING is YES, You dont need to create ZFILLING_MAT. We can use the ZFILLING - YES,electrolyte Required and not required. This is enough and we dont need extra one.

And if you want to use material number you have to create reference characteristics that will enable the ZFILLING_MAT and CELL too.

You are correct with the table like if user chose material number and cell.

What is your configurable material? Is it battery. IF it is so, You have to create material number that is known configurable material.

Or if you are having variant frequently used by the sales team, you have to create the material variant.

Regards

Mahe

[ngiannopoulos]

Hello

If I do not use ZFILLING_MAT, how I will know the electrolyte matnr so I use it in BOMs?

Best regards

Nikos