topic Re: How to Create Transaction code for a Report in Application Development and Automation Discussions

How to Create Transaction code for a Report

Former Member — Tue, 03 Oct 2006 14:56:14 GMT

Hi Gurus,

I created some reports and I wants those reports

should be placed in the SAP Menu(initial screen) not

in the User menu in the form of Transaction codes.

I would really appreciate if any one can please send the process to create transaction codes for the User reports/Report groups in R/3 and how to add those created Transaction codes to the SAP MENU.

Thanks in Advance

Danial

Re: How to Create Transaction code for a Report

Former Member — Tue, 03 Oct 2006 15:11:35 GMT

hello Daniel,

You can use transaction SE93 to create transaction codes for your reports.

I dont think you should be tampering with SAP standard menu. If I understand correctly then you want these transactions to display in the initial menu along with the SAP standard menu which wont be possible if you use user menu. i think the solution for it is simple. Add all these transactions as favorites. For this go to Favourites in menu bar of the first screen. Here you can create a new folder and add transactions to it. i hope it solves the issue.

Please reward points accordingly.

With regards.

Ruchit.

Re: How to Create Transaction code for a Report

Former Member — Tue, 03 Oct 2006 15:30:55 GMT

Actually you can update the SAP menu through SE43 for area menu S000. Would not recommend it since it would get overwritten with your next upgrade. Would recommend you create a custom area menu and assign to your users.

Re: How to Create Transaction code for a Report

Former Member — Tue, 03 Oct 2006 15:57:05 GMT

hello Danial,

I would like to add something to the solution suggested by JC. In the custom user menu you can actually add standard SAP menu S000. For this when creating a custom menu through SE43 go to EDIT in menu bar then to REFERENCE TO ANOTHER AREA MENU then choose INSERT AS SUB NODE. You wil get a pop up. Add S000 as the arae menu then press enter. Of course you have to also add the new custom transactions to this new area menu. Then assign this area menu to the users and you should find the the new transactions as well as the SAP menu being present. This is one more aproach to solving this issue.

regards.

Ruchit.

Re: How to Create Transaction code for a Report

Former Member — Tue, 03 Oct 2006 18:13:24 GMT

Thanks to all for your reply and suggestions.

I Created the Transaction Code for all the reports but when I tried to add those Transations to Menu tree Its not allowing to add the subnode to the existing tree.

I tried from same procedure as u memtioned Edit->....

Iam getting " Object maintanence in this System only Possible in Original Language DE"

can you please add some light on this...

Thanks

Re: How to Create Transaction code for a Report

Former Member — Tue, 03 Oct 2006 19:30:20 GMT

Hi,

Try to login with language option DE and that should work. Had the same problem. Used note 854311 to fix it permanently. Check if that applies in this case.

Cheers,

Kedar

Re: How to Create Transaction code for a Report

Former Member — Tue, 03 Oct 2006 19:43:35 GMT

Try to insert it into the main menu if you must change S000 (there is a function module for everything)? Perhaps SAP protects their menu trees from foreign subnodes in SE43?

Also note that for report transactions you do not need to give the user transaction code start_report. If you do, then they could enter it directly and potentially start many other reports too. The system will call start_report for submitting the report internally without authorizations for it required (unless start_report is maintained in SE97).

Regarding DE, this also confuses me sometimes and I noticed that it generally indicates that I am doing something which has an implication for a SAP standard object. Try either hitting the enter button to see what the next screen is, or, choose original language in the previous screen, or, logon in sy-langu = DE and (remember the path if you dont speak German) change it, or, follow JCs advice to create your own menu.

Re: How to Create Transaction code for a Report

Former Member — Wed, 04 Oct 2006 08:35:00 GMT

Dear Danial,

You are getting the DE language issue because i guess you are directly trying to change S000. As advised earlier by other forum members and me as well please don,t try changing SAP menu. First of all standard SAP objects should never be changed for such issues. Secondly changes will get overwritten after upgrade and may be also after some support package import.

The best approach in my opinion is to create a new user menu Z*.

However it is only my specualtion that you are directly trying to change S000. if you are getting this message trying tio create a custom area menu then let me know. I will try to solve the issue then.

Regards.

Ruchit.

Re: How to Create Transaction code for a Report

Former Member — Wed, 04 Oct 2006 13:28:26 GMT

Once again hartfull thanx to all.

I created One Folder by name Reports in the SAP Menu and try to add the Created Transaction code by loging as DE language. It worked...

When I tried to insert the Sub node its asking for transaction code to be inserted thats looks fine now...

Only concirn is whether this process is recomended by SAP and what will be the impact if we login as DE and make some changes in SAP MENU, I tried in Development system but iam bit worried to perform the same process in PRD.

I would appreciate if any one send some SAP recomended notes or related documents, that would really helpfull.

Thanks

Danial.

Re: How to Create Transaction code for a Report

otto_rodrguez — Tue, 24 Oct 2006 23:52:45 GMT

i tried to do the examples in se93 transaction, but the system show me the error AQ801.

D_SREPOVARI-REPORTTYPE AQ

D_SREPOVARI-REPORT ZSD

D_SREPOVARI-EXTDREPORT LISTAFACTURAS

when i try to put the G letter does not work, what can i do ?, i use the '_' caracter but anyway does not work.

the user group is ZSD

THANKS IN ADVANCE.

Re: How to Create Transaction code for a Report

meredithmo24 — Wed, 04 Sep 2019 07:05:35 GMT

If you meet the error AQ801 during creat transaction code for query. It's about the name of USER GROUP. If the query area of your user group is created by global area(cross-client), you need to add a G letter behind your user group name, just to represent the query area.

And as we know that user group name is 12 characters long, but your is 3 characters, so you need to use whitespace to instead.

D_SREPOVARI-REPORT should be typed:

ZSDwhitespacewhitespacewhitespacewhitespacewhitespacewhitespacewhitespacewhitespacewhitespaceG

Hope will help you.