topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 06 Dec 2006 10:00:04 GMT

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

Re: select statement

Former Member — Wed, 06 Dec 2006 10:01:56 GMT

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

Re: select statement

Former Member — Wed, 06 Dec 2006 10:03:13 GMT

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

Re: select statement

Former Member — Wed, 06 Dec 2006 10:04:19 GMT

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

Re: select statement

Former Member — Wed, 06 Dec 2006 10:04:42 GMT

Hi Kiran ,

bukrs in p_bukrs : 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

bukrs eq p_bukrs : This is used when you have only one value.

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

Regards

Arun

Re: select statement

Former Member — Wed, 06 Dec 2006 10:05:35 GMT

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.

Re: select statement

Former Member — Wed, 06 Dec 2006 10:15:22 GMT

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

Re: select statement

Former Member — Wed, 06 Dec 2006 10:21:30 GMT

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.

Re: select statement

Clemenss — Wed, 06 Dec 2006 11:01:07 GMT

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