to give price as per sales orders

[former_member371992]

Hi Experts!

   I got a scnario where we have to give price(pr00) as per sales orders.....

Eg: sales orders            Price

       01-99                    500

       100-199                1000

       200-299                1500

       300 +                    2000

Here the system should pick up the price as per the sales order.....like for sales orders 01-99 it should propose price as 500  and from sales orders 100-199 it should propose price 1000....like that...

Is this possible in standard sap or not...

Pls do the needful..

Regards

Bala.

[former_member184771]

Dear Bala,

Try with condition Update function in VK11.

Thanks,

Sumeet Sah

[former_member371992]

Hi!

   Condition update works only for first 3 orders only.....

Regards

Bala.

[Former Member]

simply go for different Sales order type with specific number ranges & maintain price accordingly based on the document type. This requirement is unusal & may not give consistent results. hence to be safer, play with the standard approach.

Order type	number range	Price based on order type
ZA	01- 99	500
ZB	100-199	1000
ZC	200-299	1500
ZD	300-399	2000

[od_manikandan]

Dear Mr Bala,

Can u please explain practical scenario for the price related to sales order.

R u trying to explain sales order means customer order qty ? or number of order given by customers.

Regards,

Mani

[former_member371992]

Hi Mani!

   I am clarifying once again....its not the quantity in the sales order.....my requirement is whatever may be the quantity in the sales order.....system should pick the price based on sales order number...i.e...for fist 99 sales orders one price...and for sales orders 100 the price is different...like this....hope you got it...

Regards

Bala.

[former_member182378]

bala,

Eg: sales orders            Price
       01-99                    500
       100-199                1000
       200-299                1500
       300 +                    2000

All sales orders with numbers (VBELN) from 1 to 99 shall have price = 500.

Does that mean all the orders shall be created with the same material?

Suppose sales order no. 65 is created a material and sales order no. 54 is created a different material, then should be price in both these orders = 500?

Please explain.

[former_member371992]

Hi!

   Lets take that we are having only one material but price should pick differently for sales orders as per the sacles i mentioned...hope you got it..

Regards

Bala.

[former_member182378]

bala,

This requirement can not be achieved by standard. You would have to go for some coding.

In your pricing procedure, for the price condition type, in field AlCal Typ, create a new routine which has a custom table with fields Sales order number range, Price (if needed put more fields).

The system shall calculate the value of price condition type based on the Sales order number.

Take the help of an ABAPer -

- To create the routine, coding for the same

- Custom table

- The logic in pricing userexit, to extract the Sales order number (VBAK-VBELN), for ascertaining the price.

[former_member186385]

Hi,

Try with condition index and condition update in the pricing condition type

If you check those two fields, you can see MAX NUMBER OF ORDERS field populated in VK11 at ADDITIONAL DATA (F7)

here you can maintain the value so this price can be effected till such number of orders

hope it is clear

regards,

santosh

[Former Member]

Hi Santosh ,

But here we can maintain mas 1 to  3 numbers . not more than that.

then how come we will match to 0-99, 100-199.. like this.

Regards

Pitabash

[former_member182575]

Maybe to something like this and see if it works:-

Eg: sales orders            Price

       01-99                    500                    ZR00

       100-199                1000                  ZR01

       200-299                1500                  ZR02

       300 +                    2000                  ZR03

And the use the exclusion function to control the best price.  Another way would be to code a routine that did the above calculation for you and then put the value in XKWERT.

Regards

Waza

[Former Member]

Hi,

This is not possible in standard SAP . whereas standard it is allowed only to 3 no's of orders.

So here you need to do some enhancements with help of user exit or routines.

Regards

Pitabash