How to handle Gold portion in SD/Condition..?

[Former Member]

Hi Folks,

We want to put a gold surcharge on every material which is been sold.

The gold surcharge value should be the official daily gold rate.

So the question is how to handle this.

First of all every material has a certain gold portion, for example 10 G.

Where can we put the gold portion for a certain material?

Where can we maintain the daily gold rate?

Finally we want the system to calculate the rate multiplied with the gold portion and

put the value into SD document, while creating a sales order?

Any suggestions how to obtain this?

Thx

Dieter

[former_member183879]

Hi,

The floating gold rate should actually be taken from some external source dynamically. The same concept is used in FI to take the exchange rate on daily basis especially on forex trading/exim markets etc.

Hence, you should take the floating gold rate (say per gram) from some program through an external interface (You have to devise a program which should run automatically to fetch the data) and update the same in a Z table in SAP.

Once this is automated and tinkered to work without any flaw, your work is almost done.

You also should know the gold portion in each material you are selling (either through a Z table or through some reserve fields available in configuration for custom purposes).

If you know the gold rate for the day (from the Z table) and the gold content in your material (Z table or reserve field), it will be easy to create a condition value routine to calculate the value of the gold portion surcharge. YOu can assign this routine to a condition type meant for gold portion surcharge. This can further be used to calculate the total pricing.

Hope this helps you. If you need any more info on this, pls lemme know.

[Former Member]

hi,

this can be achieved 50% by functionally by creating condition record as and when gold rate changes because the system picks the latest price from the system into condition records.

coming to technical,

sit with abaper or technical consultant say him to attach a routine against teh condition type which you are using as a final price or a condition type for which surcharge has to be calculated and i think your surcharge is fixed if it is so he will calculate and keep the information in buffer as and when that condition type triggers into teh sales order then it triggers the surchage also into the sales order.