Upload planning calendar periods from an excel file

18
Oct/090

Upload planning calendar periods from an excel file

Our users are supplying the updates to planning calendar (MD26 transaction) in an excel sheet. We have hundreds of these planning calendars that need to be updated on a regular basis.

Is there any function module or any other way to update planning calendar from excel sheet. I tried BDC. The period I extend are appearing in the recording.

The solution is:

You can use the Legacy System Migration Workbench (LSMW transaction) to record the MD26 transaction using the process you would follow manually. After saving the recording you can use a text input file to upload the calendar changes with your new recording. This is how I maintain adding / deleting / changing the planning calendars in our system today and it sure beats entering all that data by hand!