SAP Note 489867 - KP06 and following: Setting up an Excel upload

Component : Planning - Planning

Solution : https://service.sap.com/sap/support/notes/489867 (SAP Service marketplace login required)

Summary :
SAP users who want to utilize flexible Excel uploads in Overhead Cost Controlling (CO-OM) can follow specific instructions due to insufficient online documentation. Real Excel files (.XLS) cannot directly be uploaded; instead, they should be saved in "Text (Tab delimited)" format (.TXT). The process includes creating a planning layout without formulas and with minimal leading or unnecessary columns to optimize performance. Integrating the layout into a planner profile, defining layouts for controlling, and setting up default parameters without totals rows are essential steps. Lastly, after all settings on the SAP planner profile (Transaction KP34) are configured, ensure the Excel file structure remains unchanged to guarantee correct data mapping during uploads.

Key words :
load real excel files, excel upload                        totals rows, error messages preventing, move functions contained, error message k9363, mere display columns, -digit technical abbreviation, file -> save copy, system-side support, system automatically finds

Related Notes :

499152KP06 and following: Setting up Excel Inplace
319713Error with Excel upload - possible causes