IBP: Price and ABC Segemntation

[OliverA41]

Hello,

I have an ABC Segmentation on customer level. Furthermore, I have also in my masterdata type prodcut custtomer two attributes called price1 and price2.

The result of the abc segmentation should be the reason, which price the customer-product combination should have..

For example.

Customer 1 is an A customer therefore customer 1 and product 1 have the price1

Customer 2 is an B customer therefor customer 2 and product2 have the price 2

How can I assign in a planning view the correct price to the product-customer combination.

Can I use a If - Condition

Regards

Oliver

[piyush_parekh]

Hi Oliver,

If I understood the question correctly, you want system to consider price1 if ABC ID in customer MDT is A and price 2 if ABC ID is B. You can define a calculation definition as below :

Final Price@PERPRODCUST = IF("ABCID" = ' 'A' ', "price1@PERPRODCUST", IF("ABCID" = ' 'B' ', "price2@PERPRODCUST", 0))

You can define as many nested loop as required. Price attributes added in customer product MDT has to be attribute as a key figure (type : decimal). Also, make sure you have added ABC ID attribute in the PERPRODCUST planning level.

Regards,

Piyush

[OliverA41]

Hi Piyush,

thanks for the response. Your answer was helpful.

Regards

Oliver