Skip to Content
0
Former Member
Mar 06, 2009 at 06:44 AM

Problem fetching data using inner join

39 Views

Hi All,

I need to fetch data of a fiedl BSTNK (Customer Purch.order no) from table VBAK using an inner join with table VBAP. Now this INNER JOIN works at times and doesnt at other times.

Can someone explain what is the problem with the same.

CLEAR: g_bstnk.

SELECT SINGLE k~bstnk FROM vbak AS k INNER JOIN vbap AS p

ON kvbeln EQ pvbeln

INTO g_bstnk

WHERE k~auart EQ 'ZC'

AND k~kunnr EQ vbdkl-kunnr

AND k~vkorg EQ vbdkl-vkorg

AND k~guebg LE likp-fkdat

AND k~gueen GE likp-fkdat

AND p~matnr EQ tvbdpl-matnr

AND p~werks EQ tvbdpl-werks.