SAP Knowledge Base Article - Public

2543149 - Not All Standard Fields Can Be Added To Excel Import Template

Symptom

You are trying to add standard fields to your Excel Import template but do not succeed.

Environment

Sap Sales Cloud

Reproducing the Issue

This may occur for several different objects, in our example we look at Leads.

  1. Go to the Sales work center.
  2. Go to the Leads view.
  3. On the right top side from the action wheel select Import from Microsoft Excel.
  4. Select the language of your choice and click Download.
  5. In the Excel Addin, attempt to add new columns of standard fields, examples: Contact Permission or Item/Product.
  6. While it first appears that the columns got added, you then receive an error and cannot save.

Cause

Only fields that belong to the Business Object root node are supported.

In the example with Lead, this is not support by Excel-import because Item does not belong to the Root node of Lead but to Products.

Resolution

This is current expected system behaviour.

Keywords

KBA , LOD-CRM-LM , Lead Management , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions