This example works from SAP version 3.1H on up.

 select lips~vbeln lips~lfimg likp~wadat
        into corresponding fields of table ltab_orders
        from lips join likp on ( lips~vbeln = likp~vbeln )
        join vbfa on ( lips~vbeln = vbfa~vbelv )        
        where lips~matnr = matnr
        and   lips~vbeln in vbeln
        and   likp~vbeln in vbeln          
        and   vbfa~vbelv in vbeln
        and   lips~werks in werks
        and   likp~wadat in datum
        and   vbfa~vbtyp_n = 'Q'             "WMS transfer order
        and   vbfa~vbtyp_v = 'J'.            "Delivery