topic Re: ABAP Queries table in Application Development and Automation Discussions

ABAP Queries table

Former Member — Thu, 11 Oct 2007 11:14:30 GMT

Hi,

can any bady help me that there is a one table which stores all custom abap queries , i need ...

varma_narayana — Thu, 11 Oct 2007 11:50:59 GMT

Hi Raja...

ABAP Queries are also stored in the Table TADIR along with other Repository Objects.

the following fields must be checked to Find ABAP Queries in this Table:

PGMID = 'R3TR'

OBJECT = 'AQQU' "For ABAP Queries

This will help u to retrieve the ABAP queries from this table TADIR.

sample code:

data: itab type table of TADIR.

SELECT * FROM TADIR into table ITAB.

WHERE PGMID = 'R3TR'

and OBJECT = 'AQQU'

and (OBJ_NAME like 'Z%' or OBJ_NAME like 'Y%').

<b>REWARD IF HELPFUL.</b>

Former Member — Thu, 11 Oct 2007 20:02:57 GMT

See the following tables related to ABAP querries

Querries- AQGDB

User groups- AQGDBBG

Query Texts - AQGTQ

User Group Texts - AQGTB

if you need further check in SE11 with AQG* for all query related tables

Regards

Anji

Former Member — Fri, 12 Oct 2007 04:09:02 GMT

good

AQGDB - SAP Query: Tables and Data (Global

thanks

mrutyun^