Input Tax code for MM Process

[former_member326855]

Hi,

We are using SAP system since last 5 years. Due to Change in budget every year, excise rate or vat rate gets changed. Based on changes we are creating new tax code every year thru FTXP tcode and maintaining tax conditions thru FV11 tcode.

Now during this five year we have created lots of tax code. Since the tax code having only two characters, we can create maximum 1035 tax code. Now all possible combinations are almost used by us.

Is there any alternate solution available in SAP to capture further changes. We are working as a group of companies under AMUL and based on requirement of all I am looking to earliest solution.

Bhaskar Gadani

[ankurch]

Hi Gadani,

Your requirement is really very strange, but could you please try with changing in the existing tax codes instead of creating new ones.

Thanks,

Ankur Chauhan

[former_member326855]

Hi,

Thanks for prompt reply.

But it is very difficult to get the data from all company code that which tax code is not in use now. To take out data for tax code which are not in use, we are supposed to access PO and Invoice Booking tables. which is very very long process and many time system gives ABAP run time error.

we can change only those tax code which are not in use.

if you have any alternate method to find out such tax code then please let me know. It would be very helpful to me.

Bhaskar Gadani

[former_member192897]

What is the access sequence you are using? Have not you defined any custom table with validity for Tax classification (Country and tax code combination)?

[former_member326855]

Hi,

Thanks for prompt reply.

we have not done customization. we are using standard functionality. Thru FV11 tcode we are maintaining tax condition at Tax code level only. so that across all company code all user can use that tax code.

if any customization can help me out then, give some of the detail so that we can explore.

Bhaskar Gadani

PS : We are using TAXINN Process. Tax conditions are being maintained by us with Tax Code and validity period.

Message was edited by: Gadani Bhaskar

[former_member192897]

If you have the validity period available for the Condition table, you can change the condition record validity and create new one with the new validity date and price / rate.

[former_member326855]

Hi,

The suggested solution can work. But in this case the tax code description will mismatch.

e.g. present tax code description is "I/P In:Ex12%+ED2%+AS1%+Vat4%+AddVat1%"

considering change in excise 12.36% to 12% the tax is as under

I/P In:Ex12%+Vat4%+AddVat1%

we are creating new tax code for ease of end user so that he can select proper tax code from list of values.

Bhaskar Gadani

[former_member192897]

You have two ways to handle this case. One is Creating a new tax code and maintain rate in FTXP / FV11 or identify the unused or old tax codes and change the validity and rate.

The description is merely a text field which will be helpful for user to select the right tax code. Based on the rate you have entered in FTXP or FV11 your tax code calculation happens.

If your client is fine for changing the tax code description then you can change the description as well. But, you have to ensure that you have ended the validity of Condition record for the old rate for all the appropriate conditions.

[former_member326855]

Thanks a lot for suggestion.

[Former Member]

This message was moderated.

[Former Member]

Hello,

Yes there is one alternative by which you can use one tax code for different purpose.

For this reason you have to create few additional access sequences (as per requirement) so that while maintaining condition records you can choose it with proper validity dates. (if tax procedure is TAXINN.

for e.g if you have tax code V1= 5% VAT

then you can maintain one condition record JVRN =5%

but you got requirement to create new tax code 5.5% VAT which is applicable on particular products or you have dont require previous tax code then you can change "From" & "To" date in condition record.

Hope this will help you to minimize tax codes.

[Former Member]

Please go through it.... It will helpful to you..

Yes there is one alternative by which you can use one tax code for different purpose.

For this reason you have to create few additional access sequences (as per requirement) so that while maintaining condition records you can choose it with proper validity dates. (if tax procedure is TAXINN.

for e.g if you have tax code V1= 5% VAT

then you can maintain one condition record JVRN =5%

but you got requirement to create new tax code 5.5% VAT which is applicable on particular products or you have dont require previous tax code then you can change "From" & "To" date in condition record.

Hope this will help you to minimize tax codes.

[Lakshmipathi]

First of all, I am really surprised that you have exhausted creation of new tax codes.  Better go through this

so that you will get list of tax codes used.  Whatever combination is left out, you can make use of that.  Also have a look at OSS note 1557220

G. Lakshmipathi

[Former Member]

Hi Bhaskar,

Creating multiple tax codes for picking tax records is quite old now. SAP provides functionality where you can pick tax percentages directly from condition records with minimum tax codes based on dcoument date.

here is a nice doc on that