Ansicht
Dokumentation

HNZUHCU0 - NZHPI Upload Program

CL_GUI_FRONTEND_SERVICES - Frontend Services BAL Application Log Documentation
This documentation is copyright by SAP AG.

Title

NZHPI Upload Program (HNZUHCU0)

Purpose

This report is used to either download the information from Holiday Payment Information - NZ ( NZHPI) cluster table or it can be used to upload or update NZHPI entries.

You use this report :

When you do not have employee data in the SAP system for the last 12 months. For example, when you are converting employees onto SAP payroll from a legacy payroll system.

When the data in Holiday Payment Information - NZ ( NZHPI) cluster table needs to be adjusted for some reason and cannot be fixed via retro processing.

There are two types of download options:

Straight Download: In this case, the report downloads the existing information from Holiday Payment Information - NZ( NZHPI) cluster table as it appears in the payroll results cluster.

Download: In this case, the report creates the entries in the download file based on information contained in the RT results cluster and WPBP table. The system determines the gross earnings based on Gross $ Amount in cur pay(/121) wage type and the ordinary hours based on cumulation class 26 or WPBP entries, depending on the selection criteria.

Note that, this selection was required when the Holidays Act 2003 was first introduced in 2004 and a Holiday Payment Information - NZ ( NZHPI) cluster table had to be created from new based on the information already contained in the results cluster. It is not expected that this option will be commonly required post 2004.

When the Update Weeks/Casual Status option is selected, the following information will be updated in the NZHPI records that start from the begin date specified in the report:

Number of weeks calculated using the begin and end date of the NZHPI record, excluding the absence type specified as leave without pay (LWOP) in the Absence Type field

Casual employment status of the employee read from the Employee Category - NZ (V_T7NZCT) table view based on the employee group and subgroup

Integration

When using this program in Upload mode, there must be an existing payroll result for the data to be uploaded into and there must be data in the upload file that matches that pay result.

When using the Update Weeks/Casual Statusoption of this program, there must be an existing payroll result in which the data will be updated.

Prerequisites

Features

Selection

The following is the selection criteria for Download, Upload and Update modes.

For Download mode:

To use this program in download mode the following is required. Note that the straight download option is useful if you need to determine the file layout required for uploading.

Enter the employee selection criteria.

Enter the File Type as DAT.

Enter the File Name.

Enter the period for which you want to download or upload the data for the NZHPI cluster table.

Choose the relevant radio button in Upload/ Download section. For example either choose Straight Download or the Download radio button.

Select one of the options for Calculation of Work Hours only if you have selected Download radio button:

Using WPBP - Select this, if you want to calculate ordinary hours based on information maintained in the WPBP table.

Using Cumulation Class 26 - Select this, if you want to calculate ordinary hours by determining which wage types have cumulation class 26 set and querying the RT results cluster table for these wage type values.

Note that if you have selected Straight Download radio button, you need not select any option in Calculation of Work Hourssection as these options are ignored.

Enter the number of employees after which the report should update the TemSe file.

Note:If you enter a very low value, for example 10, or a very high value, for example, 500, it may result in performance issues.

Select Delete TemSe before starting programindicator so that the previous TemSe is deleted.

For Upload Mode:

In upload mode this report will create or replace the NZHPI table for each pay period specified in the upload file that has an "S" in the Data Type field where the sequence number, period start and end dates in the file match an SAP pay result for the employee.

Note that for this mode there must be at least one payroll result to upload the file against. The data that will be uploaded will be all entries with a Data Type field set to L and all S records that have the same or lower sequence number specified for the payroll result being updated.

To upload information into Holiday Payment Information - NZ ( NZHPI) cluster table the following is required:

Employee selection criteria is not required in Upload mode because the employees updated will be based on data contained in the upload text file.

Enter the File Type as DAT.

Enter the File Name to be uploaded.

Select date range - you need not change the default settings as NZHPI will only be uploaded according to the data in the upload file.

Select Upload.

Enter the number of employees after which the report should update the TemSefile.

Note: If you enter a very low value, for example 10, or a very high value, for example, 500, it may result in performance issues.

",,Select Delete TemSe before starting program indicator so that the previous TemSeis deleted.

For Update Mode:

In update mode this report will update the number of weeks and casual employment status in each NZHPI record that falls between the begin and end date specified in the report.

To update information into NZHPI, the following is required:

Enter the employee selection criteria

Enter the date range between which you want to update NZHPI records.

Select Update Weeks/Casual Status.

Select the Absence Type that has to be deducted from the calculation of number of weeks as leave without pay (LWOP).

Standard Variants

Output

If you select the Download or Straight Download options, the report downloads the file in the format and the location that you have specified. You can open this file with Microsoft Notepad.

If you select the Upload option, the report uploads the NZHPI table with the data in the file that you have specified in the File Name field.

If you select the Update Weeks/Casual Status option, the report updates the NZHPI table with the number of weeks and casual employment status.

Activities

When you do not have employee data in the SAP system for the last 12 months:

Run this report in Straight Download mode for any employee that has an existing Holiday Payment Information - NZ ( NZHPI) cluster table table so that you can determine the required file layout for the upload file, example, an employee from the test system.

Ensure that there is at least one payroll result for the employee whose data is to be uploaded into SAP (Schema NZ20 can be used to create a dummy result with no RT when converting employees onto SAP.) This payroll result usually has a sequence number of 0001 and is run for the pay period prior to go live.

Create a text file with the required NZHPI data to be uploaded by overwriting the data that was obtained when the program was run in download mode. The earnings/hours information that relates to the pay period whose result exists within SAP should have the Data Type field set to S and the sequence number should be the same as the payroll result in SAP (i.e. probably 001). All other entries for the last 12 months for periods that do not have a matching payroll result in SAP should have the Data Type set to L. The sequence number for 'L' entries is not so important but does reflect the order in which they will be displayed in the NZHPI table.

On the selection screen enter the name of the text field in the Selection file name field.

Select the Upload radio button.

Select Delete TemSe before starting program.

Execute the program.

Check that the results table to see that the data has been uploaded.

Example

You have run the report for an employee and downloaded data. The following data has been downloaded:

Data Type	Employee No.	Sequence No.	Begin Date	End Date	Payroll ID	Pay Date	Gross for Avg. Rate	Gross for OP Rate	Contract Working Hrs	Actaul Working Hrs	Actual Working Days	Gross for RDP
S	00439244	00001	01.04.2001	30.04.2001	27.04.2001	6000.00	6000.00	60.00	60	8	5000	21
S	00439244	00002	01.05.2001	31.05.2001	28.05.2001	3000.00	3000.00	172.50	172	21	2000	21
S	00439244	00003	01.06.2001	30.06.2001	27.06.2001	3000.00	3000.00	150.00	150	18	2000	21

In this case, only last 3 months' data is available. To add data of nine months prior to April 1, 2001:

Copy any one of the rows above.
Paste the row nine times, above or below the data already present.
Change the Data Type to L from S for all the copied rows.
Change the Sequence Number of the first row that you have copied to 0004, second row to 0005 and so on.
Change the Begin Date of the first row that you have copied to 01.07.2000 and the End Date to 31.07.2000. Similarly change the dates for all the rows that you have copied.
Change the Pay Date for all the copied rows.
Change the salary details of the employee in all the copied rows.
Save your entries.

The new data should look similar to:

Data Type	Employee No.	Sequence No.	Begin Date	End Date	Payroll ID	Pay Date	Gross for Avg. Rate	Gross for OP Rate	Contract Working Hrs	Actaul Working Hrs	Actual Working Days	Gross for RDP
L	00439244	00004	01.07.2000	31.07.2000	27.07.2000	3000.00	3000.00	150.00	150	18	2000	21
L	00439244	00005	01.08.2000	31.08.2000	26.08.2000	3000.00	3000.00	172.50	172	21	2000	21
L	00439244	00006	01.09.2000	30.09.2000	27.09.2000	6000.00	6000.00	60.00	60	8	5000	21
L	00439244	00007	01.10.2000	31.10.2000	27.10.2000	3000.00	3000.00	150.00	150	18	2000	21
L	00439244	00008	01.11.2000	30.11.2000	26.11.2000	3000.00	3000.00	172.50	172	21	2000	21
L	00439244	00009	01.12.2000	31.12.2000	27.12.2000	6000.00	6000.00	60.00	60	8	5000	21
L	00439244	00010	01.01.2001	31.01.2001	27.01.2001	3000.00	3000.00	150.00	150	18	2000	21
L	00439244	00011	01.02.2001	28.02.2001	26.02.2001	3000.00	3000.00	172.50	172	21	2000	21
L	00439244	00012	01.03.2001	31.03.2001	27.03.2001	6000.00	6000.00	60.00	60	8,5000		21
S	00439244	00001	01.04.2001	30.04.2001	27.04.2001	6000.00	6000.00	60.00	60	8	5000	21
S	00439244	00002	01.05.2001	31.05.2001	28.05.2001	3000.00	3000.00	172.50	172	21	2000	21
S	00439244	00003	01.06.2001	30.06.2001	27.06.2001	3000.00	3000.00	150.00	150	18	2000	21

You can run this report again to upload the above data to the NZHPI cluster table. The Holiday Payment Information - NZ ( NZHPI) cluster table will be updated with the additional data for sequence numbers 001, 002 and 003 since there are three "S" records in the file.

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up General Data in Customer Master
This documentation is copyright by SAP AG.

Length: 22674 Date: 20240531 Time: 234231 sap01-206 ( 215 ms )

Ansicht Dokumentation