BPC Master Data tables

BPC dimensions are normally maintained via BPC web client (cockpit). There none of its technical information (e.g. tech name of objects) is shown. Because of that, it is a bit tricky to find out what database tables are storing data for the BPC dimensions. There is a small ABAP program that can serve a purpose of revealing of these database tables. It is called UJ0_GET_GEN_TABNAME and it displays following database tables for given BPC Environment and Model ID:

COMMENT

COMMENT_ARCHIVE

AUDDATA

AUDDATA_A

JOURNAL_DETAIL

JOURNAL_TRANSLATION

MEMBER_ACS

MEMBER_INF

CONTROL_SET

CONTROL

CONTROL_BD

Work Status Lock

In addition to that ABAP program, one can use table UJA_DIMENSION which holds data about BPC’s dimension data table, text table (ending with T) and corresponding BW infoobject.