Excel Import in the Master Items List
If the items list is available in Excel, you can also import it into FUTURA Engineering. For the import to be successful, the structure must conform to a defined scheme.
The following columns must be present in the Excel file or are then taken into account during the import:
Column | Description | field length |
service no. | service number of the service line | 18 |
Titles 1 to 4 | 4 columns, one per level of detail | 40 |
Line style |
| -- |
Short | Short text of the Items list element (title or service line) | 80 |
Long | Long text of the Items list element (title or service line) | 32.000 |
Unit | Unit of the service line | 4 |
We are happy to provide you with a corresponding Excel template for the import!
Structure of the items list in Excel
Note:
Units of measure used in the items list must be maintained in FUTURA Engineering and mapped with a corresponding SAP unit. Otherwise, the import is cancelled.
To import an Excel file, proceed as follows:
In the tree, select the position (red folder). Attention: The position must not contain any elements!
Click the Import/Export button > Import from Excel
Select the file in your Windows environment and start the import.
After successful import, the items list is displayed under the red folder.