cancel
Showing results for 
Search instead for 
Did you mean: 

KP26 Mass upload

shreekumar
Participant
0 Kudos

Hi Expert,

I am new to controlling. Our client wants to upload the price in KP26 in a mass mode. How to do this?

Please guide me

Regards,

Shreekumar

Accepted Solutions (1)

Accepted Solutions (1)

Paulo_Vitoriano
Active Contributor
0 Kudos

Hi Shreekumar,

In the KP26 menu you have an option for Excel upload.

Extras -» Excel Planning -» Upload...

The layout can be defined in Report Painter, please do the search for Excel planning.

Regards,

Paulo

shreekumar
Participant
0 Kudos

Hi Paulo,

Could you please guide me how to get the format for upload it in excel file?

Regards,

Shreekumar

Paulo_Vitoriano
Active Contributor

Hi,

You can do the search as I should not repeat something that was explained many times and is available in public access.

This is just one example:

https://answers.sap.com/questions/1952077/kp26-excel-upload-configuration.html

Regards,

shreekumar
Participant
0 Kudos

Hi Paulo,

I checked the above link as per your suggestion. But I found that due to client lock issue, I couldn't make any modification in KP34 tcode. Could you please suggest me another way to upload the price in mass?

Regards,

Shreekumar

Paulo_Vitoriano
Active Contributor
0 Kudos

Hi Sheekumar,

This is customizing to be done in Development system and to be transported like any customizing.

Anything else you can try? BW retraction from BPC will not be any easier. Any scripting tools like Winshuttle, I doubt it.

CATT scripts? Normally disabled on Production systems...

Regards,

Paulo

Answers (2)

Answers (2)

former_member198692
Active Contributor
0 Kudos

Hi Shreekumar,

You can also use t code LSMW for mass upload KP26.

Regards,

Prasad

former_member221103
Participant
0 Kudos

Hi Shreekumar,

Standard feature is available wherein data can be uploaded using Excel. First, you need to design the template in KP75/76/77.

kp75.jpg

The template can be uploaded using KP26 t.code as mentioned by Paulo