SAP Note 26466 - VKM4: Credit limit, performance

Symptom:

When you use Transaction VKM4 to select sales documents and deliveries from the credit point of view, long waiting times can occur.

Cause and prerequisites

Under certain circumstances, you need to set up secondary indexes for the database tables VBAK and LIKP.

Solution

The correction in Note 26464 or Release 2.2G or 3.0B is a requirement.
This is caused by missing secondary indices for the database tables VBAK and LIKP.The following contains examples of where the secondary indexes are necessary.

• All sales documents and deliveries should be selected which are outstanding, authorized or blocked from the point of view of credit and whose next shipping or goods issue date lies in the first half of the month of September 1995.
  ------------------------------------------------------------------
  from to
  Credit control area
  Credit management account
  Risk category
  Credit representative group
  Customer credit group
  
  Sales and distribution document
  Document statuses A B
  Total statuses A B
  Next shipping date 01.10.1995 15.10.1995
  Credit check next an/D date
  
  X sales documents
  X deliveries
  ------------------------------------------------------------------

A database index is necessary for the database tables VBAK and LIKP.The fields are VBAK-CMNGV and LIKP-CMNGV. Set up this index.

• All sales documents which are outstanding, which are authorized from the point of view of credit and for which the date of the next credit check lies in the first half of the month of September 1995 should be selected.This is necessary to recheck sales documents if schedule lines exist which were outside of the credit horizon when they were entered.
  ------------------------------------------------------------------
  from to
  Credit control area
  Credit management account
  Risk category
  Credit representative group
  Customer credit group
  
  Sales and distribution document
  Document statuses A B
  Total statuses A
  Next shipping date
  Credit check 01.10.1995 15.10.1995 next an/D date
  
  X sales documents
  Deliveries
  ------------------------------------------------------------------

A database index is necessary for the database table VBAK. The field is VBAK-CMNUP. Set up this index.

Additional key words

RVKRED02, credit limit