Material Group wise Proforma Split

Dear All,

Issue is regarding the Material Group wise Proforma Split (proforma invoice is w.r.t Sales Order).

Here we have 2 different City Discounts 15% & 30% respectively on material group wise.

However, suggestion was given to create Condition Type at Item level, with Access Sequence as Material Group / Material / Plant etc., and maintain condition record accordingly.

Then through Routine in Copy Control in [VTFA] (Sales Document to Billing Document).

The concern is, whether the solution provided will suffice the requirement????

If any other method to arrive will be of great help.

Thanks n regards,

Vijayashree