SAP Query

[Former Member]

Hi experts,

I am developing SAP query which uses table VABK, VBAP, VBBE, VBEP, KNA1, MVKE and MARC..

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.

Can you please suggest me what will be the perfect join..

Thank you in advance

[csaba_szommer]

Try:

MVKE-MATNR = VBAP-MATNR

MVKE-VKORG = VBAK-VKORG

MVKE-VTWEG = VBAK-VTWEG

(...or please specify what you want to get exactly)

Edited by: Csaba Szommer on Aug 3, 2010 11:17 AM