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.