Table for release code and role

[Azeemquadri]

Hello,

I am looking for a relation between:

Release code - T16FS-FRGCO

and Role - AGR_USERS-AGR_NAME.

This is for an ABAP report.

Please help

Tks a lot.

[GauthamV]

Check T16FW,T16FC tables.

[Former Member]

hi,

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

[Azeemquadri]

The role I am looking for is stored in Table AGR_USERS in field AGR_NAME.

So I want to determine which role is used for the Release Code T16FS-FRGC1 .

[Former Member]

hi,

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.

regards,

orhan

[Former Member]

hi,

does your problem solved ?

[Azeemquadri]

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.

Thanks.