Skip to Content
0
Former Member
Nov 29, 2009 at 08:19 AM

is it better to use join?

23 Views

hi

i want to select header details from LIKP and item details from LIPS. i have VBELN number with me. now there are two scenarios

in first one

i can use select single to get the header details

then chekc sy-subrc to make sure that document exists in the system then query LIPS to get the item details.

second case

use join between LIKP and LIPS join on VBELN.

what would be the best in terms of performance in case if u want to select only one item from LIPS?