Display TCRT entries on forms via Taxcompany

[wilcoxt]

Hello All,

I am trying to provide the results on forms either via PE51 or HRforms based upon the tax company. For example. Employee changes from Tax company A to tax company B mid year. I would like to reflect monh/Quarter/ or YTD based upon the current tax company.

I am not seeing anything in PE51 rules configuration that supports me putting in a rule based on tax company. Has anyone encountered or resolved this?

Any guidance would be appreciated.

Thansk,
Todd

[davidadams]

Unless something has changed that I am not aware of, this will be a considerable amount of work. In the sample forms that SAP provides, they had made it fairly simple in PE51 to display tax types per tax authority without repeating the tax authority for each.

Example

FED

Withholding

Unemployment

The TCRT contains the entries by tax company, but the problem is that in the RT - you can't tell which tax company it is without going to cluster PERM. One RT entry (one payroll result) can only represent one tax company. To be clear - you can have cumulated tax results in the TCRT for multiple tax companies, but the RT can only represent one. If you wanted to create Infotype 0221 for 2 tax companies in the same day, it would require 2 payroll results with a different pay i.d.

All of that is said as background. You can write rules in PE51 and even add tables via PE51_CHECKTAB so you could cumulate by tax company PERM. This seems like it could get a little difficult as theoretically you could have more than 2 tax companies.

In smartforms, you should be able to look at the code mentioned above that does the tax types per tax authority, and an ABAPer can expand it to be Tax Types Per Tax Authority Per Tax Company.

Sorry for not having a specific solution, but either this came in and I am unaware of it, or this can be done but it is a good bit of work. I looked into this long ago, but seem to recall that breaking out by tax company was not statutorily required. Because of that, and the degree of difficulty - we decided not to pursue this.

[BalaAP]

Hi,

Tables TCRTM, TCRTQ and TCRTY tables are available in the rule (by selecting table list) for comparison. But you may need to use PE51_CHECKTAB transaction to add the fields for these TCRTx tables to reflect in the CEDT form.