on 08-18-2016 9:12 AM
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
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 :
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.