topic sap query in Application Development and Automation Discussions

sap query

shishupalreddy — Tue, 26 Sep 2006 06:47:54 GMT

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

Re: sap query

Former Member — Tue, 26 Sep 2006 06:50:17 GMT

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

Re: sap query

shishupalreddy — Tue, 26 Sep 2006 08:10:17 GMT

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

Re: sap query

Former Member — Tue, 26 Sep 2006 09:08:01 GMT

hi,

check TCODES SQ01,SQ02,SQ03

thanks,

kcc

Re: sap query

Bema — Tue, 26 Sep 2006 09:30:03 GMT

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

Re: sap query

shishupalreddy — Tue, 26 Sep 2006 09:50:50 GMT

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

Re: sap query

Former Member — Tue, 26 Sep 2006 10:06:14 GMT

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

Re: sap query

Bema — Tue, 26 Sep 2006 10:08:12 GMT

you checked it in usergroup ZF ?