SAP Knowledge Base Article - Public

2512410 - Sequence of Products in BoM in Exported Excel File is Different from the Sequence in UI

Symptom

You exported the structure of BoM in material cost estimation to excel file. But the sequence of products in BoM in exported excel is different from what you see in UI.

Reproducing the Issue

  1. Go to Inventory Valuation work center and view Material Cost Estimate.
  2. Find product XYZ (XYZ stands for product ID).
  3. Select Edit, and you get the structure of input products with multi-level structure.
  4. Select Export to export the structure to excel. You found the sequence of input products in excel differs from the sequence in UI.

Cause

While creating the hierarchy of material cost estimate for exporting into excel, system fills the node that has sub nodes first then the other nodes. Hence the material with sub node appears first then the other nodes.

Resolution

This is the designed system behavior.

Keywords

KBA , LOD-CRM-EMP , Employee , How To

Product

SAP Business ByDesign all versions