Query using field MWSKZ without using BSEG

[JulienGirard]

Hi,

I'm trying to create an Infoset (t-code SQ02) that will contain the field MWSKZ (Tax on sales/purchases code).

This field is located in the table BSEG and I get the message: «Table BSEG cannot be used in a join» when I try to create an infoset using BSEG.

Is MWSKZ (Tax on sales/purchases code) located in any other table?

Thanks,

Julien

[JulienGirard]

Hi,

I'm trying to create an Infoset (t-code SQ02) that will contain the field MWSKZ (Tax on sales/purchases code).

This field is located in the table BSEG and I get the message: «Table BSEG cannot be used in a join» when I try to create an infoset using BSEG.

Is MWSKZ (Tax on sales/purchases code) located in any other table?

Thanks,

Julien

[Former Member]

BSIK, BSAK, BSID, BSAD.

But I'm not sure how useful these tables will be in a JOIN.

Rob

Edited by: Rob Burbank on Apr 23, 2009 2:53 PM

[JulienGirard]

Is there a transaction in SAP where you can search for tables using fields criterion ?

Thanks,

Julien

[Former Member]

Sure - in SE11, you can enter your field in the data type and do a where used list.

Rob