on 09-09-2011 3:26 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.