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
- Go to the 'Maintain Business Partner' app.
- Open the Business partner.
- Open the Supplier in 'Display BP Role'.
- Navigate to the Company Code tab.
- 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