Query tables mard and mvku

[Former Member]

Hello,

I just started with building queries with SQ01. Now I have a question about the tables MARD and MSKU.

I link these tables with the fields MATNR and WERKS. Problem is that in the output of these query only

the articles which are present in table MARD and MSKU show up. I also would like to see the articles

which are only present in table MARD show up.

Is this possible to do with a query? I know you can also add some coding in the infoset of the query, however what coding should I use? Now I have build two different queries and I combine the output in Excel. Thanks in advance,

SAP trainee

[Former Member · Accepted solution]

Hi,

You need to revise the link between MARD and MSKU, the default link is inner link, you can change it to left-out link, I think it will be okay!

Good luck

Z.T

[Shiva_Ram]

Hi,

Your message is not clear enough.

It looks you may need to add table MARA and MARC also in the query.

Regards,