Table Name

[Former Member]

In which table I can get Tax Classification(Sales Org1) ,Plant & Material list.

Thanks

apr

[Former Member · Accepted solution]

Hi there,

Table MVKE contains all the Sales Org, distribution channel

Table MLAN contains Sales data, tax indicator, tax

Table MARC Contains classification and Plant related Data.

Thanks,

Raja

[Former Member · Accepted solution]

In MVKE & MARC I could not able to find Tax Classification.

In MLAN , Tax Classification is there but could not able to get Material/Plant field.

Is there any single table where can I get all three Tax Classification ,Material & Plant .

Thanks

apr

[Former Member · Accepted solution]

Dear Prasad,

I dont think there is a single table from where you can get all the details. In any case you can join these tables by creating small query by SQVI.

By which you can get all the details,

Thanks,

Raja

[Former Member · Accepted solution]

Can you please tell me all the steps of how to create Query.

[Lakshmipathi · Accepted solution]

Please go through my suggestion in the below link

[Re: How can we create Query by using SQVI |]

thanks

G. Lakshmipathi

[Former Member]

Hi,

Sales Org1/2 views are stored in MVKE.

Regards,

Raghu.