topic Re: Tax Code in Application Development and Automation Discussions

Tax Code

Former Member — Fri, 08 Jun 2007 04:47:06 GMT

Hello,

How to calculate total percentage for a particular tax code,

for example , for tax code VA ---> 16 % Excise, 2% ECS, 4% Vat

we calculate total percentage of tax in the following way,

2% of 16% = 0.32

so it will 16 + 0.32 = 16.32

now 4% Vat for 16.32 % = 0.6528.

16.32 + 0.6528 = 16.9728 %

now the total tax percentage for VA is 16.9728 %.

is such Details maintained in SAP for all tax Code...

WIth regards,

Poornima.

Former Member — Fri, 08 Jun 2007 04:50:36 GMT

If I am not wrong all the Tax related Percentages etc are maintained in the pricing related tables KONV and KONP based on a condition type.

check those tables

Take the sales order/Invoice condition no(KNUMV) field and pass to KONV and search in those tables.

Reward points for useful Answers

Regards

Anji

Former Member — Fri, 08 Jun 2007 05:01:29 GMT

Hello Mr.Anji Reddy Vangala,

I have checked those table from KONP I am reading the percentage,

but I need to calculate the total percentage , as I explained above. Plz the ckeck the question and help me out.

Poornima.

Former Member — Fri, 08 Jun 2007 05:06:02 GMT

We will use the KBETR (rate) and KWERT(amount) fields of KONV and KONP tables which are already calculated based on the percentage mentioned

We don't calculate like that.

And always Percentages are maintained upto 2 decimal places.

Reward points for useful Answers

Regards

Anji

Former Member — Fri, 08 Jun 2007 05:12:38 GMT

hi,

as above explained...u need to calculate tax based on percentage................

if want to check your calculation varification than go to ME22n............

where for each PO Items.......tax value displayed.................

Reward points if helpful,

Regards,

Imran