| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ARBERP_D_SO_SAR | SAR versioning for outbound messages | 4 | ABART | Scheduling agreement release type | nvarchar | 1 | 0 | | |
2 | P2B2_AB | HCM Declustering B2 - Absences | 8 | ABART | Settlement Type | nvarchar | 1 | 0 | | |
3 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 22 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
4 | P2CN_CNREI | Payroll result: structure for retro difference details | 8 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
5 | P2CN_CNREO | Payroll result: structure for retro difference details | 8 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
6 | P2CO_COAVA | PC2CO_AVA | 22 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
7 | P2HK_RETI | Payroll structure for retroactive accounting | 10 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
8 | P2HK_RETO | Payroll structure for retroactive accounting | 10 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
9 | P2HR_CUF | Structure of difference table Croatia | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
10 | P2HR_CUP | Structure of difference table Croatia | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
11 | P2HR_DTF | Structure of difference table Croatia | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
12 | P2HR_DTP | Structure of difference table Croatia | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
13 | P2IS_RETI | Payroll structure for retroactive accounting | 10 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
14 | P2IS_RETO | Payroll structure for retroactive accounting | 10 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
15 | P2KR_BEN_BPS | Payroll result for benefit point request | 6 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
16 | P2KZ_FUP | Structure for Table FUP - Future Periods | 8 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
17 | P2NZ_SALSAC | Salary Sacrifice Details | 7 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
18 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 7 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
19 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 7 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
20 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 7 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
21 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 8 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
22 | P2RH_HU_HKIF | P21PB | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
23 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
24 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 7 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
25 | P2RQ_HT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
26 | P2RQ_NT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
27 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
28 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
29 | P2RR_SRT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
30 | P2RX_AB | Cluster RD/B2: Table AB | 6 | ABART | Settlement Type | nvarchar | 1 | 0 | | |
31 | P2RX_ACCR | Payroll Result: Month End Accruals | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
32 | P2RX_DFT | Payroll Results: Differences for Gross/Net Payroll | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
33 | P2RX_GRT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
34 | P2RX_RT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
35 | P2RX_RT_PERSON | Results Table (Person) | 9 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
36 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 20 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
37 | P2SI_CUF | Difference table of payroll results | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
38 | P2SI_CUP | Difference table of payroll results | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
39 | P2SI_DTF | Difference table of payroll results | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
40 | P2SI_DTP | Difference table of payroll results | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
41 | P2TN_TWOT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
42 | P2UA_FUP | table FUP - future periods | 8 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
43 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 8 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
44 | P2UA_UART | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
45 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 9 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
46 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 9 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
47 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 9 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
48 | P2UN_HT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
49 | P2UN_NT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
50 | P2UR_FUP | table FUP - future periods | 8 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
51 | P2UR_RURT | Payroll Results: Results Table | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
52 | T517A | Educational Establishment Types/Final Certificates | 3 | ABART | Certificate | nvarchar | 2 | 0 | | |
53 | T546 | Employee Subgroup for PersCalcRule/CollAgreemProvision | 2 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
54 | TKKAS_CONV | Copy of TKKAS | 9 | ABART | Results Analysis Type | nvarchar | 1 | 0 | | |
55 | TN23OEBS | DE: Outpatient P301 Billing: OU-POWN Assignment | 4 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
56 | ZEIM_LIPS | SD document: Delivery: Item data | 136 | ABART | Release type | nvarchar | 1 | 0 | | |
57 | ZEIM_VBEP | Sales Document: Schedule Line Data | 36 | ABART | Release type | nvarchar | 1 | 0 | | |
TOPAgency Business Global Trade |
58 | TMFK | Agency Business: Billing Document Types | 15 | ABART | Settlement Type | nvarchar | 1 | 0 | | |
59 | WBRK | Agency business: Header | 8 | ABART | Settlement Type | nvarchar | 1 | 0 | | |
TOPBasic Data |
60 | TNF32 | IS-H: Work Organizers with Billing Type and Ins. Prov. Cond. | 5 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
61 | TNREL | IS-H: Insurance Provider Assignments | 8 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
TOPBelgium |
62 | T5BVD | Mapping Table Educational Type | 3 | ABART | Certificate | nvarchar | 2 | 0 | | |
TOPCost Object |
63 | TKKAS | Control Table for Results Analysis | 9 | ABART | Results Analysis Type | nvarchar | 1 | 0 | | |
64 | TKKAU | Results Analysis Methods - Default Values in TKKAS | 5 | ABART | Results Analysis Type | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
65 | VVBEP | Sales Document: Schedule Line Data | 36 | ABART | Release type | nvarchar | 1 | 0 | | |
TOPDenmark |
66 | T5M9H | Split Indicators for Wage Types Sent to PBS | 19 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPEnhancements to scheduling agreements MM Outbound |
67 | ISAUTOEKLWES | Last Deliveries for FLAB | 4 | ABART | Release type | nvarchar | 1 | 0 | | |
68 | ISAUTOEKLWESH | Last Deliveries for FLAB | 4 | ABART | Release type | nvarchar | 1 | 0 | | |
TOPFinland |
69 | T7FIV0 | Holiday Bonus Handling Types | 2 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPGermany |
70 | T5D0I | Fictitious Run Control: Wage Type Assignment | 11 | ABART | Notional Run Control: Employee Subgroup Proc. Grouping | nvarchar | 1 | 0 | | |
TOPHong Kong |
71 | T7HK4B | Factor & constants for LSP/severance payments | 2 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
72 | NTFI | IS-H: Service Catalog Determination Rules | 9 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
73 | NVBRP | IS-H: Billing document item data | 58 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
74 | TN20A | IS-H: Service Catalog Column Determination | 5 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
75 | TN21 | IS-H: Billing Types | 3 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
76 | TN21A | IS-H: Billing Type Determination | 8 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
77 | TN21T | IS-H: Texts for Billing Types | 4 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
TOPPayroll |
78 | T5T558_AB | HRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP | 5 | ABART | Druh zúctování | nvarchar | 1 | 0 | | |
79 | T7BGQ3 | Vacation debt | 4 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
80 | T7SK558_AB | Transfer absences (supplement to T558D) - SK | 5 | ABART | Settlement Type | nvarchar | 1 | 0 | | |
TOPPayroll General Parts |
81 | HRPY_CYCLEINFO | Comments for Payroll Rules | 3 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
82 | HRPY_WPBP | HR-PAY: Transparent Table WPBP | 18 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
83 | T52C5 | Personnel Calculation Rules | 3 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
84 | T546A | Employee Subgroup Grouping for Payroll | 2 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
85 | T546T | EE Subgroup Groupings for Personnel Calculation Rules | 3 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
86 | T558D | Transfer Wage Types with Split Indicator | 4 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
87 | T503 | Employee Group/Subgroup | 4 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
88 | T7COT8 | Payroll external results transfer: COAVA | 22 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
89 | T7SI0V | Educational Establishment Types/Final Certificates | 3 | ABART | Required educational level | nvarchar | 3 | 0 | | |
TOPPersonnel Cost Planning |
90 | HRP1015 | Infotype 1015 DB table | 21 | ABART | Time unit (payroll type) used to evaluate the wage element | nvarchar | 1 | 0 | | |
91 | T77KL | Wage Elements in Personnel Cost Planning | 9 | ABART | Time unit (payroll type) used to evaluate the wage element | nvarchar | 1 | 0 | | |
TOPPersonnel Management |
92 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPPersonnel Time Management |
93 | T555M | PDC Accounting Types | 3 | ABART | Employee grouping for the time evaluation rule | nvarchar | 1 | 0 | | |
94 | T555N | Employee Grouping for the Time Evaluation Rule | 2 | ABART | Employee grouping for the time evaluation rule | nvarchar | 1 | 0 | | |
TOPPublic sector Sweden |
95 | T5SVA_CE | Vacation debt | 4 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPPurchasing |
96 | EKEH | Scheduling Agreement Release Documentation | 4 | ABART | Scheduling agreement release type | nvarchar | 1 | 0 | | |
97 | EKEHH | Removed Scheduling Agreement Release Documentation | 4 | ABART | Scheduling agreement release type | nvarchar | 1 | 0 | | |
98 | EKEK | Header Data for Scheduling Agreement Releases | 4 | ABART | Scheduling agreement release type | nvarchar | 1 | 0 | | |
99 | EKEKH | Removed Header Data of Scheduling Agreement Releases | 4 | ABART | Scheduling agreement release type | nvarchar | 1 | 0 | | |
100 | EKET | Scheduling Agreement Schedule Lines | 29 | ABART | Scheduling agreement release type | nvarchar | 1 | 0 | | |
101 | EKETH | Scheduling Agreement Schedules: History Tables | 29 | ABART | Scheduling agreement release type | nvarchar | 1 | 0 | | |
TOPReuse Services for Country Development |
102 | T599E | Time-Dependent Rounding for Operation RNDC | 4 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPSales |
103 | VBAG | Sales Document: Release Data by Schedule Line in Sch.Agrmt. | 4 | ABART | Release type | nvarchar | 1 | 0 | | |
104 | VBEH | Schedule line history | 6 | ABART | Release type | nvarchar | 1 | 0 | | |
105 | VBEP | Sales Document: Schedule Line Data | 36 | ABART | Release type | nvarchar | 1 | 0 | | |
106 | VBLB | Sales document: Release order data | 5 | ABART | Release type | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
107 | /ISHFR/TN21A | IS-H FR: Determine Billing Type | 10 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
108 | NNTF | IS-H NL: Service Catalog Determination | 12 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
109 | TN22D | IS-H: Steuerungstabelle für Art der ambulanten Zuzahlung | 4 | ABART | IS-H: Abrechnungsart der Patientenabrechnung | nvarchar | 2 | 0 | | |
110 | TNEO_BILLTYP_DET | IS-H: External Orders - Billing Type Determination | 8 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
111 | TNWCH107 | Billing Type Determination for Fee Billing | 11 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
112 | TNWCH81 | IS-H CH: Billing Type Determination | 12 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | | |
113 | TNWCH83 | Ermittlung der Baserate | 3 | ABART | IS-H: Abrechnungsart der Patientenabrechnung | nvarchar | 2 | 0 | | |
114 | TNWCHEA10 | IS-H CH: Abrechnungsartenermittlung für Externe Aufträge | 8 | ABART | IS-H: tipo fatturazione della fatturazione paziente | nvarchar | 2 | 0 | | |
TOPShipping |
115 | LIPS | SD document: Delivery: Item data | 136 | ABART | Release type | nvarchar | 1 | 0 | | |
TOPSimulation |
116 | VSVBEP_CN | Version: Sales document: Schedule line data | 37 | ABART | Release type | nvarchar | 1 | 0 | | |
TOPStatements |
117 | P01W_DBAE | Data Module: Statement of Earnings - Remuneration | 15 | ABART | Fixed Monthly Salary/Monthly Remuneration | nvarchar | 1 | 0 | | |
118 | P01W_DBEK | Data Module: Statement of Earnings for Sick Child | 36 | ABART | Fixed Monthly Salary/Monthly Remuneration | nvarchar | 1 | 0 | | |
119 | P01W_DBKR | Data Module: Remuneration Statement for Sick Pay | 50 | ABART | Fixed Monthly Salary/Monthly Remuneration | nvarchar | 1 | 0 | | |
120 | P01W_DBMU | Data Module: Statement of Earnings, Maternity Pay | 52 | ABART | Fixed Monthly Salary/Monthly Remuneration | nvarchar | 1 | 0 | | |
TOPStatistical Key Figures |
121 | TAPRF | Cap. inv. measure profile for AuC and dep. simulation | 10 | ABART | Indicator: Line item settlement of inv. measure | nvarchar | 1 | 0 | | |
TOPSweden |
122 | T5SVA | Vacation and Compensation debt | 5 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPSwitzerland |
123 | T5C3H | HR-CH: Control of End of Year Bonus (13th Wage) | 4 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
124 | T5CZV | HR-CH: Differing Reduction Rules | 4 | ABART | Employee subgroup grouping for personnel calculation rule | nvarchar | 1 | 0 | | |
TOPTools |
125 | T532B | HR: Connection to Third-Party Payroll: Choice of Wage Types | 6 | ABART | Component 709: Entry field for field selection in PC207 | nvarchar | 1 | 0 | | |