How To Fix FMRP100 - Only & entries were selected from the database

SAP Error Message - Details

• Message type: E = Error

• Message class: FMRP - Message Class Information System

• Message number: 100

• Message text: Only & entries were selected from the database

What causes this issue?

The maximum number of hits &V1& for lines of tranaction data was read
when the database was accessed.
The amount of data displayed can be lower than the maximum number of
hits because the selected data is processed further or aggregated in the
program.

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

System Response

How to fix this error?

If the object you are looking for is not displayed, but the number of
objects displayed corresponds to the number of hits specified, proceed
as follows:
If you have executed the report <LS>document journal</>, read the notes
on using the maximum number of hits in the section "Performance" of the
<DS:RE.RFFMEPGAX>report documentation</>
If you have executed a report that evaluates budget data, increase the
number of hits.
If you execute your own report, note that the logical database selects
the transaction data in the following order: FMOIX, FMFIX, FMCOX, BPEP,
EPBY, EPBT.
Then increase the number of hits or limit the selection according to
<DS:GLOS.3526B992AFAB52B9E10000009B38F974>value type</>.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FMRP100 - Only & entries were selected from the database ?

  The SAP error message FMRP100 ("Only & entries were selected from the database") typically occurs in the context of the SAP Funds Management (FM) module. This message indicates that a query or report has returned a limited number of entries from the database, which may not meet the user's expectations or requirements.
  Cause:
  
  Data Selection Criteria: The selection criteria used in the report or query may be too restrictive, leading to a limited number of records being retrieved.
  Data Availability: There may simply be a limited number of entries in the database that meet the specified criteria.
  Authorization Issues: The user may not have the necessary authorizations to view all relevant entries, resulting in fewer records being displayed.
  System Performance: In some cases, performance issues or database constraints may limit the number of records returned.
  
  Solution:
  
  Review Selection Criteria: Check the selection parameters used in the report or query. Consider broadening the criteria to include more records.
  Check Data Availability: Verify that there are indeed more entries in the database that should be returned. You can do this by running a different query or checking the relevant tables directly.
  Authorization Check: Ensure that the user has the appropriate authorizations to view all relevant entries. This may involve checking user roles and permissions in the SAP system.
  Consult with IT Support: If the issue persists, it may be beneficial to consult with your IT support team or SAP Basis team to investigate any underlying system or database issues.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes in SAP FM, such as FMAVCR01 (for budget availability control) or FMFMD (for funds management documents).
  SAP Notes: Check SAP Notes for any known issues or patches related to the FMRP100 message. SAP Notes can provide additional context or solutions for specific scenarios.
  Documentation: Review SAP documentation related to Funds Management for best practices on data selection and reporting.
  
  By following these steps, you should be able to address the FMRP100 error message effectively. If the problem continues, further investigation into the specific context of the error may be necessary.