Hi ,
i am using an inner join Between likpuk and lipsup, but its taking lot of time to execute,
the inner join is between two views, is there any other way to get the same what i am getting from the below inner join..
SELECT avbeln bmatnr bwerks blgort b~charg FROM likpuk AS a INNER JOIN lipsup AS b
ON avbeln = bvbeln INTO TABLE tb_delivery
WHERE akostk = 'C' AND bwbsta NE 'C' .
thanks in advance,
vinayaka
Move to correct forum
Edited by: Rob Burbank on Feb 18, 2009 1:55 PM