SAP HR DTONI: how it can be used for NI Data Take On and Adjustments

Using DTONI to update the NI Data

For the UK payroll, the table T5G_DTONI is used for both data take-on and adjustments (usually year end) for National Insurance (NI) data for employees.

Within the table, you will notice that there is a field called Niable Pay. This is the total Niable Pay and will, in most cases, equal the sum of all the values used in the band thresholds. If the 2 don’t add up then go back to the business to check the values for both.

Ensuring that you have data in the DTONI table is the easiest way of making adjustments to the CNIC table and ultimately the employee’s NI pay. There are other backdoor bespoke methods which are used in exceptional cases.

You should be able to edit the table in all clients using transaction SM30 (table maintenance). To be able to know which values to enter, take a look at the payroll results for the period which you would like to adjust and look at the results in the CNIC table.

Remember also that in the table you need to use the actual pay date for the employee and that any negative values are entered with the minus sign after the value e.g. 374.87-

Differences between the CRT and CNIC for NI contributions

You may find that you have the following situation.

The CNIC table for the employee’s NI contributions is not the same as the values held on the CRT.

You might ask the question, should you adjust the CNIC at year end if the tables are different?

The answer is that you don’t need to make any adjustments to the CNIC if the employer has paid over arrears of NI as identified in the NIRA table. This is due to the fact that the P14 and P35 figures are shown in the CNIC and not the CRT. The amount paid over to the Inland Revenue each month is based on the actual amount deducted from the employees (for example the running total will be as per the CRT) and then the amount that the employer pays over in respect of NIRA at the end of the year will, when added to the CRT value already paid over, bring the amounts paid over into balance with the amount as reported on the P14 and P35.

It sounds complicated, but if you identify one employee with arrears of NI in NIRA and compare the amount you have paid over in respect of this employee to the amount on the P14 and P35 – you should find that when you add the NIRA value to the amount already paid over that the figures then balance which confirms that no action should be taken to adjust the CNIC in this particular situation.

Adjusting the CNIC values for a Leaver

You may wish to adjust the CNIC values for an employee who has left your organisation. You might find that after updating the DTONI table (T5G_DTONI) and re-running the payroll, the NI figures have not been correctly adjusted.

You may find that the employee has not been picked up by the payroll run, meaning that the relevant DTONI adjustments would not have been made.

You can run payroll for a leaver by entering a date in the field “run payroll up to” on infotype 0003. In most cases you would enter the end date of the current payroll period into this field.

If the payroll is still not retro’ing back to the required date, you will need to enter the start date of the period in which you wish to retro back to in the field “Earliest MD change” on infotype 0003.

The combination of these two filled fields should ensure that the DTONI entries are picked and the adjustments made.

Loading Year to Date figures

You are in the process of undertaking the data migration for your SAP project and would like to know what the process is for loading year to date (YTD) figures into SAP and where you can find out more about the process.

In essence you need to load the tax and gross pay wage types into table T588a and the NI details into the table T5G_DTONI. Loading the NI figures as wage types will not work correctly as you need to load the NI figures into the DTONI table to get them into the CNIC cluster which will then allow the data to be picked up the by the year end programs.