cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation in Pricing

Former Member
0 Kudos

Hi Experts,

I have created new condition type for difference amount to be capture in Pric Proc.

Example -

Total of (94094594) 11,776.10 INR 1 MT

Copy of ZPRS 1,000.00 INR 1 MT

ZDIF Difference 0.00 INR 0.00

My issue is i am not getting the difference amount from Total and Copy of ZPRS.

I want the system shud calculate 11776.10 - 1000 = 10776.1 --- i want the value 10776.1 in ZDIF condition type.

I want the difference amount in ZDIF. I am sure ther is some problem in condition type Plz Advice..

Thanks

Shri...

Edited by: shrii on Feb 1, 2010 12:58 PM

Accepted Solutions (1)

Accepted Solutions (1)

jignesh_mehta3
Active Contributor
0 Kudos

Dear Friend,

In nutshell you want to substrat the value of ZPRS from Total & have that difference amount in ZDIF Condition Type.

This means system should calculate as follows:

Total - ZPRS = ZDIF...

To achieve the above the value of ZPRS should be negative (-ve).

New check whether currently the ZPRS is positive or negative. (Mostly it would be positive) ..

Thus you will have to create one more condition Type & this should be negative (V/06 - select the Condition Type & under Control Data 1 the Plus/minus indicator should be X (Negative).

Now copy the value of ZPRS into this new condition type (which will make the value negative)

Then for ZDIF condition insert necessary from (copy of Total) & to (copy of ZPRS)

This will make sure that the value is substracted from total value.

Hope this helps...

Thanks,

Jignesh Mehta

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Your explanation shows that you are getting the values for Total and ZPRS.

Say the step number is 100 for u2018Totalu2019 and 110 for u2018ZPRSu2019.

1. First you have to make the values of u2018ZPRSu2019 in negative. If u2018ZPRSu2019 is in negative you can skip this step. If u2018ZPRSu2019 is positive value following this step. Create a condition type u2018ZZZ1u2019 by copying u2018JEX2u2019 and make u2018negativeu2019 in the u2018positive/negativeu2019 field.

2. Create a step 115; this is copy of u2018Totalu2019 value. So give u2018Fromu2019 as 100 and u2018Tou2019 as 100.

3. Create a step 120; the condition type is u2018ZZZ1u2019. This is a copy of u2018ZPRSu2019; but in negative form. Maintain condition record for u2018ZZZ1u2019 as 100%.

4. Create a step 125; this is u2018Subtotalu2019; give u2018Fromu2019 value as 115 and u2018Tou2019 value as 120.

5. If you want to show this value in condition type, create a condition type u2018ZDIFu2019 by copying u2018JEX2u2019; do not change anything. Maintain the condition record for u2018ZDIFu2019 and give 100%. Give u2018Fromu2019 as 125 To as 125. So Difference value will be copied to u2018ZDIFu2019 line.

Hope this will be useful to you.

Regards,

K Bharathi

reazuddin_md
Active Contributor
0 Kudos

Check whether you have maintained the entry in Table:T001R or not?

Just would like to ask, Why you want to use ZDIF cond type, instead of DIFF cond type?

Former Member
0 Kudos

Dear Sir,

Is ther any standard condition type wher i can get the difference amount.

Thanks

Shri..

Former Member
0 Kudos

GUYS PLZ HELP