Material Master tax Category Issue

[Former Member]

Hi all,

I have some doubt in Material Master sales view.

I want to know the Database Table name in which the field Tax Category and tax classification stored.

I know that these tables are stored in the stucture during creation of material master.

thanks in advance..

Muthupandiyan

[Former Member]

hi

check in this table u will get both the fields

tax details of materials are stored in TSKM

check in table "TSKM" for tax classification TAXKM field and TATYP for tax type

[Former Member]

tax details of materials are stored in <b>TSKM</b>

check in table <b>"TSKM"</b> for tax classification <b>TAXKM</b> field and <b>TATYP</b> for tax type

[Former Member]

Hi Prasanth,

There is no link between material and tax fields in TSKM.. then how will we find the link..

In TSKM only those two fields are available..

Muthu

[Former Member]

hi

tax details of materials are stored in TSKM

check in table <b>"TSKM"</b> for tax classification TAXKM field and TATYP for tax type

regards

[Lakshmipathi]

Dear Muthupandiyan

To find a table for the data stored in structure,

1) Goto SE84

2) Select "ABAP Dictionary" on left

3) Again select "Fields" and "Table Fields"

Now on your right side, a screen will appear. Give the field value "Field Name" and execute. You can now see the tables in which the structure field are stored.

Thanks

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi

I know that how to find.. but these fields are basically Structure fields. so this will be stored in some database table. i want to know that.

Muthu

[Former Member]

Table for Material axes is 'MLAN'.Go to se 12 and give 'MLAN' there.Data element is"TAKLM".

Regards

Ram Pedarla

[Former Member]

Hi Aram,

Thanks your response

But in MLAN only tax classification is available. I need tax category also.

Can you tell me the table that includes the tax category too

Muthu

Message was edited by:

Muthupandiyan

[Former Member]

Hi Muthu,

Go to DB15 and find the table there.Jus type"mm_matnr",it will show all the tables associated with material master there.

Regards

Ram Pedarla

[Lakshmipathi]

Dear Muthupandiyan

Tax Category is being stored in the field <b>VTEXT - Table T685T</b>.

Thanks

G. Lakshmipathi