Skip to Content
avatar image
Former Member

Trying to substitute 0P_KEYDT for another automatic variable on a BEX Query

I have made a BEX query, based on infocube 0FIAP_C03.
The query works fine, but i am using for the query , a lot of formulas (aprox. 150 formulas)
in order to show the values of this infocube accordingly to a specified range or days.

Everything goes fine, but now the end user is asking to avoid the "date" asking prompt.

We used the 0P_KEYDT (sap - exit bex variable) in order to give order to the formulas,
and this variable is used with offsets (-1,-2, -3,...0.... +1 , +2 , +3) .

I want to ask to you dear sap friends, people, and experts, if it is possible to substitute,
or change this variable, or it's value, for a predefined value of the current date (today).

I have noticed that as an old job, we have a variable called "ZKEYDT" which holds the today value.
Now I am asking if there is any method to substitute the old variable 0P_KEYDT for this new variable.
Is it possible for my 100 formulas, instead of making again each formula and offsets for each one.

Can you help me ?

Thanks in advance for your help

Carlos E.

Guatemala.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 12, 2017 at 09:19 AM

    Hi,

    is there another approach possible, maybe you can set the date-infoobject in the columns and restrict by an interval, so you adaptions will not be that grand?

    for your question I have to remain silence, I think that it's not possible to achieve that.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded