Start of Content Area

Procedure documentation Switch Access Optimization On/Off  Locate the document in its SAP Library structure

Use

If a query returns incorrect results and the suspected cause is an incomplete reference list, then a query report can be generated without access optimization.

See Access Optimization in Queries

Prerequisite

You are in the Query: Title, Format screen in the Sap Query → Queries component.

Procedure

To test a query with access optimization, proceed as follows:

  1. Choose the function Extras ® Additional Special Attributes.

    2. The Additional Special Attributes window is opened.Mark the No Access Optimization checkbox and click Continue This graphic is explained in the accompanying text.

  2. Use the Test This graphic is explained in the accompanying text function to test the query.

Access optimization can be reactivated either by calling up the Extras ® Additional Special Attributes function again or by deselecting the check box.

Note

The access optimization should be deactivated only for test purposes. If the query works correctly when the access optimization is deactivated then the InfoSet must be investigated and corrected so that a complete reference list gets generated (see Access Optimization in Queries). If the query does not work correctly even with the access optimization deactivated then the problem is caused by something else.

Following a test without access optimization and any necessary processing of the InfoSet, you should always switch access optimization on again. If you do not do this you will see a considerable drop in performance.

 

 

 End of Content Area