Ansicht
Dokumentation
RPUDNIG0 - Upload Report for T5G_DTONI From Excel Spreadsheet
PERFORM Short Reference Fill RESBD Structure from EBP Component StructureThis documentation is copyright by SAP AG.
Title
GB upload report for the table National Insurance Data Take-on (T5G_DTONI).
Purpose
This report updates the table National Insurance Data Take-on (T5G_DTONI) from an Excel spreadsheet. This is especially useful when a large number of table entries must be entered into the SAP R/3 System. Typically, this situation would occur as follows:
- Before going live with the mySAP HR Payroll solution for Great Britain
- If you need to correct existing NI records to adjust your payroll results.
Prerequisites
To fill the table National Insurance Data Take-on(T5G_DTONI) with this report, you must create an Excel sheet in exactly the following format (in order to ensure that the data from the Excel sheet is compatible with the SAP R/3 System). Upon saving the file in Excel, choose the file type Text (Tab delimited)(*.txt).
Note: Do not write any header text in the column, as this will cause an error in the SAP R/3 System during the upload process. In addition, ensure that your Excel file is closed before executing this upload report. Finally, the values for the indicators are the possible F4 values set on the domain for each field in the table National Insurance Data Take-on(T5G_DTONI).
Column A - Personnel Number
Column B - National Insurance Category
Column C - NI Director Indicator (set to X or leave blank)
Column D - Pay date for payroll result
Column E - Assignment number
Column F - NI calculation priority
Column G - APPS Indicator (set to X or leave blank)
Column H - Director with Regular Payments Indicator (set to X or leave blank)
Column I - Director Number of Tax Weeks for Pro-rating
Column J - Late Starter / forgotten time sheet indicator (set to X, Y, A, or leave blank)
Column K - Late Leaver Indicator (set to X or leave blank)
Column L - Niable pay
Column M - Niable pay base
Column N - Niable pay up to LEL (Lower Earnings Level)
Column O - Niable pay between LEL (Lower Earnings Level) and PT (Primary Threshold).
OR
Niable pay between LEL (Lower Earnings Level) and ST (Secondary Threshold) from 06.04.2020.
Column P - Niable pay between PT (Primary Threshold) and ST (Secondary Threshold)
OR
Niable pay between ST (Secondary Threshold) and PT (Primary Threshold) from 06.04.2020
Column Q -Niable pay between UAP (Upper Accrual Point) and UST (Upper Secondary Threshold ) OR
ST and UST/AUST (Apprentice Upper Secondary Threshold)/UEL (Upper Earnings Threshold)
OR
PT and UST/AUST (Apprentice Upper Secondary Threshold)/UEL (Upper Earnings Threshold) from 06.04.2020
Column R - Niable pay above UEL
Column S - Employee NICs
Column T - Employer NICs
Column U - blank
Column V - blank
Column W - Delete Indicator (Set the indicator to 'X' if you want to remove entries from table T5G_DTONI. For a normal upload, the indicator should be empty.)
Note: The above list is a comprehensive list of all the possible fields. You only need to enter data in the columns relevant for your processing.
Features
Selection
File Name - Name of the Excel sheet with your NI Data Take on data.
ALV variant name - Name of the ALV variant.
Test- Indicator for test run.
Standard Variants
In the standard solution, the ALV variant 08_SAP_DTONI is offered to cover the most critical fields.
Output
Upon running the report, statistical information on the processing is displayed:
Records on upload file: Indicates the number of entries in the Excel sheet.
New records: The number of entries in the Excel sheet that have the correct format, but not yet exist in the table T5G_DTONI. When run in live mode, the SAP R/3 System inserts these records into table T5G_DTONI on the database.
Modified records: The number of entries in the Excel sheet that have the correct format and already exist in table T5G_DTONI. When run in livemode, the SAP R/3 System overwrites the existing records on the database.
Deleted records: The number of entries in the Excel sheet that have the correct format and are marked for deletion in column Z (Delete indicator). When run in live mode, the SAP R/3 System deletes the corresponding records from the table T5G_DTONI.
Rejected records: The number of records in the Excel sheet that do nothave the correct format.
You can also display the New, Modified and Deleted records.
Activities
To upload the data from the Excel sheet:
- Execute this report in Test mode.
- If the number of rejected records is not zero, review the error list and correct any error.
- Run the report with the Test indicator switched off. Note: The database will only be updated if there are no errors in any of the records.
Once table T5G_DTONI has been updated via this report, the next payroll run picks up the table entries for the appropriate pay period and fills tables NIC and CNIC accordingly. tables NIC and CNIC accordingly.
Addresses (Business Address Services) Fill RESBD Structure from EBP Component Structure
This documentation is copyright by SAP AG.
Length: 6325 Date: 20240601 Time: 093410 sap01-206 ( 92 ms )
