topic Re: Table which contains generated program name for SAP query in Application Development and Automation Discussions

Table which contains generated program name for SAP query

Former Member — Tue, 29 May 2007 14:29:18 GMT

Hello All,

I need to know the name of the table which contains the generated program name for SAP query. Or if we generate program for SAP query where will the program name get stored.

Second thing is if we want to transport SAP query into productive system. Is it necessary to send user group, infoset with SAP query. If user group and infoset is not sent will there be problems.

I know there is a standard report which can be used for sending usergroup, infoset and SAP query. From source sytem these have to be exported through the report and in the target system they have to be imported once request is being transported.

Kindly clarify my doubts and let me know the table name.

Thanks,

Mark

Re: Table which contains generated program name for SAP query

ferry_lianto — Tue, 29 May 2007 14:34:14 GMT

Hi,

Pleae try this.

Go to SE16 and then go to table TSTC.

in that give program name as *followed by your query name

(for example *TESTQUERY)

and run , that will give progname======queryname.

This way you can find program name.

Regards,

Ferry Lianto

Re: Table which contains generated program name for SAP query

amit_khare — Tue, 29 May 2007 14:43:07 GMT

Check this table - AQLQCAT

Table related to SAP query starts with AQ*.

This FM is used to fetch them - RSAQSQU_SELECT_QUERY

Regards,

Amit

Reward all helpful replies.

Re: Table which contains generated program name for SAP query

Former Member — Tue, 29 May 2007 15:03:46 GMT

use the following tables related to Query

AQGQCAT- Query Catalog

AQGSCAT -Functional Area Catalog

AQGDB -SAP QUERY tables and Data

AQGTB -User Group texts

AQGTQ - QUERY texts

AQGTS -Functional Area texts

Reward points if useful

Regards

Anji

Re: Table which contains generated program name for SAP query

Former Member — Wed, 28 Nov 2007 04:17:05 GMT

Function RSAQ_REPORT_NAME. is used to form te Query name

Re: Table which contains generated program name for SAP query

Former Member — Tue, 03 May 2011 11:30:02 GMT

This message was moderated.