description tax code in table T007S

[former_member445510]

Hello Every Body,

I want to get the description of tax code from the table T007S, but when i type for example "C1"  in the field tax code i receive a several description of this tax code.

What can i give at the field Procedure( = Proc) to get the right description of the tax code ?

I notice in the field Procedure   that letters "TAX" is standard, but after "TAX" there is the country code, the problem is that this logic is not always right, some time you find the country code one letter like "L".

Did some one knows hoe can i resolve that problem, to get one description for One tax code ?

Thank you in advance for your answers.

Best Regard,

Roukbi.

[Sijin_Chandran]

Provide a Particular value for TAX PROCEDURE ( KALSM ) as well while Selecting from DB.

A Tax Code can be there in more than one TAX PROCEDURE , so ask your Functional Guy which Procedure they use and Select using that Procedure only.

Or

You can get the Procedure applied by fetching the same from Documents over which Pricing are applied

eg in Purchase  Order ( Material Management ) you can get the same from EKKO-KALSM .

and in Sales Order ( Sales and Distribution ) you can get the same form VBAK-KALSM.

[former_member201275]

Hi Ouail,

It is not necessarily linked to Country Code, it depends on how the config was setup. Refer table T683.

I think you cannot get 1 description per tax code unless the logic used for your config is consistent. You can get 1 description per Procedure though.

Not sure if that helps you, but I hope so.

[former_member445510]

Thank you to everyone,

I must to write query between T001, T005 and T007s to get the right Tax code description.

Best Regard,

Ouail.