Skip to Content
0
Former Member
Nov 22, 2007 at 09:46 AM

change to select single

31 Views

HI,

what is the Best way to converse this select to select single

and remove the line AND posnr EQ '00010' .

Regards


    SELECT  vbeln  kvgr3                  "change this to select single
    FROM vbrp INTO CORRESPONDING FIELDS OF TABLE sdprojectinvoice
    FOR ALL ENTRIES IN l_sdproj
    WHERE vbeln = l_sdproj-vbeln
    AND posnr EQ '00010'                 " remove this 
    AND ps_psp_pnr = l_project.