| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRSS/D_DAG_ASG | Demand Agr. Graph for Demand that is planned | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
2 | /MRSS/D_DAG_DEM | Demand Agr. Graph for Total and Attribute specific Demand | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
3 | /MRSS/D_DAG_MOB | OBSOLETE DB Table - NOT IN USE | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
4 | /MRSS/D_DAG_PAS | Demand Agr. Graph for Preparation/Warp-up of Assignments | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
5 | /MRSS/D_DAG_PDE | Demand Agr. Graph for expected Prep/Warp-up of unpl. Dem. | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
6 | /MRSS/D_DAG_RSB | Demand Agr. Graph for virtual Reserve Base(non existing Dem) | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
7 | /MRSS/D_DAG_RSV | Demand Agr. Graph for virtual Reservation (non existing Dem) | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
8 | /MRSS/D_DAG_TAS | Demand Agr. Graph for Travel Times of Assignments | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
9 | /MRSS/D_DAG_TDE | Demand Agr. Graph for expected Travel Times of unpl. Dem. | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
10 | /MRSS/D_DAG_TRV | OBSOLETE DB Table - NOT IN USE | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
11 | /MRSS/D_DAG_UNA | Demand Agr. Graph for Demand that is not planned yet | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
12 | /MRSS/D_PN_HIER | Planning Node - Hierarchical Relationships | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
13 | BBP_CT_LOADSTRUC | Structure of Product Catalogs or Classification Schemas | 4 | NODE_GUID | GUID for General Node | varbinary | 16 | 0 | | |
14 | ESH_OM_AOTYPNL | Object Types: Nodes: Layout Templates | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
15 | ESH_OM_AOTYPNRP | Object Types: Nodes: Related Perspectives | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
16 | ESH_OM_COTYPNL | Object Types: Nodes: Layout Templates | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
17 | ESH_OM_COTYPNRP | Object Types: Nodes: Related Perspectives | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
18 | ESH_OM_IOTYPNL | Object Types: Nodes: Layout Templates | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
19 | ESH_OM_IOTYPNRP | Object Types: Nodes: Related Perspectives | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
TOPGroup Hierarchy |
20 | BUT_HIER_NODE | Business Partner Hierarchy Group | 2 | NODE_GUID | GUID of Hierarchy Node | varbinary | 16 | 0 | | |
21 | BUT_HIER_NODE_BP | Business Partner Hierarchy Group - Bus. Partner Assignment | 7 | NODE_GUID | GUID of Hierarchy Node | varbinary | 16 | 0 | | |
22 | BUT_HIER_NODE_D | Business Partner Hierarchy Group - Description | 3 | NODE_GUID | GUID of Hierarchy Node | varbinary | 16 | 0 | | |
23 | BUT_HIER_NODE_DU | Business Partner Hierarchy Group - Description | 3 | NODE_GUID | GUID of Hierarchy Node | varbinary | 16 | 0 | | |
24 | BUT_HIER_STRUCT | Business Partner Hierarchy Group - Hierarchy Relationship | 3 | NODE_GUID | GUID of Hierarchy Node | varbinary | 16 | 0 | | |
TOPLogistics - General |
25 | CRMC_CO_HIER | CRM-CO Interface: Hierarchy Node Table | 3 | NODE_GUID | UUID in X form (binary) | varbinary | 16 | 0 | | |
26 | CRMC_CO_HIER_D | CRM-CO Interface: Description of Hierarchy Nodes | 3 | NODE_GUID | UUID in X form (binary) | varbinary | 16 | 0 | | |
27 | CRMC_CO_HIER_ID | CRM-CO Interface: COPA-ID Hierarchy Nodes | 2 | NODE_GUID | UUID in X form (binary) | varbinary | 16 | 0 | | |
TOPMaintenance Orders |
28 | /MRSS/D_PN_CAPA | Capacity Rule Definition for Planning Nodes | 3 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
29 | /MRSS/D_PN_HD | Planning Node - Header Data | 2 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
30 | /MRSS/D_PN_HD_T | Node - Language dependent Texts | 2 | NODE_GUID | GUID | varbinary | 16 | 0 | | |
TOPNetWeaver Enterprise Search |
31 | ESH_OM_ADPRVDFL | Data Providers: Filters | 6 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
32 | ESH_OM_AOTYPN | Object Types: Nodes | 3 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
33 | ESH_OM_AOTYPNA | Object Types: Nodes: Operational Data Providers | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
34 | ESH_OM_AOTYPNBN | Object Types: Nodes: Backend Navigations | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
35 | ESH_OM_AOTYPNC | Object Types: Nodes: Authority Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
36 | ESH_OM_AOTYPNCC | Object Types: Nodes: Assignment of Authorization Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
37 | ESH_OM_AOTYPNCCL | Object Types: Nodes: Logical Conjunctions of Auth. Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
38 | ESH_OM_AOTYPNF | Object Types: Nodes: Node Fields | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
39 | ESH_OM_AOTYPNGF | Object Types: Nodes: Node Attribute Groups | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
40 | ESH_OM_AOTYPNP | Object Types: Nodes: Members of Node | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
41 | ESH_OM_AOTYPNQ | Object Types: Nodes: Requests | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
42 | ESH_OM_AOTYPNQN | Object Types: Nodes: Requests: Queries: Nodes | 5 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
43 | ESH_OM_AOTYPNRF | Object Types: Nodes: Response Fields | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
44 | ESH_OM_AOTYPNRG | Object Types: Nodes: Response Attribute Groups | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
45 | ESH_OM_AOTYPNRO | Assignment of Roles to Nodes | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
46 | ESH_OM_AOTYPNRR | Object Types: Nodes: Related Requests | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
47 | ESH_OM_AOTYPNT | Object Types: Nodes: Descriptions | 3 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
48 | ESH_OM_AOTYPQN | Object Types: Queries: Nodes | 5 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
49 | ESH_OM_CDPRVDFL | Data Providers: Filters | 6 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
50 | ESH_OM_COTYPN | Object Types: Nodes | 3 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
51 | ESH_OM_COTYPNA | Object Types: Nodes: Operational Data Providers | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
52 | ESH_OM_COTYPNBN | Object Types: Nodes: Backend Navigations | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
53 | ESH_OM_COTYPNC | Object Types: Nodes: Authority Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
54 | ESH_OM_COTYPNCC | Object Types: Nodes: Assignment of Authorization Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
55 | ESH_OM_COTYPNCCL | Object Types: Nodes: Logical Conjunctions of Auth. Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
56 | ESH_OM_COTYPNF | Object Types: Nodes: Node Fields | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
57 | ESH_OM_COTYPNGF | Object Types: Nodes: Node Attribute Groups | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
58 | ESH_OM_COTYPNQ | Object Types: Nodes: Requests | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
59 | ESH_OM_COTYPNQN | Object Types: Nodes: Requests: Queries: Nodes | 5 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
60 | ESH_OM_COTYPNRF | Object Types: Nodes: Response Fields | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
61 | ESH_OM_COTYPNRG | Object Types: Nodes: Response Attribute Groups | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
62 | ESH_OM_COTYPNRO | Assignment of Roles to Nodes | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
63 | ESH_OM_COTYPNRR | Object Types: Nodes: Related Requests | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
64 | ESH_OM_COTYPNT | Object Types: Nodes: Descriptions | 3 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
65 | ESH_OM_COTYPQN | Object Types: Queries: Nodes | 5 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
66 | ESH_OM_IDPRVDFL | Data Providers: Filters | 6 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
67 | ESH_OM_IOTYPN | Object Types: Nodes | 3 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
68 | ESH_OM_IOTYPNA | Object Types: Nodes: Operational Data Providers | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
69 | ESH_OM_IOTYPNBN | Object Types: Nodes: Backend Navigations | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
70 | ESH_OM_IOTYPNC | Object Types: Nodes: Authority Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
71 | ESH_OM_IOTYPNCC | Object Types: Nodes: Assignment of Authorization Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
72 | ESH_OM_IOTYPNCCL | Object Types: Nodes: Logical Conjunctions of Auth. Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
73 | ESH_OM_IOTYPNF | Object Types: Nodes: Node Fields | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
74 | ESH_OM_IOTYPNGF | Object Types: Nodes: Node Attribute Groups | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
75 | ESH_OM_IOTYPNP | Object Types: Nodes: Members of Node | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
76 | ESH_OM_IOTYPNQ | Object Types: Nodes: Requests | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
77 | ESH_OM_IOTYPNQN | Object Types: Nodes: Requests: Queries: Nodes | 5 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
78 | ESH_OM_IOTYPNRF | Object Types: Nodes: Response Fields | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
79 | ESH_OM_IOTYPNRG | Object Types: Nodes: Response Attribute Groups | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
80 | ESH_OM_IOTYPNRO | Assignment of Roles to Nodes | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
81 | ESH_OM_IOTYPNRR | Object Types: Nodes: Related Requests | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
82 | ESH_OM_IOTYPNT | Object Types: Nodes: Descriptions | 3 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
83 | ESH_OM_IOTYPQN | Object Types: Queries: Nodes | 5 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
84 | ESH_OM_SDPRVDFL | Data Providers: Filters | 6 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
85 | ESH_OM_SOTYPN | Object Types: Nodes | 3 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
86 | ESH_OM_SOTYPNBN | Object Types: Nodes: Backend Navigations | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
87 | ESH_OM_SOTYPNC | Object Types: Nodes: Authority Checks | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
88 | ESH_OM_SOTYPNF | Object Types: Nodes: Node Fields | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
89 | ESH_OM_SOTYPNQ | Object Types: Nodes: Requests | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
90 | ESH_OM_SOTYPNQN | Object Types: Nodes: Requests: Queries: Nodes | 5 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
91 | ESH_OM_SOTYPNRF | Object Types: Nodes: Response Fields | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
92 | ESH_OM_SOTYPNRO | Assignment of Roles to Nodes | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
93 | ESH_OM_SOTYPNRR | Object Types: Nodes: Related Requests | 4 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
94 | ESH_OM_SOTYPNT | Object Types: Nodes: Descriptions | 3 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
95 | ESH_OM_SOTYPQN | Object Types: Queries: Nodes | 5 | NODE_GUID | Node GUID | nvarchar | 32 | 0 | | |
TOPQuestion Answer Database |
96 | QADB_SCOPE | Scope from ASAP QADB | 2 | NODE_GUID | Unique ID - 32 characters | nvarchar | 32 | 0 | | |
TOPTest Organizer |
97 | TWBMAN_RECO_FAV | TWBM: Favorites | 4 | NODE_GUID | Unique ID - 32 characters | nvarchar | 32 | 0 | | |