Download Consolidation Monitor and Control Status Tables

[Former Member]

Hi,

I would like to download the consolidation monitor to Excel.

Alternatively, I’d like to download the consolidation status, control status, and work status.

Control status – I can get from a specific table to the install

Where can I find the consolidation and work status for a particular combination of Category Scope Currency and Time by Entity like the Consolidation monitor?

Regards,

Eyal

[Former Member]

To Summarize:
Use the  SE38 - UJ0_GET_GEN_TABNAME to obtain the Work Status Lock Table for Work Status and

the Control table listed for controls

Additionally can join the Work Status table to status description table :

[Former Member]

Let's try again:

To Summarize:

1) Use the  SE38 - UJ0_GET_GEN_TABNAME to obtain the Work Status Lock Table for Work Status and

the Control table listed for controls

2) Additionally can join the Work Status table to status description table :UJW_STATCODE 

There is no known table to obtain consolidation status.

Thanks to all for responding.

Regards,

Eyal

[Former Member]

You can use UJW_WS_TEST export Work Status. In trx SE38, enter the program name: UJW_WS_TEST, then select the environment model and click the "LOCKS TABLE", view tables, and download content to excel.

Regards,

Tomasz

[Former Member]

Thanks for your responses.  Still searching.

The table above is one of the tables set up when defining the dimensions and has the Work Status.

Will update if I find anything further. 

Regards,

Eyal

[former_member186338]

Table with work status:

SE38 - UJ0_GET_GEN_TABNAME

Select Environment and Model

[former_member225135]

Hi Eyal,

Please check below tables

UJCTRL_CONTROL	BPC: Controls
UJCTRL_CTRL_SET	BPC: Control set
UJW_EMAIL10	BPC Work Status - Email Setting Table
UJW_EMAIL10T	BPC Work Status - Email Setting Text Table
UJW_LCK_DIM	BPC Work Status - Lock Dimension Table
UJW_STATCODE	BPC Work Status - Status Code Table
UJW_STATCODET	BPC Work Status - Status Code Text Table
UJW_UPD_LOG	BPC Work Status - Locks Update Log Table
UJP_PROC_LOG	Consolidation Process error log
UJP_PROC_STEP	BPC: Process Step of Consolidation
UJP_PROC_STEP_A	BPC: Archive Table of Consolidation Process

As far as i know, i don't think it is possible to download consolidation monitor in Excel

Regards,

Rahul

[Former Member]

Hi Eyal,

Here is a list of all BPC tables in BW......SAP BPC Training | SAP BPC Online Training | SAP BPC Course | SAP BPC Certification: sap bpc trainin...

But please can you explain why do you require to download the consolidation monitor?? Dint understand the purpose specifically..

Regards,

JP