Skip to Content
author's profile photo
Former Member

Distribute from Month to Days

I'm using manual planning to enter plans for each month of a year.

I want to have a function that takes the monthly plan and distributes it into days based on an average. But the average should be based on Number of Working days.

How do I do this ?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 12, 2007 at 09:26 AM

    Frank

    I guess you should be able to do this by using "Distribute by Reference Data". Ideally you can have a set of ref data that is calculated in the background to prepare the averages for the month. The the function [dist by ref data] could be executed as a sequence after this event.

    You could use a process chain to first do the calculation and then follow it with a planning sequence that has your function.

    Srikant

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You do not need to include Days in the layout as you are using the FOX to generate it.

      In your level include Days, Month, Sales Org and anything else relevant in the "Fields to be changed". You can include Key figures, but you won't need it if you are reading and writing to the same key figure and there is only one Key Figure included in the level.

      Try this pseudocode for your FOX:

      FOREACH SALESORG, MONTH.

      CALENDAR = ATRV(...., SALESORG).

      AMT = {SALESORG, MONTH,...}.

      CALL Z function to get NO_OF_WORKDY.

      CALL /OSP/GET_DAYS_IN_MONTH to get NO_OF_DY.

      DAILY_AMT = AMT / NO_OF_WORKDY.

      COUNT = 1.

      DAY = CONCAT(MONTH,'01').

      DO

      CALL HOLIDAY_CHECK_AND_GET_INFO on DAY to get HOLIDAY.

      IF HOLIDAY <> 'X'.

      {SALEORG,MONTH,DAY,..} = DAILY_AMT.

      ENDIF.

      IF COUNT = NO_OF_DY.

      EXIT.

      ENDIF.

      DAY = TMVL(DAY, 1).

      COUNT = COUNT + 1.

      ENDDO.

      ENDFOR.

      I do not have access to a system to test this, so I not sure if it will work.

      Let me know how you go.

      Thanks

      Chami

  • author's profile photo
    Former Member
    Oct 11, 2007 at 03:19 PM

    Is there a shortage of BPS expertise or just a lack of involvement?

    I'm sure somebody has had a situation close enough to throw a thought or two.

    Would appreciate responses.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded