Validation Criteria for CSV File-Based BOM Upload

This topic lists various fields supported in the BOM CSV file and the validation criteria for the BOM data.

For successful validation of the BOM data, the fields marked mandatory in the following table must be present in the CSV file and meet the validation criteria specified in the corresponding description column of the table. You can choose not to include the optional fields in the CSV file. However, if you include any of the optional field, ensure that the values meet the validation criteria as explained in the description field.

Field	Mandatory/ Optional	Description
Level	Mandatory	Enter an integer value to indicate the hierarchical position of an entry in BOM. The topmost level entry is level 1.
MaterialNumber	Mandatory	Enter a material number. If the material number does not have an entry in Ariba Sourcing, a new material will be added in Ariba Sourcing. The number of characters in the material number string should not exceed 60.
BOMNumber	Mandatory	Enter a unique string of not more than 40 characters to identify the BOM.
BOMCategory	Mandatory	Enter a two-character notation to indicate the BOM Category. Supported categories are material BOM and service BOM.
ValidFromDate	Mandatory	Enter a date in the YYYY-MM-DD format to indicate the valid-from date for the BOM.
ValidToDate	Mandatory	Enter a date, greater than the ValidFromDate, in the YYYY-MM-DD format to indicate the valid-to date for the BOM. To delete a BOM entry, enter a past date in this field.
PlantID	Mandatory	Enter at least one valid SAP Plant ID. Can contain more than one SAP Plant IDs as a comma-separated list. This field is applicable only at the header level.
ItemCategory	Mandatory	Enter the item category of the BOM component. Supported values are: D (Document item) \| I (PM structure element) \| K (Class item) \| L (Stock item) \| M (Intra material) \| N (Non-stock item) \| R (Variable-size item) \| T (Text item) Note To send `ItemCategory` values back to the SAP ERP system (such as values for items in event data or contract line items documents), the `ItemCategory` values must be in English.
AlternateBOMNumber	Optional	Enter a unique string of not more than five characters to assign a alternative BOM number for variant BOMs. If you leave this field blank, Ariba Sourcing adds the default value, 01, as the alternate BOM number.
TechnicalType	Optional	Enter a two-character string to identify the technical type of the BOM, such as variant BOM and multi BOM.
Usage	Optional	Enter a value of not more than two characters to indicate the BOM usage such as production, research and development, and so on. If you leave this field blank, Ariba Sourcing adds the default value, 01, as the alternate BOM number.
DeletedPlantId	Optional	Enter valid SAP Plant IDs (other than the ones entered in the PlantID column) that you want to delete from the BOM. You can enter more than one SAP Plant IDs associated with the BOM in a comma-separated list.
SupplierId	Optional	Enter the SAP vendor identifier for the suppliers that you want to associate with the material. The Supplier information should be present in Ariba Sourcing.
DeletedSupplierId	Optional	Enter SAP vendor identifiers for the suppliers that you want to delete from the BOM. If there are more than one suppliers, enter in a comma-separated list.
OwnerId	Optional	Enter the unique identifier of the owner you want to assign to a material. The owner ID must be present in Ariba Sourcing.
UOM	Optional	Enter a string of not more than three characters to indicate the unit of measure. The unit of measure value should be available in Ariba Sourcing.
Quantity	Optional	Enter an integer value to indicate the quantity of the material.
BOMGroup	Optional	Enter a string of not more than 40 characters to indicate BOM grouping. This isn’t currently supported in Ariba Sourcing and this field is a placeholder for future use.
BOMStatus	Optional	Enter a string to indicate the status of BOM. This isn’t currently supported in Ariba Sourcing and this field is a placeholder for future use.
BOMText	Optional	Enter the BOM text maintained in the BOM header as a string of not more than 40 characters. This is not currently supported in Ariba Sourcing and this field is a placeholder for future use.
AlternateBOMText	Optional	Enter the alternative BOM text maintained in the BOM header as a string of not more than 40 characters. This isn’t currently supported in Ariba Sourcing and this field is a placeholder for future use.
ItemGroup	Optional	Enter a string of not more than 40 characters to identify the alternative BOM group; you can use alternative BOM groups when there are several alternative components in an assembly.
ItemText1	Optional	Enter a string of not more than 40 characters as the item text for the BOM component. This isn’t currently supported in Ariba Sourcing and this field is a placeholder for future use.
ItemText2	Optional	Enter a string of not more than 40 characters as the item text for the BOM component. This isn’t currently supported in Ariba Sourcing and this field is a placeholder for future use.
ChangeNumber	Optional	Enter the change number for the BOM as string of not more than 12 characters. This isn’t currently supported in Ariba Sourcing and this field is a placeholder for future use.
MaterialName	Optional	Enter the name of the material as referenced in the BOM; can be a string of not more than 255 characters.
MaterialDescription	Optional	Enter a description for the material; can be a string of not more than 255 characters.
MaterialClassPath	Optional	Enter the class path of the material; can be a string of not more than 255 characters.
MaterialMaturityLevel	Optional	Enter the maturity level of the material; can be a string of not more than 255 characters.
MaterialStatus	Optional	Enter the status of the material; can be a string of not more than 255 characters.
MaterialProject	Optional	Enter the type of project associated with the material; can be a string of not more than 255 characters.
MaterialPartType	Optional	Enter the unique identifier for the part type of the material as given in Ariba Sourcing; can be a string of not more than 255 characters.
MaterialGroup	Optional	Enter the unique identifier for the material group as given in Ariba Sourcing; can be a string of not more than 255 characters.