How To Fix 70005 - Only one currency entry found for &1 in table T500W


SAP Error Message - Details

  • Message type: E = Error

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

  • Message number: 005

  • Message text: Only one currency entry found for &1 in table T500W

  • Show details Hide details
  • 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, only one currency entry is available for the 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.


Smart SAP Assistant

  • What is the cause and solution for SAP error message 70005 - Only one currency entry found for &1 in table T500W ?

    The SAP error message "70005 Only one currency entry found for &1 in table T500W" typically indicates that there is an issue with the currency configuration for a specific wage type or payroll area in the SAP system. This error arises when the system expects multiple currency entries for a particular configuration but finds only one.

    Cause:

    1. Missing Currency Configuration: The error often occurs when the currency configuration for a specific wage type or payroll area is incomplete or missing in the T500W table.
    2. Incorrect Payroll Area Setup: If the payroll area is not set up correctly to handle multiple currencies, it can lead to this error.
    3. Data Inconsistency: There may be inconsistencies in the data related to the wage types or payroll areas, leading to the system not being able to find the expected entries.

    Solution:

    1. Check Table T500W:

      • Go to transaction SE16 or SE11 and check the entries in table T500W for the specific wage type or payroll area indicated by the error message. Ensure that the necessary currency entries are present.
    2. Maintain Currency Entries:

      • If there is only one currency entry, you may need to add the required currency entries for the wage type or payroll area. This can typically be done through the configuration settings in the SAP system.
      • Use transaction SPRO to navigate to the relevant configuration path:
        • Payroll -> Payroll: General Settings -> Define Wage Types and ensure that the wage types are correctly configured with the necessary currencies.
    3. Review Payroll Area Configuration:

      • Ensure that the payroll area is correctly set up to handle multiple currencies. This can also be checked in the configuration settings.
    4. Check for Data Consistency:

      • Run consistency checks or reports to identify any discrepancies in the payroll data that might be causing the issue.
    5. Consult Documentation:

      • Review SAP documentation or notes related to this error message for any specific guidance or updates that may apply to your version of SAP.
    6. Contact SAP Support:

      • If the issue persists after checking the above points, consider reaching out to SAP support for further assistance.

    Related Information:

    • Table T500W: This table contains the currency settings for wage types in the SAP payroll module.
    • Transaction Codes: Familiarize yourself with relevant transaction codes such as SE16 (Data Browser), SE11 (Data Dictionary), and SPRO (SAP Reference IMG) for configuration.
    • SAP Notes: Check for any SAP Notes that may address this specific error or provide additional troubleshooting steps.

    By following these steps, you should be able to resolve the error message and ensure that your currency configurations are set up correctly in the SAP system.

    • Do you have any question about this error?


      Upgrade now to chat with this error.


Instant HelpGet instant SAP help. Start your 7-day free trial now.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo simplifies finding the accurate answers to SAP message errors. I now use every week. A must have tool for anyone working with SAP! Highly recommended!
Rate 1
Kent Bettisworth
Executive SAP Consultant