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 QUERY

Former Member
0 Kudos
323

Hi all

I developed the Abap QUERY via SQ01

i created : in Global DEfinition

Infoset, User group , Query :

now if i tried to attatch this query : with Ztransaction code :

Using Transaction With Variant option :

Now here i am passing the Transaction Start_report for first screen :

For sccond :

I took the screen :

D_SREPOVARI : report type : AQ

Report : my user group name

but when i execute it shows USERgrop not EXIT..

Same Query if i rum with the SQ01 its worked fine there :

Any suggestion are welcome :

Thanks in advance :

9 REPLIES 9

andrea_galluccio2
Contributor
0 Kudos
150

Hi .

Run the query and at the selection screen in Menu System-> Status, chek the program name.

Sign it. Go to se93 trx and create a new report transaction.

Here u can put the report name and eventually a variant to start with.

This is workaround that should works.

Hope it helps

Bye

Andrea

Pls reward if it helps

0 Kudos
150

Hi Andrea

that i tried already :

But with that method will work fine in English Lanugauge

But if i tried with other language : then It will give the Dump ...

So i can't used that method :

sridhar_k1
Active Contributor
0 Kudos
150

Use parameter transaction type in SE93,

After entering START_REPORT in transaction hit enter and populate the following in the default values

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = User group

D_SREPOVARI-EXTDREPORT= Query name

D_SREPOVARI-VARIANT = Variant

Regards

Sridhar

Former Member
0 Kudos
150

Hi Sridhar:

I have enter the parameter which you have suggest:

When i Execute the Transaction : it Give message

User group has not created :

0 Kudos
150

Did you execute the Z transaction or START_REPORT?

Select skip initial screen check box when creating the parameter transaction and try.

It's working fine in my system when i execute the Z transaction, but I'm getting the same error when i try to execute the query using transaction START_REPORT.

Regards

Sridhar

0 Kudos
150

Hi Sridhar:

Yes i executed the z transaction only :

And use the skip first screen option : tick

I am wonder why its giving this error :

As user group is already maintain :

Is it some thing related to : Client specific or Global function :

As i have created this query in Global : because i have to moved in another Clients also ........

Former Member
0 Kudos
150

I have a similar problem. The user group is fine, it is also assigned. The query runs fine when executed via sq01. When I try to run it via a transaction with parameters which runs START_REPORT with the relvavant parameters, the message I get is user group does not exist.

I tried debugging the system and I found that the function call RSAQ_EXIST_CHECK_QUERY fails. This is strange because I look at the tables and see that both the query and user group exist. Maybe this is a cluster issue ?

Any ideas anybody ?

Former Member
0 Kudos
150

I forgot to mentions one more thing... I tried adding the user parameters: AQB (with the user group as a parameter value) and AQW with (G as the parameter value because it is a query in the global area).

This did not help either.

0 Kudos
150

Hi

Using parameter transaction type in SE93,

After entering START_REPORT in transaction hit enter and populate the following in the default values

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = User group X " ZF_VEN X

D_SREPOVARI-EXTDREPORT= Query name

D_SREPOVARI-VARIANT = Variant

D_SREPOVARI-REPORT assign user group space X it will give output