| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 25 | TRFST | | nvarchar | 2 | 0 | | |
2 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 26 | TRFST | | nvarchar | 2 | 0 | | |
3 | DFKK_TRIGX_CL | Outbound Interface: New Trigger Table of Cleared Items | 13 | TRFST | Outbound Intrface: Trigger Status | nvarchar | 1 | 0 | | |
4 | DFKK_TRIGX_OP | Outbound Interface: New Trigger Table for Business Partner | 9 | TRFST | Outbound Intrface: Trigger Status | nvarchar | 1 | 0 | | |
5 | DFKK_TRIGX_PAY | Outbound Interface: New Trigger Table for Payment Info | 19 | TRFST | Outbound Intrface: Trigger Status | nvarchar | 1 | 0 | | |
6 | DFKK_TRIGX_RCL | OI: New Trigger Table for Reopened Items | 15 | TRFST | Outbound Intrface: Trigger Status | nvarchar | 1 | 0 | | |
7 | P2B2_ALP | HCM Declustering B2 - Alternative Payment Table ALP | 22 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
8 | P2B2_CWST | HCM Declustering B2 - PDC Time Tickets | 89 | TRFST | Pay scale level | nvarchar | 2 | 0 | | |
9 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 43 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
10 | P2B2_WST | HCM Declustering B2 - PDC Time Tickets | 89 | TRFST | Pay scale level | nvarchar | 2 | 0 | | |
11 | P2RQ_QHDA | HR-AU-PS: Payroll structure for Higher Duty Allowance | 27 | TRFST | Pay scale level of the higher duty position | nvarchar | 2 | 0 | | |
12 | P2RR_RM | Payroll Results: Table for Master data (SG) | 42 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
13 | P2RV_VAP | VAP Structure Norway | 18 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
14 | P2RX_ALP | Alternative Payment Table ALP | 20 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
15 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 41 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
16 | P2UN_QHDA | HR-UN: Payroll structure for Higher Duty Allowance | 27 | TRFST | Pay scale level of the higher duty position | nvarchar | 2 | 0 | | |
17 | P2UN_RS | UN Rental Subsidy internal structure | 52 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
18 | PA0576 | HR Master Record Infotype 0576 | 28 | TRFST | | nvarchar | 2 | 0 | | |
19 | T510E | Dynamic Standard Pay Increase II | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
20 | T510N | Pay Scales for Annual Salaries (NA) | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
21 | T5FPBS4B | Echelon | 6 | TRFST | Échelon | nvarchar | 2 | 0 | | |
22 | T5GPBSS_PSC | SWF: Pay Scale | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
23 | T5GPBSS_PSC2 | SWF: Pay Scale | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
24 | T5PPBS5SS | Progression depending on seniority session table | 13 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
25 | T5PPBS8A | Index Value for Pay Scale Type, Area, Group, and Level | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
26 | T7UNPF_HR_CATM | Mapping table for Pay scale type to Salary Category | 5 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
27 | ZCATSDB | Records changed with processing status '10' | 42 | TRFST | | nvarchar | 2 | 0 | | |
28 | ZCATSDB2 | Records changed with processing status '10' | 43 | TRFST | | nvarchar | 2 | 0 | | |
TOPArgentina |
29 | T7AR65 | Pay scale agreement category identification | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPAttendancesAbsences |
30 | CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR | 48 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPCompensation Management |
31 | PA0380 | HR Master Data Record Infotype 0380 (Comp. Adjustment) | 33 | TRFST | Pay Grade Level | nvarchar | 2 | 0 | | |
32 | T510D | Dynamic Standard Pay Increase | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
33 | T510R | Pay Scale Reclassification | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
34 | T510_PSRCL | Pay scale reclassification | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
35 | DFKK_TRIGGER_CL | Outbound Interface: Trigger Table of Cleared Items | 12 | TRFST | Outbound Intrface: Trigger Status | nvarchar | 1 | 0 | | |
36 | DFKK_TRIGGER_OP | Outbound Interface: Trigger Table for Business Partner | 8 | TRFST | Outbound Intrface: Trigger Status | nvarchar | 1 | 0 | | |
37 | DFKK_TRIGGER_PAY | Outbound Interface: Trigger Table for Payment Information | 18 | TRFST | Outbound Intrface: Trigger Status | nvarchar | 1 | 0 | | |
38 | DFKK_TRIGGER_RCL | Outbound Interface: Trigger Table for Reopened Items | 14 | TRFST | Outbound Intrface: Trigger Status | nvarchar | 1 | 0 | | |
TOPDenmark |
39 | T5MF6 | Conversion of R/3 Pay Scale Structure to FA PS Structure | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPESS Based on WD ABAP |
40 | HRESS_D_CATS_FAV | CATS Favorites: database table | 49 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPFinland |
41 | T7FI510 | TVR relevant payscale group/level (Finland) | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPGermany |
42 | T5D3M | Assignment of a Valuation of Pay Scales for Statistics | 9 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPIndia |
43 | T7INA3 | Allowance grouping definition table | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPItaly |
44 | PA3214 | HR Master Record: Infotype 3214 | 276 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
45 | T5ITC4 | Lowest rate amounts | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
46 | T5ITS1 | Percentage pay scale jumps - percentage ceiling | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
47 | T5ITS2 | Amount-based pay scale jumps - number/amount-based ceiling | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
48 | T5ITS3 | Amount-based pay scale jumps - fractional no. based ceiling | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
49 | T5ITS4 | Percentage pay scale jumps - number-based ceiling | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
50 | T5ITS7 | Insurance pay scale jumps - class change | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPJapan |
51 | T5J59 | HR Job promotion - pay scale level ordering JPN | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPKorea |
52 | T7KR32 | Standardized monthly compensation | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPNew Zealand |
53 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 45 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPNon Profit Organizations |
54 | PA0961 | HR Master Record: Infotype 0961 | 32 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
55 | PA0965 | HR Master Record: Infotype 0965 | 62 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
56 | T7UNPAD_DPDS | Dependency Allowance: Lowest Entry Level Determinatio | 9 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPPayroll |
57 | T5HPBS01 | Szorzószámok | 6 | TRFST | Bérrendszerszint | nvarchar | 2 | 0 | | |
58 | T5HPBS01X | Szorzószámok | 6 | TRFST | Bérrendszerszint | nvarchar | 2 | 0 | | |
59 | T5HPBS62 | Közalkalmazotti pótszabadság megképzését vezérlo tábla | 4 | TRFST | Bérrendszerszint | nvarchar | 2 | 0 | | |
60 | T5HPBS63 | Generating leave quotas | 4 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
61 | T5HPBS96 | Foreign exchange multipliers (for IT3265) | 4 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
62 | T5HPBS98 | FX multipliers for long-term studies abroad | 4 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
63 | T5T10 | Tarif groups - ext.survey | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
64 | T7SK10 | Tarif groups - ext.survey | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPPayroll General Parts |
65 | HRPY_WPBP | HR-PAY: Transparent Table WPBP | 32 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPPension Administration |
66 | PA0845 | HR Master Record Infotype 0845 (Work Relationships) | 29 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
67 | PA0008 | HR Master Record: Infotype 0008 (Basic Pay) | 27 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
68 | PA0052 | HR Master Record: Infotype 0052 (Wage Maintenance) | 28 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
69 | T510 | Pay Scale Groups | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
70 | T510M | Valuation of pay scale groups acc. to hiring date | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
71 | T510U | Pay Scale Groups | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
72 | T528B | Positions | 11 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
73 | T5ITS5 | Scatti in categoria tetto massimo in numero - HR Italy | 6 | TRFST | Livello retributivo | nvarchar | 2 | 0 | | |
74 | T5ITS8 | Scatti assicurativi premio fedelta' | 6 | TRFST | Livello retributivo | nvarchar | 2 | 0 | | |
TOPPersonnel Time Events |
75 | TPTCOR_APL | Different Payment (Correction Scenario) | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
76 | CC1ERP | Incorrect Time Events from CC1, Postings | 48 | TRFST | Pay scale level | nvarchar | 2 | 0 | | |
77 | CC1TEV | Temporary Buffer for Time Events from CC1 | 43 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
78 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 45 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
79 | PA2002 | HR Time Record: Infotype 2002 (Attendances) | 38 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
80 | PA2003 | HR Time Record: Infotype 2003 (Substitutions) | 51 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
81 | PA2004 | HR Time Record: Infotype 2004 (Availability) | 38 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
82 | PA2005 | HR Time Record: Infotype 2005 (Overtime) | 48 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
83 | PA2010 | HR Time Record: Infotype 2010 (Employee Remuneration Info.) | 40 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
84 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 37 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
85 | PTEX2003GEN | Interface Table for IT 2003: General Information | 36 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
86 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 12 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
87 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 36 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
88 | TEVEN | Time Events | 33 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
89 | TEVEN_MORE | Additional Data for Time Events | 47 | TRFST | Pay scale level | nvarchar | 2 | 0 | | |
TOPPortugal |
90 | T5PP1 | HR-PT: Professional categories assignment | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
91 | T5PS1 | HR-PT: professional categories assignment (IRC code) | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPPosition Budgeting and Control |
92 | HRFPM_BPREP_DATA | Preprocesses Data for BPREP Data Extraction | 20 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPPublic Sector |
93 | PA0509 | HR-AU-PS: Master Data (Higher Duty Allowance) | 44 | TRFST | Pay scale level of the higher duty position | nvarchar | 2 | 0 | | |
94 | PDPBSDNEUG_UEB_T | Carried Over to DNeuG: Personnel Pay Scale Information | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
95 | PDPBSTVOED_UEB | Transfer to TVoeD: Personnel Master Record Before Transfer | 8 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
96 | T5APBS06 | Pay scale reclassification | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
97 | T5D7N | Determination of Hiring Level Model 8 | 11 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
98 | T5D82 | Pay Scale Information for Calculation of Minimum Pension | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
99 | T5DPBS1C | Basis for Activity with Higher Rate of Pay | 14 | TRFST | Payment by Pay Scale Level | nvarchar | 2 | 0 | | |
100 | T5DPBS3D | TVoeD: Structural Adjustment | 9 | TRFST | Remuneration Level | nvarchar | 2 | 0 | | |
101 | T5PBSR6G | Basic Component | 5 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
102 | T5QPBS1E | National Wage Case (NWC) increase for Superannuation | 7 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
103 | T5QPBS1H | Priority Table used in calculating HDA super salary comp. | 5 | TRFST | Pay scale level of the higher duty position | nvarchar | 2 | 0 | | |
104 | T5VPPS_510 | Table to update T510 for yrly changes-Norway Public Sector | 4 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
105 | T5VPPS_PSRALV | Norway Public Sector: IT 0509 records in ALV of RPIPSP00 | 12 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPRecruitment |
106 | PB0008 | Applicant Master Record Infotype (Basic Pay) | 27 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPSouth Africa |
107 | T5W10 | Link pay scale groups to occupational level. - Equity | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPSpain |
108 | T5E51 | Seniority bonuses | 4 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
109 | T5E53 | Amounts of seniority bonuses | 6 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPTime Sheet |
110 | CATSDB | CATS: Database Table for Time Sheet | 42 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
111 | CATS_TEMP | CATS: Database Table for Templates | 44 | TRFST | Pay Scale Level | nvarchar | 2 | 0 | | |
TOPTime Tickets |
112 | EVHR | HR Order Confirmations (Times/Time Events) | 47 | TRFST | Pay scale level | nvarchar | 2 | 0 | | |
113 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 47 | TRFST | Pay scale level | nvarchar | 2 | 0 | | |