Skip to Content
avatar image
Former Member

set key due date automatically

Hello all,

I am new on this forum and using BI.

I create a query on BEX query designer and everything works fine. but I want to broadcast it daily and everyday I need to open the query on BEX broadcaster and change the key due date (mandatory field) manually.

There's any function to change automatically the date? (e.g, current_date, today(), ......)

Thanks and sorry if i dont use the right terms, but im really new using this application.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 07, 2010 at 02:34 PM

    Hi,

    Create one exit variable for date characteristics. In the user exit, just populate the exit variable value with system date.

    Then there is no need to change the query selection everyday.

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2010 at 02:42 PM

    Instead of creating your own customer exit variable you can just use the SAP exit variable 0DAT which always returns the current calendar day.

    You might have to activate it as BC if you can not locate it in your system.

    Hope this helps.

    BR

    Stefan

    Add comment
    10|10000 characters needed characters exceeded