| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 14 | ORGEH | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 15 | ORGEH | | nvarchar | 8 | 0 | | |
3 | /OTEI/DU_WD_DCTP | Document types customzing table | 4 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
4 | CNVLTHCM_APLNO | Application Number Organisational data (Before Conversion) | 17 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
5 | CNVLTHCM_PERNR | Personnel Number Organisational data (Before Conversion) | 17 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
6 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 27 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
7 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 25 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
8 | PA3343 | HR Master Record: Infotype 3343 | 25 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
9 | T5BPBS27X | Organisational units and Employee's activity Code (NACE) | 3 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
10 | T5REG | Employee Information Log for Destruction of Data | 19 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
11 | T5RPD | Personnel Data Deletion Log | 29 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
12 | T77WWW_TEAAD | Administrative Data | 45 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
13 | T77WWW_TEAAD_BU | Administrative Data - Back Up | 45 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
14 | ZSY_CRM_ORG | Region and Pernr configuration for CRM Syclo User | 3 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPBasic Functions |
15 | T011E | Calendar of person responsible for unit | 3 | ORGEH | Organization object | nvarchar | 14 | 0 | | |
TOPCompensation Management |
16 | PA0395 | HR Master Record: Infotype 0395 (External Org.Assignment) | 27 | ORGEH | Organizational Unit External | nvarchar | 40 | 0 | | |
TOPCross-Application Objects in HR |
17 | HRP5581 | DB Table for Infotype 5581 | 19 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPItaly |
18 | PA3214 | HR Master Record: Infotype 3214 | 270 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPJapan |
19 | PA0853 | HR Master Record: Infotype 0853 | 31 | ORGEH | Organizational Unit External | nvarchar | 40 | 0 | | |
TOPLogbook |
20 | ADFSH_PRTHEAD | Flight Scheduling: PRT Master records | 2 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
21 | ADFSH_PRTHEAD_T | Flight Scheduling: PRT Description | 3 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPMaintenance Processing |
22 | /MRSS/C_PREMK | Dummy table for creating Org. Assgnmnt Search Help (No Data) | 9 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPPayroll |
23 | PA3261 | Commission contracts H | 26 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
24 | PA3265 | HR master record, infotype 3265 | 30 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
25 | T5HPBS07 | Szervezeti egységek címe | 2 | ORGEH | Szervezeti egység | nvarchar | 8 | 0 | | |
26 | T5HPBS78 | Konvertáló tábla szervezeti egység és részterület között | 3 | ORGEH | Szervezeti egység | nvarchar | 8 | 0 | | |
TOPPayroll General Parts |
27 | HRPY_WPBP | HR-PAY: Transparent Table WPBP | 23 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
28 | PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 35 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
29 | PA0030 | HR Master Record: Infotype 0030 (Powers of Attorney) | 25 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
30 | PB0395 | HR Master Record: Infotype 0395 (External Org.Assignment) | 27 | ORGEH | Organizational Unit External | nvarchar | 40 | 0 | | |
31 | T527X | Organizational Units | 3 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
32 | T528B | Positions | 18 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPPublic Sector |
33 | PA0509 | HR-AU-PS: Master Data (Higher Duty Allowance) | 141 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
34 | T5D8K | Assignment of Exception Indicator to Organizational Unit | 2 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPRecruitment |
35 | PB0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 35 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
36 | T750X | Vacancy | 10 | ORGEH | Reserve field/unused field 8 characters in length | nvarchar | 8 | 0 | | |
TOPSouth Africa |
37 | T5W8P | Strategic Skills Priorities | 3 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPTaiwan |
38 | T7TW2I | Reported data of Tax withdrawal report | 34 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
TOPUSA |
39 | T5U26 | WC: Assignment of WC to Organizational Units | 2 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |
40 | T5U27 | EEO/AAP: Organizational Unit attributes | 2 | ORGEH | Organizational Unit | nvarchar | 8 | 0 | | |