Ansicht
Dokumentation

/BCV/QRM414 - Query &1: No mass selection possible using sec. field &3 in join crit. &2 - /BCV/QRM 414

BAL Application Log Documentation   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Diagnosis

In query , you have created the join criterion that uses input field of the secondary search connector . For this field, only selection mode Single Value or Interval is available. This means that the system cannot pass a set of field values to search connector in one search request.

System Response

When processing a join, the system collects all different values returned by the output field of the primary search connector corresponding to field . Since it can only pass one field value to search connector at a time it might have to call the search connector multiple times. Depending on the data provision technology and the amount of data inside the data provider this may result in long runtimes or even in aborting query processing due to lack of memory.

Procedure

To avoid the problem, pay attention to the following:

• Use query fields with selection modes Single Value or Interval as input field in join criteria only in exceptional cases.

• Use a fast data provision technology.

• Use a small set of field values to be passed to the secondary search connector (not more than 10).

• If possible, look for an equivalent search connector that can handle the problematic field in selection mode Multiple Values or Select Option.

If you have to use search connector , ensure the following:

• You have set the MaxExec (Maximum Number of Executions of Secondary Search Connector) feld of the query join definition to the maximum number of calls of the search connector that you consider acceptable.

• You have checked whether setting the Dld. Sel. (Delayed Selection by Optional Input Fields Allowed) indicator of the query join definition could reduce the number of necessary calls.

Procedure for System Administration

General Data in Customer Master   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 2530 Date: 20240427 Time: 024547     sap01-206 ( 50 ms )