How To Fix 3G650 - Wage type &1 exists more than once in table T52LIDIBASE

3G650 - Overview

• Message type: E = Error

• Message class: 3G - Payroll: International

• Message number: 650

• Message text: Wage type &1 exists more than once in table T52LIDIBASE

What causes this issue?

Wage type &1 exists in table T52LIDIBASE more than once as a liability
wage type.
A liability wage type may only exist once in the table. It does not
matter whether the wage type is the main liability or part of a wage
type package.
The wage types that are processed together with other liabilities as a
wage type package are to be entered as a liability wage type in the
detail view in the blocks "Distribtution Basis 2" and "Distribtution
Basis 3".

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?

Check both the overview and detail view.
Wage type &1 exists at least once as a "Liability Wage Type" in the
"Distribution Basis 2" block or in the "Distribution Basis 3" block in
the detail view. Ensure that each wage type exists only once.

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 3G650 - Wage type &1 exists more than once in table T52LIDIBASE ?

  The SAP error message 3G650 indicates that a wage type (represented by &1) exists more than once in the table T52LIDIBASE. This typically occurs in the context of payroll processing, where wage types are used to define various components of employee compensation.
  
  Cause:
  The error arises when there are duplicate entries for a specific wage type in the T52LIDIBASE table. This can happen due to:
  
  Incorrect configuration in the payroll schema.
  Manual data entry errors leading to duplicate wage types.
  Issues during data migration or system upgrades that result in duplicate records.
  
  
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Check for Duplicates:
  
  Use transaction SE16 or SE11 to view the contents of the T52LIDIBASE table.
  Execute a query to find all entries for the specific wage type that is causing the error. You can use a simple SQL query like:SELECT * FROM T52LIDIBASE WHERE WT = '&1';
  
  Replace &1 with the actual wage type code.
  
  
  
  Identify and Remove Duplicates:
  
  Once