SAP Knowledge Base Article - Public

1850300 - Migration of Additional Part Numbers for Existing Materials

Symptom

The approach to be taken while migrating additional part numbers for existing materials.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Configuration work center.
  2. Go to Overview.
  3. Show Activities and Find Migration of Materials.
  4. Select the Change Immediately button.
  5. Select the hyperlink Migrate materials using the Migration tool.

Resolution

As to your query of being able to upload additional part numbers for materials, you only need to specify the additional part numbers in the template. The system will only append the new part numbers to the list of existing ones, existing parts remain.

The Customer Part Numbers and Supplier Part Numbers sheets are hidden in the migration template. You can un-hide them and feed the new part numbers corresponding to the respective material IDs. To un-hide them, right-click title of any visible sheet and select the Unhide option. In the subsequent window, select the aforementioned sheets.

While Migrating, please see to that the option to Enhance already existing records is selected.
This can be done through the following steps:

  1. In the Migration tool, select the file you are trying to migrate.
  2. Select Properties button.
  3. Select Advanced option.
  4. You will see an option to choose the Migration Mode.
  5. In the drop down choose Enhance already existing records.

Note: It is not possible to delete Supplier Part Number in bulk after import. You can only delete it manually following below mentioned steps:

  1. Go to Product Data work center
  2. Select Materials view
  3. Select Edit button and select View All
  4. Select Purchasing subtab
  5. Select Supplier Part Number
  6. Select the required row
  7. Select Remove

In case the requirement is to update an existing Supplier Part Number, that is only possible through web service. In the below link, you can find the documentation for the Material web service API:

https://help.sap.com/doc/a2b4c7ef61d64397b2b1d052082a8a08/2011/en-US/PSM_ISI_R_II_MANAGE_MATERIAL_IN.html

See Also

https://help.sap.com/doc/a2b4c7ef61d64397b2b1d052082a8a08/2011/en-US/PSM_ISI_R_II_MANAGE_MATERIAL_IN.html

Keywords

Supplier part number , delete , update , enhance , migration, webservice , KBA , enhance part numbers , materials , additional part numbers , AP-PRD-MAT , Material , How To

Product

SAP Business ByDesign all versions