Bulk prices in SAP IBP DEMAND

[OliverA41]

Hello,

I have a question, if it is possible, that we can work with bulk prices. That means, the the price per product will be lower if the customer ordered more products?

Regards

Oliver

[former_member367912 · Accepted solution]

Hi Oliver,

Try this

Assuming you have following slab for the Price

1- 500 = $10

501- 1000 = $8

>1000 = $7

Customer OrderCO@WKPRODCUST

Variable PriceVP@WKPRODCUST (Stored and Calculated Both)

VP@request = VP@WKPRODCUST (Only Input)

VP@WKPRODCUST = IF( (CO@WKPRODCUST >=1 AND CO@WKPRODCUST <= 500),10, If( (CO@WKPRODCUST >500 AND CO@WKPRODCUST <= 1000),8), 7)

Customer Revenue : CR@WKPRODCUST

CR@WKPRODCUST = CO@WKPRODCUST * VP@WKPRODCUST

If you don't want to hard code price then you use Attribute as KF for Price and in the If condition based on the slab multiple that KF with some discount factor. for eg

VP@WKPRODCUST = IF( (CO@WKPRODCUST >=1 AND CO@WKPRODCUST <= 500),"price * .9"), If( (CO@WKPRODCUST >500 AND CO@WKPRODCUST <= 1000),"price * .8 "), "price*.7")

Regards,

Akhilesh

[OliverA41]

Hi together,

thansk for the response.

@ Akhilesh

I will try it. the bulk price are customer dependent. For that reason, my idea is to create some attributes as kf for customer.

customer .price1

customer.price2

customer. price3

.....

With this, I can uplaod from the source (S4) different price values in this new price attributes. with the if calculation, i can snap to the correct attribute based on the quantity

if quantity = 50 than customer.price1

if quantity = 102 than customer.price2

And so on

Regards

Oliver

[lingaiahvanam]

Hi Oliver,

I would suggest creating an attribute as a key figure its best option and performance also good.

Create an attribute as a key figure BULKPRICE@PERPRODCUST and write logic based on your requirement.

Best Regards,

Lingaiah

[OliverA41]

Hi Ivan, hi Lingaiah

@ Ivan

I will do that. I think, that will be a nice features.

@ Lingaiah

This was also my approach to implementing this with a customer KF.
But I think it would be better to create an attribute as KF, which takes into account the "Lotsize of Order"
But I do not know how to build the IF condition
If 1-100 then 30 €
If 101 -200 then 50 €
Can I use "Select Case Instructions" in the calculations?

Thanks in advance

Oliver

[former_member194529]

Dear Oliver,

As Lingaiah mentioned, this requirement is not fulfilled by the standard functionality.

Despite the workaround provided by him, you may considering sending an Improvement request to the IBP Product Management team: https://launchpad.support.sap.com/#/notes/2479068

Best,

Ivan

[lingaiahvanam]

Hi,

This requirement will not fulfill by standard process.

You have to create custom key figures (Bulk price) and based on customer order price to be defined.

Customer order - 1 to 100 PC Bulk price for each piece is 10 USD

Customer order - 101 to 1000 PC Bulk price for each piece is 8 USD

Best Regards,

Lingaiah