Single quote in dynamic where condition

[Former Member]

BAPI_STUDENT_IDENTIFIC_ADD has a field called IDENTIFICATIONNUMBER. This field is later used in a dynamic where condition and causes a short dump when it contains a single quote. I will change the program that calls the BAPI to check for single quotes, but is there anything else I need to check for to ensure a correct where condition?

Thanks,

Dan

[Former Member]

BAPI_STUDENT_IDENTIFIC_ADD has a field called IDENTIFICATIONNUMBER. This field is later used in a dynamic where condition and causes a short dump when it contains a single quote. I will change the program that calls the BAPI to check for single quotes, but is there anything else I need to check for to ensure a correct where condition?

Thanks,

Dan

[Former Member]

Hi Dan,

You need to exclude the following characters:

CONTANTS:
  c_single_quote VALUE '''',
  c_double_quote VALUE '"',
  c_asteriks     VALUE '*'.

Regards,

Rob.

[Former Member]

Hi Dan,

The best way to ensure correctness of syntax of a dynamic where condition is:

Run the program in debugging mode, Get the Query that is generated dynamically and write it to some other ABAP program and perform syntax check.

This will help you to remove all the syntax errors.

Regards,

Darshil