https://community.sap.com/t5/application-development-and-automation-discussions/update-preferred-vendor-oitm-cardcode-by-sql/m-p/421807#M11564 <P>I need to update Preferred Vendor on Item Master table which is OITM.[CardCode]. I try to use SQL update. It works and I can update OITM.[CardCode]. Will it have any side effect, if I change OITM.[CardCode] only? What is the best way to change it - by SQL or any other tools? I need to update thousands item which is saved in Excel file. It is too much to update it manually. Thanks</P> Thu, 23 Mar 2017 12:58:36 GMT Former Member 2017-03-23T12:58:36Z https://community.sap.com/t5/application-development-and-automation-discussions/update-preferred-vendor-oitm-cardcode-by-sql/m-p/421807#M11564 <P>I need to update Preferred Vendor on Item Master table which is OITM.[CardCode]. I try to use SQL update. It works and I can update OITM.[CardCode]. Will it have any side effect, if I change OITM.[CardCode] only? What is the best way to change it - by SQL or any other tools? I need to update thousands item which is saved in Excel file. It is too much to update it manually. Thanks</P> Thu, 23 Mar 2017 12:58:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/update-preferred-vendor-oitm-cardcode-by-sql/m-p/421807#M11564 Former Member 2017-03-23T12:58:36Z