| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 22 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
2 | P2HK_RETI | Payroll structure for retroactive accounting | 5 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
3 | P2HK_RETO | Payroll structure for retroactive accounting | 5 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
4 | P2IS_RETI | Payroll structure for retroactive accounting | 5 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
5 | P2IS_RETO | Payroll structure for retroactive accounting | 5 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
6 | P2MX_GRORD | Maintenance payment order | 11 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
7 | P2PH_SSSB | HR-PH: Include for SSS structure - Philippines | 9 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
8 | P2RK_GRCUM | Cumulation for garnishment results | 7 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
9 | P2RK_GRORD | Payroll results Canada: Garnishment order | 12 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
10 | P2RK_ROE | Payroll Results - ROE | 7 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
11 | P2RK_VC2 | Vacation pay entitlement per reference year | 6 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
12 | P2RQ_PASUM | Payment summary components | 6 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
13 | P2RU_GRCUM | Cumulation for garnishment results | 7 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
14 | P2RU_GRDOC | Payroll Results: Garnishment for US Document | 32 | PERMO | Period modifier | nvarchar | 2 | 0 | | |
15 | P2RX_ARRRS | Payroll Results: Arrears Table | 5 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
16 | P2RX_VERSC | Payroll Status Information | 25 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
17 | T549Q | Payroll Periods | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
18 | T549S | Personnel Date Specifications Per Payroll Period | 4 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
19 | T7CNREW_APRPARS | Payroll result master table | 9 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPCanada |
20 | T5K8E | HR-CA: Transfer additional external payroll results | 5 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPCompany Pension Scheme Germany |
21 | P01CABR | Actions from Payroll Accounting | 6 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPDenmark |
22 | T5M49 | Date Identifiers for Special Payroll | 4 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
23 | T5M5J | SAP-PBS Interface: AGRUPPE (DK) | 7 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPFinland |
24 | T7FI549Q | Finnish pay periods to average calculation relevance | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
25 | T7FIV0 | Holiday Bonus Handling Types | 8 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPInterface to External Payroll Systems |
26 | T5UOT | Tax Services: Terminations and Inactives | 7 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPNetherlands |
27 | T5N14 | Additional Legal Person Data for Wage Return | 6 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPPayroll General Parts |
28 | HRPY_RGDIR | Directory for Payroll Results | 20 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
29 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 20 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
30 | PYNOSCREEN | Selection Screen Fields (Only as Interface) | 10 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
31 | T506D | Conditions for Employee Loans | 7 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
32 | T549M | Monthly Assignment: Payroll Period (no longer used) | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
33 | T549Z | Calendar for payment model | 3 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
34 | T54C1 | Calendar for Cumulation | 3 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
35 | T558B | Payroll Account Transfer: Payroll Periods | 7 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
36 | PA0002 | HR Master Record: Infotype 0002 (Personal Data) | 53 | PERMO | Modifier for Personnel Identifier | nvarchar | 2 | 0 | | |
37 | T510W | Pay Scale > Period Parameter Assignment | 8 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
38 | T549A | Payroll areas | 3 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
39 | T549N | Period Modifiers | 3 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
40 | T549R | Period Parameters | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
41 | T549R_CUST | Mapping of Period Modifier with Molga | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
42 | T549W | Recurr. Pymts/Deducs: Payment Models | 4 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPPublic Sector |
43 | T7MXPBS30 | SAR - Report Period Table | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPRecruitment |
44 | PB0002 | HR Master Record: Infotype 0002 (Personal Data) | 53 | PERMO | Modifier for Personnel Identifier | nvarchar | 2 | 0 | | |
TOPReporting |
45 | T77PRNL_ADDLPD | Pension Return: Additional Legal Person Data | 5 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPSingapore |
46 | PA0412 | HR Master Record: Infotype 0412 [View to I0021] (SG) | 47 | PERMO | Modifier for Personnel Identifier | nvarchar | 2 | 0 | | |
TOPSouth Africa |
47 | T5W1K | Pension Funds and Medical Aid Schemes (RSA) | 8 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
48 | T5W2I | (Old) RSA Tax Year Specifications | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
49 | T5W2Q | South African Tax Year Status | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPSpain |
50 | T5EI6 | Arrears by period and grouper | 2 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |
TOPUSA |
51 | PA0106 | HR Master Record: Infotype 0106 (Related Persons NA) | 24 | PERMO | Modifier for Personnel Identifier | nvarchar | 2 | 0 | | |
52 | T5UB8 | Benefits Payment Model Assignment | 4 | PERMO | Period Parameters | nvarchar | 2 | 0 | | |