Skip to Content
0
Jun 18, 2020 at 08:50 AM

Need to apply inner join

57 Views

How to apply Inner join for below code ?

SELECT locid FROM /sapapo/loc INTO lr_locfr_line-low

WHERE locno IN r_locfr.

APPEND lr_locfr_line TO lr_locfr.

ENDSELECT.

SELECT locid FROM /sapapo/loc

INTO lr_locto_line-low WHERE locno IN r_locto.

APPEND lr_locto_line TO lr_locto.

ENDSELECT.

SELECT locfr locto ttype durat FROM /sapapo/trm

INTO CORRESPONDING FIELDS OF TABLE lt_tlane

WHERE trname = p_model

AND locto IN lr_locto

AND locfr IN lr_locfr.