Date Picker based on PO Line Item creation date

Hi all,

in our P2P analysis we used to filter based on PO Header creation date (“EKKO”.“AEDAT”). However, it would be more precise to filter based on PO Line Item creation date. Looking in our SAP table for PO Line Items (EKPO), the date which is available in EKPO is always the last update date (which is not necessarily the line item creation date, in case there are changes in the PO line item after the creation). Thus, we have to also look at the CDPOS and CDHDR tables in SAP to see what kind of change have been done for the PO line item (–> Insert = PO line item creation date; Update = change date after PO line item creation date).

As we are not having CDPOS and CDHDR tables in our P2P data model, we are now using a date picker with the formula “_CEL_P2P_ACTIVITIES”.“EVENTTIME”. However, by doing so we would need to add component filters or an Analysis script in order to consider only the activity “Create Purchase Order Item” for the event time (FILTER “_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN” = ‘Create Purchase Order Item’).

I’m looking for another way to directly have a formula in the date picker which only looks for the event time for the activity “Create Purchase Order Item” in order to not filter all other components / the full analysis with the activity.

Any suggestions how to change the formula in the date picker in order to directly filter on PO line item creation date?

Thanks
Oli

We use this directly in the date picker / fiscal period drop-downs and it seems to work:
PU_FIRST(
“_CEL_P2P_CASES”,
“_CEL_P2P_ACTIVITIES”.“EVENTTIME”,
“_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN”=‘Create Purchase Order Item’)

Thanks for the fast feedback! :slight_smile:

Unfortunately, the table “_CEL_P2P_CASE_KEY” is not available in combination with the Date Picker component. We have this field and table in general available in our data model, but somehow, it is not possible to use in the date picker component.
I could not find the component “fiscal period drop-down” --> maybe this component is only available for later Front End versions (we are still operating on 4.4)

Fiscal period drop-down: sorry for the misunderstanding. This is not an out of the box component. What I meant that I have added a Dropdown component and added
RIGHT(PU_FIRST(
“_CEL_P2P_CASES”,
“_CEL_P2P_ACTIVITIES”.“FISCAL_PERIOD”,
“_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN”=‘Create Purchase Order Item’),4)
as Dropdown items, creating a “fiscal period” drop-down rather than using a date picker.
But it also works with a date picker if you use
PU_FIRST(
“_CEL_P2P_CASES”,
“_CEL_P2P_ACTIVITIES”.“EVENTTIME”,
“_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN”=‘Create Purchase Order Item’)
as date picker items. --> you basically filter the eventtime right in the date picker instead of adding component filters to all components.

1 Like