Complex Pricing

[former_member301027]

Dear Gurus,

I have the following prcing scenario in Crude oil sale.

Crude oil price change on weekly basis, so user will create record accordingly.

Suppose Condition type PR00 record is as follow.

01.05.2010 to 08.05.2010 PR00 $ 120

09.05.2010 to 16.05.2010 PR00 $ 130

17.05.2010 to 24.05.2010 PR00 $ 150

25.05.2010 to 31.05.2010 PR00 $ 200

Quantity contract is once created for the whole month lets say 01.05.2010 to 31.05.2010 of xyz quantity.

Creating first sales order on 02.05.2010, system call the respective price at order than create deliveryand PGI.

Creating sec. sales order on 12.05.2010, system call the respective price at order than create deliveryand PGI.

Creating third sales order on 20.05.2010, system call the respective price at order than create deliveryand PGI.

Client following POD practice, and wants that price should applicale in the system on which user receive the delivery challan, on that user put DATE stamp and confirm the quantity, same document client use as POD.

Now in POD client input the POD date what is written on Delivery Challan from customer.

Now requirement is this system calculate the price on the basis of POD date, I can do this by input the pricing date at the time of invoicing VF01 pricing date. but there is collective invoice, each delivery suppose to belong different pricing.

Can any guru have any workaround or standard solution.

If have any query please feel free to ask.

[former_member301027]

In Progress.

Regards,

[Former Member]

Hi,

In SAP you handle the type of cenario that you have menioned through Commodity Pricing Engine (CPE : http://help.sap.com/saphelp_erp60_sp/helpdata/en/de/7a8534c960a134e10000009b38f83b/frameset.htm). Look at this link I belive it will give you some concept. By using the CPE logic you can build your pricing schema like this:

YPOD (Price baed on POD) - Create an alternate calculation which will scan the Pricing table & fetch the price based on the POD date.

Prerequisite:

You can make the system uderstand to pick the POD date as the pricing date in the folowing way -

Create a condition sa YDAT (Date determination condition) - You need to use the structure KOMPAZD. When maintaining a condition table, you can choose a field from the key in the Technical Settings field. It is then designated as a data field and is automatically indicated with C in the access in Customizing for access sequences. KOMPAZD already has the field Price List, so you can use this field to make the system understand that pick the POD date. Once the price list i.e. priing date is eermned then you can retrieve the price in the above mentioned condition type i.e. YPOD through the alternate calculation routine.

[former_member301027]

Dear,

Thanks for the reply.

Can you pls elaborate what is KOMPAZD detail, what condition table i will actually use, did I used condition table of Price list... where I will fix it i nbetween pricing procedure.

Your response will be highly appreciated.

Regards,

[Former Member]

Data determination requires a structure in which the data determined can be stored and accessed from pricing. Communication structure KOMPAZD is provided for this purpose.

Data determination in the access for pricing takes place at field level. A field is selected for this. It is used for data determination, not pricing. When maintaining a condition table, you can choose a field from the key in the Technical Settings field. It is then designated as a data field and is automatically indicated with C in the access in Customizing for access sequences. This is only possible when it is created.

By doing the above steps you can determine which pricing date the system should consider i.e. POD date through the Price List.

Please go through the link which I sent you in my last post which will give you a good idea about what I am talking about.

[Former Member]

Hi,

Create condition record in vk11 in that will find valid periods u create records one by one like u create condition record for first condition save it latter you create for second one with different valid periods so that it will work.

Regards,

Suresh

[former_member301027]

Dear Suresh,

done the same, tell me if create 2 delivery with different price or price date. than at the time of POD get to know the i am suppose to take the price in both delivery of first week or common price, what control u will have for this..

or u have 3 delivery for collectiv einvoice at the time of POD u get will apply 3 pricing date rates on three delivery, what can u will do.

Regards,