cancel
Showing results for 
Search instead for 
Did you mean: 

Rounding off through Routine...

rajesh4379
Explorer
0 Kudos

Dear Gurus,

I am having a requirement from client for rounding off as below:

1. Routine for rounding the values of condition means if USD maintain 3 digit in OB90 but client needs at 2 digit rounding off.

     e.g. a) if Condition value is 2.173 then system should take it as 2.170.

            b) if Cond. value is 2.177 then system should take it as 2.180.

2. Routine for VAT Condition , VAT should get formula on below Explanation:

          Suppose , VAT is 12%

          Net value  = 100

           Then, Formula = {100-(100/1.12)} = {100-89.2857}  = 10.7142

Shall i need to change the Calculation type ? if yes what should i maintain?

Regards,

Rajesh

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Dear Rajesh,

you can full fill both requirements in the same pricing with the help of ABAPer you can change your logic accordingly :-

1. Try to use DIFF for rounding purpose and assign new manipulated routine in Requirement, using  FM 'ROUND' (tkomv str.).

2. Create new routine for alternate condition base value for VAT write kwert = kwert - (kwert/1.12) as       per your formula 100-(100/1.12),(find data in XKOMV str.).

Hope this will help to other SCN user's.

Thanks,

Deekshita

Answers (2)

Answers (2)

od_manikandan
Active Contributor
0 Kudos

Hai Rajesh,

Please Check

1. Cal Type - 17 - Rounding as perT001R

2. Cal Type - 165 - (1 - XKAWRT / D) * E

Regards,

OD

rajesh4379
Explorer
0 Kudos

Dear OD,

will you pls elaborate on the solution given?

Regards,

Rajesh

Former Member
0 Kudos

Dear Rajest

1. Cal Type - 17 - Rounding as perT001R,

Cal Type 17 is standard rule in Tax procedure and Table T001R rounding rule for company code and currency.

check the table details.

MANDT BUKRS  WAERS   REINH

010   IN00   INR     0100

Regards,

Radhe

vinod_vemuru2
Active Contributor
0 Kudos

Hi,

Check if any standard rounding rule(Calculation type) helps like 16 or 17. If not, you can define custom alternate calculation type and write ABAP coding.

Thanks,

Vinod.