Vendor Master Management - How to make 'Corporate Group' field an autoupdat

[Former Member]

Vendor Master Management - How to make 'Corporate Group' field an automatically updated field

Frnz,

I am doing a Spend Analysis and thereby restructring some aspects of SAP and business processes. One of the intiatives is to leverage the 'Corporate Group' field in Vendor Master for getting the consolidated spend visibility at the corporate group level of vendors. So far this field wasn't been used to effect. I can update it manually, but the question remains is how do I do with the change management of the corporate group of large vendor base in the scenario of everhappening Mergers and Acquisitions. Are there any alternatives anybody can suggest ? (Like linking D&B numbers etc)

Thanks in advance for your suggestions..

[former_member205403]

Hi,

Please can you provide some more details like on what basis you want to automatically update Corporate group field.

This will help to check on the solution.

Regards,

Shiv

[Former Member]

Hi Shiv,

Let me elaborate the purpose of using this field. I want to have a consolidated spend visibility across a corporate group which has multiple vendor codes. Its difficult everytime to group the spends of these vendors manually especially when the number of vendors are too high. Also sometimes the names of vendor companies may not indicate that these are from same corporate group but in fact they could be. In order to have the reports generated on corporate groups, I must maintain this field in vendor master or a Z table. But the problem here is, it should be possible to update this field as and when there are any mergers or acquisitions at vendor side and the corporate group of a particular vendor gets changed due to this. So this has to be effected in vendor master or Z-table automatically. I do know that there are certain agencies like Dunn & Brad (DNB) which provide possibly the details on corporate group of a company but its not fully effective for Indian Vendors as its not mandatory on them to have DNB number & also its a disconnected process and I was looking to connect it seamlessly to Corporate Group field so that I need not bother to update these things manually everytime. I also wanted to explore various possibilities of doing this.

I hope I have spelled it out correctly.