0

I have one requirement in BODS to execute ABAP dataflows with dynamic global variables. The ABAP code is a custom one with dynamic where clause. I am trying to send the global variable value like Field-name like "%underscroe%". But instead of fetching records with only 'underscore', it is fetching all records from the table.

Do you have any solution for this issue?

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
tst2016
  • 67
  • 1
  • 7

1 Answers1

0

Use ESCAPE clause for this. If you wanna search for underscore, set

LIKE '%#_%' ESCAPE '#'.

I am not sure, if it works with BODS though.

Suncatcher
  • 10,355
  • 10
  • 52
  • 90
  • Hello Suncatcher, The above code is working but I have another issue in ABAP that is if I am trying to send dynamic like clause Field-name like $variable. In the $variable I am sending '%#_%' ESCAPE '#' but it is not working, it's fetching all records. Can you please help – tst2016 Oct 30 '17 at 08:11