My customer installed the following Apps from Marketplace and check the KPI.
・SAP S/4HANA - Accounts Receivable - Working Capital
She would like to confirm the following PQL syntax for the KPI "Actual DSO" in the KPI.
Here are the three points she would like to confirm.
(1) What is the formula for KPI_AR_DSO calculated for?
(2) What do {p1} and {p2} represent in the formula?
(3) If I understand (1) and (2), I may know what Actual DSO is calculating.
It would be helpful if you could also tell me what the Actual DSO is KPI to produce.
―――――
◆Apps
SAP S/4HANA - Accounts Receivable - Working Capital
◆KPI name
Actual DSO
◆KPI PQL
KPI("KPI_AR_DSO", <%= VAR_US_CURR_TIMEFRAME_START %>, <%= VAR_US_CURR_TIMEFRAME_END %>)
KPI_AR_DSO:
SUM(
CASE
-- When the date is right
WHEN PU_FIRST("<%=VAR_GS_CASE_ITEM_TABLE%>", "_CEL_AR_ACTIVITIES"."EVENTTIME", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = '<%=VAR_ACTNAME_ENTER_IN_SAP%>') > {p1}
AND PU_FIRST("<%=VAR_GS_CASE_ITEM_TABLE%>", "_CEL_AR_ACTIVITIES"."EVENTTIME", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = '<%=VAR_ACTNAME_ENTER_IN_SAP%>') <= {p2}
AND ISNULL(<%=VAR_KPI_DSO_CLEAR%>)=0 -- When the invoice is cleared
THEN DATEDIFF(dd, ROUND_DAY(<%= VAR_KPI_DSO_START %>), ROUND_DAY(<%=VAR_KPI_DSO_CLEAR%>)) * <%=VAR_GS_CASE_ITEM_TABLE%>."WRBTR_CONVERTED"
ELSE NULL
END
)
/
SUM(
CASE
-- When the date is right
WHEN PU_FIRST("<%=VAR_GS_CASE_ITEM_TABLE%>", "_CEL_AR_ACTIVITIES"."EVENTTIME", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = '<%=VAR_ACTNAME_ENTER_IN_SAP%>') > {p1}
AND PU_FIRST("<%=VAR_GS_CASE_ITEM_TABLE%>", "_CEL_AR_ACTIVITIES"."EVENTTIME", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = '<%=VAR_ACTNAME_ENTER_IN_SAP%>') <= {p2}
AND ISNULL(<%=VAR_KPI_DSO_CLEAR%>)=0 -- When the invoice is cleared
THEN <%=VAR_GS_CASE_ITEM_TABLE%>."WRBTR_CONVERTED"
ELSE NULL
END
)
◆Variables
VAR_US_CURR_TIMEFRAME_START：ROUND_YEAR(TODAY())
VAR_US_CURR_TIMEFRAME_END：TODAY()
VAR_GS_CASE_ITEM_TABLE：BSEG
VAR_ACTNAME_ENTER_IN_SAP：Enter in SAP
VAR_KPI_DSO_CLEAR："BSEG"."AUGDT"
VAR_KPI_DSO_START："BKPF"."BUDAT"
VAR_KPI_DSO_CLEAR："BSEG"."AUGDT"
―――――