05-29-2007 3:29 PM
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
05-29-2007 3:34 PM
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
05-29-2007 3:43 PM
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.
05-29-2007 4:03 PM
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
11-28-2007 4:17 AM
05-03-2011 12:30 PM