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' 
        and   vbfa~vbtyp_v = 'J'. 
 
 
 
Serkan AKKAVAK
Bilgisayar Mühendisi
serkurumsal@yandex.com