Solution : https://service.sap.com/sap/support/notes/359868 (SAP Service marketplace login required)
Summary :
SAP Note addresses an issue in CO Planning Processor where Excel upload fails to exclude non-input ready data columns from uploads, despite these being statically set as non-editable in planning layouts. This inadvertently includes certain standard columns with attributes (e.g., distribution key, units) in uploads. The correction ensures these columns are ignored during file generation and subsequent uploads. Additionally, challenges with complex lead columns and planning layouts containing formulas (sheet formulas) are highlighted as unsupported in current infrastructure. Post-correction actions include deleting outdated file descriptions via report RKCDPREO or function module KCD_EXCEL_SHEET_DESCR_DELETE to maintain data integrity.
Key words :
additional key words excel upload, execute function module kcd_excel_sheet_descr_delete, statistical key figure planning, delete individual file descriptions, long text indicator, -called sheet formulas, memo record entry, contian formulas defined, planner profile items, attached advance corrections
Related Notes :
| 701390 | Planning with Excel integration: different errors |
| 328356 | Excel upload: attributes w/out ref to data column |
| 319713 | Error with Excel upload - possible causes |