Show TOC

Define SAP Queries

Standard Financial Accounting reports are contained in a report selection tree. Some of these reports have been created using ABAP Query. In this activity you define any new ABAP queries for Financial Accounting.

Standard Settings

SAP delivers various standard queries for Financial Accounting (such as G/L account list). These queries are within the global work area in which the query objects are non-client-specific and are connected to the Workbench Organizer. You can use these queries directly.

If you want to change queries, you should copy them into your own user groups.

There are queries for customer, vendor, and G/L accounts per user group and per functional area as well as five sample queries delivered with the standard system. These sample queries are linked to the report trees for account types in master data evaluations. You can insert evaluations created by users or the IT department into the standard report trees or user-defined reporting trees.

The standard delivery encompasses the following components:

1. User groups /SAPQUERY/FD (FI A/R evaluations), /SAPQUERY/FK (FI A/P evaluations), /SAPQUERY/FS (FI G/L evaluations)
2. Functional areas /SAPQUERY/FIDD (FI A/R evaluations), /SAPQUERY/FIKD (FI A/P evaluations), /SAPQUERY/FISD (FI G/L evaluations)
3. Sample queries F1 customer address list, F2 customer telephone list, F1 vendor address list, F2 vendor telephone list, F1 G/L account list

Activities

1. Assign all R/3 users who make Financial Accounting queries to user groups /SAPQUERY/FD, /SAPQUERY/FK and /SAPQUERY/FS by accessing the "Define queries" activity in IMG and then choosing Environment -> User group.
2. Define queries to fit your requirements.
a) Copy the required queries into your own user groups.
b) Modify the standard queries for Financial Accounting.

Further Notes

For more information on ABAP Queries, see the SAP Library under Basis -> ABAP Development Workbench.