Dump with FM HR_employee_search

[nitu_kumari2]

For the Function module HR_EMPLOYEE_SEARCH , we get ABAP dump when we enter names with ‘, example O'BRIEN.

Kindly suggest the resolution.

Runtime Errors         SAPSQL_WHERE_PARENTHESES

Exception              CX_SY_DYNAMIC_OSQL_SYNTAX

[Former Member]

Hi Nitu ,

The error is coming from the following statement in the FM:

SELECT PERNR INTO TABLE I_PERNR

                  FROM PA0002 WHERE BEGDA LE SEARCH_DATE

                                AND ENDDA GE SEARCH_DATE

                                AND (WHERE_TAB).

Here WHERE_TAB will have value - VNAMC LIKE 'O'BRIEN'.
This is a wrong declaraton of SQL statement , so it is giving you a dump.
Could you check in PA0002 table , how the fields VNAMC or NCHMC maintained?

BR.
GIRI

[nitu_kumari2]

Hi Giri,

I have checked in PA0002 table,

The entries are as below.

NCHMC    O'BRIEN

VNAMC    AARON

Regards,

Nitu

[nabheetscn]

You will have to pass in this case  O''BRIEN as two single quote reporesent one single quote

[Former Member]

Hi Nitu ,

Refer Note 118253.

BR.
Giri