| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /KORA/PROTOCOL_T | kr: protocol error messages | 5 | RDATE | System Date | nvarchar | 8 | 0 | | |
2 | LXE_RLTP_LOG | Remote Copy Registration | 6 | RDATE | System Date | nvarchar | 8 | 0 | | |
3 | P08P1CNT | CLASS Interface Control Table (OBSOLETE from 46C) | 8 | RDATE | CLASS CPX INTERFACE Control File Run Date | nvarchar | 8 | 0 | | |
4 | P08P_CLSC | CLASS Interface Control Table (46C onwards) | 9 | RDATE | CLASS CPX INTERFACE Control File Run Date | nvarchar | 8 | 0 | | |
5 | P08P_USSC | USS Interface Control Table (Contributions & Salary Changes) | 5 | RDATE | USS Interface Control File Run Date | nvarchar | 8 | 0 | | |
6 | P08P_USSC_CARE | USS Interface Control Table (Contributions & Salary Changes) | 6 | RDATE | USS Interface Control File Run Date | nvarchar | 8 | 0 | | |
7 | P2RX_ACCR | Payroll Result: Month End Accruals | 12 | RDATE | Reversal date for month-end accruals | nvarchar | 8 | 0 | | |
8 | T5GPBSH_CONTROL | HESA NISR Control table | 4 | RDATE | Changed On | nvarchar | 8 | 0 | | |
9 | T5GPBST_CONTROL | TPS Control records | 5 | RDATE | Changed On | nvarchar | 8 | 0 | | |
10 | T77CNCAREM_TASK | Task Data for Payroll Calendar | 12 | RDATE | Date | nvarchar | 8 | 0 | | |
TOPBasic Functions |
11 | T243LS | Logging Table for Distributed CM Data | 4 | RDATE | Date: TR-CM subsystem for sending data requested | nvarchar | 8 | 0 | | |
12 | T807R | FI-SL Rollup: History of Executions | 14 | RDATE | Reversal date | nvarchar | 8 | 0 | | |
TOPBelgium |
13 | T5BSD | SI Declaration: directory table | 9 | RDATE | Release date SI declaration | nvarchar | 8 | 0 | | |
14 | T5BSR | Reductions for an employee reported on level 3 | 10 | RDATE | Startdate Reduction | nvarchar | 8 | 0 | | |
TOPBudget Management |
15 | HRPMPROT | HR-FPM Log Table | 21 | RDATE | Date | nvarchar | 8 | 0 | | |
TOPCalculation of Employment Period |
16 | PA0553 | HR Master Data Record for Infotype 0553 | 34 | RDATE | Result of Employment Period Calculation: Key Date | nvarchar | 8 | 0 | | |
TOPCapacity Evaluations |
17 | TCY08 | Option profiles | 29 | RDATE | Date of backlog dispatching | nvarchar | 10 | 0 | | |
TOPCapacity Leveling |
18 | TCY33 | Time profile for capacity leveling | 10 | RDATE | Date of backlog dispatching | nvarchar | 10 | 0 | | |
TOPClinical System |
19 | N1MEOACT | i.s.h.med: Medication, Order Activities | 8 | RDATE | Medication: Execution Date of Order Activity | nvarchar | 8 | 0 | | |
TOPComputer Aided Process Planning |
20 | TCAPM | Date of the last mini reorg | 2 | RDATE | Date | nvarchar | 8 | 0 | | |
TOPControlling |
21 | COK41C_ID | Identification Table for Posting Runs | 5 | RDATE | System Date | nvarchar | 8 | 0 | | |
TOPCost Center Accounting |
22 | T811D | Allocations: Document Numbers | 11 | RDATE | Allocations: Reversal date | nvarchar | 8 | 0 | | |
23 | T811DA | Allocations: Dependent Document Numbers | 11 | RDATE | Allocations: Reversal date | nvarchar | 8 | 0 | | |
24 | T811DS | Allocations: Document Numbers for Segment Reverse/Rebook | 15 | RDATE | Allocations: Reversal date | nvarchar | 8 | 0 | | |
TOPCross-System Tools |
25 | MCSTATLIST | Multiple Client Analysis: Status List | 15 | RDATE | Date | nvarchar | 8 | 0 | | |
TOPFinland |
26 | T7FITELME | TEL messages | 3 | RDATE | Run date | nvarchar | 8 | 0 | | |
27 | T7FITELME_ABS | TEL messages - Absences | 3 | RDATE | Run date | nvarchar | 8 | 0 | | |
TOPFrance |
28 | PA0424 | Industrial accident / maternity / sickness statement (FR) | 27 | RDATE | Date of notification of work stoppage | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Accounting |
29 | FAGL_RPLAN | -Obsolete- Reorganization: Plan | 3 | RDATE | Reorganization Date | nvarchar | 8 | 0 | | |
TOPIndonesia |
30 | PA0241 | Indonesian Tax Data | 29 | RDATE | NPWP registration date | nvarchar | 8 | 0 | | |
TOPIreland |
31 | T7IE7 | Irish Health Insurance Group Details | 6 | RDATE | Date used to calculate number of periods | nvarchar | 1 | 0 | | |
32 | T7IEE | EHECS: Return Data | 20 | RDATE | EHECS: Document Date | nvarchar | 8 | 0 | | |
33 | T7IEP | Pension schemes Ireland | 13 | RDATE | Date used to calculate number of periods | nvarchar | 1 | 0 | | |
TOPJust-In-Time Processing |
34 | JITIT | Components Group | 22 | RDATE | Planned Time of Requirements | decimal | 15 | 0 | | |
35 | JITOIT | Components Group JIT Outbound | 12 | RDATE | Planned Time of Requirements | decimal | 15 | 0 | | |
TOPliveCache Applications |
36 | /SAPAPO/RSP_LCCS | Management of Planning Version in the RSP liveCache Check | 5 | RDATE | System Date | nvarchar | 8 | 0 | | |
TOPLocalization |
37 | J_1IRG23D | RG23D register for the depot | 42 | RDATE | Posting date in the reference document | nvarchar | 8 | 0 | | |
TOPMalaysia |
38 | T5LES | ESS Malaysia: TP1 TP2 | 38 | RDATE | Request Date | nvarchar | 8 | 0 | | |
TOPNorway |
39 | T5V5M | Messages sent electronically to AA-registeret | 3 | RDATE | AA Register file reporting date | nvarchar | 8 | 0 | | |
40 | T5V7B | Messages sent to employees/emplyoers register | 5 | RDATE | Date message for the AA-register was created in the system | nvarchar | 8 | 0 | | |
TOPOverhead Cost Controlling |
41 | T823D | Revaluation document numbers | 12 | RDATE | Allocations: Reversal date | nvarchar | 8 | 0 | | |
TOPPatient Accounting |
42 | NBDT | IS-H: Ins. assoc. billing cases transferred - status header | 5 | RDATE | IS-H: Confirmation Date of PPA Case | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
43 | PA0255 | HR master record Infotype 0082 (Additional absence data) | 26 | RDATE | Reported on | nvarchar | 8 | 0 | | |
TOPPersonnel Time Management |
44 | PA0082 | HR Master Record: Infotype 0082 (Additional Absence Data) | 26 | RDATE | Reported on | nvarchar | 8 | 0 | | |
TOPProfitability Analysis |
45 | TKE_DIST_EXEC | Document Numbers in CO-PA Distribution | 13 | RDATE | Processing date | nvarchar | 8 | 0 | | |
TOPSingapore |
46 | T5R0P | Plant section/Singapore | 15 | RDATE | Company Registration date with ACRA. | nvarchar | 8 | 0 | | |
TOPSweden |
47 | T5S0S | Messages for sickness administration (SE) | 5 | RDATE | Date message for the AA-register was created in the system | nvarchar | 8 | 0 | | |
TOPThird Party Remittance |
48 | T51R1 | Remittance evaluation run data | 7 | RDATE | Date | nvarchar | 8 | 0 | | |
TOPTranslation Tools |
49 | LXE_WRKLID | Personal Worklists | 3 | RDATE | Date | nvarchar | 8 | 0 | | |
TOPUnited Kingdom |
50 | T5G_ASHE_CONTROL | ASHE Control Table | 3 | RDATE | Changed On | nvarchar | 8 | 0 | | |
TOPWork Clearance Management |
51 | WCAAP | WCM: Application | 71 | RDATE | Received | nvarchar | 8 | 0 | | |