UJA_DIMENSION - BPC: Dimensions

BPC: Dimensions information is stored in SAP table UJA_DIMENSION.
It is part of development package UJA in software component EPM-BPC-NW-ADM. This development package consists of objects that can be grouped under "Admin".

Fields for table UJA_DIMENSION

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
APPSET_ID	SAP BusinessObjects - AppSet ID	X	UJ_APPSET_ID	CHAR	40	UJA_APPSET_INFO
DIMENSION	BPC: Dimension Name	X	UJ_DIM_NAME	CHAR	40
DIM_TYPE	BPC: Dimension Type		UJ_DIM_TYPE	CHAR	2
DIM_TYPE_INDEX	Index of the dimension with a given type		UJA_DIM_TYPE_INDEX	INT4	4
REF_DIM	BPC: Dimension Name		UJ_DIM_NAME	CHAR	40
NUM_HIER	BPC: 2-byte Integer		UJ_SMALLINT	INT2	2
TECH_NAME	BPC: Technical name		UJ_TECH_NAME	CHAR	32
SERVER_VERSION	BPC: Version		UJ_VERSION	CHAR	20
FILE_VERSION	BPC: Version		UJ_VERSION	CHAR	20
FILE_LOCK	BPC: Generic indicator		UJ_FLG	CHAR	2
PROCESS_STATE	Dimension's Process State		UJ_PROCESS_STATE	CHAR	2
LOCKED_BY	BPC: User ID		UJ_USER_ID	CHAR	120
CAPTION	Caption Field		UJ_CAPTION	CHAR	80
HIER_TIME_DEP	BPC: Generic indicator		UJ_FLG	CHAR	2
PROCESS_DATE	System Date		SYDATUM	DATS	16
PROCESS_TIME	System Time		SYUZEIT	TIMS	12
STRUC_MODIF_DATE	System Date		SYDATUM	DATS	16
STRUC_MODIF_TIME	System Time		SYUZEIT	TIMS	12
MBR_MODIF_DATE	System Date		SYDATUM	DATS	16
MBR_MODIF_TIME	System Time		SYUZEIT	TIMS	12
DATA_TABLE	Table Name		TABNAME	CHAR	60
DESC_TABLE	Table Name		TABNAME	CHAR	60
HIER_DATA_TABLE	Table Name		TABNAME	CHAR	60
TDA_TABLE	Table Name		TABNAME	CHAR	60