SAP Knowledge Base Article - Public

3606039 - Error When Assigning Same Withholding Tax Type for Different Tax Codes in SAP S/4HANA Cloud Public Edition

Symptom

While trying to assign the same withholding tax type for different tax codes, an error occurs stating: "Table LFBW_NEW: Duplicate entry with key".

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Go to the 'Maintain Business Partner' app.
  2. Open the Business partner.
  3. Open the Supplier in 'Display BP Role'.
  4. Navigate to the Company Code tab.
  5. In 'Vendor: Withholding Tax' Tab, add same tax types twice and click on enter. The error occurs: 'Table LFBW_NEW: Duplicate entry with key'.

Cause

This is a system standard Design.

Resolution

The system is designed for withholding tax to be used only once. Withholding Tax code is a primary key, which means it only takes unique entries. If tax type A is used with tax code A, then it is not possible to use the same tax type A for another tax code B. Understand that the system only allows unique entries for withholding tax codes.

If additional tax codes need to be used, a different withholding tax type should be used.

Keywords

Withholding tax, tax code, tax type, duplicate entry, business partner, SAP S/4HANA Cloud Public Edition, error, maintain business partner app, vendor, withholding tax tab, unique entries. , KBA , LO-MD-BP-2CL , Business Partners for Public Cloud , Problem

Product

SAP S/4HANA Cloud Public Edition all versions