| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 38 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
2 | P2B2_ABWKONTI | HCM Declustering B2 - Absence Quotas (Table ABWKONTI) | 18 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
3 | P2B2_ALP | HCM Declustering B2 - Alternative Payment Table ALP | 13 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
4 | P2B2_ANWKONTI | HCM Declustering B2 - Attendance Quotas (Table ANWKONTI) | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
5 | P2CN_CNREI | Payroll result: structure for retro difference details | 20 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
6 | P2CN_CNREO | Payroll result: structure for retro difference details | 20 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
7 | P2CO_COAVA | PC2CO_AVA | 34 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
8 | P2HK_RETI | Payroll structure for retroactive accounting | 22 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
9 | P2HK_RETO | Payroll structure for retroactive accounting | 22 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
10 | P2HR_CUF | Structure of difference table Croatia | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
11 | P2HR_CUP | Structure of difference table Croatia | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
12 | P2HR_DTF | Structure of difference table Croatia | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
13 | P2HR_DTP | Structure of difference table Croatia | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
14 | P2IS_RETI | Payroll structure for retroactive accounting | 22 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
15 | P2IS_RETO | Payroll structure for retroactive accounting | 22 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
16 | P2MX_GRORD | Maintenance payment order | 16 | ZEINH | Payroll Time Units | nvarchar | 2 | 0 | | |
17 | P2NZ_SALSAC | Salary Sacrifice Details | 19 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
18 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 20 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
19 | P2RB_I0125 | Garnishment payroll Belgium | 21 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
20 | P2RD_XIT | Payroll Results: Extended IT | 15 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
21 | P2RD_ZTBAU | Payroll Result: Construction Pay Daily Statement | 10 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
22 | P2RG_COURT | Types of Court Order (GB) | 36 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
23 | P2RH_HU_HKIF | P21PB | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
24 | P2RH_HU_MEMB | P21MB | 14 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
25 | P2RH_HU_NREN | P21PA | 14 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
26 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
27 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 19 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
28 | P2RK_GRORD | Payroll results Canada: Garnishment order | 17 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
29 | P2RN_NSR0 | Payroll Results: Special Provisions (NL) | 11 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
30 | P2RP_SCRT | HR-PT: Cumulated result table (Legal entity dependent) | 11 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
31 | P2RQ_HT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
32 | P2RQ_NT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
33 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
34 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
35 | P2RR_RM | Payroll Results: Table for Master data (SG) | 23 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
36 | P2RR_SRT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
37 | P2RU_GRDOC | Payroll Results: Garnishment for US Document | 23 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
38 | P2RX_ALP | Alternative Payment Table ALP | 11 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
39 | P2RX_DFT | Payroll Results: Differences for Gross/Net Payroll | 8 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
40 | P2RX_GRT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
41 | P2RX_RT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
42 | P2RX_RT_PERSON | Results Table (Person) | 21 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
43 | P2SI_CUF | Difference table of payroll results | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
44 | P2SI_CUP | Difference table of payroll results | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
45 | P2SI_DTF | Difference table of payroll results | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
46 | P2SI_DTP | Difference table of payroll results | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
47 | P2TN_TWOT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
48 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 20 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
49 | P2UA_UART | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
50 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 21 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
51 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 21 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
52 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 21 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
53 | P2UN_HT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
54 | P2UN_NT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
55 | P2UR_RURT | Payroll Results: Results Table | 17 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
56 | PA0297 | HR Master Record: Infotype 0297 Work conditions | 32 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
57 | PA3364 | HR Master Record: Infotype 3364 | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
58 | T538B | Units of Time/Measurement | 4 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
59 | T538C | Permissibility of Time/Measurement Units for Infotypes | 3 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
60 | T538Z | Permissibility of Time/Measurement Units for Infotypes | 3 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
61 | T5D1T | SI Assessment Threshold | 9 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
62 | T5M3U | Bank Transfer Types (Denmark) | 2 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
63 | T5UPBSPOOL | Sick Leave Pool | 4 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
64 | T5UPBSPOOLA | Sick Leave Pool Attributes | 11 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
65 | T7RU53P | Status for time accounting for PSG | 5 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPAustralia |
66 | PA0701 | HR Terminations Data Container : Infotype 0701 | 70 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
67 | T5QRS | Terminations Redundancy Payments Australia | 12 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPAustria |
68 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 18 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPBelgium |
69 | PA0125 | HR Master Record: Infotype 0125 (Garnishment B) | 27 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPBrazil |
70 | T7BRQT | Absence quota type | 9 | ZEINH | Unit of measure/time | nvarchar | 3 | 0 | | |
TOPCanada |
71 | PA0067 | HR master data infotype 0067 - Canadian garnishment: debt | 44 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
TOPChile |
72 | T7CL17 | Tax Brackets | 2 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
TOPCompany Pension Scheme Germany |
73 | P01CSO | Special Information | 10 | ZEINH | Time/measurement unit | nvarchar | 3 | 0 | | |
74 | P01CVD | Actuarial CPS Data | 37 | ZEINH | Time unit for determining next payment | nvarchar | 3 | 0 | | |
75 | PA0202 | HR Master Record Infotype 0202 (Entitlements) | 34 | ZEINH | Time/measurement unit | nvarchar | 3 | 0 | | |
76 | T5DCA | Entitlements / Benefit Types | 31 | ZEINH | Time/measurement unit | nvarchar | 3 | 0 | | |
TOPCompensation Management |
77 | T50X1 | Type of Expatriate | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPConfirmations |
78 | AFRV | Confirmation pool | 57 | ZEINH | 3-Byte field | nvarchar | 3 | 0 | | |
79 | AFRV_DEL | Backup Copy for Confirmation Pool | 57 | ZEINH | 3-Byte field | nvarchar | 3 | 0 | | |
TOPConstruction Industry |
80 | PA0215 | Construction Pay Transaction Data | 32 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPGermany |
81 | P01Y15 | PAISY: Management Table Subrecord Type 15 | 20 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPGreat Britain |
82 | PA0070 | HR Master Record: Infotype 0070 (Court Orders - GB) | 51 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPIndia |
83 | T77WWW_INFAP | Additional Payments Configuration | 9 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPIndonesia |
84 | T7ID2L | Tax Constant Amounts (Indonesia) | 4 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
TOPIreland |
85 | PA0386 | HR Master Record: Infotype 0386 (VHI Scheme) | 27 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPMaster Data |
86 | RSDB | Index of the RESB for the Direct Procurement Element | 14 | ZEINH | Unit for the time interval between relationships | nvarchar | 3 | 0 | | |
TOPNetherlands |
87 | PA0317 | HR Master Record: Infotype 0317 (Special Provisions) | 28 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPNetwork and Activity |
88 | AFAB | Network - Relationships | 9 | ZEINH | Unit for the time interval between relationships | nvarchar | 3 | 0 | | |
89 | PLAB | Relationships | 15 | ZEINH | Unit for the time interval between relationships | nvarchar | 3 | 0 | | |
TOPOff-Cycle |
90 | T52OCAP | Payroll in Advance - Default Values for Number of Periods | 3 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
TOPPayroll |
91 | PA3234 | HR master record, infotype 3234 | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
92 | PA3261 | Commission contracts H | 34 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
93 | T5HPBS_T538C_DAY | Comm. - number of days for IT3261 time units | 2 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
94 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 31 | ZEINH | Casová/merná jednotka | nvarchar | 3 | 0 | | |
95 | T7SKEC0011 | Logovacia tabulka pre EURO konverziu - IT 0011 | 32 | ZEINH | Casová/merná jednotka | nvarchar | 3 | 0 | | |
TOPPayroll General Parts |
96 | PA0267 | HR Master Record: Infotype 0267 (One time Payment off-cycle) | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
97 | PA0477 | Personnel Master Record Infotype 0477: Debt (Garnishments) | 50 | ZEINH | Payroll Time Unit | nvarchar | 2 | 0 | | |
98 | T510H | Payroll Parameters for Time Unit | 4 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
99 | T512K | Text for Payroll Constants Regarding Time Units | 5 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
100 | T549P | Valid Time Units for Payroll | 2 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
101 | T54C2 | Calendar Type | 3 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
102 | T54C4 | Valid Calendar Types | 3 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
103 | T558D | Transfer Wage Types with Split Indicator | 16 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
104 | T56C1 | Parameter for Cumulation Types | 3 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
105 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 28 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
106 | PA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
107 | PA0014 | HR Master Record: Infotype 0014 (Recur. Payments/Deds.) | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
108 | PA0015 | HR Master Record: Infotype 0015 (Additional Payments) | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
109 | PA0040 | HR Master Record: Infotype 0040 (Objects on Loan) | 26 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
110 | PA0057 | HR Master Record: Infotype 0057 (Membership Fees) | 31 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
111 | PA0441 | Corrections for reports (Hungary) | 27 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
112 | PA0657 | HR Master Record: Infotype 0657 | 39 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
113 | T510F | Assign Pay Scale --> Currency | 8 | ZEINH | Not used | nvarchar | 2 | 0 | | |
114 | T511 | Wage Types | 9 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
115 | T531 | Deadline Types | 4 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
116 | T538A | HR Time/Measurement Units | 2 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
117 | T538D | Units of Time/Measurement | 4 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
118 | T538T | Units of Time/Measurement Texts | 3 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
119 | T549R | Period Parameters | 3 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
120 | T7COT8 | Payroll external results transfer: COAVA | 34 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPPersonnel Management |
121 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 21 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPPersonnel Time Management |
122 | PA2010 | HR Time Record: Infotype 2010 (Employee Remuneration Info.) | 30 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
123 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 31 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
124 | T554W | Periods of Military Service | 8 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
125 | T555W | [OBSOLETE; NOW USE T705K] Ext. Wages Types from Subsystem | 10 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
126 | T556A | Absence Quota Types | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
127 | T556P | Attendance Quotas | 7 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
128 | T556R | Rules for Deduction Sequence for Absence Quotas | 8 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
129 | T557M | Time Types Relationships Table (from Period Totals Table) | 6 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
130 | T705K | External Wage Types for Subsystem | 10 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
131 | TEVEN | Time Events | 12 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
132 | TEXLGA | Employee Expenditures | 11 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPPhilippines |
133 | T7PHTA | Tax installment amounts per salary bracket | 3 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
134 | T7PHTW | Period Tax Withheld | 2 | ZEINH | Payroll time units | nvarchar | 2 | 0 | | |
TOPPlant Data Collection |
135 | RUECK | Temp. storage for subsystem confirmations | 52 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPProcess Controls -Automated Controls |
136 | GRPCRTA_HRDA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 27 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
137 | GRPCRTA_HRDA0267 | PC HR control data for infotype 0267 | 27 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
138 | GRPCRTA_HRDAT1 | PC HR control data for infotype 0014 and 0015 | 27 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPRecruitment |
139 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 28 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
140 | PB0014 | Applicant Master Record IT 0014 Recurring Pymnts/Deductions | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
141 | PB0015 | Applicant Master Record Infotype 0015 (Additional Payments) | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPRouting |
142 | PLMZ | Allocation of bill of material items to operations | 40 | ZEINH | Unit for the time interval between relationships | nvarchar | 3 | 0 | | |
TOPSimulation |
143 | VSAFAB_CN | Version: Network relationships | 10 | ZEINH | Unit for the time interval between relationships | nvarchar | 3 | 0 | | |
144 | VSRSDB_CN | Version: Index of RESB for direct procurement elements | 15 | ZEINH | Unit for the time interval between relationships | nvarchar | 3 | 0 | | |
TOPSouth Africa |
145 | PA0151 | HR Master Record Infotype 0151 (Ext.Insurance South Africa) | 31 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
146 | T5W1N | Social insurance schemes | 15 | ZEINH | Payroll frequency. Used for medical aid tables | nvarchar | 2 | 0 | | |
TOPSwitzerland |
147 | PA0120 | HR Master Record: Infotype 0120 (Pension Fund Trans. CH) | 29 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
TOPTools |
148 | PA0579 | HR Master Record Infotype 0579 (Ext. Wage Components) | 33 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | |
149 | T532B | HR: Connection to Third-Party Payroll: Choice of Wage Types | 18 | ZEINH | Component 709: Entry field for field selection in PC207 | nvarchar | 1 | 0 | | |
TOPWarehouse Management |
150 | T328 | Warehouse Activity Monitor: Defin. of Critical Parameters | 8 | ZEINH | Warehouse activity monitor: Time unit for critical duration | nvarchar | 3 | 0 | | |