Calculate price from different UoM and tarrif indicator

[Former Member]

Hello Gurus,

Ive got a requirement to calculate price using different Unit of Measure which are multiplied by a pricing indicator.

Imagine if we have service i.e.

painting works for 100 m2 which took about 12 Hours.

The tariff is 3,5 EUR.

we need to multiply the 100m2 * 12 H * 3,5 = 4200 EUR

Is there any way possible to do this in Sales order?

Regards

Laurynas Prikockis

[jignesh_mehta3 · Accepted solution]

Hello,

I think your requirement will not be possible in SAP Standard. Because, you ned three variable to be conidered i.e. UoM = 100 * Hours * Price per hour.

The only possibility that I can think of is Maintain UoM in Material master as M2 & while creating Sales (Service) order, user will enter qualtity as 100 * Hours, which in above example will be 1200. Now the PR00 (Basic Price) Condition Record will be for EUR 3.5 so system will calcualte 1200 * 3.5 = 4200.

If above is not acceptable than you will have go for a enhancement, create a Routine (T-Code VOFM) with required logic & assign the same at Alternate Base Value for Condition in Pricing Procedure .

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Hi Jignesh,

thanks for quick response. Could you explain in more detail the step you've described?

I mean that part:

Creating material and assigning an hour rate.

Then maintaining line item in sales order

Creating condition record? for what?

Regards

Laurynas

[jignesh_mehta3 · Accepted solution]

Hello,

Maintian Material Master with Units of Measurement as M2.

Now, maintain condition record for Basic Price of Material as EUR 3.5 per M2.

Then while creating Sales Order, under will have to enter Quantity as 1200 (which is 100 * 12 hours).

Then will ensure that total Price is 4200 (1200 * 3.5).

If the above is not accepted, then as suggested above, you will have to go for Z-Development.

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Thanks, for clarifying.

So basically these 1200 i have to calculate manually?

LP

[jignesh_mehta3 · Accepted solution]

Hello LP,

Yes. That will be calculated Manually.

For automation you will have to go for Z-development.

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

thanks again for solution.

[Former Member · Accepted solution]

hi jignesh,

just correct me where i was wrong but i got soution like this:-----

created material a1 with unit of measurement M2.

and

sales unit of measurement as HOURS (i.e.) 12 hours <-----> 1 M2.

create conditon record in vk11 as 1 M2 per Hour is Rs. 5/-

raised sale order va01,

once entered line item by default it taken per 100 units taken hours as unit measurement and calculated 100 * 5 = 500 and

i have changed UOM manually as M2 so that it calculated as 500*12 as 6000 so requirement met but i have confusion whether it is correct process or not.

warm regards,

Jagadeesh.

waiting for your valuable suggestions and correction.

[Former Member · Accepted solution]

thanks Jagadeesh,

Regards

Laurynas