topic Re: Finding username based on Release Code for a PO in Application Development and Automation Discussions

Finding username based on Release Code for a PO

sanjeev_mishra_15aug — Thu, 26 May 2016 10:05:52 GMT

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

Re: Finding username based on Release Code for a PO

JL23 — Thu, 26 May 2016 12:44:52 GMT

"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

Re: Finding username based on Release Code for a PO

former_member235362 — Thu, 26 May 2016 17:17:57 GMT

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".

Re: Finding username based on Release Code for a PO

JL23 — Thu, 26 May 2016 17:21:59 GMT

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

Re: Finding username based on Release Code for a PO

former_member235362 — Thu, 26 May 2016 17:22:21 GMT

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

Re: Finding username based on Release Code for a PO

former_member235362 — Thu, 26 May 2016 17:25:36 GMT

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

Re: Finding username based on Release Code for a PO

sanjeev_mishra_15aug — Fri, 27 May 2016 04:28:47 GMT

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

Re: Finding username based on Release Code for a PO

JL23 — Fri, 27 May 2016 09:17:23 GMT

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.

Re: Finding username based on Release Code for a PO

sanjeev_mishra_15aug — Tue, 21 Jun 2016 09:30:09 GMT

Thanks friends,

My problem is resolved by using view USR_ADDR.