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 @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
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
