Skip to main content

Hello everyone,

 

I'm currently wondering how the date picker exactly filters the dates within the P2P process. Since: "_CEL_P2P_ACTIVITIES"."EVENTTIME" refers to several activities for a single purchase order item, does it "cut off" PO's that have a single activity outside the defined range?

 

Let's say I filter only for the 1st of September and a single PO has 3 activities: one on 31st of August, one on the 1st of September and another one on the 2nd of September. Would the date picker then consider this order because a single activity lies within the specified time period or cut it off because one or more activities are out of the defined scope? Either way feels I little bit inaccurate.

 

Another question: How would I have to adapt the date picker to see only PO's for which the "Record Goods Receipt" lies between the specified time period?

 

Thank you in advance and best regards

Aram

One PO can have multiple activities "Record Goods Receipt".

One example that might fulfill your request would be replacing the "_CEL_P2P_ACTIVITIES"."EVENTTIME" by

PU_FIRST(EKPO,"_CEL_P2P_ACTIVITIES"."EVENTTIME","_CEL_P2P_ACTIVITIES"."Activity_EN" = 'Record Goods Receipt')

The date picker would filter dates based on the first occurrence of 'Record Goods Receipt' on a PO Line level


Thanks for the reply!

 

Does someone know the first answer to my question? It would be helpful for me to be able to explain to colleagues what exactly they are filtering with the standard date picker.


Reply