topic Re: IN seltab in Application Development and Automation Discussions

IN seltab

Former Member — Wed, 28 Feb 2007 11:40:02 GMT

Hello,

I have a seltab of a type with two characters, and I need to select documents from bsid where the two first positions of the xblnr are in the seltab.

SELECT SINGLE * INTO lr_bsid

FROM bsid

WHERE xblnr(2) IN seriegem.

How can I do this?

Thanks in advance!

Re: IN seltab

Former Member — Wed, 28 Feb 2007 11:44:51 GMT

HI,

Create RANGEtable for seriegem.

U will get it.

Kishore.

Re: IN seltab

Former Member — Wed, 28 Feb 2007 11:47:19 GMT

concatenate seriegem-low '%' into lv_value

SELECT SINGLE * INTO lr_bsid

FROM bsid

WHERE xblnr(2) like lv_value.

Regards,

Ravi

Re: IN seltab

Former Member — Wed, 28 Feb 2007 11:47:21 GMT

Try this..
say ur first 2 characters are CH

loop at seriegem.
  seriegem-sign = 'I'.
  seriegem-option = 'CP'.
  seriegem-low = 'CH*'.
  seriegem-high = ''.
  append seriegem.
  clear seriegem.
endloop.

SELECT SINGLE * INTO lr_bsid
FROM bsid
WHERE xblnr IN seriegem.

Re: IN seltab

alex_m — Wed, 28 Feb 2007 11:49:42 GMT

May be u try this.

SELECT SINGLE * INTO lr_bsid

FROM bsid

WHERE xblnr like lv_value%.

Re: IN seltab

Former Member — Wed, 28 Feb 2007 11:50:53 GMT

Hi,

Using ranges you can achieve this

loop at seriegem into wa_seriegem.
    wa_xblnr_r-sign   = 'IN.
    wa_xblnr_r-option = 'CP'.
    concatenate wa_seriegem '%' into wa_xblnr_r-low.
    APPEND wa_xblnr_r TO r_xblnr.
endloop.

SELECT SINGLE * INTO lr_bsid
FROM bsid
WHERE xblnr IN r_xblnr

Regards

Bhupal Reddy

Re: IN seltab

Former Member — Wed, 28 Feb 2007 12:42:14 GMT

Thanks!!