Solution : https://service.sap.com/sap/support/notes/499152 (SAP Service marketplace login required)
Summary :
SAP Note 499152 facilitates the use of Integrated Excel for manual planning in overhead cost planning scenarios, replacing the default SAP table control. When setting up, activate the necessary indicator via Transaction KP34 in planner profile maintenance; this allows Excel usage within system boundaries. Key considerations: ensure Excel’s security settings allow macro execution from SAP, be aware of specific functionality limits like period screens and cell deactivation, and format Excel sheets in adherence with SAP field assignments. Detailed adjustments and data integrity checks are crucial to maintaining accurate system transactions and display consistency.
Key words :
menu option 'settings -> lead columns', excel warning messages occur, normal table control, usual input table, create blank rows, sample master data, normal planning table, entire planning area, generated excel sheets, position individual cells
Related Notes :
| 1380918 | Excel planning: Problems with transport of Excel templates |
| 489867 | KP06 and following: Setting up an Excel upload |
| 426877 | KP06ff: Error message SOFFICEINTEGRATION 230 |
| 416387 | KP06: Message K8038 with Excel layout |