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).
Im 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
Page 1 / 1
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)
PU_FIRST(
_CEL_P2P_CASES,
_CEL_P2P_ACTIVITIES.EVENTTIME,
_CEL_P2P_ACTIVITIES.ACTIVITY_EN=Create Purchase Order Item)
Thanks for the fast feedback! 
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)
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.
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.