Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP Query

Former Member

‎08-03-2010 10:07 AM

0 Kudos

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

1 REPLY 1

csaba_szommer
Active Contributor

‎08-03-2010 10:17 AM

0 Kudos

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