Wrong material picking

[Former Member]

Hello Everyone

Material XYZ I assigned OD      Characteristic1 = '1' and

                                              Characteristic2 = '2'    

Material ABC I assigned OD    

                                               Characteristic1 =  '1' and 

                                               Characteristic2 =  '2'  and

                                               Characteristic3 =  '3'

When i checked in Cu 50 With Putting value of XYZ material

Material should be picked XYZ but both material is picking . How come it possible or  is it system consider only to charecteristic (and logic)

Please guide us . Where i am wrong

Regards

Sushant

[Former Member · Accepted solution]

Hi Ritesh

I tried but its not working both material is picking in CU50

if i write NOT SPECIFIED P13_Filler wire it gives syntex error so i write

P11_Filler wire = SS336 and

P12_Filler wire = F336  and NOT  P13_Filler wire

There is another way to solve the problem

Regards

Sushant

[Ritz · Accepted solution]

Sushant,

you need to include SPECIFED then only it work, its a build in condition and syntex always have word SPECIFIED in it.

try another way

NOT SPECIFIED P13_Filler wire  and

P11_Filler wire = SS336 and

P12_Filler wire = F336 

check the exact spacing between the words and hope it will work.

give it a try.

Thanks

Ritesh

[Former Member · Accepted solution]

Hi Ritesh

Its not working . When i using NOT SPECIFIED I got syntax error. remaining part of expression cannot be interpreted . Also i checked spacing between the  words

Regards

Sushant

[Ritz · Accepted solution]

Sushant,

its seems your dependencies are not working , please check there status .

also i have created below syntex in my sandbox n it work perfectly

000010 P11_FILLERWIRE = '01' and

000020 P12_FILLERWIRE = '01' and

000030 NOT SPECIFIED P13_FILLERWIRE

please give try .

Thanks

Ritesh

[Former Member · Accepted solution]

Hi Ritesh

Status is 1 its release .

For SPECIFIED its gives syntax error

For  NOT its working . but matl is not picked

Regards

Sushant

[Former Member · Accepted solution]

Hi Sushant,

This is strange as having NOT should not fulfill the condition. I believe somehow your OD is being fulfilled that is why the first component is picked. Please run a trace and see what does the selection condition says. You should get condition not fullfilled.. If you enter NOT  then it means the component should only be picked up if it doesnot have the value that you have mentioned in the OD. so there is something missing in the OD.

Thanks

Amber

[Ritz · Accepted solution]

its strange, i coped the exact code from my system so it should work.

also i want to know , you havent maintained ' ' for values, see the syntex i pasted value is in quote mark , but in your code the value is without quote mark.

if i remove quote mark i will get syntex error.

so please also check this , and put your values in quote marks , like

P11_Filler wire = 'SS336' and

P12_Filler wire =  'F336' and

NOT SPECIFIED P13_Filler wire

Thanks

Ritesh

[Former Member · Accepted solution]

Hi Ritesh

Sorry actually i put the value against NOT SPECIFIED P13_Filler wire that's why error is came

but as per instruction i Wright the condition as follows for filler wire 1dia

NOT  SPECIFIED P99_OPTIONS_A  AND

P15_400_TC_WELL_MATL = '316'  AND

P21_400_TC_FLG_MATL = 'F316'

for filler wire 2dia

P15_400_TC_WELL_MATL = '316'  AND

P21_400_TC_FLG_MATL = 'F316' AND

P99_OPTIONS_A = '13A'

But in CU50 when i assign the value 316 and F316 then filler wire 1 dia should be pick but both filler wire 1& 2 dia is picked . Please check the above condition

Thanx

Sushant

[Ritz · Accepted solution]

Shushat,

as i said in my previous reply , it seems your dependencies are not working, please use trace function in CU50 to confirm same.

you can also use Analysis function in CU50 to check how many dependencies are getting triggered and what values they are setting as well as what materials its picking.

as a last try use below code for dia 1

P15_400_TC_WELL_MATL = '316'  AND

P21_400_TC_FLG_MATL = 'F316' AND

NOT SPECIFIED P99_OPTIONS_A

Thanks

Ritesh

[Former Member · Accepted solution]

Hi Ritesh

I think you are right . dependencies are not working . I checked with analysis function .value assign in CU50 is shown (A) in analysis function is shown right . but both material picked

Is it system check only 2 condition ?

An other BOM also same think happened few material is permanently picking. Then what should i do ...

Please guide us

Regards

Sushant

[Ritz · Accepted solution]

Sushant,

you can

1)  write new dependencies and replace it with old one and then check.

2) please if you dont assign any value to any of the characterstic is any of both component is getting selected?

3) if every thing is fine , ask a ABAP person to debug Code and check how components are being getting selected.

Thanks

Ritesh

[Former Member · Accepted solution]

Hi Ritesh

Thanx its working

Regards

[Ritz · Accepted solution]

Thats good news.

Now pleae share what was the reason so that it will be useful for others in future.

Thanks

Ritesh

[Former Member · Accepted solution]

Hi Ritesh

1)  We removed the all $self.

2) Maintained in sequence when written the OD  which is maintained in class

3) Mostly avoid the OR condition for ex

P15_400_TC_WELL_MATL = '316'  or

P15_400_TC_WELL_MATL = '321' and

P21_400_TC_FLG_MATL = 'F316' and

P99_OPTIONS_A ='13a'

Instead of we Wright

(P15_400_TC_WELL_MATL = '316' and

P21_400_TC_FLG_MATL = 'F316' and

P99_OPTIONS_A ='13a' ) or

(

P15_400_TC_WELL_MATL = '321' and

P21_400_TC_FLG_MATL = 'F316' and

P99_OPTIONS_A ='13a')

4) Replays the old Dependency name and assign new one

All above changes done in this tread now its working

Thanx a lot

Sushant

[Ritz · Accepted solution]

Thanks Shushant for sharing changes done to solve the issue.

Regards

Ritesh

[Former Member]

Hi Rirtesh

OD1 on WIRE1 DIA

P11_Filler wire = SS336 and

P12_Filler wire = F336      

When both condition is satisfied, i  want to select the matl filler wire 1dia only

OD2 on WIRE2 DIA

P11_Filler wire = SS336 and

P12_Filler wire = F336 and

P13_Filler wire = 13a   

when above 3 conditions are satisfed , Iy want to select the matl filler wire 2 dia only not wire 1dia.

But when i assign the value SS336 and F336 both matl is picked in CU50 and also when i using the value SS336 , F336 and 13a that time also both mtl is picked . I want to only one material picked  dependent on P133_filler wire characteristic (13a)

Thanx

Sushant

[Ritz]

have you tried the syntex in my previous reply

OD1 on WIRE1 DIA

P11_Filler wire = SS336 and

P12_Filler wire = F336 and NOT SPECIFIED P13_Filler wire

try it , hope it will work for you.

Thanks

Ritesh

[Former Member]

Hi Amber

I tried but its not working both material is picking.

How to solve

Regards

Sushant

[Ritz]

Sushant,

you want both to be picked or you want only one should be picked?

please specify?

if you want dia 1 only when dai 2 is not selected , dependency for selection of dia 1 could be

P15_400_TC_WELL_MATL ='304L' OR

P15_400_TC_WELL_MATL ='304H' AND

P21_400_TC_FLG_MATL = 'F316l' AND

NOT SPECIFIED P99_OPTIONS_A

try it , hope it will work for you.

Thanks

Ritesh

[Former Member]

Hi Ritesh

Please check it

Regards

Sushant

[Ritz]

both looks fine 

in such case when you assign all three values both material should be selected.

can you do a test , first assign 2 values and check XYZ get selected and then go back and assign third value too and heck both XYZ and ABC are selected.

also use trace 0r Analysis function in CU50 it will give you idea , which dependencies are getting trigger.

Thanks

Ritesh

[Former Member]

Hi Sushant ,

Please add the following syntax in the first OD!

P15_400_TC_WELL_MATL ='304L' OR

P15_400_TC_WELL_MATL ='304H' AND

P21_400_TC_FLG_MATL = 'F316l'

AND NOT P99_OPTIONS_A = '13A'.

In that case, You first component will be selected If P15_400_TC_WELL_MATL ='304H' and P21_400_TC_FLG_MATL = 'F316l'.

and if set value 13A to characteristic  P99_OPTIONS_A along with the above  2 , then only second component will be selected.

Basically , characteristic you want to select for the second component should have NOT with the value in the selection condition of the first component.

Eg

OD1 on WIRE1 DIA

P11_Filler wire = SS336 and

P12_Filler wire = F336       

When both condition is satisfed, you want to select the matl filler wire 1dia

OD2 on WIRE2 DIA

P11_Filler wire = SS336 and

P12_Filler wire = F336 and

P13_Filler wire = 13a    

when above 3 conditions are satisfed , you only want to select the matl filler wire 2 dia not wire 1dia.

Synatx for OD1 on WIRE1 DIA should be the following :-

P11_Filler wire = SS336 and

P12_Filler wire = F336

AND  NOT P13_Filler wire = 13a.

Hope this helps.

Thanks Amber

[Former Member]

Hi Retesh

Please check the attached  OD1 & OD2

Sorry but i am not getting your point  mention what BOM positions this materials are maintained

In screen shot 3611matl selected when 2 condition meet and 3610 selected when 3 condition meet.

Regards

Sushant

[Ritz]

Sushant,

Here both are being selected as for both selection condition is being meet, if you have condition that only one should be picked you need to include that in dependency.

if you assign  1 , 2, and 3 both will be picked, if you assign only 1 and 2 only XYZ will be picked.

please let me know , what exactly distinguish this  2 material and i can help you to write the correct dependency.

THanks

Ritesh

[Former Member]

Hi Ritesh

My material is filler wire 1 dia and it should be selected when  (value1) SS336 and (value2) F336

and another material is filler wire 2dia it should be selected when penetration required  its mean  (value3) 13a( value1 & value2 also required)

During the creating sales order when i assign the value1 and value2 then  material should be picked up filler wire 1 dia but some time customer required  penetration so then sales dept  chose the value 3  and

that time only pick-up the filler wire 2 dia instead of filler wire 1 dia

As per my knowledge i wrote the selection condition

P11_Filler wire = SS336 and

P12_Filler wire = F336          when both condition is satisfy select the matl filler wire 1dia

P11_Filler wire = SS336 and

P12_Filler wire = F336 and

P13_Filler wire = 13a     when above 3 condition is satisfy select the matl filler wire 2 dia

Please suggest the how to right the correct OD

Regards

Sushant

[Ritz]

Sushant,

The dependencies looks fine and when you assign all three values both materials should be selected.

please check wheather there is come condition which says only one can be selected ?

also mention what BOM positions this materials are maintained? 

if possible , post the screen shot of dependencies.

Thanks

Ritesh