we’re currently only considering user types to define which activities have been done automatically (batch user) and which have been processed manual (all other user types):
100.0*AVG(CASE WHEN “_CEL_P2P_ACTIVITIES”.“USER_TYPE” IN (<%=auto_user_type%>)
THEN 1.0 ELSE 0.0 END)
However, for our MRP runs which shall be also considered automated there is always a manual user in SAP. We can identify MRP runs by the doc type (EP) in combination with the PR creation indicator (B).
Any suggestions how we can adjust above formula to also consider EP in combination with B as automated?