Skip to Content
0
May 30, 2018 at 05:39 AM

Pricing Routine

1368 Views

Hi,

I am new to enhancements. I have a requirement mentioned below. Please help me to develop this.

Multiple Pricing routines are required to fulfill small business requirements in SAP Pricing. These routines could be of different types in SAP, however, we want to create pricing routine calculation type and the same will be focus of this document

Three pricing calculation formulae are required

1.1.1Gross Margin %

Gross margin is required to calculate profitability of an order. Gross margin is achieved by deducting gross price from sales price.

Gross Margin = (Sales Price – Total Production Cost) / Sales Price *100

xkwert = komp-netwr - komp-kzwi1.

workfield = xkwert * 100/ komp-netwr


1.1.2Net Margin %

Analyzing net margin would require all the indirect costs also to be considered, costs like SG&A etc.

Net Margin = (Sales Price – Total Cost) / Sales Price *100

xkwert = komp-netwr - komp-kzwi2.

workfield = xkwert * 100/ komp-netwr

1.1.3Banana Price Rework

Banana price is a price that is defined in business independent of any currency for a product. Business then apply a multiplier that takes care of currency conversion. For example;

Banana price100Banana price 100

USD Multplier0.6EUR Multiplier0.5

List price 100*0.6 = 60List price100*0.5 = 50

In SAP we will have two condition types, one for Banana price and second for Multiplier. However, it is impossible to define any condition type or condition record without currency and SAP will immediately convert value into currency.

Banana Price defined in condition record with EUR since condition record is always with currency

By default system will convert based on conversion rate value in currency of document

Exchange rate from EUR to USD

The routine that is required is supposed to equate the price back to 100

If 1000 * 0.94 = 940

When we divide 940 back with 0.94, system will bring back the price independent of conversion

940 / 0.94 = 1000

We require a routine to bring back the banana price and only multiply with quantity and not with exchange rate

1.1.4Base for the Currency Multiplier

For the standard motors, the currency multiplier will be applied on the Banana price to arrive at the List price. In case of configurable motors, there is a possibility of having the net SP/TP price for the Base Motor whereas the List price for variants will still be based on the variant Banana prices.