topic description tax code in table T007S in Application Development and Automation Discussions

description tax code in table T007S

former_member445510 — Mon, 14 Oct 2013 09:08:03 GMT

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.

Re: description tax code in table T007S

Sijin_Chandran — Mon, 14 Oct 2013 09:16:58 GMT

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.

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.

Re: description tax code in table T007S

former_member201275 — Mon, 14 Oct 2013 09:34:09 GMT

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.

Re: description tax code in table T007S

former_member445510 — Thu, 17 Oct 2013 09:22:52 GMT

Thank you to everyone,

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

Best Regard,

Ouail.