SAP ABAP Message Class VT Message Number 611 (Unfavorable sequence of fields - Possible performance problems)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BF (Application Component) Basic Functions
     VA0C (Package) Customizing R/3 sales
Attribute
Message class VT  
Short Description SD Tables    
Message Number 611  
Documentation status       Space: object requires documentation
Authorization check Error Message      
Changed On 20130531   
Message Text
Unfavorable sequence of fields - Possible performance problems
Help Document

Diagnosis

In access sequence , 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.

Procedure

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

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.

History
Last changed on/by 20140121  SAP 
SAP Release Created in