How To Fix VT611 - Ungünstige Reihenfolge der Felder. Performanceprobleme möglich

SAP Error Message - Details

• Message type: E = Error

• Message class: VT - Vertriebstabellen

• Message number: 611

• Message text: Ungünstige Reihenfolge der Felder. Performanceprobleme möglich

Was verursacht dieses Problem?

In <GL:access_sequence>access sequence</> &V1& &V2&, the system
determined an unfavorable sequence of the fields.
In addition, there is a header field after an item field. This may be
disadvantageous to performance when you use the prestep.

Systemantwort

The system tries to avoid future performance problems.

Wie behebe ich diesen Fehler?

Consider whether the fields of access sequence &V1& &V2& or the
underlying condition table can or should be changed.

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Defining the prestep
Specifies whether the system searches for valid condition records by at
first only checking the document header data.
Usage
This function improves the performance. Using the prestep, you
determine whether the system at first only uses the document header
data to search for condition records. This preliminary search
determines whether it is necessary to check the item data. This
function does not influence the result of the search. It may speed up
the search process. The function should only be used for accesses of
access sequences whose key combination includes header and item data
(e.g. customer-material discounts).
Procedure
In order to determine whether you should use the prestep function, you
can consider the following factors:
average number of items in a document (the more items, the greater the
benefit of the prestep)
degree of probability that the system finds valid records during the
search of the header data (the lower the probability, the greater the
benefit of this function - see the following example)
Example
In pricing, you use a customer-material discount. The condition records
that you created are based on customer data from the document header
and material data from each document item. However, the discount is
only valid for 2% of your customers. This means that in 98% of all
cases, the system does not find a valid condition record, not taking
into account the items in the document. In this case, the system should
carry out a preliminary search, only taking into account the header
data.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE