cancel
Showing results for 
Search instead for 
Did you mean: 

Tax calculation in Pricing Procedure

Former Member
0 Kudos

Hi Guys,

I have a pricing procedure setup to be modified for calculation of surcharge. The current pricing procedure calculates surcharge based on total price. Needs to change it to calculate on Unit price.How to achieve this?

Current Setup

Price Unit Price Qty. Net Price

PR00 655.55 5 3277.75

ZSUR = 3277.75*12/100 = 393.33

Required setup

Price Unit Price Qty. Net Price

PR00 655.55 5 3275

ZSUR = 655*12/100 = 78.666 = 78.67

Then this should be multiplied with the qty. 78.67*5 = 393.35

How to achieve this.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I solved this same issue by doing the following.

When determining ZSUR, create a Condition formula for alternative calculation type in VOFM.

calculate the 12% off of the PR00 each price and round this result to 2 decimals. In your example you would get .12 * 655.55 = 78.666 commercial rounded to 78.67, then multiply this rounded result with qty to get your extended amount 78.67 * 5 = 393.35 and put the result in XKWERT for ZSUR.

With this type of calcualtion you will always get consistant pricing regardless of qty. When you are finished with your formula assign it within config of the pricing procedure on your ZSUR

line. Hope this helps.

When calculating .12 * 655.55 , create a working data field and do a 'like' to netpr in your formula:

eg DATA: ZZEA LIKE KOMP-NETPR. ( netpr is curr dec 2)

when calculating zzea = .12 * 655.55 since the field is defined as 2 decimal, commercial rounding will be the default calculation(round up if >= .005, down if < .005). So in your example 78.666 = 78.67

Code looks like(had to deal with floating decimals):

DATA: ZZEA LIKE KOMP-NETPR.

ZZEA = KOMP-NETPR * XKOMV-KBETR / 100000.

XKWERT = ZZEA * KOMP-MGAME / 1000.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Salman,

In your pricing procedure for condition type ZSUR there might be a routine or requirement attached, ask your ABAPer to modify the same besed on the unit price instead of net value..

regards

prasad

Former Member
0 Kudos

HI,

Lets say u r Maintained the Unit price in COndition price PR00-100

if Qty is 10 ,system will caluculate 10*100=1000.

You want to Calculate Surcharge 2% on 100/-(Pr00)(If i understood rgt)

Step Counter Condition type From TO Etc....in Pricing Procedure

10 0 PR00

20 0 Test(Surcharge) 10(Step Number).

Now you will get Output.

Regards

raj