How To Fix 5Q004 - Supplementary pension fund & is missing in SPI table

SAP Error Message - Details

• Message type: E = Error

• Message class: 5Q - Error Texts for Public Sector

• Message number: 004

• Message text: Supplementary pension fund & is missing in SPI table

What causes this issue?

The entry for the supplementary pension fund is missing in table T5D5Z.

System Response

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

How to fix this error?

Go into table maintenance (transaction SM31) and maintain this entry in
table T5D5Z.
ODER
Maintain this entry in table <LS>SPF data</> (T5D5Z) via the initial
entry screen for the supplementary pension (transaction PU11).

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 5Q004 - Supplementary pension fund & is missing in SPI table ?

  The SAP error message 5Q004 indicates that there is a missing entry for a supplementary pension fund in the SPI (Supplementary Pension Information) table. This error typically arises in the context of payroll processing or when dealing with employee benefits related to pension funds.
  Cause:
  
  Missing Configuration: The supplementary pension fund may not be configured correctly in the system. This could be due to missing entries in the relevant tables or incorrect settings in the payroll configuration.
  Data Entry Errors: There may be errors in the employee master data or infotypes related to pension funds, leading to the system not being able to find the required information.
  Inconsistent Data: If there are inconsistencies between the employee's data and the configuration of the pension fund, the system may not be able to process the information correctly.
  
  Solution:
  
  
  Check Configuration: 
  
  Verify that the supplementary pension fund is correctly configured in the system. This includes checking the relevant tables (e.g., T5D1A for pension fund types) and ensuring that the fund is active and properly set up.
  Ensure that the SPI table (T5D1B) has the necessary entries for the supplementary pension fund.
  
  
  
  Review Employee Master Data:
  
  Check the employee's master data (infotypes 0001, 0002, 0587, etc.) to ensure that the supplementary pension fund is correctly assigned.
  Make sure that the employee has the correct infotype entries that correspond to the pension fund.
  
  
  
  Run Payroll Simulation: 
  
  After making the necessary corrections, run a payroll simulation to see if the error persists. This can help identify if the issue has been resolved.
  
  
  
  Consult Documentation: 
  
  Refer to SAP documentation or notes related to the specific error message for additional guidance and troubleshooting steps.
  
  
  
  Contact SAP Support: 
  
  If the issue persists after checking the configuration and employee data, consider reaching out to SAP support for further assistance.
  
  
  
  Related Information:
  
  Transaction Codes: You may need to use transaction codes like SE11 (Data Dictionary) to check table entries, or PA30 (Maintain HR Master Data) to review employee records.
  SAP Notes: Look for relevant SAP Notes that may address this specific error message or provide additional troubleshooting steps.
  User Forums: Consider checking SAP community forums or user groups for similar issues and solutions shared by other users.
  
  By following these steps, you should be able to identify and resolve the issue related to the 5Q004 error message in SAP.