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: 

sap query

shishupalreddy
Active Contributor
0 Kudos

Hi ,

I know only the program name generated using SAP QUERY ,,

Now my requirement is to modify this program as we cant modify this program I have only one option to change the SAP QUERY of the same program .

But how to find the respective SAP QUERY usergroup and infoset of the same ....

Earliest responce will be gr8

thanks

1 ACCEPTED SOLUTION

Bema
Active Participant
0 Kudos

hi,

Can i know your program name generated by SAP QUERY.

Is it of the form

AQZZ..?

For ex: if

AQZZZFI_ALL=====YFIQOCOL======

is the program name,

here ZFI_ALL is the usergroup and YFIQOCOL is the query name.

AQZZ(ZFI_ALL)=====(YFIQOCOL)======

In SQ01 you can search for the this query under this usergroup. You will get the infoset also here

7 REPLIES 7

Former Member
0 Kudos

you can find user group and infoset from transactions SQ01 AND SQ02.

shishupalreddy
Active Contributor
0 Kudos

If i know either infoset name or query name i can find out from SQ01 SQ02 or SQ03

But my problem is that i dont know anything I know only the report name generated with SAP QUERY tool

so I could not able to find out the respective qury or infoset

Former Member
0 Kudos

hi,

check TCODES SQ01,SQ02,SQ03

thanks,

kcc

Bema
Active Participant
0 Kudos

hi,

Can i know your program name generated by SAP QUERY.

Is it of the form

AQZZ..?

For ex: if

AQZZZFI_ALL=====YFIQOCOL======

is the program name,

here ZFI_ALL is the usergroup and YFIQOCOL is the query name.

AQZZ(ZFI_ALL)=====(YFIQOCOL)======

In SQ01 you can search for the this query under this usergroup. You will get the infoset also here

shishupalreddy
Active Contributor
0 Kudos

Hai

here Iam providing the report name generated using SAP QUERY

AQAAZF==========ZSTOCKBYGRP===

HERE I tried with ZSTOCKBYGRP to find out the query in SQ01 but no such query is there

thanks

0 Kudos

simple just check table <b>AQGQDOC</b>

AQGDB SAP Query: Tables and Data (Global)

AQGDBBG SAP Query: User Groups

AQGDBBN SAP Query: Assigning Users to User Groups

AQGDBBS SAP Query: Assigning Functional Areas to U

AQGIDOC SAP Query: InfoSet Documentation (Key)

AQGQCAT SAP Query: Query Catalog

AQGQDOC SAP Query: Documentation for queries (key

AQGQSTRUC SAP Query: Query / Structure Assignment

AQGSCAT SAP Query: Functional Area Catalog

AQGTB SAP Query: Texts for User Groups

AQGTQ SP Query: Texts for Queries

AQGTS SAP Query: Texts for Functional Areas

Bema
Active Participant
0 Kudos

you checked it in usergroup ZF ?