topic Re: help in select in Application Development and Automation Discussions

help in select

Former Member — Wed, 07 Nov 2007 08:39:00 GMT

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 ' '.

Re: help in select

Former Member — Wed, 07 Nov 2007 08:44:16 GMT

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 ' '.

Re: help in select

Former Member — Wed, 07 Nov 2007 08:45:12 GMT

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,

Re: help in select

Former Member — Wed, 07 Nov 2007 08:46:45 GMT

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 ' '.

Re: help in select

Former Member — Wed, 07 Nov 2007 08:48:11 GMT

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

Re: help in select

varma_narayana — Wed, 07 Nov 2007 08:55:04 GMT

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.

Re: help in select

Former Member — Wed, 07 Nov 2007 09:11:05 GMT

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

Re: help in select

Former Member — Wed, 07 Nov 2007 09:31:23 GMT

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