SAP Knowledge Base Article - Public

3030952 - Copy/Past from MS Excel file to Opportunity or Lead not working.


You are trying to insert information of Products tab in the opportunity or  Lead entity, however, when using the paste information from MS Excel in the Products table, the values in the column 'Requested Quantity from Dealer' are not filled.


 SAP Cloud for Sale

Reproducing the Issue

  1. Go to the Sales Work center.
  2. Go to the Opportunity or Leads view.
  3. Open any Opportunity Lead and go to Products facet.
  4. Click Edit button in the opportunity or Lead header.
  5. Click Paste button.
  6. Copy data from MS Excel file.
  7. Paste the data into the table.


You will see that some fields are not filled, they remain blank or field with value 0.00.



This is not supported due to a cross Business Object association.

Cross Business Object association mean that you are copying  value from Product to Opportunity witch they are two different BO. Copy/Past is not supported.


 This is the system behavior.


Opportunity, Lead, Excel, Copy, Past, Product, Blank, Value , KBA , LOD-CRM-OPP , Opportunity Management , AP-RC-UIF , C4C UI Framework , Problem


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