cancel
Showing results for 
Search instead for 
Did you mean: 

How to do KEPM mass planning(for all periods) through a single upload file

Former Member
0 Kudos

Hi Experts,

My client requirement is Revenue mass planning for all periods in KEPM. I advised go for Flexi upload by put 12 files (for 12 periods ) in file directory and upload but they are asking for a single upload file instead of 12 files.

Its appreciated if any of you advise how to do this mass planning. I tried through LSMW (Recording) but i failed.

And one more requirement is have to transfer this plan data from KEPM to profit center accounting. Plz suggest how to do this.

Version is ECC6.0 and Classical PCA was activated in our client.

Help me on these issues, its very very urgent.

Regards,

Spandana.

Accepted Solutions (1)

Accepted Solutions (1)

ajaycwa1981
Active Contributor
0 Kudos

Hi

Use KE13N and you can upload using a single file

You need to have the12 Periods as 12 columns in your Planning layout...

Fiscal year is what you would provide at the Planning package level...

To Transfer COPA to PCA: IMG > COPA > Planning > Integrated Planning > Set Up Transfer of Planning Data to EC-PCA/FI-GL/FI-SL

br, Ajay M

Former Member
0 Kudos

Hi Ajay,

Thanks for your quick inputs.

I am trying to create one planning layout in KE14 but in the available fields Period is not available can you please advise how to include the field Period in a planning layout. if i used the wrong Tcode please guide me the correct one.

Regards,

Spandana.

ajaycwa1981
Active Contributor
0 Kudos

Hi

Its very much available

Go to KE14 - Enter a Plan Layout name and click Create

Double click on the Column and choose "Value Field with Chars"... Here, choose Sales Qty Value Field and plug in the char "Period/Year" from right to left

Note that PERIOD is not available in COPA for Planning.. You need to use Period/Year

br, Ajay M

Former Member
0 Kudos

Hi Ajay,

Thanks for your reply. I have created one planning layout as per your instructions but when i am trying to save the layout its throwing error messges as"

"Element Sales qty requires selection Period -> change"

"Element Revenue requires selection Period -> change"

Message no. KH582

Please help me in this issues.

Regards

Spandana.

ajaycwa1981
Active Contributor
0 Kudos

Hi

Never faced this error.. Can you give details of this msg?? Click on the error msg and paste the details here

br, Ajay M

Former Member
0 Kudos

Hi Ajay,

Now this problem resolved so i assigned this planning layout in KEPM and trying to execute by activate integrated excel but not getting the layout exactly. have to plan Quantity as well as Revenue.

My layout is looking like

Profit center Product Revenue Sales quantity Jan Feb Mar Apr May June Jul Aug and so on.

My Requirement is

Profit center Product Revenue Jan Feb Mar Apr May June Jul Aug and so on

Sales quantity Jan Feb Mar Apr May June Jul Aug and so on.

The 12 periods defined only for the Sales Quantity in the layout. what about Revenue..........

can you please advise.

ajaycwa1981
Active Contributor
0 Kudos

Hi

It seems you are in love with COPA :)... Even I was in love with it (and am still II!)

Well, you would need 24 columns - 12 for Qty and revenue each...

In your columns, you need to select Sales Qty as the Value field and include Period/year as the Char 12 times

Similarly, for Revenue as well

br, Ajay M

Former Member
0 Kudos

Hi Ajay,

Thank you very much. Now i am able to do mass plan for both Revenue and Quantity.

Regards,

Spandana.

Answers (0)