Skip to Content

Download Consolidation Monitor and Control Status Tables

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Aug 18, 2016 at 08:39 AM

    Hi Eyal,

    Please check below tables

    UJCTRL_CONTROLBPC: ControlsUJCTRL_CTRL_SETBPC: Control setUJW_EMAIL10BPC Work Status - Email Setting TableUJW_EMAIL10TBPC Work Status - Email Setting Text TableUJW_LCK_DIMBPC Work Status - Lock Dimension TableUJW_STATCODEBPC Work Status - Status Code TableUJW_STATCODETBPC Work Status - Status Code Text TableUJW_UPD_LOGBPC Work Status - Locks Update Log TableUJP_PROC_LOGConsolidation Process error logUJP_PROC_STEPBPC: Process Step of ConsolidationUJP_PROC_STEP_ABPC: 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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2016 at 09:04 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2016 at 02:28 PM

    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 :

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.