Uploading of Spare parts from Visual Design Stream Document
Context
To get familiar with SAP 3D Visual Enterprise Author tool. Please refer https://help.sap.com/viewer/8e4c65bb3a6c4ef6b56dc27d1d95cde6/9.0.0.4/en-US
To maintain spare part metadata according to the relevant product standards, please go through following steps:
Procedure
- Open SAP 3D Visual Enterprise Author.
- Open Metadata panel, refer to https://help.sap.com/viewer/67c291fba1bd10148bea8dce7b0caa3e/9.0.0.4/en-US/a46817d5f0874720bff566b9c7e68990.html

- Export the current metadata of VDS Viewer to maintain spare parts metadata according to product standards. Refer to https://help.sap.com/viewer/67c291fba1bd10148bea8dce7b0caa3e/9.0.0.4/en-US/0fd8ec37c0574419bb7a7487f5f47741.html
- Open excel and try to open the file, which you have just exported as .txt file.
On opening .txt file in excel following should be marked:
- Choose the Delimited file type that best describes your data and click Next.

- Set the Tab as the delimiters your data contains.

- Set the data format of each column to Text.

- Choose the Delimited file type that best describes your data and click Next.
- Please add following columns in the excel:
Column Name
Description
0
These are the unique Locator ID for each spare part of the VDS. This is already provided as part of the VE document.
VE Name
This is the Name of the spare part and is already provided as part of the VE document.
AIN / Manufacturer
It describes the manufacturer of the spare part and will also play vital role in mapping these spare part to any AIN object.
AIN / ManufacturerDescription
This describes any additional description about the Manufacturer of the spare part.
AIN / ManufacturerPartID
It describe the Part ID given by the manufacturer to the spare part. This will also play a vital role in mapping these to any AIN object.
AIN / EANNumber
It describes the standard bar code symbology and numbering system used in global trade to identify a specific spare part in VDS.
AIN / PartName
It describes any other part name given to the spare part
AIN / Quantity
It describes how many of these spare parts are used in a certain VDS.
AIN / UOM
It describes what will be the unit of measure for this spare part.
AIN / ShortDescription_XX
It describes the short description for spare parts. Here XX can be any valid language code.
Example: en, de
AIN / LongDescription_XX
It describes the long description for spare parts. Here XX can be any valid language code.
Example: en, de
- Import the excel created with SAP Asset Strategy and Performance Management specific data to the same VDS. Refer to https://help.sap.com/viewer/67c291fba1bd10148bea8dce7b0caa3e/9.0.0.4/en-US/3569c3003f0f443da3f702a2c25268ee.html
To validate if your metadata is successfully added to the VDS, click Select Metadata Keys To Show on Metadata menu panel and select the new columns and click OK.
