hi
i need some help in performence because this select is running time is to much:
Thanks
SELECT vbrk~vbeln vbrk~vbtyp vbrk~fkdat vbrk~netwr vbrk~waerk vbrp~kvgr3 tvv3t~bezei dd07v~ddtext FROM ( ( ( vbrk INNER JOIN vbrp ON vbrp~vbeln EQ vbrk~vbeln AND vbrp~posnr EQ '00010' AND vbrp~ps_psp_pnr EQ l_project ) LEFT OUTER JOIN tvv3t ON tvv3t~kvgr3 EQ vbrp~kvgr3 AND tvv3t~spras EQ sy-langu ) LEFT OUTER JOIN dd07v ON dd07v~domname EQ 'VBTYP' AND dd07v~ddlanguage EQ sy-langu AND dd07v~domvalue_l EQ vbrk~vbtyp ) INTO TABLE sdtab WHERE vbrk~rfbsk EQ 'C' AND vbrk~fksto EQ '' AND vbrk~sfakn EQ ''.