group (statistical) condition
we have the following requirement in SD pricing.
Prices and rebates on item level depend on a so-called "module value". This module value has to be determined for the whole SD order. This means that every item has a specific module value. The sum of all item is the module value for the whole order which determines the prices and rebates of each item.
E.g.: SD order:
item 100 Material 4711 Module value: 0,5
item 200 Material 4712 Module value: 0,6
total value for the order: 1,1
Price for item 100: when total value for the order >1: 100 USD
Price for item 100: when total value for the order <1: 200 USD
Price for item 200: when total value for the order >1: 50 USD
Price for item 200: when total value for the order <1: 75 USD
So the question how to determine the total module value. We thought about a statistical group condition with a group condition key to collect the module value of each item. The problem that in SD standard there is no appropiate scale basis as all end up in value or quantity.
May be some of you have faced a similiar requirement.
Any help is highly appreciated!
Thanks and best regards,