Skip to Content
0
Nov 27, 2009 at 10:12 PM

SELECT command using String

35 Views

Hi

How can I do to select data using string with range:

srch_strA = notcr-low.
srch_strb = notcr-high.

* Building selection
IF srch_strA IS NOT INITIAL AND srch_strB IS INITIAL.
  CONCATENATE '%' srch_strA '%' INTO srch_strA.

*document header
  SELECT bukrs belnr gjahr bktxt bldat xblnr 
    FROM bkpf INTO CORRESPONDING FIELDS OF TABLE it_bkpf
    WHERE bukrs EQ p_bukrs AND
          belnr IN belnr AND
          gjahr EQ p_gjahr
          AND xblnr IN xblnr
          AND BKTXT LIKE srch_strA.

ENDIF.

IF srch_strA NE '' AND srch_strB NE ''.
  CONCATENATE '*' srch_strA '*' INTO srch_strA.
  CONCATENATE '*' srch_strB '*' INTO srch_strB.

  ti_nc-sign    =  'I'.
  ti_nc-option  =  'BT'.
  ti_nc-low     =  srch_strA.
  ti_nc-high    =  srch_strB.
  append ti_nc. clear ti_nc.

*document header
  SELECT bukrs belnr gjahr bktxt bldat xblnr 
  FROM bkpf INTO CORRESPONDING FIELDS OF TABLE it_bkpf
    WHERE bukrs EQ p_bukrs AND
          belnr IN belnr AND
          gjahr EQ p_gjahr
          AND xblnr IN xblnr
          AND BKTXT IN ti_nc.

  ENDIF.

Thanks in advance.

Moderator message - Please use code tags around your code

Edited by: Rob Burbank on Nov 27, 2009 5:26 PM