Table of tax rate percent from FTXP

[bm_naidu]

Can any one tell the table name to find Tax Rate Percent, to post the same Tcode is FTXP.

[Former Member]

Hi,

Tax codes have to be manually exported from source client (DEV) and then imported into the target clients (QA, PRD).

Please read OSS note 605537 and F1 help below for further information.

Important note on transporting tax codes -> F1

Message no. F4794

Diagnosis

Transporting tax codes requires manual postprocessing. This postprocessing is also necessary if tax codes have to be transported from one client to another within the system.

Procedure

When tax codes are transported, only the tax rates of the tax codes are transported.

The transport of tax codes between systems or clients is carried out in two steps:

1. step:

Export of tax codes from the source system or source client

2. step:

Import of tax codes into the target system or target client

Export

1. In Customizing for Financial Accounting Global Settings in the source system or client, select Tax on Sales/Purchases -> Calculation -> Define Tax Codes for Sales and Purchases.

2. Select Tax code -> Transport -> Export.

3. Assign the export to the corresponding transport order, and note the order number.

4. Select and save the tax codes to be transported.

5. Make sure that the tax codes selected are marked with the transport number in table T007V.

To check the table, in the SAP menu, select Tools -> ABAP Workbench -> Overview -> Data Browser.

Enter the table name. The tax codes are in field MWSKZ and the tax jurisdiction codes are in fields TXJCD.

6. Carry out the transport into the target system.

To do this, in the SAP menu, select Tools -> ABAP Workbench -> Overview -> Workbench Organizer -> Environment -> Customizing Organizer.

Import

1. Make sure that the tax codes to be transported are selected in table T007V in the target system or target client.

2. In Customizing for Financial Accounting Global Setting in the source system or client, select Tax on Sales/Purchases -> Calculation -> Define Tax Codes for Sales and Purchases.

3. Create the tax codes that do not already exist in the target system.

Create them complete, but without tax percentage rates.

If you set internal systems in company codes in the USA or Canada, the corresponding tax jurisdiction codes should also exist. You can make the settings for these in Customizing for Financial Accounting Global Settings under Tax on Sales/Purchases -> Basic Settings -> Define Tax Jurisdiction Codes.

4. Select Tax code -> Transport -> Import.

5. Check the proposed values for the transport order and country.

6. Carry out the import.

Notes for the transport of tax accounts

When you transport tax codes between different systems or clients, no tax accounts are transported.

Adjust the tax accounts in the source and target system (or source and target client) manually.

Rewrad If helpfull,

Naresh.