11-25-2009 2:47 PM
Hi there,
i try to use the BAPI_USER_GETLIST
if i use the following expression i get a correct resultlist with my user, firstname 'Dirk'.
ls_selection_exp-parameter = 'USERNAME'.
ls_selection_exp-option = 'EQ'.
ls_selection_exp-low = 'C512....'.
if i use the next expression the list is empty.
ls_selection_exp-parameter = 'ADDRESS'.
ls_selection_exp-field = 'FIRSTNAME'.
ls_selection_exp-option = 'EQ'.
ls_selection_exp-low = 'Dirk'.
thx for help
Dirk
11-25-2009 2:59 PM
Hello,
I check the field FIRSTNAME of structure BAPIADDR3. The field is case-sensitive.
Can you please run BAPI_USER_GET_DETAIL with your user-id ''C512...." & check what is the value in ADDRESS-FIRSTNAME?
Put the same value in BAPI_USER_GETLIST & recheck.
BR,
Suhas
11-25-2009 3:12 PM
Hi Suhas,
thx u gave me the straight tip, with search parameter 'DIRK' it works.
confusing is that the bapi returns 'Dirk'
thx a lot
Dirk
11-25-2009 3:39 PM
I got the catch.
If you check the code for BAPI_USER_GETLIST, you will find that when you use ADDRESS-FIRSTNAME combination, it fetches the data from the DB view USER_ADDRS based on field MC_NAMEFIR. But the underlying domain is not case-sensitive may be this is cause.
I check the dynamic WHERE clause, something like this is generated:
USER_ADDRS~MC_NAMEFIR EQ 'Suhash'
BR,
Suhas