| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 16 | PLANS | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 16 | PLANS | | nvarchar | 8 | 0 | | |
3 | CNVLTHCM_APLNO | Application Number Organisational data (Before Conversion) | 18 | PLANS | Position | nvarchar | 8 | 0 | | |
4 | CNVLTHCM_PERNR | Personnel Number Organisational data (Before Conversion) | 18 | PLANS | Position | nvarchar | 8 | 0 | | |
5 | HRAE_D_NOMINEES | Promotion Nominees | 5 | PLANS | Position | nvarchar | 8 | 0 | | |
6 | P2AR_ARSES | Social Insurance master data | 17 | PLANS | Welfare Fund plan | nvarchar | 10 | 0 | | |
7 | P2B2_ALP | HCM Declustering B2 - Alternative Payment Table ALP | 16 | PLANS | Position | nvarchar | 8 | 0 | | |
8 | P2B2_CWST | HCM Declustering B2 - PDC Time Tickets | 120 | PLANS | Position | nvarchar | 8 | 0 | | |
9 | P2B2_VERT | HCM Declustering B2 - Table VERT | 24 | PLANS | Position | nvarchar | 8 | 0 | | |
10 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 23 | PLANS | Position | nvarchar | 8 | 0 | | |
11 | P2B2_WST | HCM Declustering B2 - PDC Time Tickets | 120 | PLANS | Position | nvarchar | 8 | 0 | | |
12 | P2RJ_KGT | Kijungai time occured in for-period with Position info | 9 | PLANS | Position | nvarchar | 8 | 0 | | |
13 | P2RQ_QHDA | HR-AU-PS: Payroll structure for Higher Duty Allowance | 19 | PLANS | Higher duty position | nvarchar | 8 | 0 | | |
14 | P2RR_RM | Payroll Results: Table for Master data (SG) | 46 | PLANS | Position | nvarchar | 8 | 0 | | |
15 | P2RV_VAP | VAP Structure Norway | 12 | PLANS | Position | nvarchar | 8 | 0 | | |
16 | P2RX_ALP | Alternative Payment Table ALP | 14 | PLANS | Position | nvarchar | 8 | 0 | | |
17 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 21 | PLANS | Position | nvarchar | 8 | 0 | | |
18 | P2UN_QHDA | HR-UN: Payroll structure for Higher Duty Allowance | 19 | PLANS | Higher duty position | nvarchar | 8 | 0 | | |
19 | PA3343 | HR Master Record: Infotype 3343 | 24 | PLANS | Assigned Position | nvarchar | 8 | 0 | | |
20 | PA3356 | HR Master Record: Infotype 3356 | 31 | PLANS | Target Position | nvarchar | 8 | 0 | | |
21 | T5REG | Employee Information Log for Destruction of Data | 20 | PLANS | Position | nvarchar | 8 | 0 | | |
22 | T5RPD | Personnel Data Deletion Log | 30 | PLANS | Position | nvarchar | 8 | 0 | | |
23 | ZCATSDB | Records changed with processing status '10' | 46 | PLANS | | nvarchar | 8 | 0 | | |
24 | ZCATSDB2 | Records changed with processing status '10' | 47 | PLANS | | nvarchar | 8 | 0 | | |
TOPArgentina |
25 | PA0392 | Social Security: General data | 30 | PLANS | Welfare Fund plan | nvarchar | 10 | 0 | | |
26 | T7AR46 | Welfare Fund plans | 3 | PLANS | Welfare Fund plan | nvarchar | 10 | 0 | | |
TOPAttendancesAbsences |
27 | CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR | 52 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPAustria |
28 | T5A4S | Assgmt Job/Pos. to Heavy Labor Pos. in Acc. with Sec. 5 Reg. | 4 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPBrazil |
29 | T7BRCB | Brazilian Job Occupation Code (by position) | 2 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPCanada |
30 | T5K14 | Assignment Positions to NOC | 2 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPClinical System |
31 | N1MAPS | ISHMED: Employee-position staffing | 3 | PLANS | Position/Workplace Code | nvarchar | 8 | 0 | | |
32 | N1PLST | ISHMED: Position | 2 | PLANS | Position/Workplace Code | nvarchar | 8 | 0 | | |
33 | N1PLSTT | ISHMED: Position text | 3 | PLANS | Position/Workplace Code | nvarchar | 8 | 0 | | |
34 | N1PSAUF | ISHMED: Position Task | 2 | PLANS | Position/Workplace Code | nvarchar | 8 | 0 | | |
TOPCross-Application Objects in HR |
35 | HRP5581 | DB Table for Infotype 5581 | 18 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPDenmark |
36 | T5MF8 | FA: Default Work Function, Work Level, Management Level | 3 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPESS Based on WD ABAP |
37 | HRESS_D_CATS_FAV | CATS Favorites: database table | 53 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPFrance |
38 | T5FPD28 | Public Revenue Office position | 3 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPItaly |
39 | PA3214 | HR Master Record: Infotype 3214 | 271 | PLANS | Position | nvarchar | 8 | 0 | | |
40 | T5ITPM | Check Table for Higher Duties : infotype (3214) subtype 0002 | 6 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPNew Zealand |
41 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 49 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPPayroll |
42 | PA3265 | HR master record, infotype 3265 | 31 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPPayroll General Parts |
43 | HRPY_WPBP | HR-PAY: Transparent Table WPBP | 19 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
44 | PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 36 | PLANS | Position | nvarchar | 8 | 0 | | |
45 | T528B | Positions | 3 | PLANS | Position | nvarchar | 8 | 0 | | |
46 | T528C | Wage Type Catalog | 3 | PLANS | Position | nvarchar | 8 | 0 | | |
47 | T528T | Position Texts | 4 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPPersonnel Time Events |
48 | TPTCOR_APL | Different Payment (Correction Scenario) | 4 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPPersonnel Time Management |
49 | CC1ERP | Incorrect Time Events from CC1, Postings | 18 | PLANS | Position | nvarchar | 8 | 0 | | |
50 | CC1TEV | Temporary Buffer for Time Events from CC1 | 17 | PLANS | Position | nvarchar | 8 | 0 | | |
51 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 49 | PLANS | Position | nvarchar | 8 | 0 | | |
52 | PA2002 | HR Time Record: Infotype 2002 (Attendances) | 42 | PLANS | Position | nvarchar | 8 | 0 | | |
53 | PA2003 | HR Time Record: Infotype 2003 (Substitutions) | 55 | PLANS | Position | nvarchar | 8 | 0 | | |
54 | PA2004 | HR Time Record: Infotype 2004 (Availability) | 42 | PLANS | Position | nvarchar | 8 | 0 | | |
55 | PA2005 | HR Time Record: Infotype 2005 (Overtime) | 52 | PLANS | Position | nvarchar | 8 | 0 | | |
56 | PA2010 | HR Time Record: Infotype 2010 (Employee Remuneration Info.) | 44 | PLANS | Position | nvarchar | 8 | 0 | | |
57 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 41 | PLANS | Position | nvarchar | 8 | 0 | | |
58 | PTEX2003GEN | Interface Table for IT 2003: General Information | 40 | PLANS | Position | nvarchar | 8 | 0 | | |
59 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 16 | PLANS | Position | nvarchar | 8 | 0 | | |
60 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 40 | PLANS | Position | nvarchar | 8 | 0 | | |
61 | TEVEN | Time Events | 20 | PLANS | Position | nvarchar | 8 | 0 | | |
62 | TEVEN_MORE | Additional Data for Time Events | 17 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPPublic Sector |
63 | PA0509 | HR-AU-PS: Master Data (Higher Duty Allowance) | 36 | PLANS | Higher duty position | nvarchar | 8 | 0 | | |
64 | T5D8I | Assignment of Exception Indicator to Position | 3 | PLANS | Position | nvarchar | 8 | 0 | | |
65 | T5D8M | Position Table for College Statistics | 4 | PLANS | Position | nvarchar | 8 | 0 | | |
66 | T5VPPS_PSRALV | Norway Public Sector: IT 0509 records in ALV of RPIPSP00 | 4 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPRecruitment |
67 | PB0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 36 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPSouth Africa |
68 | T5W16 | Position to SOC Code Allocation (South Africa) | 2 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPSweden |
69 | T5S8B | ISCO + SSYK codes | 3 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPTime Sheet |
70 | CATSDB | CATS: Database Table for Time Sheet | 46 | PLANS | Position | nvarchar | 8 | 0 | | |
71 | CATS_TEMP | CATS: Database Table for Templates | 48 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPTime Tickets |
72 | EVHR | HR Order Confirmations (Times/Time Events) | 17 | PLANS | Position | nvarchar | 8 | 0 | | |
73 | LSHR | HR Order Confirmations (Durations/Time Tickets) | 17 | PLANS | Position | nvarchar | 8 | 0 | | |
TOPUSA |
74 | T5U28 | WC: Position Attributes | 2 | PLANS | Position | nvarchar | 8 | 0 | | |
75 | T5U29 | EEO/AAP: Position Attributes for US | 2 | PLANS | Position | nvarchar | 8 | 0 | | |