Skip to Content

Mass upload of spare parts is a function within the SAP Asset Intelligence Network application where users can create multiple spare parts at a time.

A predefined CSV template needs to be downloaded from the application and after providing all the details of spare parts in this CSV, the user uploads the same in the SAP AIN application. The spare parts details are stored in SAP AIN, after successful upload of the CSV.

This blog provides step-to-step details of the mass upload of spare parts with all field descriptions and validations.

Download CSV Template

  1. Log on to the SAP Asset Intelligence Network solution
  2. Choose the AIN Applications à Spare Parts
  3. On the Spare Part List page choose the New button
  4. The Mass Upload of Spare Parts dialog box appears with fields Download Template and Upload Template.
  5. To get the CSV template of spare parts upload, click on the link displayed in the Download Template field.

Field Descriptions

The first row indicates all the downloaded CSV fields. It is recommended for users not to make any changes in the first row. If there is any change, you will not be allowed to upload it.

The below table provides the field descriptions:

Field Name Description Value Type Mandatory Size
manufacturerPartNumber Spare part number provided by the manufacturer Text Yes 255
manufacturer Name of the manufacturer spare part Enumeration Yes 40
eannumber Should be unique across the client Text No 32
Uom Unit of measure Enumeration Yes 50
sizeDimensions Description of size or dimension of spare part Text No 32
grossWeight Gross weight of spare part Number No 10
netWeight Net weight of spare part Number No 10
weightUnit Unit of grossWeight and netWeight Enumeration No 15
Volume Volume of the spare part Number No 10
volumeUnit Unit of volume Enumeration No 15
Length Length of spare part Number No 10
Width Width of spare part Number No 10
Height Height of spare part Number No 10
unitOfLengthWidthHeight Unit of Length Width and Height Enumeration No 15
Quality Quality Text No 40
Contract Contract of spare part with customer Text No 100
Standard Spare part standards Enumeration No 100
sparepartDescription Short description Text Yes 40
longDescription Detailed description Text No 5000
sparepartID Unique name across client Text Yes 40
Subclass Subclass from spare part is inherited Enumeration No 255
dimension Dimension Enumeration No 50
originalManufacturer Original manufacturer name Enumeration No 255
originalManufacturerPartNumber Spare part number provided by the original manufacturer Text No 40
deliveryTime Delivery Time Number No 10
deliveryTimeUnit Unit delivery time Enumeration No 15
shelfLifeDuration Shelf Life Duration Number No 10
shelfLifeDurationUnit Unit shelf Life Duration Enumeration No 15
isHazardous If the spare part is hazardous Number No 40

Validations

Mandatory Field Validation

The mandatory fields cannot be empty in CSV. If the mandatory fields are empty, the system throws up an error message.

For example, if no values are provided in manufacturerPartNumber field, an error message “Manufacturer part number cannot be empty’ is displayed. See the table above to know which fields are mandatory.

Uniqueness Validation

Spare parts should be unique across the client. Uniqueness is determined by sparepartID, eanNumber and combination of manufacturerPartNumber and manufacturer. If any spare part exists in the system with these values, the system throws up an error message.

For example, if provided sparepartID already exists in system, the error message ‘The spare part ID < sparepartID > entered already exists” is displayed.

An error message is also displayed if multiple rows exist in CSV with duplicate values in these columns.

Enumeration Field Validation

The value provided in enumeration fields should exist in the system. The system displays an error message for an invalid entry. All the fields which contain enumeration value are mentioned in the field description table.

For example, if you provide an invalid uom, then an error message ‘The UOMs <value in uom field> are not valid’ is displayed.

Information on getting valid enumeration value is described later part of this document.

Unit and Unit Field Value Validation

If you provide any value for unit fields like volume or height, it is mandatory that you also provide the unit for those fields.

For example, if you provide volume without the volume unit, an error message ‘You must specify the unit for the volume’ is displayed.

Number Format Validation

For any field with number type, provide a valid positive number

For example, if you provide an invalid number in volume filed, an error message ‘Please provide a valid positive number for volume’ is displayed.

Field Size Validation

The length of value should not exceed the limit mentioned in field description.

For example, if the value in the volume field exceeds 10, an error message ‘Size of the volume should not exceed 10’ is displayed.

Enumeration Field Value

There is one public API exposed to get all valid enumeration values.

Run the below API for the respective account to get all enumeration field values: https://<account>.int.sap.hana.ondemand.com/ain/services/api/v1/parts/enumerations.

For uom the service will provide data as shown below. You provide the value of the code in uom field in CSV. And, the service then provides valid data of all enumeration fields.

Upload the CSV File

  1. Choose the AIN Applications à Spare Parts
  2. On the Spare Part List page choose the New button
  3. Choose Mass Upload of Spare Parts
  4. The Mass Upload of Spare Parts dialog box appears with fields Download Template and Upload Template.
  5. To upload the CSV, choose Browse in Upload Template section and select the prepared CSV that contains all valid data.

The CSV with all valid data, passing all validations, will uploaded to SAP AIN.

Conclusion

You have successfully completed the mass upload of spare parts.

 

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply