How To Fix SV807 - Select no more than 99 fields for the list.

SAP Error Message - Details

• Message type: E = Error

• Message class: SV - View Maintenance: Customize Messages

• Message number: 807

• Message text: Select no more than 99 fields for the list.

What causes this issue?

The table or view contains &V1& fields.

System Response

No more than 99 fields can be output in the list.

How to fix this error?

Choose no more then 99 fields

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SV807 - Select no more than 99 fields for the list. ?

  The SAP error message SV807 ("Select no more than 99 fields for the list") typically occurs when you are trying to create a report or a list in SAP that includes more than 99 fields. This limitation is imposed by the SAP system to ensure performance and manageability of the data being processed.
  Cause:
  The error arises when a user attempts to select more than 99 fields in a report or list output. This can happen in various transactions or reports where users can customize the output fields, such as in the SAP Query, ABAP reports, or other reporting tools.
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Reduce the Number of Fields: Review the fields you have selected and remove any that are not essential for your report. Aim to keep the total number of fields to 99 or fewer.
  
  
  Use Multiple Reports: If you need to include more than 99 fields, consider breaking your report into multiple reports, each containing a subset of the fields.
  
  
  Create a Custom Report: If you have access to ABAP development, you can create a custom report that can handle more fields. This would involve writing an ABAP program that can fetch and display the required data without being limited by the 99-field restriction.
  
  
  Use Variants: If you are using a standard report, check if you can create variants that allow you to save different field selections for different purposes.
  
  
  Consult Documentation: Check the SAP documentation or help resources for the specific transaction or report you are using, as there may be additional tips or best practices for managing field selections.
  
  
  Related Information:
  
  SAP Notes: You can search for SAP Notes related to this error message in the SAP Support Portal. There may be specific notes that provide additional context or solutions based on the version of SAP you are using.
  Performance Considerations: Keep in mind that selecting a large number of fields can impact performance. Always aim for efficiency in your reports.
  User Training: If this error is common among users, consider providing training or guidelines on how to effectively select fields for reports.
  
  By following these steps, you should be able to resolve the SV807 error and create your desired report or list in SAP.