Get Bname from external name

[Former Member]

HI,

I want to get the bname from the external name from table USREXTID with select single statement ,

I see that the external user is string with the domain so any idea what is the best way to get it?

The problem with the field EXTID is that it CHAR112

So i get there entry like :CN=C112321, O=SA-AG, C=DE

and i want to do simple select like

Select banme

from userextid

where extid = C112321.

And to get the bname of the user.

Best regards

Ricardo

[Former Member]

HI,

I want to get the bname from the external name from table USREXTID with select single statement ,

I see that the external user is string with the domain so any idea what is the best way to get it?

The problem with the field EXTID is that it CHAR112

So i get there entry like :CN=C112321, O=SA-AG, C=DE

and i want to do simple select like

Select banme

from userextid

where extid = C112321.

And to get the bname of the user.

Best regards

Ricardo

[Former Member]

try this way...

Select single banme

from userextid

where extid = C112321.

[Former Member]

Hi,

it's not that simple ,the field EXTID contain another data except the user number,

so the select is little bit difficult .

please see table USREXTID and you see that.

Best Regards

Ricardo

Edited by: ricardo arona on May 22, 2009 1:35 AM

[former_member222860]

Can you bit clear about your problem

Check this:

tables: USREXTID.

SELECT single bname into USREXTID-bname
             from USREXTID
            where extid = 'C112321'.

WRITE:/ USREXTID-bname.

Mahesh

Edited by: Mahesh Reddy on May 21, 2009 12:12 PM

[Former Member]

Hi,

Make use of this FM "RSEC_GET_USREXTID" , this will solve your issue.

Regards,

Smart Varghese

[Former Member]

HI smartvarghese ,

Thanks,

I try it but it's not work,any idea why ?

I try to put just the external user name and i get noting.

Best regards

Ricardo

Edited by: ricardo arona on May 25, 2009 9:40 AM

[Former Member]

Hi Ricardo,

The input for the FM "RSEC_GET_USREXTID" should be

1. SY-MANDT

2. The External Id ( plain text or hash value -- which is a field of type CHAR length112)

Please try with this, let me know the upshot.

Regards,

Smart Varghese

[Former Member]

HI,

Thanks but i have to put all the user data like DN -CN=I01234, O=SA-AG, C=DE

I want to put just the user number like: I01234 and to get the Bname ,

There is a way to do so?

Best regards

Ricardo

Edited by: ricardo arona on May 26, 2009 5:04 PM

[SuhaSaha]

Hello Ricardo,

I think you can make use of LIKE with SELECT statement.

SELECT <fields> FROM USREXTID
INTO TABLE IT_USREXTID
WHERE BNAME LIKE 'I01234%'.

Hope this helps.

BR,

Suhas