Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Tables in BP

Former Member
0 Kudos
581

Hi,

In BP transaction, role: Employee, in the Identification Tab, where does the values for fields: Personnel number and user name are getting stored in the Tables?

Thank you!

1 ACCEPTED SOLUTION

Former Member
0 Kudos
241

hi,

These information are coming from tables HRP1001 and HRP1000.

basically HRP1001 is used to store the relationships between objects and object

types, and HRP1000 is where the object details are stored.

Personnel number of object type P.

user is object type US.

you need to get the user mapped to a person from hrp1001 and get the details

from HRP1000. (you can use function module BAPI_USER_GET_DETAIL to get

the user details)

Hope this helps,

Sajan Joseph.

10 REPLIES 10

Former Member
0 Kudos
241

Hi,

Press F1 on that particular field and click on Technical Settings. It will display all technical settings for that field.

Thanks

Ravi

0 Kudos
241

I did that, but it is displaying structure BUS000EMPL

I need the table

Former Member
0 Kudos
242

hi,

These information are coming from tables HRP1001 and HRP1000.

basically HRP1001 is used to store the relationships between objects and object

types, and HRP1000 is where the object details are stored.

Personnel number of object type P.

user is object type US.

you need to get the user mapped to a person from hrp1001 and get the details

from HRP1000. (you can use function module BAPI_USER_GET_DETAIL to get

the user details)

Hope this helps,

Sajan Joseph.

0 Kudos
241

Hi Sajan,

Could you please let me know the flow of how the values is it is getting stored in these tables...

Like I have a BP say 20 and in the User name field i gave the value as "TEST1".

The value of BP is getting stored in Table BUT000 and the value of TEST1 is getting stored in Table :HRP1001. Is there any other table which connects these two?

Thanks!

Former Member
0 Kudos
241

Hi dn,

1. In the table BUT000,

there is the field PERNO which corresponds to Personnel Number.

regards,

amit m.

0 Kudos
241

Hi Amit,

There is some value generated for PERNO in the table BUT000. Using this value, how is it connected to the HRP1001, HRP1000Table?

0 Kudos
241

Hi again,

1. using PERNO, there is no need to connect to HRp1001 tables.

2. In fact it is connected to PA0002 tables,

where the PERNR and his name details are stoerd. (personal details are stoerd)

Other tables where pernr is used is PA0001, PA0006 etc.

regards,

amit m.

0 Kudos
241

Hi Amit,

In our system, we dont have PA* tables, we only have HRP..... tables....

Do you know any other solution for this, where I can get UserID, User name information....?

0 Kudos
241

Hi again,

1. Sorry, the details are kept in HRP1001 table itself.

2. The details are fetched in two steps, ie two different sqls,

both on HRP1001 table.

3. However, to get it easily,

use the FM

<b>BAPI_BUPA_GET_EMPLOYEE_FROM_BP</b>

(From Business Partner -


> Employee ID)

regards,

amit m.

0 Kudos
241

Hi Amit,

Let me test it and will get back to you and will award full points if it works..

I did award partially some points for now.....

Thank you!