Hierarchy
BBPCRM (Software Component) BBPCRM⤷
CRM-MD-BP (Application Component) Business Partners⤷
FB0C (Package) Financial Accounting customers
IMG Activity
| ID | SIMG_CFORFBSQ02A | Define SAP Queries |
| Transaction Code | S_ALR_87001908 | IMG Activity: SIMG_CFORFBSQ02A |
| Created on | 19981222 | |
| Customizing Attributes | SIMG_CFORFBSQ02A | Define SAP Queries |
| Customizing Activity | SIMG_CFORFBSQ02A | Define SAP Queries |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | SIMG_CFORFBSQ02A |
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:
- User groups /SAPQUERY/FD (FI A/R evaluations), /SAPQUERY/FK (FI A/P evaluations), /SAPQUERY/FS (FI G/L evaluations)
- Functional areas /SAPQUERY/FIDD (FI A/R evaluations), /SAPQUERY/FIKD (FI A/P evaluations), /SAPQUERY/FISD (FI G/L evaluations)
- Sample queries F1 customer address list, F2 customer telephone list, F1 vendor address list, F2 vendor telephone list, F1 G/L account list
Activities
- 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.
- Define queries to fit your requirements.
- Copy the required queries into your own user groups.
- Modify the standard queries for Financial Accounting.
Further notes
For more information on ABAP Queries, see the SAP Library under Basis -> ABAP Development Workbench.
Business Attributes
| ASAP Roadmap ID | 207 | Establish Reporting |
| Mandatory / Optional | 1 | Mandatory activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | SIMG_CFORFBSQ02A | 0 | HLA0006514 O HLA0006504 |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| IMGDUMMY | D - Dummy object | SQ00 | FIQUERIES4 | Define SAP Queries |
History
| Last changed by/on | SAP | 19981222 |
| SAP Release Created in |
