kepm(Copa Planning) : Display periods in columns

[Former Member]

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

[Former Member · Accepted solution]

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

[ajaycwa1981 · Accepted solution]

Hi

I tried doing what you said, but system is giving me error...

The reason behind this is that I am using the CHAR "PERIO: period/year"....In planning package, I can specify only one variable... In the planning layout, i am creating 12 columns for the VF-Sales qty ie. one for each month and I am specifying 12 different variables in it... At this juncture, system gives me the error as below... If only we cud select the Chars GJAHR(Fiscal year) and PERDE (Period) instead of PERIO (which is a combination of these two chars) that shud resolve the issue

The error msg is as below

Diagnosis

Planning layout "PERWISE" has one or more variables for characteristic "PERIO". These variables are given values from the selection criterion for the planning package. The selection criterion (single values and/or interval) must match the variables.

System Response

The system tries to replace the variables in the planning layout with the selection criterion for the planning package.If, for example, there is a variable for a single value in the planning layout for a characteristic, then the selection criterion must contain a single value. If there are two variables for the from and to value of an interval in the planning layout for a characteristic, then an interval must also exist in the selection criterion .

Regards, Ajay

[ajaycwa1981 · Accepted solution]

Hi

The chars GJAHR and PERDE are not available for selection in KEPM... Can those be made available?

Regards,, Ajay

[Former Member · Accepted solution]

IF I remember correctly, you need to have the periods from-to in a higher level planning package. Then you need to modify the layout manually to add the different columns. I managed to get it working at a prior client a year or so ago.

[ajaycwa1981 · Accepted solution]

Hi

At the higher level planning package, I have specified a variable which contains From and To values as 001.2009 to 012.2009

While defining the planning layout, i create 12 columns and assign 12 variables to each of the columns for the characteristic PERIO.. each of the variable represent one period

But system gives error saying that the variables defined in the planning layout dont match with the one specified at planing package level

Regards, Ajay

[Former Member · Accepted solution]

Can you please show me how you ended up doing this? I have the same monthly plan upload requirement.

[Former Member · Accepted solution]

So I guess I'm not the only one having this problem...I am trying to work this through using variables and my idea is to create one basic variable for PERIO for the user to enter in the planning package and then to create 11 more variable which are PERIO1, PERIO2, etc... so that each column represents a subsequent month.

so far, I have no success in defining the subsequent month variables.

If you managed to overcome this issue and create the layout for 12 periods I'll be happy to learn how.

Cheers.

[former_member7439 · Accepted solution]

Hi

Any lead on the process for monthly updating the issue.

[sivaprasad_r · Accepted solution]

Hi,

How could you include the Period and Fiscal year in the KEPM ?

Thanks

Siva

[raviakasapu · Accepted solution]

hi

The Periods need to be included in the Layout for Planning in T Code KE15. The selections need to be provided in Gen. Data. Selection.

Ravi

[Former Member]

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

[Former Member]

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

[Former Member]

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?