| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | EHPRCD_EXIMDS | Available Search Criteria | 10 | UPD_TIMESTAMP | Changed On | decimal | 15 | 0 | | |
TOPEnvironment, Health and Safety |
2 | /TDAG/CPT_EXIMDS | Available Search Criteria | 10 | UPD_TIMESTAMP | Changed On | decimal | 15 | 0 | | |
TOPIncentive and Commission Management ICM |
3 | CACS00_DOCACT | Commission Document: Activities | 9 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
4 | CACS00_DOCDT | Comn: Detail Items for Remuneration Rows | 22 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
5 | CACS00_DOCFI_H | Data Transfer: FI Documents (Header Data) | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
6 | CACS00_DOCFI_P | Data Transfer: FI Documents (Items) | 20 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
7 | CACS00_DOCHD | Commission Document Header | 56 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
8 | CACS00_DOCINV | Participant in Commission Document | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
9 | CACS00_DOCOBJ | Commission Document: Object Data | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
10 | CACS00_DOCPAR | Participation of Commission Document | 8 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
11 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 61 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
12 | CACS00_DOCREL | Commission Document: Relationships Between Participants | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
13 | CACS00_DOCSE | Commission Document, Settlement | 31 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
14 | CACS00_DOCSEDT | Line Item Detail Line | 12 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
15 | CACS00_DOCVA | Commission Document, Valuation | 25 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
16 | CACS42_DOCSHA | Commission Document: Complex Distribution Ratios | 11 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
17 | CACSCD_DOCCD_HD | Settlement to FS-CD: Reference Document Header | 7 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
18 | CACSFA_DOCFA_HD | Settlement to FI-CA: Reference Document Header | 7 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
19 | CACSFI_DOCFI_HD | Settlement to FI: Reference Document Header | 15 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
20 | CACSHR_DOCHR_HD | Settlement to PY: Reference Document Header | 8 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
21 | CACS_CPD_REF | Data Reference for Same FS-ICM Reference Key | 7 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
22 | CACS_STL_REF_H | Settlement Document Reference - Header | 8 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
23 | YCRM01_DOCACT | Commission Document: Activities | 9 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
24 | YCRM01_DOCDT | Comn: Detail Items for Remuneration Rows | 22 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
25 | YCRM01_DOCFI_H | Data Transfer: FI Documents Header Data | 15 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
26 | YCRM01_DOCFI_P | Data Transfer: FI Documents Item | 22 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
27 | YCRM01_DOCHD | Commission Document Header | 56 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
28 | YCRM01_DOCINV | Participant in Commission Document | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
29 | YCRM01_DOCOBJ | Commission Document: Object Data | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
30 | YCRM01_DOCPAR | Participation of Commission Document | 8 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
31 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 99 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
32 | YCRM01_DOCREL | Commission Document: Relationships Between Participants | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
33 | YCRM01_DOCSE | Commission Document: Due Dates | 31 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
34 | YCRM01_DOCSEDT | Due Date Details | 12 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
35 | YCRM01_DOCVA | Commission Document, Valuation | 53 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
36 | YSVMA_DOCACT | Commission Document: Activities | 9 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
37 | YSVMA_DOCDT | Comn: Detail Items for Remuneration Rows | 22 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
38 | YSVMA_DOCFI_H | Data Transfer: FI Documents (Header Data) | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
39 | YSVMA_DOCFI_P | Data Transfer: FI Documents (Items) | 20 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
40 | YSVMA_DOCHD | Commission Document Header | 64 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
41 | YSVMA_DOCINV | Participant in Commission Document | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
42 | YSVMA_DOCOBJ | Commission Document: Object Data | 25 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
43 | YSVMA_DOCPAR | Participation of Commission Document | 8 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
44 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 76 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
45 | YSVMA_DOCREL | Commission Document: Relationships Between Participants | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
46 | YSVMA_DOCSE | Commission Document: Due Dates | 31 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
47 | YSVMA_DOCSEDT | Due Date Details | 12 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
48 | YSVMA_DOCVA | Commission Document, Valuation | 30 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
49 | YTEL05_DOCACT | Commission Document: Activities | 9 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
50 | YTEL05_DOCDT | Comn: Detail Items for Remuneration Rows | 22 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
51 | YTEL05_DOCFI_H | Data Transfer: FI Documents (Header Data) | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
52 | YTEL05_DOCFI_P | Data Transfer: FI Documents (Items) | 20 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
53 | YTEL05_DOCHD | Commission Document Header | 64 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
54 | YTEL05_DOCINV | Participant in Commission Document | 15 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
55 | YTEL05_DOCOBJ | Commission Document: Object Data | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
56 | YTEL05_DOCPAR | Participation of Commission Document | 8 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
57 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 90 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
58 | YTEL05_DOCREL | Commission Document: Relationships Between Participants | 13 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
59 | YTEL05_DOCSE | Commission Document: Due Dates | 37 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
60 | YTEL05_DOCSEDT | Due Date Details | 12 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
61 | YTEL05_DOCSHA | Commission Document: Complex Distribution Ratios | 11 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
62 | YTEL05_DOCVA | Commission Document, Valuation | 40 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | | |
TOPNetWeaver Enterprise Search |
63 | ESH_QL_ST_EXCL | Searchterm Exclusions Table | 7 | UPD_TIMESTAMP | Timestamp (Last Update) | decimal | 21 | 7 | | |
64 | ESH_QL_ST_STAT | Searchterm Statistics Table for Indexing of Statistics Data | 11 | UPD_TIMESTAMP | Timestamp (Last Update) | decimal | 21 | 7 | | |