| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 15 | STELL | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 17 | STELL | | nvarchar | 8 | 0 | | |
3 | CNVLTHCM_APLNO | Application Number Organisational data (Before Conversion) | 19 | STELL | Job | nvarchar | 8 | 0 | | |
4 | CNVLTHCM_PERNR | Personnel Number Organisational data (Before Conversion) | 19 | STELL | Job | nvarchar | 8 | 0 | | |
5 | P2B2_C1 | HCM Declustering B2 - Cost Distribution Table C1 | 35 | STELL | Job | nvarchar | 8 | 0 | | |
6 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 28 | STELL | Job | nvarchar | 8 | 0 | | |
7 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 45 | STELL | Job | nvarchar | 8 | 0 | | |
8 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 45 | STELL | Job | nvarchar | 8 | 0 | | |
9 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 45 | STELL | Job | nvarchar | 8 | 0 | | |
10 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 52 | STELL | Job | nvarchar | 8 | 0 | | |
11 | P2RT_CZDAV | P18_03 | 36 | STELL | Job | nvarchar | 8 | 0 | | |
12 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 52 | STELL | Job | nvarchar | 8 | 0 | | |
13 | P2RV_VAP | VAP Structure Norway | 13 | STELL | Job | nvarchar | 8 | 0 | | |
14 | P2RX_C1 | Cost Distribution Table C1 | 33 | STELL | Job | nvarchar | 8 | 0 | | |
15 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 26 | STELL | Job | nvarchar | 8 | 0 | | |
16 | T5BPBS13 | Link Job <-> Employee function code (ONSSAPL / RSZPPO 073) | 2 | STELL | Job | nvarchar | 8 | 0 | | |
17 | T5C13 | HR-CH: Additional jobs | 2 | STELL | Job | nvarchar | 8 | 0 | | |
18 | T5D13 | Jobs (Germany) | 2 | STELL | Job | nvarchar | 8 | 0 | | |
19 | T5GPBSH13 | HESA: Occupational categories for HE jobs | 2 | STELL | Job | nvarchar | 8 | 0 | | |
20 | T5K13 | Jobs | 2 | STELL | Job | nvarchar | 8 | 0 | | |
21 | T5M13 | !Not Used: Jobs (Denmark) | 2 | STELL | Job | nvarchar | 8 | 0 | | |
22 | T5REG | Employee Information Log for Destruction of Data | 21 | STELL | Job | nvarchar | 8 | 0 | | |
23 | T5RPD | Personnel Data Deletion Log | 31 | STELL | Job | nvarchar | 8 | 0 | | |
24 | TKCKO | Formula Operators | 2 | STELL | No. of operands | nvarchar | 1 | 0 | | |
25 | TKCTO | Language Table: Formula Operators | 3 | STELL | No. of operands | nvarchar | 1 | 0 | | |
TOPAustria |
26 | T5A4S | Assgmt Job/Pos. to Heavy Labor Pos. in Acc. with Sec. 5 Reg. | 3 | STELL | Job | nvarchar | 8 | 0 | | |
TOPConfirmations |
27 | AFRV | Confirmation pool | 43 | STELL | Job | nvarchar | 8 | 0 | | |
28 | AFRV_DEL | Backup Copy for Confirmation Pool | 43 | STELL | Job | nvarchar | 8 | 0 | | |
TOPConstruction Industry |
29 | T5DBV | Construction Pay: Cost Assignment: Hostels | 32 | STELL | Job | nvarchar | 8 | 0 | | |
30 | T5DBX | Construction Pay: Incentive Wage Connection | 32 | STELL | Job | nvarchar | 8 | 0 | | |
TOPCross-Application Objects in HR |
31 | HRP5581 | DB Table for Infotype 5581 | 33 | STELL | Job | nvarchar | 8 | 0 | | |
TOPDenmark |
32 | T5M15 | Default Values for DA Job Keys (DK) | 2 | STELL | Job | nvarchar | 8 | 0 | | |
33 | T5MF8 | FA: Default Work Function, Work Level, Management Level | 2 | STELL | Job | nvarchar | 8 | 0 | | |
TOPExternal Services |
34 | ESLL | Lines of Service Package | 33 | STELL | Job | nvarchar | 8 | 0 | | |
35 | HRMMSRVIF | Interface Table: Time Recording in MM-SRV | 12 | STELL | Job | nvarchar | 8 | 0 | | |
TOPItaly |
36 | PA3214 | HR Master Record: Infotype 3214 | 272 | STELL | Job | nvarchar | 8 | 0 | | |
37 | T5ITPM | Check Table for Higher Duties : infotype (3214) subtype 0002 | 5 | STELL | Job | nvarchar | 8 | 0 | | |
TOPNorway |
38 | T5V13 | SSB Positions code assignment | 3 | STELL | Job | nvarchar | 8 | 0 | | |
39 | T5V5B | Assignment of job to occupation code | 2 | STELL | Job | nvarchar | 8 | 0 | | |
TOPPayroll |
40 | PA3265 | HR master record, infotype 3265 | 32 | STELL | Job | nvarchar | 8 | 0 | | |
41 | T5HPBS96 | Foreign exchange multipliers (for IT3265) | 6 | STELL | Job | nvarchar | 8 | 0 | | |
42 | T5HPBS98 | FX multipliers for long-term studies abroad | 6 | STELL | Job | nvarchar | 8 | 0 | | |
43 | T5T13 | Jobs x KZAM | 2 | STELL | Job | nvarchar | 8 | 0 | | |
44 | T5TPSC1SPLIT | Rozdelení nákladu | 43 | STELL | Profese | nvarchar | 8 | 0 | | |
45 | T7SK13 | Jobs x KZAM | 2 | STELL | Job | nvarchar | 8 | 0 | | |
TOPPayroll General Parts |
46 | HRPY_WPBP | HR-PAY: Transparent Table WPBP | 24 | STELL | Job | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
47 | PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 37 | STELL | Job | nvarchar | 8 | 0 | | |
48 | T513 | Jobs | 2 | STELL | Job | nvarchar | 8 | 0 | | |
49 | T513S | Job Titles | 3 | STELL | Job | nvarchar | 8 | 0 | | |
50 | T528B | Positions | 15 | STELL | Job | nvarchar | 8 | 0 | | |
51 | T5H3C | Supplies | 2 | STELL | Job | nvarchar | 8 | 0 | | |
TOPPersonnel Time Management |
52 | ASSOB | Assignment Objects | 31 | STELL | Job | nvarchar | 8 | 0 | | |
53 | COIFT | Interface to Activity Allocation | 63 | STELL | Job | nvarchar | 8 | 0 | | |
54 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 64 | STELL | Job | nvarchar | 8 | 0 | | |
55 | PTEX2003GEN | Interface Table for IT 2003: General Information | 63 | STELL | Job | nvarchar | 8 | 0 | | |
56 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 39 | STELL | Job | nvarchar | 8 | 0 | | |
57 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 63 | STELL | Job | nvarchar | 8 | 0 | | |
TOPPlant Data Collection |
58 | RUECK | Temp. storage for subsystem confirmations | 38 | STELL | Job | nvarchar | 8 | 0 | | |
TOPPublic Sector |
59 | HRP1653 | DB Table for Infotype 1653 | 19 | STELL | Job Code | nvarchar | 4 | 0 | | |
60 | PA0509 | HR-AU-PS: Master Data (Higher Duty Allowance) | 140 | STELL | Job | nvarchar | 8 | 0 | | |
61 | T5D7Z | Assignment of Exception Indicator to Job | 2 | STELL | Job | nvarchar | 8 | 0 | | |
62 | T5PBSR6D | (Not used, will be deleted in 4.6) | 3 | STELL | Job | nvarchar | 8 | 0 | | |
TOPRecruitment |
63 | PB0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 37 | STELL | Job | nvarchar | 8 | 0 | | |
TOPSingapore |
64 | T5R13 | Occupational group | 2 | STELL | Job | nvarchar | 8 | 0 | | |
TOPSouth Africa |
65 | T5W13 | Link job category occupational level Employment equity. | 2 | STELL | Job | nvarchar | 8 | 0 | | |
66 | T5W15 | Job to SOC Code Allocation (South Africa) | 2 | STELL | Job | nvarchar | 8 | 0 | | |
TOPStatements |
67 | P01W_DBKR | Data Module: Remuneration Statement for Sick Pay | 10 | STELL | Employed as | nvarchar | 20 | 0 | | |
TOPSwitzerland |
68 | T5C31 | Salary Comparison: Function Assignment | 3 | STELL | Job | nvarchar | 8 | 0 | | |
TOPTravel Planning |
69 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 35 | STELL | Job | nvarchar | 8 | 0 | | |
TOPUSA |
70 | T5U13 | Jobs | 2 | STELL | Job | nvarchar | 8 | 0 | | |
71 | T5U25 | WC: Job Attributes | 2 | STELL | Job | nvarchar | 8 | 0 | | |
TOPVenezuela |
72 | T7VES3 | Function code relationship (Company/IVSS) | 2 | STELL | Job | nvarchar | 8 | 0 | | |