i hope this will help you.
data lv_uname(12) type c. data lv_agrname(30) type c. select OBJID into lv_uname from T16FW where FRGGR = T16FS-FRGGR and FRGCO = T16FS-FRGCO. select AGR_NAME into lv_agrname from AGR_USERS where uname = lv_uname.
Edited by: goktasor on Jun 1, 2010 10:50 AM
it is same indeed. get FRGGR and FRGCO from T16FS.
Then go to T16FW with these values and get OBJID.
Go to AGR_USERS and get AGR_NAME by UNAME = OBJID.
data lv_FRGGR(2) type c. data lv_FRGCO(2) type c. data lv_agr_name(30) type c. data lv_objid(12) type c. select FRGGR into lv_FRGGR from T16FS where FRGC1 = 'smthing' and FRGC2 = 'smthing2'. select FRGCO into lv_FRGCO from T16FS where FRGC1 = 'smthing' and FRGC2 = 'smthing2'. select OBJID into lv_objid from T16FW where FRGGR = lv_FRGGR and FRGCO = lv_FRGCO. select agr_name into lv_agr_name from AGR_USERS where uname = lv_objid.
No My problem is not solved yet. I only have the release code with me.
This release code is stored in M_EINK_FRG auth obj field FRGCO.
The table is T16FS. Codes are stored in fields FRGC1, FRGC2....
For these release codes I need to know the authorization roles.
Table T16FW gives me user id in objid . But a user can have many roles. I am looking for role for a particular release code.