You have the requirement to mass change the Status of a Sales Organization from Active to Blocked for a Material. To do so, you use the Mass Data Maintenance or Migration Tool, however the system shows the error message below:
"Invalid value 'XYZ' in column 'Sales organization ID' detected" (XYZ means the Sales Organization ID).
SAP Business ByDesign 1805 and higher.
Currently this is the expected system behavior.
As a workaround, you can use the Mass Change of the Material view to update the status of the Sales Organization, by following the steps below:
Go to the Product Data work center.
- Then click on Material View.
- Select the Materials that you want to change (by holding Ctrl key and clicking on the Materials to select them).
- Then click on the Mass Change Button.
- Change to Show Sales in the query.
- Then set from Active to Blocked.
- Then save the changes.
Sales Organization, Material, Active, Blocked, Mass Change, Inactive Sales Organization. , KBA , AP-PRD-MAT , Material , Problem