Select single Vbrk~Bukrs Vbrk~Kunrg    Vbrk~Vbeln 
                   Vbrk~Fkdat Vbrk~Bstnk_Vf Vbrk~Zterm 
                   Tvzbt~Vtext 
                   Vbak~Vbeln Vbak~Bstdk 
                   Likp~Vbeln Likp~lfdat    Likp~Lfuhr 


       into w_vbrk 
     
 from vbrk 


      inner join       Tvzbt on Tvzbt~Zterm        = Vbrk~Zterm      and 
                                Tvzbt~Spras        = sy-langu 

      Inner join       Vbfa  as SalesLnk 
                             on SalesLnk~vbeln     = pu_vbeln        and 
                                SalesLnk~vbtyp_v   = c_order 

     inner join Vbak  on Vbak~Vbeln           = SalesLnk~Vbelv

      Inner join       Vbfa  as DeliveryLnk 
                             on DeliveryLnk~vbeln   = pu_vbeln       and 
                                DeliveryLnk~vbtyp_v = c_Delivery 

      inner join Likp  on Likp~Vbeln          = DeliveryLnk~Vbelv 
      where vbrk~vbeln = pu_Vbeln


Serkan AKKAVAK
Bilgisayar Mühendisi
serkurumsal@yandex.com