Skip to Content
avatar image
Former Member

Data Provisioning Task Monitor displays

The Data Provisioning Task Monitor displays information in three tables: Task Overview, Task Execution Monitor and Task Operation Execution Monitor.

What are the underlying system reference views/tables used to store the above information?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 15 at 08:36 AM

    Hi,

    This is not a foolproof way but when I want to see which tables are used by a particular application for example the Data Provision component, I go and see what the standard Delivery Unit is, in this case HANA_IM_DP.

    I then go to the system tables and system views table to see which objects belong to this schema:

    SELECT "SCHEMA_NAME", "VIEW_NAME" FROM "SYS"."VIEWS" 
    WHERE ( UPPER("SCHEMA_NAME") LIKE  UPPER('%IM_DP%'));
    
    SELECT "SCHEMA_NAME", "TABLE_NAME" FROM "SYS"."M_TABLES" 
    WHERE ( UPPER("SCHEMA_NAME") LIKE  UPPER('%IM_DP%'))
    

    Views

    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::DP_REMOTE_SUBSCRIPTION_MONITOR_TILE
    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::DP_AGENT_MONITOR_TILE
    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::DESIGN_TIME_OBJECT_MONITOR_TILE
    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::IM_TASK_MONITOR_TILE

    Tables
    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::DP_STATISTICS
    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::NOTIFICATIONS
    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::NOTIFICATION_CONFIGURATION
    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::NOTIFICATION_PARAMETERS
    SAP_HANA_IM_DP;sap.hana.im.dp.monitor.ds::USER_PROFILES

    So, you could look at the following objects to see if they contain the results you're after:

    Kind regards,

    Dot

    Add comment
    10|10000 characters needed characters exceeded