| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/KAGR_C_DOWN | Customizing for Download | 2 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
2 | /OPT/KAGR_C_DOWT | Customizing for Download | 2 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
3 | /OPT/KAGR_C_KPI | Customizing table for KPI ID | 2 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
4 | /OPT/KAGR_C_KPIP | Customizing table for KPI ID Mapping | 2 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
5 | /OPT/KAGR_C_KPIT | Customizing table for KPI ID texts | 2 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
6 | /XPPM/CAR_C_KP | Reporting Tool: KPI Customizing | 3 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
7 | /XPPM/CAR_C_KPSO | KPI Selection definition | 3 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
8 | /XPPM/CAR_C_KP_T | KPI Customizing | 3 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
9 | /XPPM/CAR_VARIAN | Save variants | 4 | KPI_ID | KPI ID | nvarchar | 5 | 0 | | |
10 | /XPPM/EVA_C_CFLD | PPM CS EVA: Mapping Custom Fields to Usage Types | 5 | KPI_ID | ID | nvarchar | 2 | 0 | | |
11 | /XPPM/EVA_KACOB | PPM CS EVA: KPI values based on accounting objects | 4 | KPI_ID | ID | nvarchar | 2 | 0 | | |
12 | /XPPM/EVA_KACOBV | PPM CS EVA: KPI values based on accounting objects (version) | 5 | KPI_ID | ID | nvarchar | 2 | 0 | | |
13 | /XPPM/EVA_KCPOB | PPM CS EVA: KPI values based on cPro objects (project,phase) | 4 | KPI_ID | ID | nvarchar | 2 | 0 | | |
14 | /XPPM/EVA_KCPOBV | PPM CS EVA: KPI values based on cPro objects (project,phase) | 5 | KPI_ID | ID | nvarchar | 2 | 0 | | |
15 | /XPPM/EVA_KTSKN | PPM CS EVA: KPI values based on cPro tasks | 4 | KPI_ID | ID | nvarchar | 2 | 0 | | |
16 | /XPPM/EVA_KTSKNV | PPM CS EVA: KPI values based on cPro tasks (version) | 5 | KPI_ID | ID | nvarchar | 2 | 0 | | |
17 | T77ANAKPIMD | KPI Metadata | 4 | KPI_ID | KPI ID | nvarchar | 10 | 0 | | |
18 | T77ANAKPIMD_T | KPI Metadata (Texts) | 4 | KPI_ID | KPI ID | nvarchar | 10 | 0 | | |
TOPASAP Tools and Contents |
19 | SMAPPI0 | Solution Map: Performance Indicator (Header) | 1 | KPI_ID | Solution Map: Key Performance Indicator | nvarchar | 32 | 0 | | |
20 | SMAPPI0T | Solution Map: Performance Indicator (Text) | 3 | KPI_ID | Solution Map: Key Performance Indicator | nvarchar | 32 | 0 | | |
TOPEnd User Technology |
21 | RSKPI_CAT_ENTRY | KPI Catalog: Entry | 4 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
22 | RSKPI_KPI | KPI: Header Data | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
23 | RSKPI_KPIT | KPI: Header Data Texts | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
24 | RSKPI_KPI_ATTR | KPI: Attributes | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
25 | RSKPI_KPI_ATTRT | KPI: Language-Dependent Attributes | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
26 | RSKPI_KPI_CMP | KPI: Component | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
27 | RSKPI_KPI_CMPAL | KPI: Alias Call for Evaluation of Component | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
28 | RSKPI_KPI_DAS | KPI: Data Access Services with Alias Names | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
29 | RSKPI_KPI_DASIN | KPI: Data Access Services Input Parameters | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
30 | RSKPI_KPI_IN | KPI: Input Parameters | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
31 | RSKPI_KPI_INT | KPI: Texts for Input Parameters | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
32 | RSKPI_KPI_INVAL | KPI: Values for Input Parameters | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
33 | RSKPI_KPI_THD | KPI: Threshold Values | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
34 | RSKPI_VNT | KPI Variant: Header Data | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
35 | RSKPI_VNTT | KPI Variant: Header Data Texts | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
36 | RSKPI_VNT_INVAL | KPI Variant: Input Parameter Values | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
37 | RSKPI_VNT_THD | KPI Variant: Threshold Values | 1 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
38 | RSKPI_WL_ENTRY | KPI Watchlist: Entry | 3 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
TOPLogistics - General |
39 | EPM_CODE | Key Management for KPI Values | 3 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
40 | EPM_DATA_COMMENT | Comments for Data Points in Trend Analysis | 2 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
41 | EPM_KPI_CATALOG | KPIs Available in Company Catalog | 2 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
42 | EPM_KPI_CATALOGH | History of KPIs in KPI Catalog | 2 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
43 | EPM_KPI_CATALOGT | KPI Text (Language-Dependent) | 2 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
44 | EPM_KPI_DATA | Current KPI Values | 2 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
45 | EPM_KPI_USER | User-Dependent Settings for Individual KPIs | 3 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
46 | EPM_KPI_VIEW | Assignment of KPIs to User-Specific Views | 3 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
47 | EPM_USER_ALERTS | User-Dependent Alerts for KPIs | 2 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
48 | EPM_USER_GATES | User-Dependent Settings for Individual Threshold Values | 3 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
49 | EPM_USER_TEXTS | User-Dependent Settings for Individual KPIs | 3 | KPI_ID | Technical Name of KPI | nvarchar | 30 | 0 | | |
TOPPlant Maintenance |
50 | EAMS_KPIFOROBJ | KPIs for GIS and Analytics | 3 | KPI_ID | KPI ID | nvarchar | 4 | 0 | | |
51 | EAMS_KPIFOROBJ_T | Text Table for KPIs | 2 | KPI_ID | KPI ID | nvarchar | 4 | 0 | | |
52 | EAMS_KPIMETADATA | KPI Metadata Table for GIS and Analytics | 2 | KPI_ID | KPI ID | nvarchar | 4 | 0 | | |
53 | EAMS_KPIPARAM | KPI Display Parameter Customizing Table | 2 | KPI_ID | KPI ID | nvarchar | 4 | 0 | | |
54 | EAMS_KPIPERSONAL | KPI Personalisation Table | 2 | KPI_ID | KPI ID | nvarchar | 4 | 0 | | |