SAP Note 359868 - Excel upload: columns not ready for input in layout

Component : Controlling -

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 :

701390Planning with Excel integration: different errors
328356Excel upload: attributes w/out ref to data column
319713Error with Excel upload - possible causes