SAP Knowledge Base Article - Public

2823451 - How to import more than 200 items in WBS hierarchy (S/4 HANA Cloud)

Symptom

Application: Manage Global Accounting Hierarchies (App ID: F2918)

 

During change the file which is exported from Global Accounting Hierarchies the following happens:

1. Messages pop up: "Protect Workbook" / "The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet..."

2. Some cells cannot be modified

3. Not possible to add more than 200 items

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP S/4HANA Cloud

Cause

During change the file which is exported from Global Accounting Hierarchies message pops up because the file is protected.

Resolution

After the unprotection of the template file, more than 200 WBS can be imported.

Template excel - Protection

Template excel - Error

Attention!

Please do not split the file, because the newly imported file will update the WHOLE hierarchy.

Keywords

WBS, gah, global accounting hierarchy, S/4, HANA, S/4HANA, cloud, F2918, Manage Global Accounting Hierarchies , KBA , FI-FIO-GL-MD , Master Data Apps , FI-FIO-GL-MD-2CL , Master Data Apps (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions