employee id in CRM

[Former Member]

i have requirement to get all the Employee details in the CRM System.

Can anyone tell me where the employee usernames and id gets stored (TABLE)

The structure of the Employee should be as under:

- BP Id

- Employee Id

- First Name

- Last Name

- City

- Country

[Former Member]

Some important tables in CRM :

BUT000 : BP: General data

Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

BUT020 BP: Addresses

BUT050 BP relationships/role definitions: General data

Contains Relationship, Partner Number (PARTNER1), Relationship Category

BUT051 BP Relationship: Contact Person Relationship

Similar to BUT050 , additionally contains Contact Person’s Address data

BUT0BK Business Partner: Bank Data & Details

BP Number, Bank Key, Bank Country Key, Bank Account Number

BNKA Bank Master Data

BUT100 BP: Roles

ADR2 Telephone Numbers (Business Address Services)

ADR6 SMTP Numbers (Business Address Services)

Contains Email – Id of the BP.

ADRC Addresses (Business Address Services)

BP’s Complete Address Details- City, Country, Post Code, District, Street, Title No Etc

TSAD3T Table containing the Title text against a Title No.

COMM_PRODUCT Master Table for Product

CRMM_BUAG Master table for Business Agreement

CRMM_BUAG_H Header Data for Business Agreement such as Tax Category, Tax Characteristic, Form key, Business Agreement Class. Data in this table correspond to ISU CRMD_ORDERADM_H Contains the Header Information for a Business Transaction.

Note:

1. It doesn’t store the Business Partner

responsible for the transaction. To

get the Partner No, link it with

CRM_ORDER_INDEX.

2. This table can be used for search

based on the Object Id(Business

Transaction No).

CRMD_CUSTOMER_H Additional Site Details at the Header Level of a Business Transaction

CRMC_PROC_TYPE Master table Business Transaction Type

CRMC_PARTNER_FCT Definition of Partner Functions

SCPRIOT Priorities for Activities with priority text.

CRMC_PROC_TYPE_T Text for a transaction type

CRMC_ACT_OBJ_T Objective Number and Text for Activities

TJ30T All the status code and text

CRMC_PR_ASSIGN : Transaction Type and its Transaction Type Object.

IBIB : Installed Base/Ibase

IBIN : Installed Base Components

regards

dheeraj

[Former Member]

hi Dhiraj u have given me so much details thanks for that

but can u tell me in short that

in which table is the employee id is stored.

[Former Member]

Hi,

go to but100 table and get all the bp numbers who are assigned to the role “employee”.

loop the table.

get the bp address from but000 and adrc tables.

loop the table.

call function ‘bapi_bupa_get_employee_from_bp’

to get the employee id.

Employee id is stored in the table HRP1001.

Reward if it helps you.

Regards,

Srini.

[Former Member]

Hi Monalisa,

Below are the relationship of few CRM tables.

please see if they can help you.

BUT000 : Contains the key as Business Partner No

BUTOBK: Using the BP no and bank detail ID , Bank details ca be fetched.

BUT020ADRCADR2--ADR6 : is the link of the tables to get addrss details to the corresponding Bp no from BUT000 and addrss no from BUT020.

BUT100 : for BP roles.

Plz reward if helpful.

Regards

Sourabh Verma

[Former Member]

Hi There,

If you know the BP number you can get the emp. id using the FM "CRM_LEAD_GET_USER_FOR_BP". You can use the FM "BAPI_BUPA_ADDRESS_GETDETAIL" to get the address data.

The tables used are BUT000 , ADRC, BUT020.

Reward points if it helps!!

Thanks,

Vikash.

[Former Member]

Hi,

See these tables BUT000, BUT020, ADRC.

Regards

Srinu