Programme SAP HTWLAM00 - Read payroll result and update infotype 0354/0355/0818

Description
You use this report to regularly update employee's Labor Insurance,National Health Insurance and New Pension insurance amount in the LaborInsurance (LI) infotype 0345, the National Health Insurance (NHI)infotype 0355, the New Pension (NP) infotype 0818.
The insurance amount consists of two parts:
Basic salary part : the wages types to be used as LI/NHI/NP basic salaryshould be configured in the evaluation class 7 (for LI/NHI) and theevaluation class 9 (for NP) of the table T512W. Input "Basic salarymonth/year" in the selection screen. The wage types in RT which havevalues in evaluation class 7 or 9, will be summed as the "Basic SalaryPart".
You should note that, if in the period there is no payroll result incluster, a background payroll simulation run will be carried out, so youneed to fill in the "Schema" field in the selection screen with theschema you use for normal payroll run.
Average of variable incomes from the past periods: you need to fill inthe "Number of past period" and "Range of past periods" in the selectionscreen. The system will take the wage type /107 (for NHI), /108 (for LI)or /109 (for NP) from the payroll result in the specified periods, sumthem up and average them.
The sum of the two parts are the new amount. If there is an amountchange of the current calculation and last reported amount (taken fromT7TW1L or Infortype), they will be listed. For some companies, they canjust print out this list and report to LI/NHI/NP bureau. A batch jobwill also be created to update the infotype 0345, 0355 and 0818.

Note
If you use table T7TW1L to store the last reported LI/NHI/NP data, youshould choose last reported data from T7TW1L and, after updatinginfotypes, run report HTWLLIA0 (for LI), HTWLHIA0 (for NHI) or HTWLNPA0(for NP) to create paper forms and update T7TW1L. If your company hasalready reported the adjustment as described in the paragraph above,please select the flag "No actual download" in the selection screen ofthe report HTWLLIA0, HTWLHIA0 and HTWLNPA0.

Precondition

  • You should maintain the table T7TW1B and the infotype 0354, 0355 and
  • 0818 properly.
    • Payroll result should include wage type /107, /108 and /109. Wage type
    • /107 is for NHI variable amount, /108 for LI variable amount and /109for NP variable amount.
      • You should maintain the constant LIMIN and NHIMN for reading
      • non-children's and non-trainee's LI/NHI first class amount in the tableT511K .
        • You should input how many periods will be taken into account.

        • If in any of the selected periods, employee has an employment statusother than Active, you need to determine how the systemcalculates the premium amount.
          • You should update the begin date for new record.

          • If you choose last reported data as from the table T7TW1L, then you
          • should have the last reported data stored in T7TW1L (see document ofT7TW1L). If you choose data from infotype, the system will takepersonal data and old amount from infotypes on the effective date.
            • In case the insurance amount decreases, you might want to print default
            • reason on the paper, for example, job change. Then you should maintainthe feature TWADJ to set the default reason key and maintain the adjustreason table T7TW1M and its text table T7TW1S.

              Output
              After the execution of the report, there are different selectionsappeared:

              • List: list of selected persons and their data on the screen

              • Batch: create a batch input to carry out the insurance class update

              • Error/Warning: list of errors/warnings occurred
              • Example
                If you want to calculate new insurance amount with basic salary fromvariable income from 06/1998 to 08/1998 with the effective date01.09.1998, the inputs in the selection screen are:

                • Number of past periods: 3

                • Range of past periods: 06/1998 to 08/1998

                • Basic salary month: 08/1998

                • Effective date: 09/1998