‎2008 Jul 11 1:53 PM
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
‎2008 Jul 11 2:17 PM
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).
‎2008 Jul 11 1:55 PM
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.
‎2008 Jul 11 1:58 PM
Hi ,
Please check the option
for report transaction and give the report name for the query.
Asha
‎2008 Jul 11 1:59 PM
‎2008 Jul 11 1:59 PM
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.
‎2008 Jul 11 2:00 PM
‎2008 Jul 11 2:17 PM
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).