topic Re: Regarding Select Statement in Application Development and Automation Discussions

Regarding Select Statement

Former Member — Wed, 22 Aug 2007 14:12:40 GMT

Hi Experts,

I have two feilds where these two feilds will be populated in runtime of my program

let the two feilds be BUKRS1 and BUKRS2 .I want to retrive the company codes in between these two and including those also. How do i write the select condition.

[I need the values in between BUKRS1 and BUKRS2 and including thoso also.]

Re: Regarding Select Statement

Former Member — Wed, 22 Aug 2007 14:14:24 GMT

set up a range.

ranges: r_bukrs for vbrk-bukrs.

r_bukrs-option = 'BT'.

r_bukrs-sign = 'I'.

r_bukrs-low = bukrs1.

r_bukrs-high = bukrs2.

append r_bukrs

then use this range on the select statement.

Re: Regarding Select Statement

Former Member — Wed, 22 Aug 2007 14:20:27 GMT

Hi,

Try this ..

SELECT ... WHERE F1 BETWEEN P1 AND P2.

F1 - DATABASE TABLE FIELD

P1 & P2 - ARE PARAMTERS.

regards

reward all helpful answers.

Re: Regarding Select Statement

Former Member — Wed, 22 Aug 2007 14:22:45 GMT

Hi,

Try this.

Create a range and put these values in the range and use it in selectg

ranges: r_bukrs for vbrk-bukrs.

r_bukrs-option = 'I'.

r_bukrs-sign = 'BT'.

r_bukrs-low = bukrs1.

r_bukrs-high = bukrs2.

append r_bukrs.

select * from <DBTABLE> into table itab where bukrs in r_bukrs.

thanks

Mahesh

Re: Regarding Select Statement

Former Member — Wed, 22 Aug 2007 14:31:32 GMT

Hi All,

Thanks Martin, Dj and Mahesh....

I know both these answers are right and will get required results for fetching data from a range of selection criteria.

but which one of these would be better in performance point of view. I guess using range would be better,

please let me know. Thank You.

Regards

Venkat

Re: Regarding Select Statement

Former Member — Wed, 22 Aug 2007 14:44:14 GMT

Hi,

The RANGE process would be better in performance.

Always remember to APPEND your range when you fill it

Cheers,

Leeza

Re: Regarding Select Statement

Former Member — Wed, 22 Aug 2007 14:57:05 GMT

Hi Leeza,

Thanks for your reply. This is very helpful answer.

I can"t allot points as I am not the initator for this question, however I apprecaite your time and efforts.

regards

venkat