SAP Program RPCTSQL0 - Prepare EA form

Title
HR-MY: Sequence Number Generation for EA Form - Malaysia (RPCTSQL0)

Purpose
This report generates sequence numbers for the selected employees. Thegenerated sequence numbers can be saved to Database table, which isused for EA Form reporting.
This report must be executed before printing the EA Tax form for theyear.

Integration
Although SAPScript provides font substitution for individual printersto remain global, SAP recommends that you use HPLJ4Si/4SiMX PS laserjet.

Prerequisites

  • The master data records must exist.

  • You must have maintained the
    • Determination ofTax Splits for tax reporting feature (LTSPT) to decide how the EAForm should be split.

    Features

    Selection
    Employer's Reference Number uniquely identifies the employer forpayment of tax to a given tax office.
    Tax Assessment Year is the financial year for which you want togenerate the sequence numbers.

    Output
    On executing the report, you get an ALV Grid, which displays thefollowing fields:

    • Income Tax Office to which EA Form is to be submitted.

    • Employer Tax Reference Number

    • Employee Tax Number

    • Employee Personnel Number

    • Employee Name

    • Sequence Number, which is generated sequentially according to
      • the following sort order:
      Employer Tax Reference Number
      Employee Status
      Employee Name
      • Employee Status - The report considers the data in the last
        • record of the Actions Infotype (IT0000) for the year for which thereport is executed, and generates the Employee Status accordingto the following rules:
        RESET N1
        The status generated for the employee will be A (Active) if theemployee
        Joins your organization in the year previous to the financial year forwhich you are running the report, and
        Remains active throughout the financial year in which you are runningthe report until at least the beginning of the next financial year.
        The status generated for the employee will be J (Joined) if theemployee
        Joins your organization in the financial year for which you are runningthe report.
        The status generated for the employee will be L (Left) if theemployee
        Leaves your organization in the financial year for which you arerunning the report.

        Activities
        RESET N1
        From SAP Easy Access menu, choose Human Resources ->Payroll -> Asia/Pacific -> Malaysia -> Subs.activities -> Annual -> Legal reporting -> Taxes -> Prepare EA Form (Seq no. Generate).
        The Prepare EA Form Report screen appears.
        Enter the relevant selection criteria.
        Select Program -> Execute.
        The Generated Sequence Numbers screen appears.
        Select the Save Sequence Nos function to transfer the recordslisted in the ALV Grid to the Serial no Table for EA form -Malaysia (T5LSQ).
        Optionally, before saving changes, you may want to delete records fromTable T5LSQ. To do so, perform the following steps:
        Select the Delete Records from Table T5LSQ function.
        Enter the Reference Numbers for which you want to delete therecords.
        Select Program -> Execute.
        The records for the selected Reference Numbers will get deleted
        Return to the Generated Sequence Numbers screen by selecting theBack function.
        Select Transfer changes to transfer the records listed in theALV Grid to the Serial no Table for EA form - Malaysia (T5LSQ).