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