Skip to Content
avatar image
Former Member

Excel upload functionality in CJR2 transaction for the overview screen.

Hi

At present, I am able to do upload the cost planning template via Excel Planning functionality in CJR2 transaction for the overview screen.

There are two screens once CJR2 is executed.

1. Overview screen

2. Period screen

Can u please help me on how to upload the cost planning data in Period Screen format instead Overview Screen for cost element planning in layout 1 - 701.

Regards,

Basavaraj T.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 12, 2008 at 10:05 AM

    You need to create your own layout for that. Something like below

    WBS Element Cost Element Plan P1 Plan P2 Plan P3 Plan P4 Plan P5 Plan P6 Plan P7 Plan P8 Plan P9 Plan P10 Plan P11 Plan P12

    (All fields P1- P12 for each period in different columns)

    Use the Characteristic 'Period' and in the field 'From' use 1-12 for each column.

    For creating layout, please refer the link below:

    WBS- Integrated Excel Planning

    Regards

    Sreenivas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I'm uploading excel file through CJR2 transaction and i'm reffering the link that you gave in your post

      WBS- Integrated Excel Planning

      in this link i'm facing the problem in step "layout for controlling" in KP34 T-code in the field description.as it is giving the error that file description does not exist.could you please resove my problem.

      Alse in the T-code CJR2 when i'm uploading the excel file .It is giving me error as file description does not exist.

      Please resolve my problem.

  • avatar image
    Former Member
    Nov 11, 2009 at 06:46 PM

    Hi to all,

    I built the file in Excel format, but when i try to upload i always obtain the same error:

    """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

    Value 000 in field "Period" is less than 1

    Message no. K9019

    Diagnosis

    In either the initial transaction screen or within layout definition, value 000 was entered for characteristic Period.

    However, the smallest valid entry is 1.

    System Response

    The entry in the initial screen/layout definition is rejected.

    Procedure

    Change value 000 for characteristic Period appropriately.

    """"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

    The thing is that i do not know how i can solve this issue, since the period is filled in in the excel.

    In order to build the report i used the following manual, but it does not work for my example.

    Does anyone know anything concerning this issue?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      I am receiving exaclty the same message when I am trying to upload plan data in Cost Center Accounting. So please, if you have found the aswer to this question share it with us.

      Surprisingly, in my case the upload is working perfeclty when I am using my own laptop (sapgui 7.10, excel 2007). But when I am trying to execute the upload from a customer workplace (again sapgui 7.10, excel 2007) I am always receiving the error message you are describing.

      Any ideas, regarding sapgui and excel settings?