UJY_AVA_KPI

BPC: KPI | #masterdata | Component: NetWeaver Version
Column Name Description
MANDT FK Client
GUID BPC: Cluster ID(Replace UJ_CLUSID)
APPSET_ID FK SAP BusinessObjects - AppSet ID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
KPI_NAME BPC: KPI name UJY_KPI_NAME
DATECREATED BPC: KPI date and time UJY_DATE
DATEUPDATED BPC: KPI date and time UJY_DATE
DECIMALS 1 Byte Unsigned Integer INT1
KPI_TYPE BPC: KPI type UJY_KPI_TYPE
ACC_TYPE BPC: AVA KPI account type UJY_ACC_TYPE
OWNERID BPC: User ID UJ_USER_ID
SCALE 4 Byte Signed Integer INT4
ACTUAL BPC SignData UJ_SDATA
TARGET BPC SignData UJ_SDATA
VARIANCE BPC SignData UJ_SDATA
Master Data Relations Join Conditions
SAP BusinessObjects - Application ID
  • SAP BusinessObjects - Application ID
  • Client
  • SAP BusinessObjects - AppSet ID
  • UJY_AVA_KPI.APPL_ID == UJA_APPL.APPLICATION_ID
  • UJY_AVA_KPI.MANDT == UJA_APPL.MANDT
  • UJY_AVA_KPI.APPSET_ID == UJA_APPL.APPSET_ID
SAP BusinessObjects - AppSet ID
  • SAP BusinessObjects - AppSet ID
  • Client
BPC: AVA KPI category id
  • BPC: AVA KPI category id
  • Client
  • SAP BusinessObjects - AppSet ID
Client UJY_AVA_KPI.MANDT == T000.MANDT