Reconciliation between Two Country Specific Reports 
Query: 0PYCR_MP2_Q0002
This query enables you to compare the tax results between two reports like Annual Tax Statement and Monthly Tax Statement.
Note
You can use this query to compare Tax Codes in Report 1 against the relevant Tax Codes in Report 2. As mapping between every Tax Code does not exist, the system can compare only those Tax Codes from Report 1 for which relevant Tax Codes exist in Report 2.
Structure
Object Type | Name | Technical Name |
|---|---|---|
| Sub Application name |
0APPLN |
| Employee |
0EMPLOYEE |
| Payroll Status |
0PY_SRTZA |
| Pay Period |
0PAY_PERIOD |
| For Period |
0FOR_PERIOD |
| In Period |
0IN_PERIOD |
| WPBP Split Indicator |
0WPBP_INDC |
| Year |
0FIYEAR |
| Report Form Name |
0TF_NAM |
| Report Run ID |
0RUNID_NEW |
| CNTR1 Split indicator |
0CNTR1_IND |
| CNTR2 Split indicator |
0CNTR2_IND |
| CNTR3 Split indicator |
0CNTR3_IND |
| Company Code |
0COMP_CODE |
| Legal Person |
0LEG_PER |
| Payroll Area |
0PAYRL_AREA |
| Pay Date |
0PAY_DATE |
| Personnel Area |
0PER_AREA |
| Personnel Subarea |
0PER_SAREA |
| Zone |
0REUSE7 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Employer ID |
0EMP_ID |
— |
| Report Tax Codes |
0TAX_ID2 |
— |
| Wage Type |
0WAGE_TYP |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Report 1 Tax Codes Amount |
— |
— |
| Report 2 Tax Codes Amount |
Technical Name |
— |
| Diff between Report 1 & Report 2 |
Technical Name |
— |