Skip to Content
Author's profile photo Former Member

Horizontal Wage Type Reporter

Dear All,

We can use the Horizontal Wage type reporter form SAP HCM.

TC: PY_QA_HQAPPWTR

Actually, this report for Qatar, but we can also use.

Following details source from SAP Documentation.

Short text

Wage Type Reporter for Qatar PS

Description

The wage type reporter evaluates wage types from the payroll results for a selected period. This is data from tables RT (Results Table) and WPBP (Work Place Basic Pay) for the payroll results. Other tables and data from infotypes are not evaluated.

This report is Qatar-specific wage type reporter that is generated based on the international Wage Type Reporter report (H99CWTR0).

Description of the selection parameters

Selection

The standard selection fields for the logical database PNP can be used. Note that a selection according to organizational criteria in these fields does not have to correspond to a selection of payroll results for the selected organizational entity. Retroactive changes to master data can lead to differences. We recommend that you include objects, which are used for the selection, in the object selection (see below).

Payroll Period

Together with the entries for the payroll period (example: selected period 01.01.1998 to 03.31.1998), in the Payroll Type field, you can enter the type of payroll you want to evaluate, for example:

  • Regular payroll run
  • Off-cycle payroll run
  • Correction run
  • Bonus payment
  • Manual check

By entering the payroll period you can limit the amount of data to be evaluated by defining additional selection criteria for the following payroll types.

If you choose Regular Payroll, enter the following:

  • Payroll area
  • Payroll period
  • Payroll year

If you want to compare two regular payroll runs, make the required entries for the comparison.

If you choose Off-cycle payroll, in the Special run field, enter the following:

  • Payroll type
  • Payroll ID
  • Payment date of off-cycle payroll
  • Reason for Off-Cycle Payroll

If you want to compare two off-cycle payroll runs, make the required entries for the comparison.

If you have selected Perform Comparison, you can enter additional comparison parameters.

You can make the following comparisons:

  • Compare one regular payroll run with another regular payroll run.
  • Compare one special run with another special run from the same payroll type.

Period determination

You specify the desired view of the payroll results.

Example: selected period 01.01.1998 to 03.31.1998

For the in-period view, all results from all payroll types, which were created IN this period and correspond to the specified selection of payroll types, are selected. A payroll run IN February 1998 FOR December 1997 would be included in the example, however, a payroll run IN May 1998 FOR February 1998 would not.

For the for-period view, all results from all payroll types, that were created FOR this period and correspond to the specified selection of payroll types, are selected. A payroll run IN February 1998 FOR December 1997 would not be included in this selection. However, a payroll run IN May 1998 FOR February 1998 would.

Example: selected payroll period 11/2003

In-period view: The end date of the period is decisive for the period determination. The program takes into account all payroll results that were created IN this payroll period, depending on their payroll type. If you select a regular payroll period, then any off-cycle results that were created within the selected period are not taken into account.

For-period view: The end date of the period is decisive for the period determination. The program takes into account all results created FOR this payroll period, irrespective of their payroll type. If you select a regular payroll period, then any off-cycle results that were created for a special run within the selected period are not taken into account.

Example: selected special run A 0 12.10.2003

In-period view: Only the results created IN this special run are taken into account, irrespective of their payroll type.

For-period view: Only results created FOR this special run are taken into account, irrespective of their payroll type.

You can use this program to perform a comparison between two payroll periods of the same payroll type. The payroll areas for the periods to be compared can be different. However, the payroll areas must have the same periodicity.

Other selections

Wage type selection allows you to limit the selection to specific wage types.

Use Display WT with Amount to show the amount of the wage types.

Use Display WT with Number to show the number of the wage types.

Use Display WT with Amount and Number to show the amount and number of the wage types.

Output

You can choose from the following list displays to show the different type of title labels:

  • Wage Type as Column Title
  • Wage Type Text as Colum Title
  • Wage Type & WT Text as Column Title

The report is only use the SAP List Viewer (ALV) Grid Control.

Update required deatails and which wage types you required in the report.

For reference see the image

14-03-2014 12-50-19.jpg

Output:

14-03-2014 12-54-48.jpg

Regards,

Santosh Shivane

Assigned Tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi,

      Awaited report!! It will be very helpful for us.

      Thanks for sharing!

      Thanks,

      Ketul

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Ketul,

      Thanks Ketul for your comments...

      Regards,

      Santosh Shivane

      Author's profile photo Former Member
      Former Member

      Hi Santosh,

      Good document, but i didn't see out put methods which you are stated in the document, and i also want the report to be like column wise which is given by you. can you please tell us how to do, i am using this report  PC00_M99_CWTR.

      Best Regards.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Praneeth,

      Please use TC : PY_QA_HQAPPWTR  -->  Give the start date and end date , but your payroll should be live run.  Then you can get the report.  Like same PC00_M99_CWTR.


      Santosh Shivane

      Author's profile photo Former Member
      Former Member

      Hi,

      You might have not selected In-Period and for period from Object selection.

      Can you pls check after selecting that.

      Thanks,

      Ketul

      Author's profile photo Former Member
      Former Member

      Hi,

      system is giving message that Transaction PY_QA_HQAPPWTR does not exist

      my client is Indian payroll. then how can i proceed.

      Author's profile photo Former Member
      Former Member

      use

      HQAPPWTR

      in the PROGRAM area instead of

      PY_QA_HQAPPWTR ....

      and follow the mentioned procedure

      Author's profile photo Former Member
      Former Member

      Hi

      this is a great program... Always looking for something like this

      normally i make a program myself

      This is much better

      regards

      Theo

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Theo Peeters,

      Thanks for your comments.  No need to develop salary register by ABAP HR. 

      Regards,

      Santosh Shivane

      Author's profile photo Former Member
      Former Member

      Hi Santosh, very informative article. Thanks for sharing.

      Regards,

      Supriya

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Supriya,

      Thanks for your comments.

      Regards,

      Santosh Shivane

      Author's profile photo Former Member
      Former Member

      Hi,

      This is very valuable information.

      Arpit

      Author's profile photo Sikindar T
      Sikindar T

      Good one but will this work for other countries since it is related to Qatar right

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Sikindar,

      Yes, this will work for other countries also, since it is related to Qatar.

      Best Regards,

      Santosh Shivane

      Author's profile photo Masroor Ahmed Siddique
      Masroor Ahmed Siddique

      It is giving me the message that "Transaction PY_QA_HQAPPWTR does not exist". I would appreciate if you can kindly help in this regard

      Author's profile photo Former Member
      Former Member

      use

      HQAPPWTR

      in the PROGRAM area instead of

      PY_QA_HQAPPWTR ....

      and follow the mentioned procedure

      Author's profile photo Masroor Ahmed Siddique
      Masroor Ahmed Siddique

      Thanks Salman,

      It worked 😀

      Regards

      Author's profile photo Former Member
      Former Member

      Hello All,

      Need some help here ... I wanted to know if this report or any other report that could provide the data for the current month [as in have not released for payroll yet] in Excel ???

      For instance ...

      Apr - Oct have been released ... and data can be extracted using the above report.....

      we are in the November month...and the data is available in PA30 as well.....

      Please reply  at the earliest ....