We need to select order data based on material number. I've created a join starting at VAPMA and going to VBAP then to VBEP but it seems to be very expensive SQL. Should I structure this another way?
SELECT vvbeln vposnr v~matnr
pvgbel pwerks pvgpos pmeins
ewmeng ej_3asize
INTO CORRESPONDING FIELDS OF TABLE itab
FROM vapma AS v INNER JOIN vbap AS p
ON vvbeln = pvbeln AND
vposnr = pposnr
INNER JOIN vbep AS e
ON pvbeln = evbeln AND
pposnr = eposnr
INNER JOIN vbak AS k
ON kvbeln = evbeln
WHERE ....
Bluesky
