Question
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).
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
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)