IN seltab

[Former Member]

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!

[Former Member]

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

[Former Member]

HI,

Create RANGEtable for seriegem.

U will get it.

Kishore.

[Former Member]

concatenate seriegem-low '%' into lv_value

SELECT SINGLE * INTO lr_bsid

FROM bsid

WHERE xblnr(2) like lv_value.

Regards,

Ravi

[Former Member]

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.

[alex_m]

May be u try this.

SELECT SINGLE * INTO lr_bsid

FROM bsid

WHERE xblnr like lv_value%.

[Former Member]

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

[Former Member]

Thanks!!