Dynamic Query for Daily Sales in SAC

[ElenaTheophili]

Hi Community,

We are facing a request from a client to retrieve daily sales into SAC and to provide the ability for manual adjustments. To achieve this, we have created a planning model with daily granularity and are using the standard CDS view GLAccountBalanceFlow with the following filters:

• Company code
• Fiscal year: 2025
• GL account type: PLCHANING, PLOPENING, PLENDING
• Ledger: 0L

  However, we encountered two issues:

  1. The query never completes.
  2. We haven’t found a dynamic way to set the posting date without hardcoding it, but instead using a dynamic date, e.g., system date.

Has anyone faced a similar issue? If so, how did you resolve it? Any advice or direction would be greatly appreciated.

Thank you in advance for your help!

[William_Yu1]

To have a dynamic system date you can create time range filter by using system date input control.

[ElenaTheophili]

Hello William_Yu1,I want to create a time range filter in model. How can i achieve it?