BACK

Customer/Vendor Integration: Resolving Tax Number Category Errors

customer vendor integration tax code category error

Here’s a quick reference guide to resolving tax number category error while running the customer/vendor integration with the synchronization cockpit. The customer/vendor integration is mandatory for systems transitioning to SAP S/4HANA and the topic seems to be not enough covered across SAP forums. The typical error log is displayed below.

tax number category errors in SAP

Figure 1: Error log (synchronization cockpit)

Tax numbers are sourced from the “Control Data” tabs of the customer (XD03) and vendor (XK03) masters, where the country code of the tax number category represents the country code of the business partner and the numerical sign represents reference number of the tax number field. For example, “SE1” represents “Tax Number 1” field of the Swedish customer or vendor. “0” reference number always represents the “VAT Reg. No.” field.

Figure 2: Customer master (XD03)

By default, system expects only some of these values filled, depending on the country settings delivered by SAP. Others should remain empty. For more information, you may refer to help (F1) for each tax number field – it would guide you into the references expected for each of these fields. Additionally, you can see the full list of expected tax codes in the TFKTAXNUMTYPE table.

Figure 3: Help on Tax Number 2 field (XD03)

Figure 4: TFKTAXNUMTYPE table (SE16N)

 

If the code, that the system is proposing while running the synchronization, is missing in the TFKTAXNUMTYPE table, you should first try with looking in an appropriate SAP Note. It is possible that the missing category is delivered with an SAP Note and you do not have to maintain it manually. In the case value is not delivered with SAP Notes, you should check an option of cleaning the values not expected. If you still would like to have them used, you would need to maintain those codes and assign checking rules via the table TFKTAXNUMTYPE maintenance view V_TFKTAXNUMTYPE.

  • TFKTAXNUMTYPE-TAXTYPE – ID of the tax number category, the one you are missing
  • TFKTAXNUMTYPE-CHECKFCT – Reference of the function module checking the tax number
  • TFKTAXNUMTYPE-TEXT – Name of the tax number category

There are two default function modules for checking tax numbers:

  • VAT_REGISTRATION_NUMBER_CHECK – the function module performs the VAT registration number check (“0” tax number categories)
  • BUPA_TAX_NUMBER_CHECK – the function module performs the tax number checks.

Figure 5: Maintaining a tax number category in the TFKTAXNUMTYPE table (SE16N)

Both function modules are sourcing the tax number check rules (check rule and length) out of the T005 table. The table contains a separate rule for each tax number. In the case the customer/vendor synchronization still doesn’t accept the numbers you have maintained in the customer or vendor master, it would make sense checking if these values have an appropriate format as per the T005 table.

Figure 6: Selection criteria of the T005 table (SE16N)

Figure 7: Contents of the T005 table (SE16N)

 

Once you have performed the necessary clean-up activities, adjustments and have maintained additional tax number categories, proceed with synchronization activities for the customer/vendor integration again.

Leave a Reply

Your email address will not be published. Required fields are marked *