Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about the production and analysis of SAP Query Reproting. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

1. Overview

SAP Query provides us with three Query tools: SAP Query, InfoSet (Ad Hoc) Query, and QuickViewer. What we usually call Query Report without specific reference is SAP Query, because it is more powerful than the other two tools.

Characteristics of InfoSet Query:

The report generated by Quick Viewer is a user-defined report, which can only be used and maintained by the user.

Quick Viewer can only use data stored in the database and cannot be calculated (except subtotals and accumulations).

Provide interface with SAP internal tools such as EIS,ABC,ALV and external tools such as Word,Excel.

Unified management of user groups and Functional area is not required and cannot be utilized.

Unable to transmit

Special features of SAP Query:

The management of Query includes establishing Functional area (functional area) and User Group (user group), and assigning the functional area to the corresponding user group.

The Functional area (ribbon) defines the tables and fields to be referenced in the query.

Queries can be created and run only if a user belongs to at least one user group. A user can belong to several user groups. Users in the user group have the same rights.

When the Functional area (ribbon) is assigned to a user group, members of that user group can access the ribbon.

One Functional area (ribbon) can be assigned to multiple user groups; multiple Functional area (ribbon) can be assigned to one user group.

Queries is usually built for specific user groups and specific ribbons. Users of this user group can access all Queries assigned to this user group.

two。 SAP Query is explained by example operation.

To put it simply, making a SAP Query can use three transaction codes: SQ03 (create user groups and assign users), SQ02 (create InfoSet and assign to user groups), and SQ01 (use information sets to generate Query Reporting in assigned user groups).

2.1 create user groups and assign user Tcode:SQ03

Figure1-1: create a new user group

Figure1-2: save new user groups

Figure1-3: assign users to new user groups

2.2 create an InfoSet and assign it to the user group Tcode:SQ02

Figure2-1: create a new InfoSet

Figure2-2: savin

Figure2-3: assign InfoSet to user groups

Figure3: specify the data source and its type.

Figure4: if you use "include key fields", InfoSet will automatically bring in the key value field of the data source, and of course you can use the other two options, but that will look a little weird.

Figure5-1: convert display and change

Figure5-2: check for errors

Figure5-3: generate information set InfoSet (important)

Figure5-4: connection (data source connection can be added, more important)

Figure5-5: additional (you can add global fields, code control fields, control the selection screen, etc., important)

Figure5-6: view additional code

Figure5-7: add field groups (which can be used to group fields when there are a considerable number of fields in the information set)

Figure6-1: add a field group and pull in a new field Bseg-DMBTR. Drag the field on the left into the information set InfoSet on the right, or right-click the information set InfoSet field to delete it. When the operation is complete, click the save button and click the generate button to generate the information set.

Click Figure2-3 to assign the information set InfoSet to the user group.

2.3Create Query Reporting Tcode:SQ01

Figure7-1: go to the user group where the information set belongs (Query Reporting can be seen as a report derived from the information set, so the first step should be to find the information set first. SQ02 has assigned it to a user group, so you should use this button to go to this user group first. It is important)

Figure7-2: testing Query Reporting

Figure7-3: name the new Query Reporting

Figure7-4: click create

Figure7-5: quick browser (here is the QuickViewer mentioned in the overview)

Figure7-6: information set query (here is the InfoSet mentioned in the overview)

Figure7-7:Query Reporting list

Figure8: click the next page or press F6 after changing the title and format of the query

Figure9: change the group of selected fields for Quick Browse (this page can be left unchanged by default because it will be set again on the next page)

Figure10: select the search field.

Figure11-1: if you put the check mark in this check box, prepare only one entry field in the selection field. Select the button for multiple selections to attach fields, which is available to ensure that you use this feature to make multiple selections. If you want to deactivate the multiple selection feature, place the check mark in the check box.

Figure11-2: if you select this check box, you can specify a single value or interval on the selection screen. Select the extra screen button "multiple selections" is not available, effectively prevent multiple selections. If you want to restrict the selection so that only a single value is allowed, also place a check mark in the first check box.

Note: it is not possible to set whether the search condition must be lost. If you need to set it, you can set it in the SQ02 information set, which we will talk about later.

When the next page button is grayed out, click basic list. There are two formats for the display of the basic list, one is the graphic query plotter format design, the other is the non-graphical query plotter format design. They can be selected by selecting the check box on the menu "Settings-Settings-graphic query plotter", which is selected by default in SAP V4.6 or later SAP Query, which represents a WYSIWYG design format.

Figure12-1: turns on or off all tools (including sort fields, total fields, calculated fields, toolboxes, etc.). Important)

Figure12-2:Query Reporting display fields (the order of ticks is important)

Search fields for Figure12-3:Query Reporting

Figure12-4: the width, position and even color of the field can be set in the box below)

Figure12-5: gadgets that are already open (field values that can be dragged into the mini-toolbar, such as dragging "ABCDEFGHIJ" below the "voucher number" field into the sorting gadget)

Tip: if Query Reporting has a large number of fields and the display order is not easy to set, you can click Figure7-6 and then drag the column with the mouse until you are satisfied.

Test or save the Query Reporting.

3.Query Reporting advanced application

3.1 add global fields and use code to control the value (multi-table association) TCODE:SQ02

Figure13-1: click "attach"

Figure13-2: create a new field (this is a global field, not a local field. All Query Reporting generated using this information set InfoSet can see this field)

Figure14: add Z_period, which means to show the accounting period of the voucher. (because Bseg does not contain information for the accounting period, while BKPF does)

Figure15: set simple parameters for Z_period.

Click Figure13-3: go to the additional code

Figure16: enter the above code in the code attachment box, click Save and check. Pull the "Z_period" field under the "additional field" from the left data source to the information set, save it and generate it.

Figure12-2: check the Z_period below and check it.

Add global fields and use code to control values (arithmetic query results) TCODE:SQ02

Figure17: you can use simple statements to perform arithmetic operations on query results in code attachments. Other operations such as 3.1 operation.

3.3 set radio required TCODE:SQ02 for search fields

Figure18-1: click "attach"

Figure18-2: select the "Select" tab

Figure18-3: new

Figure18-4: enter a name in the create selection window and select Select Metrics

Figure19: the format "FOR" input will be set to a radio required input field; enter "OBLIGATORY NO-EXTENSION NO INTERVALS" in the attachment. Just save it.

3.4 add a local field and set a simple property SQ01

Click the menu in Figure10: edit-short name-Open / close

Figure20: enter a custom short name.

Click the menu "Edit-partial fields-create".

Figure21: enter the above in the Field definition window.

Figure22: select the "Local additional Field-amount (partial)" you just created in the basic list, and run the test.

Figure23: added the query result of "amount (partial)".

3.5 add a local field and set the icon property SQ01

Figure24: select "symbol" for the attribute, enter the condition in the condition box, and select a symbol to save.

Figure25: output result

3.6 attach operations to query results (using TR)

Click the Figure5 menu "go to-report assignment"

Figure26-1: click "insert Row"

Figure26-2: click "other report types"

Figure27-1: select TR transaction

Figure28: enter FB03 and save to double-click the query results to find the voucher.

3.7 attach operations to query results (using RT)

If you want to achieve more complex operations on the query, then choose Figure27-2 to use the "RT ABAP reporting program". The prerequisite for choosing this type is that you have written an ABAP reporting program. For example, I wrote a small program using SE38 to double-click the query line item to find the credential.

* &-- *

* & Report Z_QUERY_DELANO1

* &

* &-- *

* &

* &

* &-- *

REPORT Z_QUERY_DELANO1.

PARAMETER: z_BELNR like bseg-BELNR

Z_BUKRS like bseg-BUKRS

Z_GJAHR like bseg-GJAHR.

Set PARAMETER ID 'BLN' FIELD Z_BELNR.

Set PARAMETER ID 'BUK' FIELD z_BUKRS.

Set PARAMETER ID 'GJR' FIELD Z_GJAHR.

Call TRANSACTION 'FB03' AND SKIP FIRST SCREEN.

After clicking Figure27-2, enter the Report name you wrote in advance in Figure29 and save it.

Double-clicking a line item in the query results will pop up a window that allows you to select the action to be performed. "Show credentials" is the FB03 added using the TR transaction, and "Z_QUERY_DELANO1" is the program added using the RT ABAP reporting program, both of which can implement additional operations to the query results (such as joint checking credentials).

After reading the above, do you have any further understanding of the production and analysis of SAP Query Reproting? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.