Help with select from USREXTID table

[Former Member]

HI,

I try to select from table USREXTID and when i try to use do the select like below

SELECT bname FROM usrextid 
   INTO TABLE lt_bname
       WHERE type    = 'DN'
       AND extid     =  temp_extid
       AND status    = 'X'.

here when i take the exact entry from the table i get sy-subrc = 0.

Working o.k.

when i try to use the select for SAML like

SELECT bname FROM usrextid
   INTO TABLE lt_bname
         WHERE type      = 'SA'
           AND extid     =  temp_extid
           AND status    = 'X'.

I get sy-subrc = 4.

I have entry on the table with SA and i copy all the entry from EXTID field and put it on

temp_extid ,

What can be the problem ?

Best Regards

Nina

Edited by: Nina C on Jun 15, 2009 10:05 AM

[Former Member]

HI,

Check any entry for Type SA and given temp_extid for Status 'X' exists in the table.

[Former Member]

hi Avinash

thanks ,

but this is the first thing that i check

Best Regards

Nina

Edited by: Nina C on Jun 15, 2009 2:00 PM

[Former Member]

Has it smthing to do with CASE(Lower/Upper) of EXTID contents.

[Former Member]

HI,

i copy the entry from the table exactly and i put it ,

The problem here is with SA.

when i copy entry from table with DN it work fine.

it's behave strange .

Best Regards

Nina

[Former Member]

Hi,

Check traiing /Leading spaces while copying to temp_extid field.