2008 Apr 17 1:43 PM
hi all,
i want to link two tables i.e. pa0105 and usr01. for userid.
pls tell me how to link them.
best regards,
ashok reddy.
hi all,
i want to link two tables i.e. pa0105 and usr01. for userid.
pls tell me how to link them.
best regards,
ashok reddy.
2008 Apr 17 1:49 PM
Hi Frd
There is no releation between those two tables.
Reward Me Points
By
Pari
2008 Apr 17 1:52 PM
there is a relation ..
U can relate these two fields ...
USR01-BNAME
PA0105-USRID
2008 Apr 17 1:59 PM
Yes, there is!
Look for the Type you want. In this table you should find email address, user sap and etc.
You shouldn't forget to make your select using these fields:
ENDDA
BEGDA
Alexandre C. Rocha
2008 Apr 17 2:05 PM
Correct,
Infotype 0105(Table pa0105), SUBTY = "0001" system user name (SY-UNAME)
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |