FAQ: SAP Query

[1] When is a conversion required?

You must perform a conversion after a release upgrade from 3.1x to Release 4.0x or higher or after a client copy if necessary.
           * After a release upgrade, proceed in accordance with Note 92124.
           * Start report RSAQUM40 after a client copy and set the "release indicator".

[2] Copying between query areas

You can call transaction SQ03 and choose the menu path "Environment" -> "Transports" to copy the query objects between query areas. You can copy queries from the standard area (client-specific) to another standard area using export/import.

[3] Finding quick views

Quick views are user-specific objects. To make a quick view generally available, you must convert it into a query. To do this, go to transaction SQ01 and select a corresponding user group. Choose the menu path "Query"->"Convert QuickView" to copy the quick view to a query that is accessible to all users in the user group. Since quickviews are client-specific objects, this function can be used only within the standard area of the query.

[4] Starting a query via a transaction

Calling a generated query source code (AQ* report) from transaction SE38 or using transaction SE93 can result in errors if the query was not generated after a change or the corresponding program was not found. Calling via the function modules described in Note 393160 avoids these errors or generates the query before the call.

[5] Assigning a query to another InfoSet (extended copy functions)

The standard copy functions of transactions SQ01 and SQ02 were extended by report RSAQCOPY. For example, you can copy an InfoSet including all dependent queries or copy a query into another InfoSet. For more information, see Note 324393.

[6] Report-report interface interface (BBS)

You can use the report-report interface to go directly from the output of the data selected by the query (sender) to the corresponding application transaction (receiver, for example VA03). The system transfers the data from the query to the selection screen that was called if possible. You can also use the query itself as a receiver for other selections. For more information, see Note 50629.

[7] Inconsistency in query objects

Changes in the ABAP Dictionary (change in field length or field type) may result in problems when generating the functional area and/or query. First adjust the InfoSet via transaction SQ02 and the menu path "InfoSet" -> "More functions" -> "Adjust". You can then adjust the query using transaction SQ01 and choosing the menu path "Query" -> "More functions" -> "Adjust".

For more information

[8] For more information about displaying technical fields using the background TECH command in the ok_code, see Note 443727.

[9] For more information about this topic, see Note 451216. 

This note provides you with an exact method of analyzing whether duplicate lines are really issued.

[10] The system has the settings: "Changes to cross-client objects are not allowed".

a) Creating or changing in the global query is not possible with this setting.  Queries and Infosets should be created in the development system or Quality assurance system and should be transported from there to the production system.
b) Infosets and queries can be created in the standard area.

[11] Queries can be called using transactions (see Note 393160). 

Only specific function modules take the role assignment (SAP_QUERY_AD_HOC_ROLE) into account. Transaction PAAH calls the function module SAP_CALL_QUERY_AD_HOC, which does not take the role assignment into account. Instead of using this transaction, you should call the Ad Hoc Query using the SAP Easy Access menu (see Note 761160).

[12] The standard selections are generated dynamically by the ABAP runtime. 

This depends on the segments of the logical database that you use. For this reason, we cannot guarantee that the additional source code is correct for each query that is based on this InfoSet. Therefore, you cannot access standard selections.

Inmortalizado desde h_tp://www.saptechies.com/faq-sap-query/ pero ya no existe!