Profit Center Planning - 7KEX

[Former Member]

Hi,

By using T. Code 7KEX we are uploading planed profit center value.

In order to do this we have define a specific planner profile and dedicated planner layout.

T. Code: 7KEA - Maintain Planning Layout for Costs/Revenues

T. Code: KP34PC - Maintain Planner Profiles

With this customizing setting into the system it is possible to upload data with the excel input.

Excel input as per the layout contain following:

Key characteristics in general data selection include

Fiscal Year

Period

Company Code

Version

Column include following characteristics:

Account

Profit Center

Amount

The problem with this approach is that this file format doesn't allow profit center planning at period level (Different amount for every month) by using single input file. This means that, in order to be able to upload the detailed budget per month, it will be necessary to create 12 different upload files (one for each month).

Is there any other way of layout setting (T. Code. 7KEA) or workaround to enable upload month wise (Different amount for every month) profit center planning amount by using single input file?

Thanks in advance!

Best Regards,

Kunjapal

[ajaycwa1981 · Accepted solution]

Hi Kunjapal

You need to create 12 files - One for each month

Then choose radio button "Import File Directory" in 7KEX and give the path of the folder.. It should upload all the files one by one

Else, create an LSMW for 7KE1 and upload all periods in one go with single excel file

Regards

Ajay M

[Former Member · Accepted solution]

Hi Ajay,

Thank you very much for you input. We had already kept LSMW as a secondary option.

To upload using 7KEX we need to create 12 files - one for each month. Requirement is to upload using single file for all period in 7KEX.

Is it possible to upload using single file for all period (Each month has different value) in 7KEX, If possible then what is the changes need to be done ? Thanks so much for your cooperation !

Regards,

Kunjapal

[ajaycwa1981 · Accepted solution]

HI Kunjapal

If I remember well, you can not upload for 12 months using one single file if you are using excel upload.... The same logic applies to KP06 also where 12 files are created for 12 months and the folder can be uploaded in one shot..

If you want to have upload via one single file, then you have to use LSMW... Recording LSMW is not painful and its once a lifetime effort

Regards

Ajay M

[Former Member · Accepted solution]

Hi Ajay,

I appreciate for your suggestion. Let us wait for other suggestions also before we closed.

Regarsd,

Kunjapal