sap query

[shishupalreddy]

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

[Former Member]

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

[shishupalreddy]

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]

hi,

check TCODES SQ01,SQ02,SQ03

thanks,

kcc

[Bema]

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]

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

[Former Member]

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]

you checked it in usergroup ZF ?