Skip to Content
0
Former Member
Aug 18, 2005 at 07:33 PM

BW BEx using a wildcard ("*")???

89 Views

Hello BW Gurus,

Does anyone know if it’s possible to select characteristics in BW BEx using a wildcard-like (“”) approach. For example, if you wanted to filter on 6 digit GL Accounts that start with a 3 and end with a 1 (“31”). I can seem to come up with anything. As a test I’ve tried to use the customer exit and the CMOD structure:

l_s_range-low = ‘3000001’.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

append l_s_range to e_t_range.

l_s_range-low = ‘3001001’.

l_s_range-sign = 'I'.

l_s_range-opt = 'EQ'.

append l_s_range to e_t_range.

Thinking that I could use a select statement and a loop to fill e_t_range but it appears that e_t_range only holds one record at a time (i.e. BEX errors out when I try this code).

Anyone have any ideas?