Symptom
You are trying to paste some values in CSV format to Product item table of a document (e.g. Sales Order) using the Paste function, but only some values are showing up correctly in the new entry, while others are not showing up or showing up in the incorrect place.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Cloud For Customer
Reproducing the Issue
- On the Product table click on the Paste button.
- Paste the content on the available paste field that showed up.
- Press Enter.
Cause
Compound extension fields are counted as two on the data format.
Resolution
Besides the informed guidelines that fields must be separated by semicolons or tabs, it also important to notice that Compound fields are counted as two.
Compound fields are fields which are made of two other fields. On the example below we see two Compound fields: Price and Quantity.
Price is composed of a field for the value and one for the currency while Quantity is composed of one for the value and one for the unit of measure.
Because they are considered two fields, then on the data you paste you have to consider them as such.
So based on the above example instead of pasting 8 columns on CSV data (for the 8 fields displayed on the UI), it should be 10.
e.g. Line;ProductCategory;ProductID;ItemType;Description;Price(Value);Price(Currency);Quantity(Value);Quantity(UoM);NetPrice;
Keywords
Paste; CSV; Excel; C4C; Template; Product; Item; , KBA , AP-RC-UIF-FLX , Page Layout & Key User Configuration , How To