How To Fix VT611 - Unfavorable sequence of fields - Possible performance problems

SAP Error Message - Details

• Message type: E = Error

• Message class: VT - Vertriebstabellen

• Message number: 611

• Message text: Unfavorable sequence of fields - Possible performance problems

What causes this issue?

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.

System Response

The system tries to avoid future performance problems.

How to fix this error?

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

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

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.

Error message extract from SAP system. Copyright SAP SE.