SAP Knowledge Base Article - Public

2888689 - 'Item ABC has both assignments and items; children not imported' Error Message Importing Financial Reporting Structure from Microsoft Excel


Error message is thrown upon importing a financial reporting structure from Microsoft Excel:

'Item ABC has both assignments and items; children not imported'

ABC means the financial reporting structure item.


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Search and open the activity Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Click Edit financial reporting structures.
  5. Select the structure you want to update by importing an updated version from Excel.
  6. Click Import from Microsoft Excel.
  7. Browse for the xml file.
  8. Click OK.
  9. Error message is thrown:

'Item ABC has both assignments and items; children not imported'


As per the design of financial reporting structure hierarchy, assignments and items together can't be allowed under one item.

For example, in the respective xml file, Item node contain Item 'Assets' and 'XYZ' (Accounts Assignment) in same hierarchy. Due to that, system didn't allow the import.


The item 'XYZ' should be put under proper node, and then, the Import from Microsoft Excel function should be executed again.


financial reporting structure; import from Microsoft Excel; item; node; itemtype; assignmenttype; account , KBA , import from microsoft excel , financial reporting structure , assignmenttype , itemtype , item , node , account , SRD-FIN-GL , General Ledger , How To


SAP Business ByDesign all versions