Hello,
Im only starting to use Celonis, so maybe my question is a super obvious one. But I need to learn somehow:)
Im working on an O2C process, based on SAP.
I need to create a column chart, where as a dimension I need the month when a specific activity (create delivery) happened. So, not the case creation (VBAK.ERDAT), but the time stamp of the activity create delivery.
Can anyone help me to come up with a proper statement for that?
Thanks in advance
Regards,
Masha
Page 1 / 1
Hello Masha,
Great to hear that you are getting started with Celonis!
Please try out the following PQL-statement for the dimension of your column chart:
PU_FIRST(VBAP, ROUND_MONTH("_CEL_O2C_ACTIVITIES".EVENTTIME), _CEL_O2C_ACTIVITIES.ACTIVITY_EN = Create Sales Order Item)
If you want to know more about PU-Functions, I can highly recommend the following guide:
The longest but ultimate guide for being a Pull-Up-Functions expert
Let me know if you have any remaining questions.
Best regards,
Timo
Great to hear that you are getting started with Celonis!
Please try out the following PQL-statement for the dimension of your column chart:
PU_FIRST(VBAP, ROUND_MONTH("_CEL_O2C_ACTIVITIES".EVENTTIME), _CEL_O2C_ACTIVITIES.ACTIVITY_EN = Create Sales Order Item)
If you want to know more about PU-Functions, I can highly recommend the following guide:
The longest but ultimate guide for being a Pull-Up-Functions expert
Let me know if you have any remaining questions.
Best regards,
Timo
Hello Timo,
thank you very much, although it did not work exactly like this. This statement (also advised by your Data Science team) worked though:
ROUND_MONTH(PU_FIRST(VBAP,"_CEL_O2C_ACTIVITIES".EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = create delivery))
I guess the idea is the same. Anyway, thank you!
Regards
Masha
thank you very much, although it did not work exactly like this. This statement (also advised by your Data Science team) worked though:
ROUND_MONTH(PU_FIRST(VBAP,"_CEL_O2C_ACTIVITIES".EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = create delivery))
I guess the idea is the same. Anyway, thank you!
Regards
Masha
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.