I upload the budget information into the system 

Process: Product Costing

Responsibility area: Manage product costing



Scope
 
ERP
WP2
 Frequency
      
References


Error rendering macro 'contentbylabel'

parameters should not be empty

Content by label

There is no content with the specified labels

Attachments

IAC 01.01 Costing Model.xlsx

IAC 01.01 Costing Model_366 days.xlsx

IAC 01.01. Costing model validation  << I upload the budget information into the system >> OP.029



  Guideline  

You receive the Costing Model file completed by a FRA.

STEP 1

Open the template you received and go to the tab 

you can find : 

  1. the list of cost centers 
  2. the list of cost elements to be used
  3. the budget in local currency






STEP 2

Use the function ROUNDUP to round number upwards 

= ROUNDUP(number;0)



STEP 1

Set the planner profile with KP04

Enter:

  • ZRCSBUD to upload and excel file
  • SAPALL for manual input

 

and 

 


 

 

 

STEP 2

Start the transaction KP06

Enter : 

  1. Version = 0 
  2. Period 
  3. Cost center group (usually the plant code)

  4. Activity type : « * »

  5. Cost element : « * »

  6. Transaction currency

Click 

Enable macro if you have a warning message

 

 

STEP 3

Unprotect the excel sheet

  1. Click on
  2. Unprotect sheet 

 

 

 

STEP 4

Copy and Paste the budget

 

 

 

  1. Copy the list of cost centers in column A
  2. Copy the list of cost elements in column C
  3. Copy the Budget (Normal capacity) in column D
  4. Enter 1 in column E
  5. Enter 2 in column G

 

 

 

STEP 5

Save 

You are informed that changes have been posted

 

 

STEP 1

Open the template you received and go to the tab 

you can find : 

  1. the list of cost centers 
  2. the list of activities
  3. the number of hours (=Normal capacity)

 

 

 

 

 

STEP 1

Set the planner profile with KP04

Enter:

  • RCSBUD to upload and excel file
and 

 


 

 

 

STEP 2

Start the transaction KP26

Enter : 

  1. Version = 0 
  2. Period 
  3. Cost center group (usually the plant code)

  4. Activity type : « * »

Click 

Enable macro if you have a warning message

 

 

STEP 3

Unprotect the excel sheet

  1. Click on
  2. Unprotect sheet 

 

 

 

STEP 4

Copy and Paste the hours

 

 

 

  1. Copy the list of cost centers in column A
  2. Copy the list of activity type in column B
  3. Copy the hours (Normal capacity) in column C
  4. Enter 1 in column D
  5. Enter 2 in column F

 

 

 

STEP 5

Save 

You are informed that changes have been posted

 

 

Once everything is uploaded, control what is in the system with OP.029

If there is no error, inform the person who will run the cycle OP.026

 

16 Comments

  1. ANTUNES, Ana Lucia

    Step 2 of this OP is not clear: the period that we are working is always "1 to 12"? ROLLIER, Charlotte

    1. Sevilla, Rosario

      Yes, as we are uploading a "yearly" Budget

       

  2. ANTUNES, Ana Lucia

    Add the controlling area before starting the upload of the budget so we can upload the amounts.

  3. ANTUNES, Ana Lucia

    When trying to insert the amounts in KP06 the error we can retrieve is the one in the image below.

    1. Sevilla, Rosario

      This error pop-up when the excel file is open.

      The good practice in this case  is to save the document and close it before uploading 

      ROLLIER, Charlotte , we can update the procedure with this comment? 

  4. Priscila Morais

    In session "The regional costing manager (RCOM) sends you the file IAC 01.09 Costing model.xlsx completed by a FRA", it would be good to have the meaning of "FRA".

  5. Priscila Morais

    In session "Set the planner profile with KP04", it would be good to inform the user that this transaction closes after the "ENTER", because it seems that it did not work out.

  6. Priscila Morais

    I cannot add comments in specific points in the procedure, according to the message:

    "We can't add your inline comment; the section you highlighted may contain a macro or user mention. Try highlighting plain text."

    How should I proceed?

    1. Alexandra Lepercq

      Hello Priscila

      In fact there is a problem with the inline comment functionality.

      We are working on it

      i hope this helps

  7. Priscila Morais

    In session "Step 4 - Copy and Paste the budget", is it necessary to inform "2" in column G? In case it is, it could be added point 5.

  8. João Isaac

    Hello, when uploading the Budget in Trans. KP06 we get the following error/message:

     

    How can we handle this kind of error? Should we eliminate the duplicates? Send to Controller?

    Edit: We uploaded only the lines with amounts and it was okay. Maybe have a note regarding this situation.

    Thank you.

  9. Niphitphon Thamcharoensathit

    Hello

    For a part of KP26 upload, I have followed below steps. However, 4) mention to input "1" in column D but not mention about what to be input in column F. I understand that it is mandatory to have figure in column F as well, otherwise, it will cause error when uploading.

    1. ROLLIER, Charlotte

      ok you are right, we must add a comment regarding column F, I will update the procedure

      1. GONCALO, Ana Catarina

        Hello ROLLIER, Charlotte. It seems that you didn't update it yet. Can me and Alves, Sofia update it?

  10. Cátia Carujo

    When perform the step 5 (I upload the Excel file into the system) be sure you click in the correct save button meaning SAP save button. Because if you click in Excel save button a error message will appear. 

    As you can see in the following print screen, the correct button is in blue.

    Thanks

     

     

  11. Cátia Carujo

    Hello,

    When we perform the step 5 (upload the activity hours with KP26) we realized that in step 4, when:

    3. Copy the hours (Normal capacity) in column C 

     a message with copy as values and round to "Enter the number in a valid format (3 decimal places)" would be mandatory. Otherwise, we will have the following error: 

     

    Thanks

    Carla Oliveira and Cátia Carujo