Skip to main content
Question

Filtering for last activity of each day.

  • July 7, 2025
  • 2 replies
  • 32 views
shane.proct
Level 4
Forum|alt.badge.img

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.

    2 replies

    C
    Celonaut

    Hi Shane!

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

     

    julia.bauer
    Level 9
    Forum|alt.badge.img+6
    • julia.bauer
    • Level 9
    • July 8, 2025

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

    Community Code of ConductAccessibility statement