Finding username based on Release Code for a PO

[sanjeev_mishra_15aug]

Hi Gurus,

I have a requirement in which, I have to fetch the SY-UNAME based on any of the following data:

Release Strategy(FRGGR)

Release Group(FRGSX)   

Release Code(FRGSX)  

The screenshot for the same is as follow:

As shown in the above screen shot, How can I find the SY-Uname for the user "Mohit Malhotra".

Please suggest.

Thanks in advance.

Sanjeev

ABAPer

[JL23]

"Mohit Malhotra" is just the description for a release code, nothing more. And honestly it is the worst kind of description that can be chosen.

Permission to use a release code 13 is granted  via user roles (PFCG transaction) , which can be given to any person, and should be to at least one more just in case Mohit takes a longer sick leave.

You may want read my blog to understand the connections better

[former_member235362]

I believe, "Mohit Malhotra" is not just description, it's the person who released the level 13. Please try with user master tables or check the search help "USER_ADDR_MC".

[JL23]

it is the description of the release code and can be found in T16FD table

[sanjeev_mishra_15aug]

I agree with you Juergen,

It's the discription of the release code. And its description can be found in the table T16FD.

But my query is that using this release code/ release group / release strategy how can we find out the user id for that particular approver in SAP?

By the way I found one more table as USER_ADDR which contains the userid if we pass the complete name e.g. 'abc def' in the field NAME_TEXTC field. But that's not useful forever.

Can we have any BAPI or FM or any particular table which can be used to get the user ID based on the release code/ release group / release strategy.

Please Suggest.

Also I visited the already posted blog in SCN website for the same query but couldn't find the proper reply.

the link for that is as

Sanjeev

[JL23]

If the release already happened then you will find the user ID in the change log table (CDHDR) and of course in the transaction ME23N itself  when looking at the changes.

[former_member235362]

if you want to find user who approved the levels based on release codes check the workflow tables.

[former_member235362]

Sorry, I agree with Juergen. it's a release code description.

[sanjeev_mishra_15aug]

Thanks friends,

My problem is resolved by using view USR_ADDR.