| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCentral Part of Product Master |
1 | COMM_PME_CAT_MAP | Mapping of a Category or Product to PME Classes | 3 | FROMDATE | Date for Determining the Relevant Knowledge Base | nvarchar | 8 | 0 | | |
2 | COMM_PME_PRD_MAP | Mapping of CRM Products for PME Classes | 3 | FROMDATE | Date for Determining the Relevant Knowledge Base | nvarchar | 8 | 0 | | |
3 | COMM_PME_SET_MAP | Mapping Set Types for PME Classes | 3 | FROMDATE | Date for Determining the Relevant Knowledge Base | nvarchar | 8 | 0 | | |
TOPCollectionsDisbursements |
4 | DIMAIOBPAR | IO: Insurance Object-Partner Relationship in FS-CD | 13 | FROMDATE | Time Stamp (Date and Time) | nvarchar | 14 | 0 | | |
TOPContract Accounts Receivable and Payable |
5 | DFKKCCTK | Collections Management: Test Series - Header Data | 4 | FROMDATE | Valid-from date | nvarchar | 8 | 0 | | |
6 | DFKKCMUSER | Additional User for Collections Management | 6 | FROMDATE | Valid-From Date of Assignment | nvarchar | 8 | 0 | | |
7 | DFKKMANAGER | Additional User for Management of Worklists | 5 | FROMDATE | Valid-From Date of Assignment | nvarchar | 8 | 0 | | |
8 | DFKKVBUND | History: Trading Partners (VBUND) for Business Partner | 4 | FROMDATE | Valid-from date | nvarchar | 8 | 0 | | |
9 | DFKKVBUNDH | History: VBUND Adjustment Postings | 4 | FROMDATE | Valid-from date | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
10 | CACNS_CU_HIST | Projects at Customer | 7 | FROMDATE | Date on which the Record Was Created | nvarchar | 8 | 0 | | |
TOPIntercompany Data Exchange |
11 | EMRDETAIL | IDE: detailed information on MR results (ISU_USAGE_DATA) | 8 | FROMDATE | Start of Period | nvarchar | 8 | 0 | | |
TOPInterface to Terminal Automation System |
12 | OIK01 | IS-OIL/TAS: LID Document Data | 9 | FROMDATE | Valid from date (TAS) | nvarchar | 8 | 0 | | |
13 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 10 | FROMDATE | Valid from date (TAS) | nvarchar | 8 | 0 | | |
14 | OIK37 | IS OIL: Shadow table for SD document processing | 26 | FROMDATE | TPI From Date | nvarchar | 8 | 0 | | |
15 | OIKLIDR | TD - TAS Reference Table | 5 | FROMDATE | Timestamp valid from | nvarchar | 14 | 0 | | |
TOPLease Accounting |
16 | FILA_RE_PRG | Refinancing Program | 11 | FROMDATE | Valid-from date | nvarchar | 8 | 0 | | |
TOPMaster Data |
17 | EPROPH | Allocation of Inst. to Ownership | 4 | FROMDATE | Date from which time slice is valid | nvarchar | 8 | 0 | | |
TOPProduct Configurator |
18 | COMM_CFGKB | Runtime Version of SCE Knowledge Base | 12 | FROMDATE | KB validity date | nvarchar | 8 | 0 | | |
TOPSales and Distribution |
19 | SCEKB | Runtime Version of SCE Knowledge Base | 6 | FROMDATE | Valid-from date | nvarchar | 8 | 0 | | |
20 | SCEKBOBJ | Knowledge-Base Object (SCE) | 13 | FROMDATE | Valid-From Date | nvarchar | 8 | 0 | | |
TOPTraders and Schedulers Workbench |
21 | OIJTHPUTFCEST | OIL-TSW: Rack issue / Throughput estimate pop-up | 10 | FROMDATE | OIL-TSW: Start date | nvarchar | 8 | 0 | | |
22 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 40 | FROMDATE | OIL-TSW: Deal validity From date | nvarchar | 8 | 0 | | |
23 | OIJ_EL_DOC_MOT | Oil TSW: TSW Relevance of order item | 21 | FROMDATE | OIL-TSW: Deal validity From date | nvarchar | 8 | 0 | | |
24 | OIJ_RELPROF | Oil-TSW: Release profiles for Schedules | 4 | FROMDATE | Valid-from date | nvarchar | 8 | 0 | | |
25 | S430 | SIS: (OIL-TSW) Sales document statistics by TSW object | 39 | FROMDATE | OIL-TSW: Deal validity From date | nvarchar | 8 | 0 | | |
26 | S431 | PURCHIS: (OIL-TSW) Purchasing document stats by TSW object | 44 | FROMDATE | OIL-TSW: Deal validity From date | nvarchar | 8 | 0 | | |
TOPTranslation Tools |
27 | LXE_CSN_UPDATE | Table for Report RS_TRANSLATION_CSN_UPDATE | 7 | FROMDATE | System Date | nvarchar | 8 | 0 | | |
28 | TPM_DIR | Translation performance monitor header | 6 | FROMDATE | Date of Beginning of Interval | nvarchar | 8 | 0 | | |