H99CWTR0: Tips for using Wage type reporter in SAP

The wage type reporter is one of most used reports in Payroll, which helps us to pull out data from RT for an Employee or group of Employees for a particular selection and for a period of our selection.

In the following sections we will discuss about this very useful report.

What is this Program? The program is ; H99CWTR0, which we can run from se38.

The user menu path to access this report is :
S_PH9_46000172 – Canada -> Info system -> Payroll results -> Wage type reporter.

As we see, the tcode looks cryptic, so its better to remember the Program name and run it from se38 screen.

Now how to use this report?

We can create this report for a variety of selection of objects.
WT1

It can be even action type and action reasons.

Generally we use for Comp code, PA, PSA, EE group, EE sub group, payroll area  etc.
The next section which is useful is : Period Interval 
We define the period for which we need the data to be extracted from RT.
Here we can extract data for regular and off-cycle payroll periods.
In this section, we can also compare payroll results of two different payroll period.

WT2

The next section is : Other selections.

In this section, we define the wage types we need to extract and the objects we need as part of output report.
WT3 object selection

In the above example, I want the PERNR to be displayed in the report, so I selected Personnel number.

Last section of the report is : Output.
WT4

We can use excel, sap list viewer or our own customised ALV Variant. The best way is to use your own variant, with all the required columns as per your requirement.

Once all the entries are done, we can run the report and the report will be produced, some what like the following format.
WT5
……………………………………………………………………………………………………………………………………………………………………..

PY_TM: Some Insanely useful reports

In Payroll and Time management modules of SAP, we have few reports which are very useful. Those are so useful that we find them useful almost every day in our consulting Careers. I thought to group them together into one place, so that consultants can get a complete view of them.

1. RPDASC00
This report lists all the PCRs and schemas .
This Report lists the entries in tables T52C0 and T52C5 according to the set parameters.
R1

2. RPUCTF00
This report locks/ unlocks the attributes of the PCR. If the PCR is locked, this report is used to unlock the PCR.
R2
The editor lock is set (X) or cancelled (SPACE) for the selected schemas and personnel calculation rules.

3. RPUCTJ00
This report is used to display PCRs, those are not used in Schema.
R3

4. RPUCTX00
This report is used to copy PCRs from one client to other.
R4

5. RPDLGA20
This report is used to find the wage type characteristics of primary and secondary wage types.
R5
……………………………………………………

Solution - Dump CONVT_NO_NUMBER occurred during table conversion


Prerequisites

As you already known that, it is necessary to perform table conversion via SE14->"activate and adjust database (save data)" if the table cannot be adjusted directly using database SQL statement. For detailed information about table conversion, you can refer to wiki page

http://wiki.sdn.sap.com/wiki/display/ABAP/Table+Conversion+-+Frequently+Asked+Questions

Symptom

You changed dat type for one table field from CHAR to DEC which triggered table conversion via SE11.
before change:


After change:


However Dump CONVT_NO_NUMBER occured during table conversion. table conversion stopped at step 5 in SE14:




Reason

Data type from CHAR to DEC triggered table conversion. But because the field value contained characters which could not be converted to digital, dump CONVT_NO_NUMBER occured.


There were three entries in table ZTEST before conversion. The first entry contain value "123WET" for field F3 which was changed from CHAR to DEC. However "123WET" cannot be converted to number, so table conversion failed.

Solution

When such dump occured during table conversion, The field value and the corresponding entry that cannot be converted can be found in dump file


< WA> contain the complete key value for this entry.
You can also found the corresponding entry by running select SQL statement on database level:
select * from QCMZTEST where F3 = '123WET';
You can update the entry using Update SQL statement:
update QCMZTEST set F3 = '123456' where F3 = '123WET';
After that, go to SE14 to continue the conversion by clicking "continue adjustment".