You are trying to paste a table using the Paste option in the Products facet inside a Sales Quote or a Sales Order.
SAP Cloud for Customer
Reproducing the Issue
- Go to the Sales work center.
Go to the Sales Quotes view.
Open sales quote 123 (where 123 is the sales quote ID).
Go to the Products facet.
Click on the Paste icon (highlighted in the first screenshot).
RESULT: You will see a line that says "Paste supported data, such as Excel..."
Make a table in excel which has the same columns order than the ones displayed in the system.
Copy the excel row where you maintained the products information.
Paste the information in the line "Paste supported data, such as Excel...".
RESULT: The data is not uploaded correctly. I.e., the price and the quantity do not have the same value.
You have to pass for each entry field in a column in the XLS.
Even if some fields (i.e. the Quantity) have one label, it has 2 entry fields: one for the quantity and one for the quantity unit. Hence, you need to create to different columns in your excel.
You need to maintain a field for each entry.
If user wants to pasting data during the creation of sales quote or sales order from Add Products option, the sequence and order is different, as shown below. Additionally, Product (Obsolete) is a read-only field, whereas Product is a compound field with an icon which should also be considered while pasting
In this case, user have to follow the sequence below, by leaving an empty cell for the icon as highlighted above, so that the data is filled correctly, without mismatch
sales quote, sales order, product, excel, copy, paste, quantity, pri , KBA , add products , paste , excel , LOD-CRM-PRO , Products , LOD-LE-CQP-CO , Lean Sales Orders , LOD-LE-CQP , Customer Quote Processing , How To