| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SLCE/CACHE_KB | Knowledge Bases Cached in EJB-IPC | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
2 | /SLCE/OBO_ITEM | Mapping of Order BOM Items to Main Line items on Documents | 7 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
TOPCentral Part of Product Master |
3 | COMM_PME_CAT_MAP | Mapping of a Category or Product to PME Classes | 10 | KBID | Internal Number of SCE Knowledge Base | int | 10 | 0 | | |
4 | COMM_PME_PRD_MAP | Mapping of CRM Products for PME Classes | 10 | KBID | Internal Number of SCE Knowledge Base | int | 10 | 0 | | |
5 | COMM_PME_SET_MAP | Mapping Set Types for PME Classes | 10 | KBID | Internal Number of SCE Knowledge Base | int | 10 | 0 | | |
TOPInstalled Base |
6 | IBIB | IB: Installed Base/IBase | 20 | KBID | Configuration: Temporary Data Element for SCEKB-KBID | nvarchar | 6 | 0 | | |
TOPProduct Configurator |
7 | COMM_CFGCHADEP | Dependencies that are attached to Characteristics of Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
8 | COMM_CFGCHAPOS | Position Numbers of the Characteristics of Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
9 | COMM_CFGCHARAC | Basic Data for Characteristics | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
10 | COMM_CFGCHAREF | Characteristics that reference to external data sources | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
11 | COMM_CFGCHATX | Language-Dependent Description of Characteristic | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
12 | COMM_CFGCLACOM | Compiled Code for Classic Dependencies | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
13 | COMM_CFGCLFAC | Facets for Characteristics of Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
14 | COMM_CFGCLNDOM | Domains for Numeric Characteristics of Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
15 | COMM_CFGCLNHIER | Numeric Characteristic Values Hierarchy | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
16 | COMM_CFGCLPART | Decomposition Item | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
17 | COMM_CFGCLPREC | Class Precedence List | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
18 | COMM_CFGCLSDOM | Domains for String Characteristics of Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
19 | COMM_CFGCLSHIER | Symbolic Characteristic Values Hierarchy | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
20 | COMM_CFGCLVAL | Values and Defaults for Characteristics of Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
21 | COMM_CFGCLVTX | Language Dependent Value Descriptions | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
22 | COMM_CFGCNT | Control Objects (Tasks and Events) | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
23 | COMM_CFGCNTDEP | Dependency Nets that are attached to Tasks/Events | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
24 | COMM_CFGCNTTX | Language-Dependent Descriptions for Control Objects | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
25 | COMM_CFGCONFPR | Configurations Profiles | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
26 | COMM_CFGCUCO | Characteristic Order | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
27 | COMM_CFGCUHD | Customizing Screen Designer Header | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
28 | COMM_CFGCUSD | Customizing Screen Designer Groups | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
29 | COMM_CFGCUSDT | Language-Dependent Descriptions for Screen Designer | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
30 | COMM_CFGCUSDU | Customizing Screen Designer Groups Usage | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
31 | COMM_CFGDEP | Basic Data for Dependencies (including Nets) | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
32 | COMM_CFGDEPCOM | Compiled Code for Dependency Nets | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
33 | COMM_CFGDEPDEP | Relationship between Dependencies | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
34 | COMM_CFGDEPDNN | Discrimination Nodes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
35 | COMM_CFGDEPPAT | Pattern | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
36 | COMM_CFGDEPSPN | Simple Pattern Nodes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
37 | COMM_CFGDEPSRC | Source Text for Dependencies | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
38 | COMM_CFGDEPTX | Language Dependent Description of Dependencies | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
39 | COMM_CFGDEPVAR | Pattern | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
40 | COMM_CFGDOCKEY | Ref. table between documentation and object | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
41 | COMM_CFGDOCOBJ | Structure for Identifying Document | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
42 | COMM_CFGHASCHA | Characteristics of Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
43 | COMM_CFGHASDEC | OOClass <=> Decomposition (Deprecated) | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
44 | COMM_CFGHIER | Basic Data for Model Hierarchy | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
45 | COMM_CFGHIERTX | Language-Dependent Description of Hierarchy | 2 | KBID | Internal identifier of a model element | int | 10 | 0 | | |
46 | COMM_CFGINFILT | Filter | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
47 | COMM_CFGKB | Runtime Version of SCE Knowledge Base | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
48 | COMM_CFGKBLANG | Supported Languages of a KB | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
49 | COMM_CFGKBTX | Language-Dependent Description of KB | 2 | KBID | Internal identifier of a model element | int | 10 | 0 | | |
50 | COMM_CFGKMTDEP | Dependencies that are attached to KMATS | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
51 | COMM_CFGLNGTXT | Long Texts for Different Objects | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
52 | COMM_CFGMAT | Basic Data for Materials | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
53 | COMM_CFGNETBLOB | BLOBed Dependency Nets | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
54 | COMM_CFGNETOBJ | Position Numbers of the Characteristics of Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
55 | COMM_CFGNHIER | Numeric Characteristic Values Hierarchy | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
56 | COMM_CFGNUM | Basic Data for Numeric Characteristics | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
57 | COMM_CFGNUMDOM | Domains for Numeric Characteristics | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
58 | COMM_CFGOBJDEP | Relationship between Classes and Dependencies | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
59 | COMM_CFGOCLASS | Basic Data for OO-Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
60 | COMM_CFGOCLTX | Language Dependent Descriptions of OO-Classes | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
61 | COMM_CFGPROF | Knowledge Base Profiles | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
62 | COMM_CFGPROFTX | Language-Dependent Descriptions for Knowledge Base Profiles | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
63 | COMM_CFGPRTDEP | Dependencies that are attached to BOM positions | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
64 | COMM_CFGSHIER | Symbolic Characteristic Values Hierarchy | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
65 | COMM_CFGSTRDOM | Domains for String Characteristics | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
66 | COMM_CFGSTRING | Basic Data for String Characteristics | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
67 | COMM_CFGSUPER | Class Hierarchy | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
68 | COMM_CFGTABFUN | Variant Tables and Functions | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
69 | COMM_CFGVACOND | Variant Condition Key | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
70 | COMM_CFGVALDEP | Dependencies that are attached to Values of Characteristics | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
71 | COMM_CFGVALSYM | Symbol Table for Characteristic Values | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
72 | COMM_CFGVALTX | Language Dependent Value Descriptions | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
73 | COMM_CFGVTABLE | Variant Table Metadata | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
74 | COMM_CFGVTCOLUMN | Variant Table Column | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
75 | COMM_CFGXREF | Cross Reference | 2 | KBID | Internal identifier of a knowledge base | int | 10 | 0 | | |
TOPSales and Distribution |
76 | SCECHADEP | Assignment: Classic Dependencies to Chars of Classes | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
77 | SCECHAINP | No User Entry for Characteristic of Class | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
78 | SCECHAPOS | Position of Characteristic in Class | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
79 | SCECHARAC | Characteristics | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
80 | SCECHAREF | Reference of Reference Characteristic | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
81 | SCECHATX | Language-Dependent Description of Characteristic | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
82 | SCECHAVIS | Characteristic of Class Hidden/Shown | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
83 | SCECLACOM | Compilation for Classic Dependencies | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
84 | SCECLNDOM | Allowed Values for Numeric Characteristic of Class | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
85 | SCECLPREC | Precedence List for OO Classes | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
86 | SCECLSDOM | Allowed Values of Alphanumeric Characteristic of Class | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
87 | SCECLVAL | Values Assigned to Characteristics of a Class | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
88 | SCECLVTX | Lang.-Dependent Descs of Vals of Alphanum. Chars of Classes | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
89 | SCECNT | Control Knowledge (Tasks and Events) | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
90 | SCECNTDEP | Assignment of Dependencies to Control Knowledge | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
91 | SCECNTTX | Language-Dependent Descriptions of Control Knowledge | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
92 | SCECONFPR | Configuration Profiles | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
93 | SCECUCO | Interface Design - Sequence of Characteristics in a Group | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
94 | SCECUHD | Interface Design - Header Data | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
95 | SCECUSD | Interface Design - Grouping Structure | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
96 | SCECUSDT | Interface Design - Description of Groupings | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
97 | SCEDECOMP | Decomposition (BOM and so on) | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
98 | SCEDEP | Dependencies (Basic Data) | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
99 | SCEDEPCOM | Compilation of Dependency Nets | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
100 | SCEDEPDNN | DNNs of Dependency | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
101 | SCEDEPDOC | Documentation for Dependencies | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
102 | SCEDEPPAT | Pattern of Dependency | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
103 | SCEDEPSPN | SPNs of Dependency | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
104 | SCEDEPSRC | Source Code of Dependency | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
105 | SCEDEPTX | Language-Dependent Descriptions for Dependencies | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
106 | SCEDEPVAR | Variables of Dependencies | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
107 | SCEDOCKEY | Storage Location of Document Key | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
108 | SCEDOCOBJ | Link Between Documents and Objects | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
109 | SCEHASCHA | Characteristics of OO Class | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
110 | SCEHASDEC | Assignment of Decomposition to OO Class | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
111 | SCEHASPRT | Components of Decomposition (BOM and so on) | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
112 | SCEINVIEW | Allocation of Characteristic of Class to Org. Area | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
113 | SCEKB | Runtime Version of SCE Knowledge Base | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
114 | SCEKBTX | Language-Dependent Description for SCE Knowledge Base | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
115 | SCEKMTDEP | Assignment: Dependencies for Configurable Materials | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
116 | SCELNGTXT | Storage Location for Long Texts | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
117 | SCEMAT | Materials | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
118 | SCENUM | Numeric Characteristics | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
119 | SCENUMDOM | Allowed Values of Numeric Characteristic | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
120 | SCEOCLASS | OO Classes of SCE Knowledge Base | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
121 | SCEOCLTX | Language-Dependent Descriptions of OO Classes | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
122 | SCEPROF | Profile of Knowledge Base (Starting Point of Configuration) | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
123 | SCEPROFTX | Language-Dependent Description of Knowledge-Base Profile | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
124 | SCEPRTDEP | Assignment of Dependencies to Components (of BOM) | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
125 | SCESTRDOM | Allowed Values for Alphanumeric Characteristics | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
126 | SCESTRING | Alphanumeric Characteristics | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
127 | SCESUPER | Class Hierarchy of Knowledge Base | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
128 | SCETABFUN | Value Assignment Alternatives for Variant Table and Functs | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
129 | SCEVACOND | Assignment of Variant Condition to Char. Value in SCE KB | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
130 | SCEVALDEP | Assignment of Dependencies to Char. Values of Classes | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
131 | SCEVALSYM | Symbol Table for Characteristic Values | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
132 | SCEVALTX | Language-Dependent Descriptions of Values of Alphanum. Chars | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
133 | SCEVARVAL | Values in Variant Tables | 2 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | | |
TOPSoftware Agent Framework |
134 | CRMD_EI_SOL_CART | EI: Persist user selected solution out of SDB | 4 | KBID | Knowledge Base Entity ID | nvarchar | 50 | 0 | | |