| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | RSMDUCMUKADSO | UT DataStore Objects (Advanced): identifying attr. for MUKs | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPBatches |
2 | TVBX_CBATP | Tax Table of Materials for Characteristic-Based ATP | 8 | CHANM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
3 | TVBX_MAT_CBATP | Tax Table of Materials for Characteristic-Based ATP | 9 | CHANM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
TOPBusiness Information Collection |
4 | UISUBSET | Assignment to Evaluation Objects: Subset of Characteristics | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPBusiness Planning |
5 | UPB_CMI_101 | CMI: Assignment to Characteristics | 4 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
6 | UPB_HI_REF | Planning Applucations: Reference to Hierarchy | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
7 | UPB_MD_REF | Planning Applications: OLD!!!!!!! Reference to Master Data | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
8 | UPB_MD_REF_N | Planning Applications: Reference to Master Data | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
9 | UPB_T_MD_ROLE | Characteristic Role Assignment Persistence | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
10 | UPB_YT_CRITERIA | Table for Characteristics | 1 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPBusiness Planning and Simulation |
11 | UPC_BW_TIMEREF | Assignment Time Characteristic - Time Reference | 1 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
12 | UPC_CHACMP | Properties of a Characteristic | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
13 | UPC_CHADEP | Compoundend Values | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
14 | UPC_CHAPRO | Properties of a Characteristic | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
15 | UPC_FLDDS | Fields for Relations between Characteristics | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
16 | UPC_NODES | Hierarchy Node | 7 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
17 | UPC_STEPS | Relations between Characteristics of a Planning Area | 9 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
18 | UPC_VARIABLE | Variables - Old Version of Database (New is UPC_VAR) | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
19 | UPC_VAR_CHA | Variables - Characteristics | 4 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
20 | UPC_VAR_CHADEP | Variables - Selections using Hierarchies | 6 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
21 | UPC_VAR_CHADEPA | Variables - Selections using Hierarchies | 6 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
22 | UPC_VAR_CHA_ACT | Variables - Restricted Values | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
23 | UPC_VAR_CHA_SEL | Variables - Selections | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
24 | UPC_VAR_HIE | Variables - Hierarchies | 7 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
25 | UPC_VAR_HIE_SEL | Variables - Selections using Hierarchies | 9 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
26 | UPC_VAR_HIE_SELA | Variables - Selections using Hierarchies (Active Values) | 9 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
27 | UPP_DOC | Planning: Layout Builder Info about Document | 12 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
28 | UPS_HEADER | Header Selections for STS | 4 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
29 | UPS_TP_HIERARCHY | Connection Subplan-Hierarchy | 7 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
30 | UPX_CHANMGROUPI | UPX: Characteristic Groups - Items | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
31 | UPX_DSRC_CHANM | UPX: Data Sources - Header | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
32 | UPX_DSRC_HEAD | UPX: Data Sources - Header | 8 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
33 | UPX_HEAD | Key Figure Schemes for Planning Layouts: General Fields | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
34 | UPX_HEAD_TEXT | Texts for Key Figure Schemes | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
35 | UPX_KFS_LKF | Key Figure Schemes for Planning Layouts: Layout Key Figures | 4 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
36 | UPX_KFS_SHIFT | Key Figure Schemes for Planning Layouts: Relative Addresses | 4 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
37 | UPX_SLC_MAIN | Configuration of Lead Columns | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
38 | UPX_SLC_TEXT | Configuration of Lead Columns: Text Table | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
39 | UPX_SLC_TIME | Time Characteristics | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPBW Service API |
40 | RODCHA | BW: InfoObjects / Characteristics | 1 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPCorporate Performance Monitor |
41 | UMK_BMK002 | Master Data Mapping | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
42 | UMK_MB120 | Benchmark Data Source <-> Measure | 4 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPData Basis |
43 | RSDICHAPRO | InfoCube-specific characteristic properties | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
44 | RSMDUCMUKAGGR | UT Aggregates: Identifying attributes for MUKs | 6 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
45 | RSMDUCMUKCMP | UT Compound Cha: Identifying attributes for MUKs | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
46 | RSMDUCMUKCUBE | UT InfoCube: identifying attributes for MUKs | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
47 | RSMDUCMUKMETA | UT MetaData: identifying attributes for MUKs | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
48 | RSMDUCMUKNLS | UT Nearline Infoproviders: identifying attributes for MUKs | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
49 | RSMDUCMUKODSO | UT DataStore Objects: identifying attributes for MUKs | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPData Staging |
50 | RSARCHIPROLOCSEL | BW Archiving: Archived Data Area | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
51 | RSARCHREQSEL | BW Archiving: Request-Selections | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPDistribution |
52 | WCAT_PROFILE | Cost allocation profile | 12 | CHANM | Account characteristic of cost allocation reference data | nvarchar | 30 | 0 | | |
TOPGeneric Statistical Data |
53 | /DSD/GS_CDMI_CHA | DSD: Define Catalog of Returned Characteristic | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
54 | /DSD/GS_CDMI_SEL | DSD: Define Selections for Data Provider | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPMetadata Repository |
55 | RSDATRNAV | Navigation Attributes | 1 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
56 | RSDATRNAVSID | Assignment: Navigation attribute -> SID field name | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
57 | RSDATRNAVT | Navigation Attributes | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
58 | RSDATRNAVT_TXV | Navigation Attributes - Text Verticalization | 3 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
59 | RSDCHA | Characteristic Catalog | 1 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
60 | RSDCHATHJ | Characteristics for Temporal Hierarchy Join | 1 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
61 | RSDMTXTCHANGES | Last change to the text table of an InfoObject | 1 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
62 | RSDNAIP | Navigation Attributes of Characteristics as InfoProvider | 1 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPOLAP Technology |
63 | RRKMULTIPROVHINT | Control of MultiProvider Hint | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
64 | RSDDTPS_FILTER | MultiProvider for Polestar - Filter | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
65 | RSDRCRM_SEG_EXST | Execution Plan: Recording Additional Data for Step Calls | 7 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPPlanning |
66 | RSPLS_CHAS_LOCK | Planning: Lock-Relevant Characteristics per InfoProvider | 2 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
67 | RSPLS_CR_ROLE | Characteristic Relationships: Roles of the Characteristics | 5 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
68 | RSPLS_CR_STEPS | Relationships Between Characteristics in Basic InfoProvider | 16 | CHANM | Characteristic | nvarchar | 30 | 0 | | |
TOPPurchasing |
69 | WRFT_BUDG_LEV | Budget Level | 3 | CHANM | Name of Info Object | nvarchar | 30 | 0 | | |
TOPReport Selection for Product Costing |
70 | TKKRE | Hierarchy Summarization (Summarization Characteristics) | 2 | CHANM | Summarization Characteristic/CO Summarization | nvarchar | 30 | 0 | | |
71 | TKKRF | Hierarchy Summarization (Assignment Summar. Char. to Fields) | 3 | CHANM | Summarization Characteristic/CO Summarization | nvarchar | 30 | 0 | | |
TOPStakeholder Relationship Management |
72 | USS_BW_HIERARCHY | USTH0: BW Hierarchy | 6 | CHANM | Characteristic | nvarchar | 30 | 0 | | |