topic Re: Related table in Application Development and Automation Discussions

Related table

Former Member — Tue, 30 May 2006 17:20:23 GMT

Hi,

I need the database table related to the field MG03STEUER-TATYP.

Regards,

Swamy

Re: Related table

RichHeilman — Tue, 30 May 2006 17:24:57 GMT

Please try the following tables.

KNVI Customer Master Tax Indicator

KNVL Customer Master Licenses

Regards,

Rich Heilman

Re: Related table

RichHeilman — Tue, 30 May 2006 17:26:34 GMT

HEre are other tables that have a field which use the data element in question.



TB072_CM                         Tax Classification: Mapping R/3 <-> CRM                                                                                
TATYP                            Tax category (sales tax, federal sales tax,...)                                                                                
TSKD                             Customer Taxes                                                                                
TATYP                            Tax category (sales tax, federal sales tax,...)                                                                                
TSKDT                            Customer Taxes: Texts                                                                                
TATYP                            Tax category (sales tax, federal sales tax,...)                                                                                
TSKM                             Material Taxes                                                                                
TATYP                            Tax category (sales tax, federal sales tax,...)                                                                                
TSKMT                            Taxes: Materials: Texts                                                                                
TATYP                            Tax category (sales tax, federal sales tax,...)                                                                                
TSTE                             Invalid will not be used anymore                                                                                
TATYP                            Tax category (sales tax, federal sales tax,...)                                                                                
TSTL                             Taxes: Valid Tax Categories for Each Country                                                                                
TATYP                            Tax category (sales tax, federal sales tax,...)                                                                                
TSTMT                            Taxes: Material: Texts  (Obsolete, Superseded by TSKMT)                                                                                
TATYP                            Tax category (sales tax, federal sales tax,...)

Regards,

Rich Heilman

Re: Related table

Former Member — Tue, 30 May 2006 17:29:06 GMT

Hi,

See the where used list(CTRL + SHIFT + F3) for the data element of the MG03STEUER-TATYP.

Reward points if it helps.

Regards,

Amit Mishra

Re: Related table

Former Member — Tue, 30 May 2006 17:34:37 GMT

Hi,

Actually the table should be related to MM module. For the value should match with the value of the Tax catagory in Sales organization1 of MM03.

Regards,

Swamy

Re: Related table

Former Member — Tue, 30 May 2006 18:29:14 GMT

Check MLAN

Re: Related table

Former Member — Tue, 30 May 2006 18:31:11 GMT

Hi Swamy,

Please check <b>MARA-TAKLV</b> and table <b>TSKM</b>.

Regards,

Ferry Lianto

Re: Related table

suresh_datti — Tue, 30 May 2006 18:31:55 GMT

Did you check T685?

Regards,

Suresh Datti

Re: Related table

Former Member — Tue, 30 May 2006 18:40:41 GMT

hi,

i wanted tax catagory for some material.ie. for MATNR i wanted to fetch TATYP. So pls tell me table which contains MATNR and TATYP table.

Re: Related table

Former Member — Tue, 30 May 2006 18:51:25 GMT

hi,

MLAN doesnot contains the field, that's why only i need this...if it contains the problem doesn't exists...

Re: Related table

cmaier0404 — Mon, 01 Dec 2014 07:48:57 GMT

Hi all,

try the function module "STEUERTAB_READ", which will select all relevant data, you are searching for.

Christian