Skip to Content
author's profile photo Former Member
0
Former Member

Difference between Date KF and Current Date in BEx

Posted on Nov 07, 2008 at 02:23 PM 12 Views

Hello.

Sorry for this question but even though I've search and already found lots of stuff on this subject, I still can't figure out how to proceed except by a Customer Exit which I have no clue how to perform.

I have a Formula that add days to a date attribute of my material master. Thus, I have two variables to perform this trick. Now, I'd like to subtract the current date from this formula. I've read a lot of post mentionning the 0DAT SAP Variable. I can see that variable under a 0CALDAY characteristic within my Info Cube but I am not able to use this variable in my formula I'm trying to create as it is not being shown. It seems that I can only use this variable to create a restricted Key Figure which is not what I'm looking for.

Can't beleive SAP were not able to add a simple function like TODAY() ... Why doing thing a simple way when you can do it much more complex hey 😉

So, is the only solution being to create a customer exit variable? If so, anyone can explain me the steps required?

Thanks.

Regards,

John

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2008 at 02:45 PM
    0

    John,

    Try this:

    Create a formula for date difference: current day(sap exit variable) - (date from material)

    create another variable with replacement path to get date from Material

    Eg: current date - date from material

    Check: [Dertive Variable|https://www.box.net/shared/jhk02hvh7r]

    [Replacement Path|http://help.sap.com/saphelp_nw04/helpdata/en/03/6ba03cc24efd1de10000000a114084/frameset.htm]

    Hope it Helps

    Srini

    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.