Ratio KPI to show the ratio of eProcurement PO lines

Hi all,
I would like to define a new KPI to measure the ratio of eProcurement (EP) orders vs. all other PO doc types. The doc type information comes from the PO header (EKKO), however I’d like to show the ratio based on line item level (EKPO). The formula which I’ve set-up and which works fine for the ratio on Header looks as follows:
100 * AVG(CASE WHEN “EKKO”.“BSART” = ‘EP’ THEN 1.0 ELSE 0.0 END)

Somehow, I’ve to bring in one more variable to take line items into account: COUNT_TABLE(“EKPO”)

Any idea how to combine to show the ratio of EP PO items?

Thanks, Oli

Hey Oli,

If I understand correctly you want to show the ratio between the EP PO Lines and the not EP PO lines.

Although there are definitely different approaches for a solution of your problem, I would recommend going with a PU_COUNT to pull the amount of Positions per Header from the EKPO on the EKKO level and setting the right filter. This would look something like this:

100 *
SUM(PU_COUNT(“EKKO”, “EKPO”.“POSNR”, “EKKO”.“BSART” = ‘EP’))
/
SUM(PU_COUNT(“EKKO”, “EKPO”.“POSNR”, “EKKO”.“BSART” != ‘EP’))

Best Regard,

Benedict

1 Like

Thanks for the fast help. The proposed solution works fine with two small adjustments:

  1. I had to replace “POSNR” with “EBELP” according to the data model used
  2. In order to show the ratio of EP PO Lines vs. all PO lines I had to remove the second part of the filter “EKKO”.“BSART” != ‘EP’

100 *
SUM(PU_COUNT(“EKKO”, “EKPO”.“EBELP”, “EKKO”.“BSART” = ‘EP’))
/
SUM(PU_COUNT(“EKKO”, “EKPO”.“EBELP”))

Thanks again for the help! Oli