topic Re: Tax Rate Determination in Application Development and Automation Discussions

Tax Rate Determination

Former Member — Tue, 13 Jan 2009 10:21:47 GMT

Hi All,

I need to determine the Tax Rate in my program. I have the Tax code, Tax Jursidicion Code, Company Code, Tax Procedure and the Country available to me in my program.

Is there a function module/modules that I can use to arrive at the tax rate using the above fields.

I could find out the following function modules which could give me the tax rate however there is an issue when I use these.

FI_TAX_GET_CONDITION_TYPES -- I use this function module to get the value for KSCHL

FI_TAX_GET_KTOSL_FROM_KSCHL -- I use this function module to get the value for KTOSL

FI_TAX_GET_CONDITION -- I pass KSCHL and KTOSL along with other information to this function

module to get the tax rate (KBETR).

The issue with the first function module is that it can return multiple condition types for a give tax code and tax jurisdiction code in which case there is no way to find out which one to use (or atleast I am not aware of it).

Please let me know know if there is any other function module or any way to fix this issue.

Will greatly appreciate any solution to this problem.

Thanks for all your time.

Regards,

Vam

Re: Tax Rate Determination

christine_evans — Tue, 13 Jan 2009 10:45:18 GMT

I've used FM CALCULATE_TAX_FROM_NET_AMOUNT to get the tax from a net amount and a tax code - this also sends back the tax rate. FM GET_TAX_PERCENTAGE also seems to work well.

Re: Tax Rate Determination

Former Member — Tue, 13 Jan 2009 15:41:47 GMT

Hi Christine,

Thank you for your reply. I am using the FM GET_TAX_PERCENTAGE for all the countries that don't

use the Jursidiction Code. If I pass the Jurisdiction code to this FM, it doesn't return any records.

Hence, I started looking for other options.

Regarding the second function module, it does the same thing that the other first one I had mentioned

before. It can return two tax rates and there is no way that I can pick a unique one.

Thank you,

Vam

Re: Tax Rate Determination

christine_evans — Wed, 14 Jan 2009 10:28:58 GMT


> Hi Christine,
> 
>    Thank you for your reply. I am using the FM GET_TAX_PERCENTAGE for all the countries that don't  
>    use the Jursidiction Code. If I pass the Jurisdiction code to this FM, it doesn't return any records.
>    Hence, I started looking for other options.
>    Regarding the second function module, it does the same thing that the other first one I had mentioned 
>    before. It can return two tax rates and there is no way that I can pick a unique one.
> 
> Thank you,
> Vam

There must be some way of matching each tax code to single rate. What happens in your MIRO when all they can enter is a tax code for which it must be able to get a single rate? Running ST05 trace against MIRO might give you some clues.

The FMs mentioned all work for me here to get a single rate, and if they don't do the same for you I guess you'll need to talk to your functional consultants to get some more information on how the tax codes have been set up.

Re: Tax Rate Determination

SuhaSaha — Wed, 14 Jan 2009 10:35:22 GMT

Hello Vam,

Plz have a look @ [;

May be this might help you.

BR,

Suhas

Re: Tax Rate Determination

Former Member — Wed, 20 Aug 2014 03:42:05 GMT

seems FM FI_TAX_GET_CONDITION does not work properly if i configured the tax code with multiple conditions, i'm surprised that it returns the same rate even though only one condition has value. so my solution is:

if juristiciation NOT applied, use 'GET_TAX_PERCENTAGE'...

else use 'FI_TAX_GET_CONDITIONS' (before that, use FM 'FI_TAX_GET_PRICING_DATA' to retrieve t683s data.

regards,

Shawn