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: 

regarding database table of user-id

former_member181995
Active Contributor
0 Kudos

hello experts..

there is some performence issue in my report which is detailed sales register.

i tried a lot and made lots of performence tunning for that but still it is dumm.

i know it will always run slightly dum as compared to other reports..cause it contains lacs of data..

but at last option left for me that i will restrict the users according to their user-id and billing type.

so could u tell me in SE 11 by which table we maintain the all user-ids list.

so then i will restrict the users.

it needed because most of time users give the * in all selection fields option so report comes with lots of data

even all data not nessery for all users..so plz tell me a specific table where we maintain all user-id..

thanks in advance....

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Amit ,

in any report u have to do the validations to check the authorization wether user have authorizations to run report for other plants or not ?

so better to put more validations when he is going to select * in selection screen.

\event at selection-screen

<b>* Authorization check for Plant

select werks

into table i_auth_werks

from t001w

where werks in s_werks.

loop at i_auth_werks.

authority-check object 'Z_PLNT_AUT'

id 'ACTVT' field '03'

id 'WERKS' field i_auth_werks-werks.

if sy-subrc ne 0 .

message e398(00) with

'User' sy-uname 'not authorised for Plant : ' i_auth_werks-werks.

endif.

endloop.</b>

clear i_auth_werks.

here i am using Z authorization objects , here u can use any standard objects al.so

Regards

Prabhu

5 REPLIES 5

Former Member
0 Kudos

HI AMIT ......

GOD MORNING ....

i am a functional guy .......but wait dear i will solve ur problem ......let me check with my abapers .........so till than keeo waiting .....

shalsa007..........

mumbai

0 Kudos

i know u r functional guy but u shud also know about some authention issues which u maintain

by some table yaar i used it a long time back but its bit slipped from my mind...

0 Kudos

yeah i got it man its maintain in usr02 table here u can see the list of all user logon id..

go to se11 then usr02.

Former Member
0 Kudos

Amit ,

in any report u have to do the validations to check the authorization wether user have authorizations to run report for other plants or not ?

so better to put more validations when he is going to select * in selection screen.

\event at selection-screen

<b>* Authorization check for Plant

select werks

into table i_auth_werks

from t001w

where werks in s_werks.

loop at i_auth_werks.

authority-check object 'Z_PLNT_AUT'

id 'ACTVT' field '03'

id 'WERKS' field i_auth_werks-werks.

if sy-subrc ne 0 .

message e398(00) with

'User' sy-uname 'not authorised for Plant : ' i_auth_werks-werks.

endif.

endloop.</b>

clear i_auth_werks.

here i am using Z authorization objects , here u can use any standard objects al.so

Regards

Prabhu

0 Kudos

but better for me instead it..

if i maintain the userid in standerd table..

so could u tell me which table contains the list of userid.