Populate supplier header DFF based on based on Site Procurement BU

Summary:

We have a requirement where we want to populate certain Values ('R', 'H' , 'C') in a Supplier header level DFF based on the Site Procurement BU. please find below the complete description. Kindly suggest how can we achive this requirement.

Example :

1. If the supplier has sites with Procurement BUs : BU1,BU2 then DFF value should be populated to 'R' after Onboarding.

2.Similarly If the supplier has sites with Procurement BUs : BU3,B4 then DFF value should be populated to 'H' after Onboarding

3.If supplier having DFF value 'H' extended to Sites with BU1 or BU2 then DFF value should be automatically changed to 'C'