How To Fix 70029 - Table &1 contains foreign currency &3 in field &4 of data record &2

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 029

• Message text: Table &1 contains foreign currency &3 in field &4 of data record &2

What causes this issue?

Foreign currency &3 is entered in the data record.
Take note of the following example for illustratory purposes:
"Table PA0008 contains the foreign currency USD in WAERS field of data
record 000657210 9999123119971201000"
The data record is composed as follows:

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

Personnel number: 65721
Subtype: 0
Object identifier: blank
Lock indicator for HR master record: blank
End date of the validity period: 31.12.1999
Start date of the validity period: 01.12.1997
Number of infotype record with same key: 000
The amount fields that refer to field <LS>WAERS</> (Currency Key) are
not processed.
You will find further information about pay scale currency conversion
in the documentation of report <DS:RE.RPUEMU00>RPUEMU00</>.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message 70029 - Table &1 contains foreign currency &3 in field &4 of data record &2 ?

  The SAP error message 70029 indicates that there is an issue with foreign currency data in a specific table. The message typically means that the system has encountered a foreign currency value that is not valid or is not properly configured in the specified field of the data record.
  Cause:
  
  Invalid Currency Configuration: The currency specified in the data record may not be defined in the system or may not be allowed for the particular transaction or table.
  Data Entry Error: There may be a mistake in the data entry where an incorrect currency code is used.
  Missing Currency Translation: If the system is set up to handle multiple currencies, there may be missing exchange rates or translation settings.
  Inconsistent Data: The data being processed may not be consistent with the expected formats or values for the specified table.
  
  Solution:
  
  
  Check Currency Configuration:
  
  Verify that the currency code specified in the error message is correctly defined in the system. You can check this in the transaction code OB08 (for maintaining exchange rates) or OBY6 (for currency settings).
  
  
  
  Review Data Entry:
  
  Inspect the data record mentioned in the error message. Ensure that the currency code in field &4 of data record &2 is correct and corresponds to a valid currency in the system.
  
  
  
  Update Exchange Rates:
  
  If the currency is valid but the error persists, check if the exchange rates for the currency are maintained. You can do this in the transaction code OB08.
  
  
  
  Data Consistency Check:
  
  Ensure that the data being processed is consistent with the expected formats. If you are importing data, validate the data file for any discrepancies.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for specific details about the table &1 and its requirements regarding currency fields.
  
  
  
  Contact Support:
  
  If the issue persists after checking the above points, consider reaching out to your SAP support team or consulting SAP Notes for any known issues related to this error message.
  
  
  
  Related Information:
  
  Transaction Codes: 
  
  OB08 - Maintain Exchange Rates
  OBY6 - Define Currency Settings
  
  
  SAP Notes: Search for relevant SAP Notes that may address this specific error message or provide additional troubleshooting steps.
  Documentation: Review the SAP Help Portal for detailed information on currency handling and configuration in SAP.
  
  By following these steps, you should be able to identify and resolve the issue causing the error message 70029.