topic Re: attach a transaction code to abap query program in Application Development and Automation Discussions

attach a transaction code to abap query program

Former Member — Fri, 11 Jul 2008 12:53:51 GMT

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

Re: attach a transaction code to abap query program

GauthamV — Fri, 11 Jul 2008 12:55:56 GMT

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.

Re: attach a transaction code to abap query program

Former Member — Fri, 11 Jul 2008 12:58:04 GMT

Hi ,

Please check the option

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

Asha

Re: attach a transaction code to abap query program

Former Member — Fri, 11 Jul 2008 12:59:36 GMT

Go through the link given below :

With Regards

Nikunj shah

Re: attach a transaction code to abap query program

Former Member — Fri, 11 Jul 2008 12:59:49 GMT

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.

Re: attach a transaction code to abap query program

Former Member — Fri, 11 Jul 2008 13:00:35 GMT

Check the link given below :

Regards

Brijesh Patel

Re: attach a transaction code to abap query program

asik_shameem — Fri, 11 Jul 2008 13:17:19 GMT

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