Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

help in select


i have this select with join and i wont to separate it for to selects without join

and to get the same results what is the best way to do that ?

    SELECT vbrk~vbeln vbrk~vbtyp vbrk~fkdat vbrk~netwr vbrk~waerk vbrp~kvgr3
      FROM vbrk INNER JOIN vbrp ON vbrp~vbeln EQ vbrk~vbeln
                 AND vbrp~posnr EQ '00010'
                 AND vbrp~ps_psp_pnr EQ l_project
  INTO TABLE sdprojectinvoice
  WHERE vbrk~rfbsk EQ 'C'
        AND vbrk~fksto EQ ' '
        AND vbrk~sfakn EQ ' '.


Former Member
Not what you were looking for? View more on this topic or Ask a question