| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRBW_REC_DT | PY-XX-RECON : Country specific reports detailed results | 11 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
2 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 14 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
3 | P2AA_SV_SA | Payroll Result: SI Data for KSA | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
4 | P2AR_ARSES | Social Insurance master data | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
5 | P2B2_AB | HCM Declustering B2 - Absences | 10 | CNTR1 | National split | varbinary | 1 | 0 | | |
6 | P2BG_BG_OSI | OSI properties Bulgaria | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
7 | P2CN_CNREI | Payroll result: structure for retro difference details | 11 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
8 | P2CN_CNREO | Payroll result: structure for retro difference details | 11 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
9 | P2CO_COAVA | PC2CO_AVA | 25 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
10 | P2CO_COBTR | PC2CO_BTR | 9 | CNTR1 | SI split | varbinary | 1 | 0 | | |
11 | P2CO_COGAR | PC2CO_GAR | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
12 | P2EM_SV_AE | Payroll Result: SI Data for UAE | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
13 | P2FI_CSI | Social ins & result structure for Finland | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
14 | P2FI_SI | Social ins & result structure for Finland | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
15 | P2FI_SIRT | SI result table for Finland, cumulated wage type level | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
16 | P2HK_RETI | Payroll structure for retroactive accounting | 13 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
17 | P2HK_RETO | Payroll structure for retroactive accounting | 13 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
18 | P2HK_SV | HR-HK: Payroll structure for the MPF/ORSO Contribution | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
19 | P2HR_SI | SI properties Croatia | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
20 | P2IN_EPF | Payroll structure for Provident Fund Infotype | 6 | CNTR1 | SI split | varbinary | 1 | 0 | | |
21 | P2IN_ESI | ESI - Payroll Structure India | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
22 | P2IN_GRY | Payroll structure for Gratuity | 6 | CNTR1 | SI split | varbinary | 1 | 0 | | |
23 | P2IN_SAN | Payroll structure for Superannuation | 6 | CNTR1 | SI split | varbinary | 1 | 0 | | |
24 | P2IS_INS | Payroll Indonesia JAMSOSTEK & Other Insurance Data | 5 | CNTR1 | Split Counter | nvarchar | 2 | 0 | | |
25 | P2IS_RETI | Payroll structure for retroactive accounting | 13 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
26 | P2IS_RETO | Payroll structure for retroactive accounting | 13 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
27 | P2KR_KRSI | Payroll Result Korea : Social Insurance | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
28 | P2KW_SI_KW | Payroll Result: PIFSS Data for Kuwait | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
29 | P2KZ_FUP | Structure for Table FUP - Future Periods | 11 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
30 | P2KZ_TAX | Tax | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
31 | P2MX_SI | Soc. Insurance for calcul. data included | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
32 | P2NZ_NZSUP | Payroll Result: Superannuation (NZSUP) - NZ | 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
33 | P2NZ_SALSAC | Salary Sacrifice Details | 10 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
34 | P2PL_SV | Payroll Result PL: Split 1, social insurance | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
35 | P2QA_SV_QA | Payroll Result: SI Data for Qatar | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
36 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 11 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
37 | P2RA_SV | Payroll Result: Technical Social Insurance (A) | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
38 | P2RA_SV_ST | HR-AT: Transfer Data SI -> Tax for Special Payments | 10 | CNTR1 | SI split | varbinary | 1 | 0 | | |
39 | P2RB_BEEVL | Payroll Results: Belgium table for Evaluation | 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
40 | P2RB_SV | Social Insurance payroll Belgium | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
41 | P2RC_SV | Payroll Results: Social Insurance (Switzerland) | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
42 | P2RD_SV | Payroll Result: Social Insurance | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
43 | P2RD_SVZ | Payroll Result: Supplementary Social Insurance | 6 | CNTR1 | SI split | varbinary | 1 | 0 | | |
44 | P2RE_SV | Payroll result: Social Insurance (ES) | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
45 | P2RF_RECOT | Payroll Results: Cumulation of Contributions | 6 | CNTR1 | SI split | varbinary | 1 | 0 | | |
46 | P2RF_SV | Payroll Result: Social Insurance (F) | 5 | CNTR1 | Tax split | varbinary | 1 | 0 | | |
47 | P2RH_HU_HKIF | P21PB | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
48 | P2RH_TB | PC246 | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
49 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
50 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 10 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
51 | P2RK_TAX1 | Payroll results - master data from infotypes 0461-0463 | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
52 | P2RK_TAX2 | Payroll results - Exemption Reasons from IT0224 | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
53 | P2RK_TAXI | Payroll Results - Canada - Influx Principle | 7 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
54 | P2RK_TAXO | Payroll results - master data from infotypes 0461-0463 | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
55 | P2RK_WCB1 | Payroll results - Workers' compensation information | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
56 | P2RK_WTDT | Payroll Results - Wage type processing information | 7 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
57 | P2RL_SOCSO | Payroll result: SOCSO ( Malysian Social Insurance ) | 4 | CNTR1 | SI split | varbinary | 1 | 0 | | |
58 | P2RM_MPAC | Prior Pension Accumulations after PBS Splits | 6 | CNTR1 | SI split | varbinary | 1 | 0 | | |
59 | P2RM_MPENS | Private Pension (DK) | 7 | CNTR1 | SI split | varbinary | 1 | 0 | | |
60 | P2RN_SV | Payroll Results: Social Insurance (NL) | 5 | CNTR1 | Tax split | varbinary | 1 | 0 | | |
61 | P2RO_RO_SI | SI properties Romania | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
62 | P2RP_SS | HR-PT: Payroll Results: Social Security | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
63 | P2RQ_HT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
64 | P2RQ_NT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
65 | P2RQ_QSPR | HR-AU-PS: Payroll structure for Superannuation | 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
66 | P2RQ_QSUP | Superannuation structure for Australia | 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
67 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
68 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
69 | P2RR_ADDF | Payresult: Additional Funds/SG | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
70 | P2RR_CAW | Payroll Results: Table for CPF on AW/SG | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
71 | P2RR_RM | Payroll Results: Table for Master data (SG) | 71 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
72 | P2RR_SRT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
73 | P2RR_SV | Payresult: Soc. Provident Funds/SG | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
74 | P2RS_SFORS | Payroll result: Insurances (SE) | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
75 | P2RT_SV | Structure SV - insurance CZ | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
76 | P2RU_TAX | Payroll Results: Tax (U.S.) | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
77 | P2RW_CSV | Payroll Result: Cumulated SI Data for South Africa | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
78 | P2RW_SCRT | Payroll Result: Cumulated Tax Results for South Africa | 9 | CNTR1 | SI split | varbinary | 1 | 0 | | |
79 | P2RW_SV | Payroll Result: SI Data for South Africa | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
80 | P2RX_AB | Cluster RD/B2: Table AB | 8 | CNTR1 | National split | varbinary | 1 | 0 | | |
81 | P2RX_CODIST | Distribution opf Liabilities | 10 | CNTR1 | SI split | varbinary | 1 | 0 | | |
82 | P2RX_GRT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
83 | P2RX_MODIF | HR-PAY: Modifiers | 6 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
84 | P2RX_RT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
85 | P2RX_RT_PERSON | Results Table (Person) | 12 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
86 | P2SK_SV | Structure of table SV - insurance SK | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
87 | P2TH_SOCSE | Payroll result: Social Security Thailand | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
88 | P2TN_NPTAB | Payroll Structure New Pension Taiwan | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
89 | P2TN_SI | Payroll Structure Labor Insurance Taiwan | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
90 | P2TN_TWOT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
91 | P2UA_FUP | table FUP - future periods | 11 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
92 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 11 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
93 | P2UA_UART | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
94 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 12 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
95 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 12 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
96 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 12 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
97 | P2UN_HT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
98 | P2UN_NT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
99 | P2UN_QSPR | HR-UN: Payroll structure for Superannuation | 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
100 | P2UR_FUP | table FUP - future periods | 11 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
101 | P2UR_RURT | Payroll Results: Results Table | 8 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
102 | P2UR_TAX | Russian Tax | 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
103 | P2VE_INC_EVAL | HRMS-VE: INCE Payment Results | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
104 | P2VE_INT_EVAL | HRMS-VE: Annual Interest Results | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
105 | P2VE_LPH_EVAL | HRMS-VE: Results from Housing Scheme (RPVH) | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
106 | P2VE_PS_EVAL | HRMS-VE: Annual Balance of Profit Share Payments | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
107 | P2VE_SEN | HRMS-VE: Information on Length of Service | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
108 | P2VE_SEN_EVAL | HRMS-VE: Information on Length of Service Payment | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
109 | P2VE_SI | HRMS-VE: Information on Statutory Social Insurance | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
110 | P2VE_SI_EVAL | HRMS-VE: Cumulated Social Insurance Results | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
111 | P2VE_TAX_EVAL | HRMS-VE: Information on Income Tax | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
112 | T7RU_558D_TAX | Split Indicator Tax for Transfered Wage Types | 4 | CNTR1 | HR: Outsourcing: Country Split Indicator - Taxes | nvarchar | 2 | 0 | | |
TOPAustria |
113 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
TOPDenmark |
114 | T5M9H | Split Indicators for Wage Types Sent to PBS | 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
TOPGermany |
115 | T5D0I | Fictitious Run Control: Wage Type Assignment | 13 | CNTR1 | Delete Indicator for SI Split | nvarchar | 1 | 0 | | |
TOPGlobal Trade Services |
116 | /SAPSLL/PREGPPRO | GTS: Preference: Procedure Groups (Data Provider Upload) | 4 | CNTR1 | 2-Digit Sequence Number | nvarchar | 2 | 0 | | |
117 | /SAPSLL/PRFPMRP | SLL: Preference: Log: product: Result of BOM Calc - Proc. | 4 | CNTR1 | 2-Digit Sequence Number | nvarchar | 2 | 0 | | |
118 | /SAPSLL/PSVGPPRO | GTS: Preference: Procedure Groups (Manual Entry) | 4 | CNTR1 | 2-Digit Sequence Number | nvarchar | 2 | 0 | | |
TOPPayroll |
119 | T5T558_AB | HRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP | 7 | CNTR1 | Národní rozdelení | varbinary | 1 | 0 | | |
120 | T7SK558_AB | Transfer absences (supplement to T558D) - SK | 7 | CNTR1 | National split | varbinary | 1 | 0 | | |
TOPPayroll General Parts |
121 | T558D | Transfer Wage Types with Split Indicator | 7 | CNTR1 | HR: Outsourcing: Country Split Indicator - Taxes | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
122 | T7COT5 | Payroll external results transfer: COBTR | 9 | CNTR1 | SI split | varbinary | 1 | 0 | | |
123 | T7COT6 | Payroll external results transfer: COGAR | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
124 | T7COT8 | Payroll external results transfer: COAVA | 25 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
TOPPersonnel Management |
125 | /BKC/S21_EV | Sol21: Vergleich von Abrechnungsergebnissen | 9 | CNTR1 | Zuordnungskennzeichen National | varbinary | 1 | 0 | | |
126 | /BKC/S21_EV1 | Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR. | 8 | CNTR1 | Zuordnungskennzeichen National | varbinary | 1 | 0 | | |
127 | /BKC/S21_RT | C&T! - Table RT for the payroll comparison programs | 10 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
128 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 12 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
129 | /BKC/S21_RT_NOPN | C&T! - Table RT for the payroll comparison programs | 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | |
TOPTools |
130 | T532B | HR: Connection to Third-Party Payroll: Choice of Wage Types | 9 | CNTR1 | Component 709: Entry field for field selection in PC207 | nvarchar | 1 | 0 | | |
TOPVenezuela |
131 | T7VEI1 | Transfer of External Payroll results: Interest | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
132 | T7VEI2 | Transfer of external payroll results: INC contribution | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
133 | T7VEL1 | Transfer of ext. payroll res.: Housing Scheme (RPVH) contr. | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
134 | T7VEP1 | Transfer of External Payroll Results: Profit Share | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
135 | T7VES4 | Transfer of External Payroll Results: SSO/RPE | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
136 | T7VES5 | Transfer of External Payroll Results: Seniority | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |
137 | T7VET1 | Transfer of External Payroll Results: Income Tax | 5 | CNTR1 | SI split | varbinary | 1 | 0 | | |