Skip to Content
avatar image
Former Member

kepm(Copa Planning) : Display periods in columns

Hi Guys

Currently, period (001.2009 to 012.2009) is visible in the header section of the excel layout.. So, I have to upload sales plan for each period separately i.e. while uploading data for Jan 2009, i have to specify period as 001. 2009 to 001. 2009. in the excel header.. Similarly, I am creating 12 files, one for each month

I want to display each period in a separate column so that i can upload plan data at once.... Is it possible?

When i created planning package under planning level, i created a variable for characteristic "perio" and entered 001.2009 to 012.2009 as values for the variable.. Without specifying values for this variable, i am unable to proceed further

The char "perio" does not appear either as Header or Lead column when i create my planning layout in the step "Enter Planning data

Regards, Ajay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 05, 2008 at 09:00 AM

    Hi,

    If you need period 1...12 as 12 coloums, then you need to modify your layout. Make sure that it is not included in General Data selection and then define 12 coloums with period 1...12.

    Hope this helps you

    Varadharajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2014 at 09:34 PM

    That means I need a separate set of LAYOUTs for every year since I need to hard code columns Period/Year value... This is really cumbersome...Can anybody shed some light on how a planning layout could be used in different years?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 31, 2014 at 05:56 PM

    Hi Ajay

      Have you figured out how to added period/year char as a column on the KEPM layout, so that planning data for multiple periods can be entered at the same time?

    While creating the layout, the system is letting me add period/year in the general data selection but not in the layout as a column. I am facing the same issue of having to upload the planning data 12 times by chaning the period at the planning level each time.

    Thanks

    Vamsi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 16, 2016 at 12:24 PM

    Hi

    "I want to display each period in a separate column so that i can upload plan data at once.... Is it possible?"


    Yes you can;

    You should enter period/year parametre range not at the planning level, but at the planning package. You should create planning package for each year, and enter the the period/year parametre (001.2009 - 012.2009).

    After these process you should pass the layout which you assign parametre set; You can adjust the layout with tansaction KE15. Select the layout than go to EDIT > Gen data selection > Gen data selection (Ctrl+F5) than extract Period /year from Selected characteristic screen to Available characteristic.


    Than you can display each period in a seperate column with;

    Within the layout; insert element > create value field with charateristic and period / year parametre comes automaticly, enter the period 001.2009 for january

    Add comment
    10|10000 characters needed characters exceeded