Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.