Report Development

[Former Member]

Dear ABAPers.,

create a report about the Query user groups and the assigned queries with the query text and the related fields you can see in the online

do you have experience regarding this pls give me some inputs..

Regards

Rajedren.P

[Former Member]

Hi,

Take a look at the std transaction SQ01, SQ02 and SQ03 and try to find the underlying code you will get some inputs.

Cheers

VJ

[RaymondGiuseppi]

Here is a list of Query's table

AQDB SAP Query: Tables and Data

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 User Groups

AQGQCAT SAP Query: Query Catalog

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

AQHTMLRAW SAP Query: HTML Templates for Query

AQHTMLTMPL SAP Query: HTML Templates for Query (Language-dependent)

AQIF_C SAP Query: Interfaces (Customer)

AQIF_S SAP Query: Interfaces (SAP)

AQLDB SAP Query: Tables and Data (Local)

AQLQCAT SAP Query: Query Catalog

AQLSCAT SAP Query: Functional Area Catalog

AQLTQ SP Query: Texts for Queries

AQLTS SAP Query: Texts for Functional Areas

AQPROT Query Logging

AQPROTCUST Query Logging Control

AQSGDB SAP Query: Tables and dates (global, trash)

AQSLDB SAP Query: Tables and dates (local, trash)

AQTDB SAP Query: Transport stocks (local)

AQTXTBS SAP Query: Functional Areas and User Groups Text Table

AQTXTQ SAP Query: Text Table for Queries

AQXINT SAP Query: Additional functions

AQXINTA SAP Query: Active additional functions

AQXINTT SAP Query: Additional function texts

AQXINTUG SAP Query: Enhanced Folders - User Groups

TAQTS SAP Query: Transprt of Queries, Functn. Areas and User Grps

TEXC_DE Text ID: Exception Definiton using Data Element

TEXC_DE_C Text ID: Exception Definiton using Data Element

TEXC_DOM Text ID: Exception Definition using Domains

TEXC_DOM_C Text ID: Exception Definition using Domains

TEXC_FLD Text ID: Exception Definition using Table/Field

TEXC_FLD_C Text ID: Exception Definition using Table/Field

Regards

[Former Member]

Can you tell me Table name comination of USER & USERGRUOP

Regards

Rajednren.P

[RaymondGiuseppi]

user group was mentionned AQGDBBG SAP Query: User Groups

for users looka at USR01 or view USER_NAME

Regards.