Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP queries

Former Member
0 Kudos
56

Hi All,

Iam trying to move an ABAP query to the Production client from the dev client. It gives me a short dump when i run the transaction code assigned to the query . Is there a specific method to move a query transport to Production

Kindly let me know

1 ACCEPTED SOLUTION

Former Member
0 Kudos
39

This is because you assigned transaction code to the query directly (with the name of dynamicaly generated report name) and it is incorrect. In your production client the system has generated another report for the query and given it the new name.

NEVER assign transaction name to a generated SAP Query report. To do it in the correct way you should better update some user role via PFCG.

Was the query itself in a transport? i.e. saved in a request via SQ02? If so, it must be imported in the target system by the same method. If not, you do need to export it by that method.

If you have done that and your transaction is a parameter transaction or a straight program name where the client is the same in both dev and prod, the most likely answeris simply that you need to generate the program. Easiest fix is to execute the query in SQ01 once, then the transaction should work thereafter.

Reward if helpfull...

Cheers,

Venkoji Babu,.

2 REPLIES 2

Former Member
0 Kudos
39

Hi,

Refer the below thread..

Hope it is helpful..

Regards,

Chithra

Former Member
0 Kudos
40

This is because you assigned transaction code to the query directly (with the name of dynamicaly generated report name) and it is incorrect. In your production client the system has generated another report for the query and given it the new name.

NEVER assign transaction name to a generated SAP Query report. To do it in the correct way you should better update some user role via PFCG.

Was the query itself in a transport? i.e. saved in a request via SQ02? If so, it must be imported in the target system by the same method. If not, you do need to export it by that method.

If you have done that and your transaction is a parameter transaction or a straight program name where the client is the same in both dev and prod, the most likely answeris simply that you need to generate the program. Easiest fix is to execute the query in SQ01 once, then the transaction should work thereafter.

Reward if helpfull...

Cheers,

Venkoji Babu,.