Skip to main content

In an OLAP table, I am looking at sales documents "VBAK"."VBELN".  I only want to see the last change of each day.  How do I filter for the last "_CEL_O2C_ACTIVITIES"."EVENTTIME" of each day?  I’ve experimented with PU_MAX, but I keep getting errors.

Hi Shane!

Have you tried taking a look at PU_LAST in combination with the TODAY Function?

 

It should be solved by PU_FIRST(“VBAP”, “_CEL_O2C_ACTIVITIES”.”EVENTTIME”, ORDER BY “_CEL_O2C_ACTIVITIES”.”EVENTTIME” DESC )

Reply


Community Code of Conduct