UJY_AVA_KPI - BPC: KPI
BPC: KPI information is stored in SAP table UJY_AVA_KPI.
It is part of development package UJY in software component EPM-BPC-NW. This development package consists of objects that can be grouped under "Planning Functions ( DDB, AVA,MOF)".
It is part of development package UJY in software component EPM-BPC-NW. This development package consists of objects that can be grouped under "Planning Functions ( DDB, AVA,MOF)".
Fields for table UJY_AVA_KPI
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| GUID | BPC: Cluster ID(Replace UJ_CLUSID) | X | UJ_CLUSID2 | CHAR | 100 | |
| APPSET_ID | SAP BusinessObjects - AppSet ID | X | UJ_APPSET_ID | CHAR | 40 | UJA_APPSET_INFO |
| APPL_ID | SAP BusinessObjects - Application ID | UJ_APPL_ID | CHAR | 40 | UJA_APPL | |
| KPI_NAME | BPC: KPI name | UJY_AVA_KPI_NAME | CHAR | 40 | ||
| DATECREATED | BPC: KPI date and time | UJY_AVA_DATE | CHAR | 60 | ||
| DATEUPDATED | BPC: KPI date and time | UJY_AVA_DATE | CHAR | 60 | ||
| DECIMALS | 1 Byte Unsigned Integer | INT1 | INT1 | 1 | ||
| KPI_TYPE | BPC: KPI type | UJY_AVA_KPI_TYPE | CHAR | 40 | ||
| CATEGORYID | BPC: AVA KPI category id | UJY_AVA_KPI_CATEGORY_ID | INT4 | 4 | UJY_AVA_KPI_CAT | |
| ACC_TYPE | BPC: AVA KPI account type | UJY_AVA_ACC_TYPE | CHAR | 6 | ||
| OWNERID | BPC: User ID | UJ_USER_ID | CHAR | 120 | ||
| SCALE | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
| ACTUAL | BPC SignData | UJ_SDATA | DEC | 11 | ||
| TARGET | BPC SignData | UJ_SDATA | DEC | 11 | ||
| VARIANCE | BPC SignData | UJ_SDATA | DEC | 11 |