SAP user ve role table

su01
------
USR21
ADR6 -> SMTP_ADDR
ADRC
USR01
AGR_USERS->role


SE43
-------
SMEN_BUFFC
SMENSAPT ->OBJECTID
SMENSAPNEW ->OBJECTID

AGR_USERS USR21
-------- -------
MANDT MANDT
AGR_NAME START_MENU
UNAME BNAME
------------------------------------------------

PRINTER TABLE

TSP01 TSP02
------- -------
RQOWNER -user PJRECEIVER, PJOWNER -user
RQ1NAME -printer PKDEST -printer
RQPOSNAME - winismi PJPOSNAME -winismi

TSP02FX USR01
-------- --------
OWNER -user BNAME
TERMINAL -terminal SPLD

select rqowner, rq1name, rqposname from tsp01
where rqowner='$user'

select distinct rqowner from tsp01

select * from tsp02fx

select bname, SPLD from usr01 where spld='LOCE'

select distinct spld from usr01

select * from tsp02fx

tsp01, tsp02, tsp02fx, usr21

--------------------------------------------------

ROLE - TCODE TABLE

AGR_USERS, AGR_TCODES, AGR_1251

SELECT
TA.AGR_NAME AS LJS, TB.AGR_NAME AS SEVK,
TA.OBJECT AS LJS_OBJ, TB.OBJECT AS SVK_OBJ,
TB.MANDT, TA.MANDT,
TA.FIELD AS LJS_FIELD,
TB.FIELD AS SVK_FIELD,
TA.LOW AS LJS_LOW,
TB.LOW AS SVK_LOW,
TA.NODE AS LJS_NODE,
TB.NODE AS SVK_NODE
FROM (select * from AGR_1251--AGR_USERS
----AGR_TCODES
where AGR_NAME='$role') TA
inner join
(select * from AGR_1251--AGR_USERS
where AGR_NAME='$role') TB
on TA.OBJECT=TB.OBJECT
AND TA.OBJECT='S_TCODE'
AND TA.MANDT='$client' AND TB.MANDT='$client'
AND TA.FIELD=TB.FIELD
AND TA.LOW=TB.LOW
-----------------------------------------------------