Measure Booking Process by Order Level

I need to measure the number of orders within the booking process: anything between Create Quotation and Create Sales Order Item. For background, the # of Sales Orders using COUNT_TABLE("VBAK") is 200k.
Using either of the below formulas continues to give me 200k Sales Orders. I have also attempted it with/without many different component filters:

COUNT(DISTINCT CASE WHEN

"_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Create Quotation','Create Sales Order Item')

THEN "VBAK"."MANDT" || "VBAK"."VBELN" ELSE NULL END)

or

COUNT (DISTINCT CASE

WHEN (PU_COUNT("VBAK","_CEL_O2C_ACTIVITIES"."USER_TYPE","_CEL_O2C_ACTIVITIES"."USER_TYPE" LIKE '%' 

				AND "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Create Quotation','Create Sales Order Item')) 

				= PU_COUNT("VBAK","_CEL_O2C_ACTIVITIES"."USER_TYPE", "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" 

                    IN ('Create Quotation','Create Sales Order Item')))

			        THEN "VBAK"."MANDT" || "VBAK"."VBELN"

			    ELSE NULL

			END

			)

You guys have been a tremendous help in the past, would love to see what I am missing or any other suggestions.

Page 1 / 1

Hi,
Im not sure if I understood your question correctly. So do you want to calculate the number of cases that have gone through Create Quotation and Create Sales Order Item afterwards?
Could you clarify this a bit?
Thanks and BR
David

@d.becher,
Not necessarily directly afterwards.
Another way of stating it would be the crop selection:

For example say I was doing throughput time bucketing for the booking process, the PQL would be:

CASE

     WHEN DATEDIFF(DD,



PU_MIN(VBAK, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = Create Quotation)



, PU_MAX(VBAK, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = Create Sales Order Item)



) <= 5



                        THEN <= 5

Perhaps we can apply something similar to the crop function onto the analysis sheet filter as a whole?

In order to calculate the number of cases that have gone through Create Quotation and eventually through Create Sales Order Item, you can use PROCESS EQUALS:

COUNT( CASE WHEN PROCESS EQUALS 'Create Quotation' TO ANY TO 

'Create Sales Order Item' THEN 1 ELSE NULL END )

This also respects the cases where the two activities do not follow each other directly, but there can be other activities in between.
Best
David

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN