SAP Program RPUDNIG0 - Upload Report for T5G_DTONI From Excel Spreadsheet

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 alarge number of table entries must be entered into the SAP R/3 System.Typically, this situation would occur:

  • 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 thefollowing format (in order to ensure that the data from the Excel sheetis 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 anerror in the SAP R/3 System during the upload process. In addition,ensure that your Excel file is closed before executing this uploadreport. Finally, the values for the indicators are the possible F4values set on the domain for each field in the table NationalInsurance Data Take-on (T5G_DTONI).
    Column A - Personnel Number
    Column B - National Insurance Category
    Column C - Contracted Out Indicator (set to X or leaveblank)
    Column D - NI Director Indicator (set to X or leave blank)
    Column E - Pay Date for Payroll Result (format must bedd.mm.yyyy, for example, 17.05.2003)
    Column F - Assignment Number (SAP recommends that you leave thisfield blank.)
    Column G - NI calculation priority
    Column H - APPS Indicator (set to X or leave blank)
    Column I - Director with Regular Payments Indicator (set to X
    or leave blank)
    Column J - Director Number of Tax Weeks for Pro-rating
    Column K - Late Starter / forgotten time sheet indicator (set toX, Y, A, or leave blank)
    Column L - Late Leaver Indicator (set to X or leave blank)
    Column M - Contracted-out later than six weeks after leavingindicator (set to X or leave blank)
    Column N - Niable pay
    Column O - Niable pay base
    Column P - Niable pay up to LEL
    Column Q - Niable pay between LEL and ET (between LEL and EET forresults prior to 6.4.2001)
    Column R - Niable pay between EET and ERT (should be blank forresults after 5.4.2001)
    Column S - Niable pay between UAP and UEL
    Column T - Niable pay above UEL
    Column U - Employee NICs
    Column V - Employer NICs
    Column W - Employee (primary) NI rebate
    Column X - Employer (secondary) NI rebate
    Column Y - Delete Indicator (Set the indicator to 'X' if you wantto remove entries from table T5G_DTONI. For a normal upload, theindicator should be empty.)
    Column Z- Niable pay between ERT and UAP
    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 ondata.
    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 isoffered to cover the most critical fields.

    Output
    Upon running the report, statistical information on the processing isdisplayed:
    Records on upload file: Indicates the number of entries in theExcel sheet.
    New records: The number of entries in the Excel sheet that havethe correct format, but not yet exist in the table T5G_DTONI. When runin live mode, the SAP R/3 System inserts these records into tableT5G_DTONI on the database.
    Modified records: The number of entries in the Excel sheet thathave the correct format and already exist in table T5G_DTONI. When runin live mode, the SAP R/3 System overwrites the existing recordson the database.
    Deleted records: The number of entries in the Excel sheet thathave the correct format and are marked for deletion in column Y (Deleteindicator). When run in live mode, the SAP R/3 System deletesthe corresponding records from the table T5G_DTONI.
    Rejected records: The number of records in the Excel sheet thatdo not have the correct format.
    You can also display the New, Modified and Deletedrecords.

    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 andcorrect any error.
    Run the report with the Test indicator switched off. Note: Thedatabase will only be updated if there are no errors in any of therecords.
    Once table T5G_DTONI has been updated via this report, the next payrollrun picks up the table entries for the appropriate pay period and fillstables NIC and CNIC accordingly.