topic Query using field MWSKZ without using BSEG in Application Development and Automation Discussions

Query using field MWSKZ without using BSEG

JulienGirard — Thu, 23 Apr 2009 18:38:45 GMT

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 — Thu, 23 Apr 2009 18:48:23 GMT

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 — Thu, 23 Apr 2009 19:20:36 GMT

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

Thanks,

Julien

Former Member — Thu, 23 Apr 2009 19:36:37 GMT

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

Rob