What is the check table for KNA1 to get the USER ID for User Master Record

[Former Member]

Hi

Can anybody tell me what is the check table for kna1 to get the associated user id (user name for user master record) for kna1- kunnr.

thanks in advance

KP

[Former Member]

Hi,

All user id's are stored in USR02 table.

Regards

Subramanian

[Former Member]

Hi Subramanian,

How Can i get the associated kna1-kunnr details using user id.

Please help me.

thanks in advance

KP

[RichHeilman]

User ids are not tied to customers. What exactly are you trying to do?

Regards,

Rich Heilman

[gopi_narendra]

Hi KP,

Check the table USR05 with BNAME and PARID.

U can get the Customer related to the USER from the value PARVA.

select single * from USR05

into IS_USR05

where BNAME = SY-UNAME

and PARID = 'KUN'.

if SY-SUBRC = 0.

" IS_USR05-PARVA.gives you the value of the KUNNR

else.

" message 'Customer not maintained for User ' SY-UNAME.

endif.

Regards

Gopi

[Former Member]

Hi Heilman,

I am working on a report to get the customers associated with the user id's.

Please help me.

thanks in advance.

kp

[Former Member]

Hi Gopi,

I tried with your suggestion.

but i didnt find any rows.

please help me.

thanks in advance

kp

[Former Member]

On what screen do you see this data displayed (userid attached to a customer)?

Rob

[former_member181962]

Hi KP,

in Standard procedure, Customers do not have a User Id mapped to them. There must be some Z table in your system which maintains the relation between the customer and user id. Check if such a ztable exists in your system.

regards,

Ravi