select statement

[Former Member]

hi to all,

can anyone tell me in select satement where conditon

bukrs in p_bukrs

bukrs eq p_bukrs

what is the differnce betwen both

thanks in advance

kiran kumar

[Former Member]

bukrs in p_bukrs --> Used when p_bukrs is declared as Select-Options

Eg:

select-options: p_bukrs for t001-bukrs.

bukrs eq p_bukrs --> Used when p_bukrs is declared as Parameter

Eg:

parameters: p_bukrs like t001-bukrs.

Hope this helps.

Kind Regards

Eswar

[Former Member]

Hi Kiran,

When you use IN P_bukrs that means you are passing a SELECT OPTION with value range for selection.

When you use EQ P_bukrs that means you are passing a PARAMETER with Single value for selection.

Reward points if this Helps.

Manish

[Former Member]

HI,

if p_bukrs is a parameter then we use

where condition bukrs eq p_bukrs

if p_bukrs is select-option then we use

where condition bukrs in p_bukrs.

I hope u got it..

Regards,

Kumar

[Former Member]

Hi Kiran ,

<b>bukrs in p_bukrs</b> : This is used when you have range of values for bukrs , so if you have multiple values you use IN. It is basically used for SELECT-OPTIONS

<b>bukrs eq p_bukrs</b> : This is used when you have only one value.

There is also one more major difference if you use <b>in</b> and the value is blank then it is equavelent to not having that condition in the select statement , but if you use <b>eq</b>and the value is blank then it will search for records which have the value of the field as blank.

Regards

Arun

[Former Member]

Hi,

using bukrs in p_bukrs will allow u to accept multiple bukrs basically it used to use in selection option.

bukrs eq p_bukrs it will allow u only one bukrs and it used to declare as a parameter.

Cheers.

[Former Member]

bukrs in p_bukrs : This One is Used When You Will Use Select-Options stmt

bukrs eq p_bukrs : This One is Used When You Will Use Parameters stmt

[Former Member]

bukrs in p_bukrs: PICKS A RANGE OF VALUES WHICH ARE DECLARED IN SELECT-OPTIONS.(CONDITION CHECKS FOR RANGE OF VALUES).

bukrs eq p_bukrs: PICKS THE VALUE FROM PARAMETERS FIELD.

(IT TAKES SINGLE VALUE AND CHECKS THE CONDITION)

THANX.

[Clemenss]

Hi Kiran,

please study syntax of logical expressions as explained in

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3509358411d1829f0000e829fbfe/content.htm">Comparisons Between Different Data Types</a>

and

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/9f/dba88b35c111d1829f0000e829fbfe/content.htm">Selection Tables in Logical Expressions</a>

Regards,

Clemens