How To Fix 70007 - More than two currency entries found for &1 in table T500W

70007 - Overview

• Message type: E = Error

• Message class: 70 - HR: Messages in Master Data Reporting

• Message number: 007

• Message text: More than two currency entries found for &1 in table T500W

What causes this issue?

Table T500W <LS>Valid Country Currencies</> is not maintained properly.
This table specifies the validity period for both the the old national
currency and the euro for the country that is about to convert. The
dual-currency phase arises out of these two entries.
At the moment, there are more than two currency entries available for
country key &V1&.

System Response

The system terminates the process. You can use the selection screen to
make new entries.

How to fix this error?

Specify the validity period for the old national currency and the euro
for the country key &V1& in table T500W <LS>Valid Country
Currencies</>.
You will find further information about pay scale or payroll currency
conversion in the documentation of report <DS:RE.RPUEMU00>RPUEMU00</>
or <DS:RE.RPUEMUXX>RPUEMUXX</>.

Error message extract from SAP system. Copyright SAP SE.

70007 - Details

• The SAP error message 70007, which states "More than two currency entries found for &1 in table T500W," typically occurs when there are multiple currency entries for a specific country in the T500W table, which is used for currency conversion and exchange rate determination in SAP.
  
  Cause:
  The error is caused by the presence of more than two currency entries for a specific country in the T500W table. This can happen due to:
  
  Data Entry Errors: Incorrect or duplicate entries may have been made in the T500W table.
  
  Configuration Issues: The system may have been incorrectly configured to allow multiple currencies for a single country.
  Migration Issues: If data was migrated from another system, it may have resulted in duplicate or incorrect entries.
  
  
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Check the T500W Table:
  
  Use transaction code SE16 or SE16N to view the T500W table.
  Filter the entries by the country code that is causing the error