| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNV_10940_VARH | Storing all variants for relevant reports | 6 | ENAME | User Name | nvarchar | 12 | 0 | | |
2 | P2RN_NNAM | Personal Data | 21 | ENAME | Name Format | nvarchar | 40 | 0 | | |
3 | SLDW_ELEMENTS | Elements of Whitelists (Design) | 2 | ENAME | Name of Whitelist Entry | nvarchar | 298 | 0 | | |
4 | SLDW_ELEMENTS_RT | Elements of Whitelists (Runtime) | 2 | ENAME | Name of Whitelist Entry | nvarchar | 298 | 0 | | |
5 | T535W | ASB Reporting Schema | 4 | ENAME | Field name | nvarchar | 5 | 0 | | |
6 | T5H7U | Certificate for tax allowance | 8 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
7 | T5REG | Employee Information Log for Destruction of Data | 27 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
8 | T5RPD | Personnel Data Deletion Log | 37 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
9 | TKB7C | Pseudonyms for Field Names | 4 | ENAME | Field name in table | nvarchar | 24 | 0 | | |
TOPAustria |
10 | T5A1L | ELDA: Record Structures | 5 | ENAME | ELDA: Field Name | nvarchar | 6 | 0 | | |
11 | T5A1M | ELDA: Field Conversion | 4 | ENAME | ELDA: Field Name | nvarchar | 6 | 0 | | |
12 | T5A1N | ELDA: Value Conversion | 4 | ENAME | ELDA: Field Name | nvarchar | 6 | 0 | | |
TOPCross-Application Objects in HR |
13 | HRP5581 | DB Table for Infotype 5581 | 20 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
TOPIncentive and Commission Management ICM |
14 | CACS00_B_VAR_ACT | Variants for Commission Case Activities | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
15 | CACS00_B_VAR_BDL | Variants for Bundling | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
16 | CACS00_B_VAR_CAS | Variants for Commission Case | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
17 | CACS00_B_VAR_INV | Variants for Commission Case Participants | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
18 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
19 | CACS00_B_VAR_OBJ | Variants for Commission Case Object Data | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
20 | CACS00_B_VAR_PAR | Variants for Commission Case Participant | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
21 | CACS00_B_VAR_REL | Variants for Participant Relations | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
22 | CACS_B_VAR | Variants for BDTI | 3 | ENAME | User Name | nvarchar | 12 | 0 | | |
23 | YCRM01_B_VAR_ACT | Variants for Commission Case Activities | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
24 | YCRM01_B_VAR_BDL | Variants for Bundling | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
25 | YCRM01_B_VAR_CAS | Variants for Commission Case | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
26 | YCRM01_B_VAR_INV | Variants for Commission Case Participants | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
27 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
28 | YCRM01_B_VAR_OBJ | Variants for Commission Case Object Data | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
29 | YCRM01_B_VAR_PAR | Variants for Commission Case Participant | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
30 | YCRM01_B_VAR_REL | Variants for Participant Relations | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
31 | YHITEC_B_VAR_ACT | Variants for Commission Case Activities | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
32 | YHITEC_B_VAR_BDL | Variants for Bundling | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
33 | YHITEC_B_VAR_CAS | Variants for Commission Case | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
34 | YHITEC_B_VAR_INV | Variants for Commission Case Participants | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
35 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
36 | YHITEC_B_VAR_OBJ | Variants for Commission Case Object Data | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
37 | YHITEC_B_VAR_PAR | Variants for Commission Case Participant | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
38 | YHITEC_B_VAR_REL | Variants for Participant Relations | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
39 | YSVMA_B_VAR_ACT | Variants for Commission Case Activities | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
40 | YSVMA_B_VAR_BDL | Variants for Bundling | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
41 | YSVMA_B_VAR_CAS | Variants for Commission Case | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
42 | YSVMA_B_VAR_INV | Variants for Commission Case Participants | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
43 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
44 | YSVMA_B_VAR_OBJ | Variants for Commission Case Object Data | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
45 | YSVMA_B_VAR_PAR | Variants for Commission Case Participant | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
46 | YSVMA_B_VAR_REL | Variants for Participant Relations | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
47 | YTEL01_B_VAR_ACT | Variants for Commission Case Activities | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
48 | YTEL01_B_VAR_BDL | Variants for Bundling | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
49 | YTEL01_B_VAR_CAS | Variants for Commission Case | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
50 | YTEL01_B_VAR_INV | Variants for Commission Case Participants | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
51 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
52 | YTEL01_B_VAR_OBJ | Variants for Commission Case Object Data | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
53 | YTEL01_B_VAR_PAR | Variants for Commission Case Participant | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
54 | YTEL01_B_VAR_REL | Variants for Participant Relations | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
55 | YTEL05_B_VAR_ACT | Variants for Commission Case Activities | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
56 | YTEL05_B_VAR_BDL | Variants for Bundling | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
57 | YTEL05_B_VAR_CAS | Variants for Commission Case | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
58 | YTEL05_B_VAR_INV | Variants for Commission Case Participants | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
59 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
60 | YTEL05_B_VAR_OBJ | Variants for Commission Case Object Data | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
61 | YTEL05_B_VAR_PAR | Variants for Commission Case Participant | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
62 | YTEL05_B_VAR_REL | Variants for Participant Relations | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
63 | ZICMAG_B_VAR_ACT | Variants for Commission Case Activities | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
64 | ZICMAG_B_VAR_BDL | Variants for Bundling | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
65 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
66 | ZICMAG_B_VAR_INV | Variants for Commission Case Participants | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
67 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
68 | ZICMAG_B_VAR_OBJ | Variants for Commission Case Object Data | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
69 | ZICMAG_B_VAR_PAR | Variants for Commission Case Participant | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
70 | ZICMAG_B_VAR_REL | Variants for Participant Relations | 2 | ENAME | User Name | nvarchar | 12 | 0 | | |
TOPIreland |
71 | T7IE6 | Employer Registered Numbers (HR-IE) | 5 | ENAME | Employer Name | nvarchar | 30 | 0 | | |
72 | T7IE9 | SIPTU | 6 | ENAME | Employer Name | nvarchar | 30 | 0 | | |
TOPLocalization |
73 | J_3RSEXTRACTD | Exctract details (obsolete) | 2 | ENAME | Extract Name | nvarchar | 10 | 0 | | |
74 | J_3RSEXTRACTH | Extract header (obsolete) | 2 | ENAME | Extract Name | nvarchar | 10 | 0 | | |
TOPLogical DB, Selection Screens, Selection Variants |
75 | VARID | Variant directory | 11 | ENAME | User Name | nvarchar | 12 | 0 | | |
76 | VARID_CI | Variant Catalog, Cross-Client | 9 | ENAME | User Name | nvarchar | 12 | 0 | | |
TOPMaintenance Processing |
77 | /MRSS/C_PREMK | Dummy table for creating Org. Assgnmnt Search Help (No Data) | 16 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
TOPNorway |
78 | T5VT0 | Annual tax statements - Reporting status | 4 | ENAME | Employer name | nvarchar | 42 | 0 | | |
TOPOccupational Health |
79 | T7EHS00_EXAMT | Examinations (Text Table) | 7 | ENAME | Name of Examination | nvarchar | 75 | 0 | | |
TOPPayroll |
80 | T5H11 | Minimális járulékalap - jelentett munkavállalók | 4 | ENAME | Dolgozó ill. pályázó formatált neve | nvarchar | 40 | 0 | | |
81 | T7SIA1 | Annual tax - Master data | 6 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
82 | T7SIA3 | M4 - Temporary data | 4 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
83 | T7SIA4 | DPZ temporary data | 9 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
TOPPersonnel Administration |
84 | PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 43 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
TOPPersonnel Management |
85 | T7HRA2 | IP Form - Master data | 8 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
86 | T7HRA2N | IP Form - Master data - New (w. OIB) | 8 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
87 | T7HRA2O | IP Form - Master data - with IDENT in key | 9 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
TOPPortugal |
88 | T5P2U | HR-PT: Social Security Contributor | 13 | ENAME | Entity designation | nvarchar | 60 | 0 | | |
TOPProcess Controls -Automated Controls |
89 | GRPCRTA_HRDA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 17 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
90 | GRPCRTA_HRDA0045 | PC HR control data for infotype 0045 - Loan | 17 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
91 | GRPCRTA_HRDA0078 | PC HR control data for infotype 0078 - Loan Payments | 17 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
92 | GRPCRTA_HRDA0267 | PC HR control data for infotype 0267 | 17 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
93 | GRPCRTA_HRDAT1 | PC HR control data for infotype 0014 and 0015 | 17 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
94 | GRPCRTA_HRDAT2 | PC HR control data for infotype 0014 and 0015 | 17 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
TOPProfitability Analysis |
95 | COVAD | Variant catalog | 7 | ENAME | User Name | nvarchar | 12 | 0 | | |
96 | COVAL | Log Management Table | 7 | ENAME | User Name | nvarchar | 12 | 0 | | |
TOPRecruitment |
97 | PB0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 43 | ENAME | Formatted Name of Employee or Applicant | nvarchar | 40 | 0 | | |
TOPRegulatory reporting for insurance companies |
98 | ISSRPREFLOW | ISSR: Basistabelle/Bewegungstabelle | 59 | ENAME | Nome utente | nvarchar | 12 | 0 | | |
99 | ISSR_RPI_MFT | ISSR: Feste und variable Daten Meldewesen | 55 | ENAME | Benutzername | nvarchar | 12 | 0 | | |
100 | ISSR_RPI_MFT_BCK | ISSR: Feste und variable Daten Meldewesen als Backuptabelle | 55 | ENAME | Benutzername | nvarchar | 12 | 0 | | |
101 | TISSR_CHA_MDATA | Aufzeichnung von Aktivitaeten zur Stammdatenaenderung | 6 | ENAME | Benutzername | nvarchar | 12 | 0 | | |
102 | TISSR_LT_HEADER | Kopftabelle zur Speicherung von Listinhalten im neuen Mw | 10 | ENAME | Benutzername | nvarchar | 12 | 0 | | |
TOPRepository Browser |
103 | OBJTYPEGROUPS | Semantic Group Affiliation of Object Types | 3 | ENAME | Created By | nvarchar | 12 | 0 | | |
104 | WVOBJECTTYPES | Registry Table for Object Types | 3 | ENAME | Created By | nvarchar | 12 | 0 | | |
TOPSales and Distribution |
105 | J_1USEXTRACTD | EXTRACTD | 2 | ENAME | | nvarchar | 10 | 0 | | |
106 | J_1USEXTRACTD_MM | EXTRACTD_MM | 2 | ENAME | | nvarchar | 10 | 0 | | |
107 | J_1USEXTRACTH | EXTRACTH | 2 | ENAME | | nvarchar | 10 | 0 | | |
TOPSamples and SPC |
108 | QASH | Quality control chart | 37 | ENAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | |
109 | QAST | Control chart track | 19 | ENAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | |
TOPSAP Note Assistant |
110 | SVRS_VCNT_HEAD | Header table for TLogo test objects | 7 | ENAME | Author of the Repository object | nvarchar | 12 | 0 | | |
TOPSingapore |
111 | PA0412 | HR Master Record: Infotype 0412 [View to I0021] (SG) | 24 | ENAME | Name of employer | nvarchar | 100 | 0 | | |
TOPSouth Africa |
112 | T5W9S | Status/Level of a Labour Relation intervention process | 7 | ENAME | SAPScript text used in email body | nvarchar | 16 | 0 | | |
TOPSubsequent Settlement |
113 | AVORRAT | Worklist | 8 | ENAME | Worklist, Entry Made by User | nvarchar | 12 | 0 | | |
TOPTransport Organizer |
114 | VERSOBJ_ALIAS | List of Active Alias Object Types | 9 | ENAME | Author of the Repository object | nvarchar | 12 | 0 | | |
TOPWarehouse Management |
115 | LTAP | Transfer order item | 134 | ENAME | User Name in Pick Confirmation (First Step) | nvarchar | 12 | 0 | | |
TOPXBRL Reporting |
116 | UGXV00C | Variant - Check Table | 4 | ENAME | User Name | nvarchar | 12 | 0 | | |