Programme SAP HTWLLPD0 - Data Comparison Report for Labor Insurance or New Pension (Taiwan)

Title

Data Comparison Report for Labor Insurance or New Pension (Taiwan)

Purpose
You use this report to compare data in SAP system with data in TaiwanLabor Insurance Bureau's system. This report is applicable to thefollowing types of data:

  • Labor insurance

  • New pension (employee pay)

  • New pension (employer pay)

  • This report checks data consistency in the following areas:
    • For labor insurance data:

    • Name
      Date of birth
      Company LI (Labor Insurance) number
      Check code of company LI number
      Labor insurance amount
      Employee pay
      Employer pay
      Type of last change
      Date of last change
      • For new pension data:

      • Name
        Status
        EE (employee) rate
        ER (employer) rate
        EE premium
        ER premium
        Type of contributor
        Insurance amount
        Date of last change

        Prerequisites
        Before you run this report, you need to complete the following tasks:

        • Download data file from Labor Insurance Bureau website, and save it on
        • local disk
          • Run payroll for the relevant employees and have their payroll results
          • Features

            Selection
            o,,Select the data file from the local disk and import it into system.
            o,,Select the comparison period, including year and month.
            Note: This results in an automatic entry on Period tab.
            o,,Select the employees, whose data you wish to compare.
            o,,Choose the type of data that you would like to compare.
            Note: It should correspond to the imported data file.

            Output
            When you run the report, it generates the following results:

            • Records in SAP system that meet the selection criteria

            • Records with identical data in both SAP system and the uploaded file

            • Records with data inconsistency between SAP system and the uploaded file

            • Records belong to different types of data inconsistency

            • Records in data file, but not recognized by the system
            • Activities
              On the SAP Easy Access screen, choose Human Resources ->Payroll -> Asia/Pacific -> Taiwan -> SubsequentActivities -> Period-independent -> Reporting ->Update LI/NHI infotype -> PC00_M42_LLPD.
              Enter the required criteria to identify the employees for comparison.
              Upload data file from the local disk through the following steps:
              Access to F4 Help for field Filename
              Select data file for comparison from your computer
              Choose Open to upload it into system
              Select Comparison Year and Month, that is the same period of theimported data file.
              Select the data type for comparison.
              Choose Program -> Execute.

              Caution
              When you run this report, pay attention to the following cases:

              • In the LI data file, there are four possible values for field

              • Type of Last Change: 1, 2, 3, 4.
                This report is not applicable to value 1.
                Records whose type of last change is 1 are displayed in theInconsistent records group in the result.
                • In the NP data file, there are more than 10 possible entries for the
                • field Status.
                  This report only supports the following statuses:
                  Normal
                  Join
                  Quit
                  Adjust amount
                  Adjust rate
                  Records with other statues are displayed in the Inconsistent records
                  group in the result.

                  See also
                  For more information, see SAP Note 953749.