Skip to Content
avatar image
Former Member

Calendar shift with user input

Daer all

I want to make a calendar shift within SAP BOPC 7.5 NW. The requirement is to have revenues from actual year on a daily basis and want to shift them to plan year on a daily basis again. The logic behind is to have the revenue from a specific Monday on exactly the same Monday 1 year later. This logic we implemented already within MS Excel and want to use it in a input schedule.

Now I got the old date and the new date. All I want is to give that value to SAP BOPC to show ACT revenue of 02.03.2009 on 01.03.2010 e.g..

How can I give variable values to a data package, and do that with 31 values?

Any better ideas to do this calendar shift? Standard?

All ideas will be welcome.

Edited by: Marco Rückert on Sep 7, 2010 6:13 PM

Edited by: Marco Rückert on Sep 7, 2010 6:20 PM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 21, 2010 at 09:13 AM

    Hi

    Like I wrote earlier, is there a way within BOPC available where I can give multiple variables into a package?

    No ideas?

    I just want to copy plan values from one characteristic value "02.03.2009" to another like "01.03.2010". I know that there is the possibility to use the prompt fields within packages, but I don't know how to fill those fields by using VBA (automatically from user input in MS Excel).

    Add comment
    10|10000 characters needed characters exceeded