Cost Center Planning document

[Former Member]

Hi Gurus,

I uploaded some plan data through excel integration (KP06 Tcode) for primary cost elements. While saving the file, system shows the message as "Changed data has been posted"

But when I check the report through T code s_alr_87013611 , I do not see the values posted to cost center.  I checked number range for business transaction RKP1 and it is assigned. I tried without excel integration to post the values and system gives me same message as to changed values are posted but there is no document generated for the same.

We have new GL implemented. I checked the settings regarding the number range and FICO integration and seems everything is maintained. GL codes for which cost elements are created are also NOT blocked for posting.

What could be the reason the plan values are not posted to the cost center? What settings I should check in FI as well as in CO for this issue

regards,

makrand

[ajaycwa1981 · Accepted solution]

Hi

Can you see the values posted in KP07? If yes, then may be it is an auth issue in S_ALR

To see the plan doc line items, you need to activate integrated planning.. However, non activation of this should not produce blank screen in S_ALR

RKP1, RKPQ are the business transaction relevant I guess. RKP1 you have already assigned..

Ensure that the CC is not blocked for Plan Primary costs

Br, Ajay M

[Former Member · Accepted solution]

Dear Ajay,

Thanks you. The issue is resolved for the time being. The integrated planning was not activated and also I was not knowing the Tcode to activate the same which is KP96.

I am not able to give star (*) in cost center and cost element input fields in the layout while generating the file description. Since the number of cost centers and cost elements are running in 700 to 750 in numbers, system throws an error message as " To many objects in the overview screen". Hence I specified only one cost center and one cost element in the layout so that the file description can be generated and saved.

But the issue now is when I use tcode KP06 , system defaults the cost center and cost element I have specified while saving the layout and when I click on overview screen, excel is opened for the entry with the cost center and cost element.I unprotect the sheet to make the changes in the same. I give list of cost centers and corresponding cost element with values and save it. But the data is not posted through this.If the cost center and cost element changed in the excel sheet is different than specified in the entry screen of Tcode KP06, system does not post the values.

Instead, I copy this excel file into txt file with the generic file name I have specified in the Tcode KP34 i.e. planner profile and upload this txt file in KP06 choosing "Extras------>Excel planning----->Upload"

This way the data is posted. I am not able to understand why the system is not accepting the values through overview screen in KP06 when the cost center and cost element are different than mentioned in the entry screen?

Can you guide me for the same? Also FI document is not generated as it is generated in CO.

regards,

makrand

[Former Member · Accepted solution]

Hi..

SAP don’t allow save plan data with cost center or cost element which is different from them you input in selection screen(initial screen).

To avoid the problem, you set default range as below picture and select free type for entry.

What do you mean by saying “Also FI document is not generated as it is generated in CO” ?

You mean that you want to transfer plan data from Overhead Cost Accounting to General Ledger Accounting.

If yes, Refer to SAP Help portal site:http://help.sap.com/erp2005_ehp_07/helpdata/en/87/231ffdb4e9494ea529a99c23aa2a56/content.htm?framese...

[Former Member · Accepted solution]

Hi Big Choi,

Thanks for your reply. I tried with what you have mentioned in the entry screen. With free entry option, system pops up excel sheet with the data already posted but when I tried to make any changes in and saved it, the document is not created and values are not posted.

Regarding FI document, I was under impression that system will post FI document for any plan document posted in CO. But since I have not transferred this plan data to FI, system has not created any document in FI.

Your link is helpful for this.

Please let me know why system is not posting any data when the data from the entry screen

is different from the data in excel sheet you post.

regards,

makrand

[Former Member · Accepted solution]

Hi.

Refer to error message.

Diagnosis

You entered characteristic value 430901 for characteristic cost element in a new
row.

Value 430901 does not match the selection criteria defined in the layout
KC0000000001 or in the initial transaction screen, however, and is thus not
allowed.

System Response

The SAP System rejects your entry.

Procedure

1. Overwrite "430901" with a valid characteristic value.

1. 2. Check the selection criteria in planning layout KC0000000001.

Consequently, plan data outside the range which you define in selection screen is not allowed.

[Former Member · Accepted solution]

Thanks Big choi,

The issue is resolved. I changed the values in layout , again generated the file description and posted the values through Excel. Now system is posting the values. Thanks a lot.

regards,

Makrand

[former_member182339]

Mak,

Refer  319713 - Error with Excel upload - possible causes

refer to the point 4 There are no input-enabled cells in the file description?

Thanks

Hrusikesh

[Former Member]

Dear Hrusikesh,

Hearty Thanks for the note you have provided. That gave me good input about file description and generic file.

Regards,

makrand