topic Re: SAP Query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/7190219#M1519652 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>MVKE-MATNR = VBAP-MATNR</P><P>MVKE-VKORG = VBAK-VKORG</P><P>MVKE-VTWEG = VBAK-VTWEG</P><P></P><P>(...or please specify what you want to get exactly)</P><P></P><P>Edited by: Csaba Szommer on Aug 3, 2010 11:17 AM</P></BODY></HTML> Tue, 03 Aug 2010 09:17:12 GMT csaba_szommer 2010-08-03T09:17:12Z SAP Query https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/7190218#M1519651 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>I am developing SAP query which uses table VABK, VBAP, VBBE, VBEP, KNA1, MVKE and MARC..</P><P></P><P>I did the join of SD related tables and it works fine.. Can you please tell how to join MARC and MAKE with above table.. because I am facing a problem of duplicate entries.. I join VBAP-MATNR with MVKE-MATNR and VBAK-VKORG with MVKE-VKORG.</P><P></P><P></P><P>Can you please suggest me what will be the perfect join..</P><P></P><P></P><P>Thank you in advance</P></BODY></HTML> Tue, 03 Aug 2010 09:07:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/7190218#M1519651 Former Member 2010-08-03T09:07:34Z Re: SAP Query https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/7190219#M1519652 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>MVKE-MATNR = VBAP-MATNR</P><P>MVKE-VKORG = VBAK-VKORG</P><P>MVKE-VTWEG = VBAK-VTWEG</P><P></P><P>(...or please specify what you want to get exactly)</P><P></P><P>Edited by: Csaba Szommer on Aug 3, 2010 11:17 AM</P></BODY></HTML> Tue, 03 Aug 2010 09:17:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/7190219#M1519652 csaba_szommer 2010-08-03T09:17:12Z