Application Development and Automation 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: 
Read only

attach a transaction code to abap query program

Former Member
0 Likes
2,385

Hi!

I have developed a report with ABAP query in development server with transaction codes SQ01, SQ02 AND SQ03 respectively.

program is generated from SQ01 and i also got the program name from SQ01.

Now how to attach a transaction code with the program that is generated from ABAP query and transport it to production server

successfully.

points to be rewarded .

regards

Amit

1 ACCEPTED SOLUTION
Read only

asik_shameem
Active Contributor
0 Likes
1,240

Hi,

I don't think we need to generate the program.

You can simply go to SE93, put your t-code and create.

In the list of option for start object, select Parameter Transaction.

In transaction field: START_REPORT.

CHECK: Skip First Screen.

In the Default Values,

D_SREPOVARI-REPORTTYPE 'AQ'
D_SREPOVARI-REPORT  'HR          G'
D_SREPOVARI-EXTDREPORT  ' E2'

Here ..

AQ meant for ABAP Query.

HR is user group and G mean for Global. It has to be after 10 chars( It depends on the filed length of user group tech info).

E2 is Query name(in SQ01).

6 REPLIES 6
Read only

GauthamV
Active Contributor
0 Likes
1,240

hi,

from system status option of sq01 u can get program name.

now goto se93 transaction give that program name and create transaction and save in request.transport that request to production.

Read only

Former Member
0 Likes
1,240

Hi ,

Please check the option

for report transaction and give the report name for the query.

Asha

Read only

Former Member
0 Likes
1,240

Hi

Go through the link given below :

With Regards

Nikunj shah

Read only

Former Member
0 Likes
1,240

hiiii

go to

sq02 ->

Select Environment -> Query Areas..

Select Standard Area (Client specific)

(If Query does not exist in Standard Area then You will have to copy that Query From Global Area to Standard Area.)

For Coping Query From Global To standard first select that query from list.

Now select Environment-> Transports

In next screen select Copy Global to standard radio button.

Check Overwriting allowed (only with import/upload/copy)

Remove Check for Test Run

Select Transport InfoSets and queries radio button

Fill Infoset and Query with corresponding names.

Now Press Execute button.Copy Log will be displayed.

Now Query exist in Global & Standard Area.

Go to SQ02 .

Select Environment -> Query Areas..

Select Standard Area (Client specific)

Select Infoset from list.

Select Download radio button

Check Overwriting allowed (only with import/upload/copy)

Remove Check for Test Run

Select Transport InfoSets and queries radio button

Click on Execute button

same way you can upload sap query..from one system to another

regards

twinkal

Fill Infoset and Query with corresponding names.

Read only

Former Member
0 Likes
1,240

Hi

Check the link given below :

Regards

Brijesh Patel

Read only

asik_shameem
Active Contributor
0 Likes
1,241

Hi,

I don't think we need to generate the program.

You can simply go to SE93, put your t-code and create.

In the list of option for start object, select Parameter Transaction.

In transaction field: START_REPORT.

CHECK: Skip First Screen.

In the Default Values,

D_SREPOVARI-REPORTTYPE 'AQ'
D_SREPOVARI-REPORT  'HR          G'
D_SREPOVARI-EXTDREPORT  ' E2'

Here ..

AQ meant for ABAP Query.

HR is user group and G mean for Global. It has to be after 10 chars( It depends on the filed length of user group tech info).

E2 is Query name(in SQ01).