Table which contains generated program name for SAP query

[Former Member]

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

[ferry_lianto]

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

[amit_khare]

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.

[Former Member]

Hi

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

[Former Member]

Function RSAQ_REPORT_NAME. is used to form te Query name

[Former Member]

This message was moderated.