You have a requirement to upload new Materials along with Tariff ID or update the Tariff ID for the existing Materials. But Material Tariff ID option is not available in the Microsoft Excel upload template.
Reproducing the Issue
- Go to Product Data work center.
- Select Materials view.
- Select New button and choose New Material from Microsoft Excel.
- In the excel there is no options to update Material Tariff IDs.
This feature is not available in the current release of SAP Business ByDesign.
This is a new requirement and requires some considerable effort. Adding Tariff ID also requires extra fields to be added in the excel for the write back save to work.
We have already included this requirement in the next higher release of Business bydesign.
In the meantime, you may consider updating the Material Tariff ID using Mass Change functionality.
KBA , SRD-CC , Cross Components , How To