get bp mail id

[former_member305388]

Hi Experts,

I am trying to read the BP email id from table HRP1001.

I am doing the following steps

Select OBJID from HRP1001 where OTYPE = 'CP' and SOBID = user name and SCLAS = 'US' that , get central person number.

Then select again from HRP1001. Select SOBID from HRP1001 where OTYPE = 'CP' and OBJID = central person and SOBID = 'BP' , BP number.

From table ADR6 for the given person number there are multiple entries. How to get the address number to get the correct BP entry?

[Former Member]

Hi Srinivas,

Why not use the BAPI 'BAPI_BUPA_CENTRAL_GETDETAIL'?

Regards,

Nikhil

[former_member305388]

Hi Nikhil,

I need the data for large number of users and hence looking for tables to directly select.