Pricing Routine

[Former Member]

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.

[Lakshmipathi]

First of all, try to use the tags most relevant to your business process. Is the requirement to be achieved in ECC or CRM ? If ECC, then why you have added CRM Pricing and confuse the members ?

It seems that your question requires additional information as you have not mentioned what is your current pricing procedure, what efforts you made in achieving that and where exactly your issue is. Please make sure that your question outlines the steps you took to find information and create the question again. This way members will know that you searched and were unable to find what you needed.
You may also want to include screenshots of what you're seeing, to help members further understand the issue. And please provide some additional details, as the question is fairly short.

You can find more important guidelines in the community rules of engagement and learn more about questions and answers best practices here.

Thank you for your understanding.

G. Lakshmipathi
SAP Community Moderator