2019 Dec 24 6:37 AM
Hi Experts,
I am creating an infoset query report (SQ01) to display user's purchase requisition code authorization, displayed below, and wondering if there's any way I could add F4 selection options for both Release Group and Release Code? I would like to have the EBAN-FRGGR value to be populated as the selection options for Release Group and T16FD-FRGCO for Release Code.
※Both Release Group and Release Code are a custom field created from the infoset (SQ02)
The screenshot below is what I am trying to achieve (the options button to select the value):
Thank you.
2019 Dec 24 11:51 AM
What types did you specify for these two additional fields? Did you type them identically to the ones in transaction "User Release Code Authorisations"?
2019 Dec 25 12:40 AM
Hi Sandra, I use LIKE reference to specify the type of the two fields to the corresponding table-field.
The "User Release Code Authorisations" report actually exists in another environment and coded in ABAP. Because of different release structures, this time in the environment I am currently working I need to have the same report in place and I figured this could be done via Infoset query without additional ABAP team involvement. This query report is working as it should now, just that the user would like to have the F4 selection options available which I don't have the know-how to implement it. Much appreciate if you could provide any input on this.
2019 Dec 25 6:42 AM
Look at the other environment the types used to type the fields of the transaction "User Release Code Authorisations", see what value helps are defined for them, then look in your system which structure/table components use these value helps and type your query fields with these components.
2019 Dec 26 4:25 AM
Sandra, referring to this solution, I am trying to use the solution shared by Jogeswara Rao. Could you advise on the below please?
1. In the Infoset, I added custom "parameter" selections using EBAN-FRGGR like format as a dummy field for the user to use the F4 selection option or enter their desired value for the release group.
It will look like this:
2019 Dec 26 4:25 AM
2. So now that the user could select the release group from the custom selection field above, I plan to hide the standard "Release Group" field via a variant, and then write a line of code to pass the value entered in the custom "Release Group (S)" selection to the standard one I hide to get the result as the report is executed.
3. In the code section of the Infoset, under "Start-of-Selection" I add the line below:
※AGR_1251-LOW → Release Group, ZRLSGRP → Release Group (S)
But this doesn't seem to work as expected when I run the query and enter a value in the custom selection field. Could you advise if something is missing? I have to also mention I have no experience coding in ABAP and my knowledge is very limited in this department. I would really appreciate it if you could assist me with this.