| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2B2_AB | HCM Declustering B2 - Absences | 18 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
2 | P2B2_ANWES | HCM Declustering B2 - Attendances (Table ANWES) | 13 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
3 | P2CO_COABS | PC2CO_ABS | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
4 | P2CO_COAVA | PC2CO_AVA | 13 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
5 | P2NZ_LVPAY | Payroll Result: Leave Payment LVPAY - NZ | 13 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
6 | P2PL_EAB | Payroll Result PL: Split Y, absences | 8 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
7 | P2RD_STU | Tax Payment Interruption up to Payroll Period | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
8 | P2RP_VA | HR-PT: Payroll Results: Vacation allowance grouping (VA) | 30 | AWART | Absence type of leave period triggering allowance payment | nvarchar | 4 | 0 | | |
9 | P2RQ_SUPCOM | Superable salary components | 21 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
10 | P2RT_ABAUS | Structure of ABAUS - Paid illness | 10 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
11 | P2RX_AB | Cluster RD/B2: Table AB | 16 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
12 | P2SK_ABAUS | Documents for absence | 10 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
13 | P2UN_SUPCOM | Superable salary components For NPO | 21 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
14 | P2VE_ABC_EVAL | HRMS-VE: Record of Absences that Reduce Length of Service | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
15 | PA0601 | Antécédent d'absences (Infotype 0601) | 24 | AWART | Catégorie absence/présence | nvarchar | 4 | 0 | | |
16 | PA3267 | Személyügyi törzsrekord, 3267 infótípus | 25 | AWART | Távol- vagy jelenlétfajta | nvarchar | 4 | 0 | | |
17 | PAPBSGB_SWF_ABS | SWF: Absences | 9 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
18 | T5DPBS3G | Assignment of Absence to Absence Category | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
19 | T5FDSNABCAT | Absence categories for DSN | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
20 | T5FPBS2B | Autorisation des catégories d'absence (maladie) | 3 | AWART | Catégorie absence/présence | nvarchar | 4 | 0 | | |
21 | T5GPBSH_PL | HESA: Parental Leave | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
22 | T5H47 | Ellátásfajták IT3267 infótípushoz | 7 | AWART | Távol- vagy jelenlétfajta | nvarchar | 4 | 0 | | |
23 | T5H48 | Távollétfajták - magyar customizing | 3 | AWART | Távol- vagy jelenlétfajta | nvarchar | 4 | 0 | | |
24 | T77PADKZAG1 | Assign Attendance and Absence Types to Groups | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
25 | T7AE16 | Absence Distribution UAE | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
26 | T7AEPBS22 | Service Duration Deduction | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
27 | T7AEPBS66 | Absence Type Limit Condition | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
28 | T7KW08 | Absence Type Limit Condition | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
29 | T7KW09 | Absence Distribution Kuwait | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
30 | T7OM28 | Absence Distribution Oman | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
31 | T7OM33 | Absence Type Limit Condition | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
32 | T7QA16 | Absence Distribution Qatar | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
33 | T7QA36 | Occupational Hazard Type Mapping Absence Type | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
34 | T7QA37 | Absences Type for Occupational Hazard | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
35 | T7QA38 | Absences Type for Occupational Hazard(Obsolete) | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
36 | T7QA84 | Qatar Statutory Social Insurance Fund Type | 26 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
37 | T7QA85 | Absence for Qatar Fund Type | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
38 | T7QA88 | Absence for Qatar Fund Type | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
39 | T7QAPBS25 | Absence Type Limit Condition | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
40 | T7RU51AV_PT | Calculation Rules for Averages: Connection of Frozen Average | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
41 | T7RU554C | Relation between absence type and wage type for days of abse | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
42 | T7RU554S | Additional property of SocInsurance Absence Types | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
43 | T7RU_T554T | Attendance and Absence Long Texts | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
44 | T7SA16 | Absence Distribution KSA | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
45 | T7SA43 | Absence Type Identification | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
46 | T7SAMS02 | Service Duration Deduction | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
47 | T7SAPBS09 | Absences Type for Occupational Hazard | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
48 | T7SAPBS31 | Absence Distribution KSA Public Sector | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
49 | T7SAPBS32 | Absence Distribution KSA Public Sector | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
50 | T7SAPBS37 | Absence Type Refinement Rule Group Assign | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
51 | T7SAPBS66 | Absence Type Limit Condition | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
52 | ZCATSDB | Records changed with processing status '10' | 30 | AWART | | nvarchar | 4 | 0 | | |
53 | ZCATSDB2 | Records changed with processing status '10' | 31 | AWART | | nvarchar | 4 | 0 | | |
54 | ZZZ_IF_KRANK | Interface Meldesatz Krankenstände | 4 | AWART | Ab- oder Anwesenheitsart | nvarchar | 4 | 0 | | |
TOPAttendancesAbsences |
55 | CATSHR | Cross-Application Time Sheet (CATS): Transfer to HR | 40 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPAustralia |
56 | T5QIA | PS Specific Characteristic for absence type | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
57 | T5QLA | Australian Leave Accrual Unpaid Absence Rules | 5 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
58 | T5QRA | Redundancy LWOP Absences Australia | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPAustria |
59 | T5AE1 | Absence Types: Entry for Illness Notification | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
60 | T5AE2 | Absence Types: Alignment for Illness Notification | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
61 | T5AE3 | Absence Types: Conversion in Event of Missing Illness Notif. | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
62 | T5APBS20 | Properties for Absence Types for FRSC | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
63 | T5APBS22 | Properties for Absence Types for FRSC (New) | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPBudget Management |
64 | T7PMN | Valuation of Absence Types | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPCalculation of Employment Period |
65 | T525A | Selection Rules for Employee Data | 15 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPCanada |
66 | T5K1A | Absence type reason relevant to ROE (Canada) | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
67 | T5KV4 | Vacation pay: Absence types without corresp. entitlements | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
68 | T5UBX_GTL_AWART | Processing group for absence types | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPChile |
69 | T7CL25 | Personnel Action Code Master | 5 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPConstruction Industry |
70 | PA0215 | Construction Pay Transaction Data | 35 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
71 | T5DBD | Construction: Meal+Separation Allowances/Travel Costs | 3 | AWART | Type of Expense | nvarchar | 1 | 0 | | |
72 | T5DBG | Texts for Construction Pay Expenses | 4 | AWART | Type of Expense | nvarchar | 1 | 0 | | |
73 | T5DBI | Construct. Pay: Effects of Short Indicators for Trans. Data | 9 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
74 | T5DBO | Construction Pay Expenses: Permissible Entries | 3 | AWART | Type of Expense | nvarchar | 1 | 0 | | |
TOPESS Based on WD ABAP |
75 | HRESS_D_CATS_FAV | CATS Favorites: database table | 37 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPFinland |
76 | T7FIAG | Finnish absence classification | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
77 | T7FIAG_MULTI | Finnish absence classification (multiple) | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPFrance |
78 | PA0424 | Industrial accident / maternity / sickness statement (FR) | 67 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
79 | T5F2D | Process grace period for continued pay | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
80 | T5FDA1 | Absence categories for DADS-U structures | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPGermany |
81 | PA0597 | Personnel Master Record Infotype 0597 | 24 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
82 | T5D0D | Part Time Work During ParentalLeave | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
83 | T5D0S | Grouping of Absences | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
84 | T5DL5 | Rule Type for Absence Events | 5 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPGreat Britain |
85 | T5G26 | OSP-Related Data for SSP Offsetting | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPItaly |
86 | PA0407 | HR master record, infotype 0407 (Abs.addit.inf.) | 24 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
87 | T5ITGG | Table of general data for EEF | 16 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
88 | T5ITIE | Absence indicators | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
89 | T5ITIV | Nursing table | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPNetherlands |
90 | PA3250 | HR Master Record: Infotype 3250 | 40 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPNew Zealand |
91 | HNZLVPAY | Table for modified LVPAY cluster table records | 15 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
92 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 27 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
93 | T7NZLU | Leave Unpaid Absence Rules - NZ | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPNon Profit Organizations |
94 | T7UNPAD_AWART | NPO Aspects for Attendance/Absence Types | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
95 | T7UNPAD_PA2001EX | Extract of PA2001 fields; for use by sick leave combined | 9 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
96 | T7UNSLWOP_RC | SLWOP periods to be ignored for next reclassification date | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPNorway |
97 | T5VA5 | Norwegian absence classification | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPOff-Cycle |
98 | T52OCA | Off-Cycle Reasons for Absence Types | 5 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPPayroll |
99 | T5H1O | Control table to private pension fund monthly report | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
100 | T5HPBS37 | Long-term absences | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
101 | T5T558_AB | HRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP | 15 | AWART | Druh ne-/prítomností | nvarchar | 4 | 0 | | |
102 | T5T558_ABAUS | HRCZ - Tabulka pro prenos dat pro ABAUS pri upgrade na SAP | 9 | AWART | Druh ne-/prítomností | nvarchar | 4 | 0 | | |
103 | T7SK558_AB | Transfer absences (supplement to T558D) - SK | 15 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
104 | T7TRS03 | Sosyal Sigortalar Gününden düsülen devamsizlik türleri | 2 | AWART | Devamsizlik ya da devam türü | nvarchar | 4 | 0 | | |
105 | T7UAAG1 | Asign Attendance and Absence Types to Groups | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
106 | T7UAT5 | Sick-list payments | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPPension Administration |
107 | T7DEPBSNV0D | Assignment of Absence Types to Suspension Types | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPPersonnel Administration |
108 | PA0834 | HR master record for infotypes 0834 | 36 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
109 | T5H4R | Accountable lost time in calculation of SI average | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
110 | T5H5H | Absence identification to corrected absences on P0441 | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
111 | T7CO01 | Additional data of the company | 35 | AWART | Absence type - Leave | nvarchar | 4 | 0 | | |
112 | T7CO07 | Absence general configuration | 5 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
113 | T7COT4 | Payroll external results transfer: COABS | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
114 | T7COT8 | Payroll external results transfer: COAVA | 13 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPPersonnel Time Management |
115 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 27 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
116 | PA2002 | HR Time Record: Infotype 2002 (Attendances) | 27 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
117 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 29 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
118 | T554M | Absences for Maternity Protection: Rule Table | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
119 | T554T | Absence and Attendance Texts | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
120 | T554V | Defaults for Absence Types | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
121 | T554W | Periods of Military Service | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
122 | T555D | [OBSOLETE; NOW USE T705A] Abs./Attendance Reasons Subsystem | 8 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
123 | T557CU | Reporting Time Types | 5 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
124 | T557G | Relation Table: Absence/Attendance Accumulation | 5 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
125 | T705A | Attendance/Absence Reasons for Subsystem | 8 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPPublic Sector |
126 | T5APBS10 | Properties for Attendence/Absence Types for SI Publ. Sector | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
127 | T5PBSR1T | Link table for absence and NS Type (No longer in use) | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
128 | T5PBSR3I | Define the maximum number of absence days w/o proration | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
129 | T5QPBS2D | Mapping business rules between PS Infotype 0573 and 2001 | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
130 | T5QPBS2E | Parallel deduction sequence of quota types | 3 | AWART | Absence types induced parallel deduction | nvarchar | 4 | 0 | | |
131 | T5QPBS2J | PS Specific Characteristic for absence type | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
132 | T5QPBS2P | Absence records prior to Hiring | 3 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
133 | T5QPBS2R | Grouping for LWOP/UNAL impact on leave accrual | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
134 | T5QPBS5C | HR AU PS:Australian absence type grouping | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
135 | T5RPBS8Q | Absence type for proration of Past salary for CPF refund | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
136 | T5VPPS_SPKP | Code for SPK for leave-agreement with valid years | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPPublic sector Sweden |
137 | T5SAB_CE | Absence Properties | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
138 | T5SAM_CE | Absences to Limit code Mapping | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPReuse Services for Country Development |
139 | T799L15 | Absence Grouping for Day Type in Divisor 30 | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPRussia |
140 | T7RUT5_PAID | Social Insurance - Paid days of illness | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
141 | T7RU_554T | Absence and Attendance Texts | 4 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPShift Planning |
142 | HRP1046 | Database Table for Infotype 1046 | 29 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
143 | HRP1049 | Database Tables for Infotype 1049 | 23 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
144 | PSOLL | Shift Planning: Target Plan | 12 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
145 | T77ED | Shift Planning: Definition of Shifts | 15 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPSingapore |
146 | T5R2B | NRS Allowance averages calculation setting (SGP) | 2 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPTaiwan |
147 | T7TWAB | Absence Split Assignment | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPTime Data Recording and Administration |
148 | TMW_TDTYPE | Time Data ID | 8 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPTime Sheet |
149 | CATSDB | CATS: Database Table for Time Sheet | 30 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
150 | CATS_TEMP | CATS: Database Table for Templates | 32 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
151 | TCATX_DEDUC | CATX: Data Derived from Type/Component/Level | 7 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |
TOPVenezuela |
152 | T7VEA2 | Transfer of external payroll results: Absence | 6 | AWART | Attendance or Absence Type | nvarchar | 4 | 0 | | |