cancel
Showing results for 
Search instead for 
Did you mean: 

User list as sales wise or Plant wise?

Former Member
0 Kudos

Dear Team,

Is there a way to get a list of all users in Production according to the Sales offices or Plants???

Regards

R. Thillai Govindarajan

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Thillai,

Ask your basis team, they will help you on this.

Regards

AJC

Former Member
0 Kudos

Hi Team,

Yes I am looking for SAP Users only. I too from Basis only. The USR02 will not hold plant data.

Hi Mohit,

Can you brief on your replied post. Hope to be a helpful answer.

Thanks

RTG

Former Member
0 Kudos

can u tell me u want to use in which document i will provide u complete solution

create table which have plant,document type,number range number index only this 3 field required use select query and get number range dynamically

u can set number range plant wise

Former Member
0 Kudos

Hi Mohit,

Just I need Plantwise SAP user list or Sales office wise SAP user list as a excel report.

Thanks

RTG

Lakshmipathi
Active Contributor
0 Kudos

Can you please let me know how you were identifying the users ?  Were their roles assigned plant-wise or sales office wise ?  Nevertheless, you have to consider developing a report either through SQVI or Info Set by considering tables like TVKBZ, TVKWZ etc., if you really in need of this report. 

G. Lakshmipathi

Former Member
0 Kudos

USR21 u get person number & address number

go to adrp table u get person details &

T001W in u get plant and address number using address number u get which person in which plant & which person is available in plant user details thorough adrp

use 3 query for reporting...

Former Member
0 Kudos

USR21 u get person number & address number

go to adrp table u get person details &

T001W in u get plant and address number using address number u get which person in which plant & which person is available in plant user details thorough adrp

use 3 query for reporting...

Former Member
0 Kudos

This message was moderated.

ripu123in
Explorer
0 Kudos

Are you looking for SAP user?

ripu123in
Explorer
0 Kudos

If you are looking for SAP users then i know only one thing you can check it through USR02 in table.

Regards,

Tarun