| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7PIQ_US_IPEDSDM | Assign Reports to DMEE Trees | 3 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
TOPContent Management Service |
2 | CREP_TREE | KPRO CMS: Content Repositories (TREE) | 3 | TREE_TYPE | Structure Type | nvarchar | 5 | 0 | | |
TOPCountry-Specific Objects |
3 | DMEE_ABA | DMEE Format Tree: General Data | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
4 | DMEE_AGGR_ABA | DMEE: Aggregation of Nodes | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
5 | DMEE_CHECKS_ABA | DMEE: Checks | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
6 | DMEE_COND_ABA | DMEE: Format Tree Node Conditions | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
7 | DMEE_DEBUG_ABA | DMEE: Temporary Data for Debugging | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
8 | DMEE_HEAD_ABA | DMEE: Format Tree Header Data | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
9 | DMEE_LEVTAB_ABA | DMEE: Format Level | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
10 | DMEE_NODE_ABA | DMEE: Format Tree Nodes | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
11 | DMEE_NODE_T_ABA | DMEE: Text Table for Tree Node | 2 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
12 | DMEE_NXTSG_ABA | DMEE: Supplementary Segments (Incoming DME Files) | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
13 | DMEE_RULES_ABA | DMEE: Assignment Rules (Incoming DME Files) | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
14 | DMEE_SHEET_ABA | DMEE: Key Fields for Subtotals on Accompanying Sheet | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
15 | DMEE_SORT_ABA | DMEE: Sort and Key Fields for Format | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
16 | DMEE_TECH_ABA | DMEE: Technical Fields in the Transfer Structures | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
17 | DMEE_TYPE_ABA | DMEE: Supported Tree Types | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
18 | DMEE_TYPE_T_ABA | DMEE: Text Table for Tree Types | 2 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
19 | DMEE_T_ABA | DMEE: Text Table for Tree Definition | 2 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
TOPDocument Management Services |
20 | SDOKSTRE | SDOK: Physical storage locations (Storage Repository) | 18 | TREE_TYPE | Structure Type | nvarchar | 5 | 0 | | |
TOPEnergy Data Management |
21 | EEDMSETTLPROCPRO | Settlement Procedure (Log Display) | 3 | TREE_TYPE | Representation of Navigation Tree in Log | nvarchar | 2 | 0 | | |
TOPHierarchy Storage |
22 | TTREETYPE | List of valid structure types | 1 | TREE_TYPE | Structure Type | nvarchar | 5 | 0 | | |
23 | TTREETYPEN | List of valid node types per structure type | 1 | TREE_TYPE | Structure Type | nvarchar | 5 | 0 | | |
24 | TTREETYPET | Name of valid structure types | 2 | TREE_TYPE | Structure Type | nvarchar | 5 | 0 | | |
TOPIncentive and Commission Management ICM |
25 | TCACS_NDPRO | Customizing Table for Tree Profiles | 10 | TREE_TYPE | Natural Number | int | 10 | 0 | | |
TOPLocalization |
26 | DMEE_TREE | DMEE Format Tree: General Data | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
27 | DMEE_TREE_AGGR | DMEE: Aggregation of Nodes | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
28 | DMEE_TREE_CHECKS | DMEE: Checks | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
29 | DMEE_TREE_COND | DMEE: Format Object - & Mapping Conditions | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
30 | DMEE_TREE_DEBUG | DMEE: Temporary Data for Debugging | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
31 | DMEE_TREE_HEAD | DMEE: Format Tree Header Data | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
32 | DMEE_TREE_LEVEL | DMEE: Format Level | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
33 | DMEE_TREE_NODE | DMEE: Format Tree Nodes | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
34 | DMEE_TREE_NODE_T | Text Table DMEE: Format Tree Node | 2 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
35 | DMEE_TREE_NXTSG | DMEE: Supplementary Segments (Incoming DME Files) | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
36 | DMEE_TREE_RULES | DMEE: Assignment Rules (Incoming DME Files) | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
37 | DMEE_TREE_SHEET | DMEE: Key Fields for Subtotals on Accompanying Sheet | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
38 | DMEE_TREE_SORT | DMEE: Sort and Key Fields for Format | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
39 | DMEE_TREE_T | DMEE: Text Table for Tree Definition | 2 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
40 | DMEE_TREE_TECH | DMEE: Technical Fields in the Transfer Structures | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
41 | DMEE_TREE_TYPE | DMEE: Supported Tree Types | 1 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
42 | DMEE_TREE_TYPE_T | DMEE: Text Table for Tree Types | 2 | TREE_TYPE | DMEE: tree type | nvarchar | 4 | 0 | | |
TOPMonitoring |
43 | SAPWLDMTHD | SAP Workload: Dynamically-Called Method for Events | 2 | TREE_TYPE | SAP workload: Tree type in trans. ST03 (one no. per tree) | nvarchar | 3 | 0 | | |
TOPWeb Services Tool |
44 | CRMC_WSC_OBJTREE | WSC Object Tree Table | 15 | TREE_TYPE | WSC Tree Type Data Element | nvarchar | 1 | 0 | | |