How To Fix PZ851 - No suitable data could be selected in T042I and T042Y

SAP Error Message - Details

• Message type: E = Error

• Message class: PZ - Messages: Payment program for payment requests

• Message number: 851

• Message text: No suitable data could be selected in T042I and T042Y

What causes this issue?

No bank sub-account could be determined for the bank details.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message PZ851 - No suitable data could be selected in T042I and T042Y ?

  The SAP error message PZ851, which states "No suitable data could be selected in T042I and T042Y," typically occurs when the system is unable to find the necessary data in the tables T042I (which contains information about the currency types) and T042Y (which contains information about the currency conversion). This error is often encountered in the context of financial transactions, particularly when dealing with currency conversion or when trying to process financial documents.
  Causes:
  
  Missing Configuration: The most common cause is that the required currency types or conversion rates are not configured in the system. This could be due to missing entries in T042I or T042Y.
  Incorrect Settings: The settings for currency types or conversion might be incorrect or not aligned with the transaction being processed.
  Data Inconsistency: There may be inconsistencies or missing data in the relevant tables, which can lead to the system being unable to find suitable entries.
  Authorization Issues: Sometimes, the user may not have the necessary authorizations to access the required data.
  
  Solutions:
  
  
  Check Configuration:
  
  Go to transaction code OB08 to check the exchange rates and ensure that the necessary currency types are defined and have valid conversion rates.
  Use transaction code OBY6 to check the currency types in T042I and ensure that they are correctly configured.
  
  
  
  Review Table Entries:
  
  Use transaction code SE16 or SE11 to view the contents of tables T042I and T042Y. Ensure that the required entries exist and are correct.
  If entries are missing, you may need to create them based on your business requirements.
  
  
  
  Check User Authorizations:
  
  Ensure that the user has the necessary authorizations to access the relevant data. This can be checked with your SAP security team.
  
  
  
  Consult Documentation:
  
  Review SAP documentation or notes related to currency configuration and the specific error message for any additional guidance or updates.
  
  
  
  Contact SAP Support:
  
  If the issue persists after checking the above points, consider reaching out to SAP support for further assistance. They may provide specific notes or patches that address the issue.
  
  
  
  Related Information:
  
  
  Transaction Codes:
  
  OB08: Maintain exchange rates.
  OBY6: Define currency types.
  SE16 or SE11: View table contents.
  
  
  
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide additional troubleshooting steps.
  
  
  Documentation: Review the SAP Help Portal for documentation on currency configuration and related financial processes.
  
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.