Skip to main content
Solved

When to use ACTIVITY_TABLE and other SAP tables?

  • May 7, 2024
  • 4 replies
  • 17 views
.
Level 5

I’m a bit confused of when to use the ACTIVITY_TABLE() and other SAP tables when calculating the KPIs. So for example, when I want to calculate # of changes per PO item, is it correct when I use the ACTIVITY_TABLE() to count the change activities occurred or use the EKPO table and calculate the changes with indicator fields from the table. Same for other KPIs, this is just an example.

 

Because

sometimes I get different results (in calculating automation users/activities

for example) and I am not sure which is correct.

Best answer by Sverre Klein

Hi @1683786050,

 

The Activity_Table has, at minimum, 3 columns. A case ID, Activity Name, and Timestamp. This table is used to visualize a process and is arguably the most important table.

 

For example

 

CASE_ID | ACTIVITY | TIMSTAMP

1 | Create PO Requisition Item | 5/8/2024 10:00:00

 

You can also add additional metadata to it, such as if the action performed was a user or a system (automation)

 

CASE_ID | ACTIVITY | TIMSTAMP | PERFORMED

1 | Create PO Requisition Item | 5/8/2024 10:00:00 | User1

 

To visualize the ACTIVITY_TABLE you can make an analysis > add a OLAP Table > Dimension: Case ID > KPIs: Activity & Timestamp.

 

This essentially gives you an idea how the activity table looks like 😄

 

If you need more information or help, please let us know.

 

Kind regards,

Sverre Klein

    4 replies

    Sverre Klein
    Level 10
    Forum|alt.badge.img+14
    • Sverre Klein
    • Level 10
    • 204 replies
    • May 7, 2024

    Hi @1683786050,

     

    I think this topic is up for debate, but this is how I see it:

     

    The Activity_table is suitable for when you need to track all activities related to a Purchase Order (PO) item, including creations, changes, approvals, etc. This table captures a more granular view of user actions.

     

    The EKPO table is suitable when you specifically want to track data changes to PO item fields.

     

    In other words:

     

    If you want to understand the type of changes made (e.g., quantity change, price change) and who made them: Use ACTIVITY_TABLE in conjunction with other relevant tables.

     

    If you want the total number of changes regardless of the specific data modified: Use EKPO and count the number of times any field has changed for the item.

     

    Please take this with a grain of salt.

     

    Kind regards,

    Sverre Klein

    .
    Level 5
    • .1683757
    • Author
    • Level 5
    • 10 replies
    • May 7, 2024

    Hi @1683786050,

     

    I think this topic is up for debate, but this is how I see it:

     

    The Activity_table is suitable for when you need to track all activities related to a Purchase Order (PO) item, including creations, changes, approvals, etc. This table captures a more granular view of user actions.

     

    The EKPO table is suitable when you specifically want to track data changes to PO item fields.

     

    In other words:

     

    If you want to understand the type of changes made (e.g., quantity change, price change) and who made them: Use ACTIVITY_TABLE in conjunction with other relevant tables.

     

    If you want the total number of changes regardless of the specific data modified: Use EKPO and count the number of times any field has changed for the item.

     

    Please take this with a grain of salt.

     

    Kind regards,

    Sverre Klein

    Hi @sverre.klein11 ,

     

    Thank you for your reply.

     

    Do you know if there a way to visualize the ACTIVITY_TABLE() and its columns to be able to understand and validate the data? I tried that on the Data Explorer but I couldn't find it.

     

    Thank You.

     

    Regards,

    Nourhan

    Sverre Klein
    Level 10
    Forum|alt.badge.img+14
    • Sverre Klein
    • Level 10
    • 204 replies
    • Answer
    • May 8, 2024

    Hi @1683786050,

     

    The Activity_Table has, at minimum, 3 columns. A case ID, Activity Name, and Timestamp. This table is used to visualize a process and is arguably the most important table.

     

    For example

     

    CASE_ID | ACTIVITY | TIMSTAMP

    1 | Create PO Requisition Item | 5/8/2024 10:00:00

     

    You can also add additional metadata to it, such as if the action performed was a user or a system (automation)

     

    CASE_ID | ACTIVITY | TIMSTAMP | PERFORMED

    1 | Create PO Requisition Item | 5/8/2024 10:00:00 | User1

     

    To visualize the ACTIVITY_TABLE you can make an analysis > add a OLAP Table > Dimension: Case ID > KPIs: Activity & Timestamp.

     

    This essentially gives you an idea how the activity table looks like 😄

     

    If you need more information or help, please let us know.

     

    Kind regards,

    Sverre Klein

    .
    Level 5
    • .1683757
    • Author
    • Level 5
    • 10 replies
    • May 8, 2024

    Thank you!


    Community Code of ConductAccessibility statement