Skip to Content
0

Not able to use IN Condition in object dependency.

May 14, 2017 at 03:08 AM

123

avatar image

Hi experts.

I would like to ask you how to use IN condition in object depencency.

There are 3 characteristcs A,B,C.

I would like to make C visible when the following conditions are satisfied.

1. any value is assigned to A

2. value '1' or '2' is assigned to B

(there are other choice to be assigned to this characteristic)

In this case I wrote the formula in the editor as below.

--------------------------------

B in ('1' , '2')

AND SPECIFIED A AND SPECIFIED B.

--------------------------------

However an error occuered.

I referred to the page below.

https://help.sap.com/doc/saphelp_crm700_ehp02/7.0.2/en-US/46/423712f3be08e7e10000000a114a6b/frameset.htm

Where do I have to amend ?

Or should I use OR rather than IN ?

Best regards.

Takeshi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
flavio ciotola May 15, 2017 at 08:28 AM
0

Hi Takeshi,

Could you please share which is the error that occurs?

And, which is the data type for characteristic B?

If it is NUM (Numeric format), then the code shall better be:

B IN (1, 2) AND SPECIFIED A AND SPECIFIED B

Thank you and bye,

Flavio

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi flavio.

Thank you for your reply.

The error messages are below.

------------------------------------------

E28075 Character string required in inverted commas
E28050 Characteristic is multiple value B
E28091 Error in standard dependency: TYPE_OF
E28037 Logical expression required
E28023 Error in syntax check for simple condition

------------------------------------------

And the data type of the characteristic B is Char.

I'm afraid that I can't use IN condition with a kind of characteristics which multiple values can be set ?

Thank you and best regards.

Takeshi.

0

Hi Takeshi,

Yes, you are right: in case of a multiple value characteristic, IN cannot be used. As you said in the previous post, use OR instead.

That is, code shall look like the following:

(B = '1' OR B = '2') AND SPECIFIED A AND SPECIFIED B

Hope this could help.

Thank you and best regards,

Flavio

0

Hi flavio.

I am sorry I could not notice your post.

Thank you for your amended code, I will use this instead of the one which includes IN in it.

I appreciate your help.

Thank you.

Best regards.

Takeshi

0