help in select

[Former Member]

hi,

i wont to do this select for all project that how can i do that fits my condtion how can i do that ?

(in the code the project num is come from user.

Regards

    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 "here for all project 
  INTO TABLE sdpro
  WHERE vbrk~rfbsk EQ 'C'
        AND vbrk~fksto EQ ' '
        AND vbrk~sfakn EQ ' '.

[Former Member]

Hi Ricardo,

Try this..

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'

INTO TABLE sdpro

WHERE vbrk~rfbsk EQ 'C'

AND vbrk~fksto EQ ' '

AND vbrk~sfakn EQ ' '.

[Former Member]

Use

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 <b>NE SPACE</b>

INTO TABLE sdpro

WHERE vbrk~rfbsk EQ 'C'

AND vbrk~fksto EQ ' '

AND vbrk~sfakn EQ ' '.

Is dis wat u need..

Regards,

[Former Member]

hi,

try like this

select-options : s_project type vbrp-pspnr.

if user does not enter anything this range will be blank.

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 IN s_pspnr " use range here

INTO TABLE sdpro

WHERE vbrk~rfbsk EQ 'C'

AND vbrk~fksto EQ ' '

AND vbrk~sfakn EQ ' '.

[Former Member]

If u pass an empty range in where clause it is going to fetch all data

[varma_narayana]

Hi...

Just dont give the condition on that field.

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'

<b>**** AND vbrp~ps_psp_pnr EQ l_project "here for all project </b>

INTO TABLE sdpro

WHERE vbrk~rfbsk EQ 'C'

AND vbrk~fksto EQ ' '

AND vbrk~sfakn EQ ' '.

reward if Helpful.

[Former Member]

hi,

try this code

data:begin of itab occurs 0,

vbeln like vbrk-vbeln,

vbtyp like vbrk-vbtyp,

fkdat like vbrk-fkdat,

netwr like vbrk-netwr,

waerk like vbrk-waerk,

kvgr3 like vbrp-kvrg3,

end of itab.

data:begin of itab1 occurs 0,

kvgr3 like vbrp-kvrg3,

end of itab1.

select vbeln vbtyp fkdat netwr waerk from vbrp into table itab for all enteries in itab1 where condition.

Please reward me the points if you find this answer is helpful

[Former Member]

hi friends

the problem is solved but for some reason i cant have the place that i can reward

i try to access in IE7 and in mo mozzila and i cant see the place of rewarding

i reward latter

Thanks