How To Fix HRGB_GBSXP069 - Wage type &1 must be in table &2 to perform offsetting on &3

SAP Error Message - Details

• Message type: E = Error

• Message class: HRGB_GBSXP - Message for GBSXP

• Message number: 069

• Message text: Wage type &1 must be in table &2 to perform offsetting on &3

What causes this issue?

During the fourth processing phase of GBSXP, Statutory Absence Table
PC27J (MSA) entries have the OXP and Full Pay information added. (This
only happens if there are MSA entries.)
For each MSA entry, the OXP entries are derived from the feature COVER
(Determine Rule Group for the Refinement of Absences). The valuation
rules from COVER are then cross-referenced to table <ZK>Absence
Valuation</> (T554C) to derive which wage types should be in the Input
Table PC207 (IT) for the current period (or ORT, if we are looking at
the previous period).
The international payroll function PAB (Valuating Absences) only
creates entries on working days/hours if the customising specifies
working hours/days instead of calendar days. In this case, no check is
performed on non-working days after the application of Note 603847.
If however, you have managed to remove a OXP wage type from the IT (or
ORT) before GBSXP is processed, then this error message will be raised.

System Response

A permanent error has occurred during the processing of the payroll for
this employee. Payroll processing for the employee has been terminated.

How to fix this error?

This error is due to an error in the customising of your payroll
subschema for "Up to Gross" (that is, your copy of subschema GT00). You
should check whether:
1) You may have mistakenly put in a customer specific PCR before GBSXP
that has moved the wage type to RT, or
2) You may still have the redundant Personnel Calculation Rule GAB4 in
your schema, but before GBSXP.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HRGB_GBSXP069 - Wage type &1 must be in table &2 to perform offsetting on &3 ?

  The SAP error message HRGB_GBSXP069 indicates that a specific wage type (denoted as &1) is not found in the specified table (denoted as &2) when attempting to perform an offsetting operation on a specific object (denoted as &3). This error typically arises in the context of payroll processing or wage type management in SAP HR (Human Resources) modules.
  Cause:
  
  Missing Wage Type: The wage type specified in the error message is not defined in the relevant configuration table. This could be due to incorrect configuration or missing entries.
  Incorrect Configuration: The wage type may not be set up correctly in the payroll schema or may not be included in the relevant wage type tables.
  Data Entry Error: There may be a typo or incorrect entry in the payroll processing that references a wage type that does not exist in the system.
  
  Solution:
  
  
  Check Wage Type Configuration:
  
  Go to the transaction code SM30 or SM31 to access the relevant table (usually T512W for wage types).
  Verify if the wage type (&1) is present in the table (&2). If it is missing, you may need to create or configure it properly.
  
  
  
  Review Payroll Schema:
  
  Check the payroll schema being used to ensure that the wage type is included in the calculations. You can do this by using transaction code PE01 to access the schema and verify the inclusion of the wage type.
  
  
  
  Consult Documentation:
  
  Review SAP documentation or configuration guides related to wage types and payroll processing to ensure that all necessary steps have been followed.
  
  
  
  Check for Customizations:
  
  If your organization has custom wage types or specific configurations, ensure that these are correctly set up and that the wage type in question is included in any custom logic.
  
  
  
  Testing:
  
  After making any changes, perform a test run of the payroll process to ensure that the error does not occur again.
  
  
  
  Consult SAP Support:
  
  If the issue persists after checking the configuration and making necessary adjustments, consider reaching out to SAP support for further assistance.
  
  
  
  Related Information:
  
  Wage Type Tables: Common tables related to wage types include T512W (Wage Type) and T512T (Wage Type Text).
  Payroll Processing: Understanding the payroll process and how wage types are utilized can help in troubleshooting issues related to payroll calculations.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as PE01 (Schema Maintenance), SM30 (Table Maintenance), and PA03 (Maintain Payroll Areas).
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.