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

help in select

Former Member — Mon, 24 Sep 2007 13:54:06 GMT

HI,

i have to add to this select condition that

vbak_{vbtype = 'L' JUST WHEN vbak}auart = 'YMC0'.

what is the best way to do that?

I REWARD

Regards


  SELECT    vbak~vbeln vbak~objnr vbak~audat
            vbak~netwr vbak~waerk vbak~kvgr3
            tvv3t~bezei
            FROM vbak LEFT OUTER JOIN
      tvv3t ON tvv3t~kvgr3 EQ vbak~kvgr3
      AND tvv3t~spras EQ sy-langu
  INTO CORRESPONDING FIELDS OF TABLE lt_vbak
  WHERE vbak~ps_psp_pnr EQ l_project.

Re: help in select

Former Member — Mon, 24 Sep 2007 13:57:22 GMT

I wouldn't do the check as part of the select but instead do the check while looping the internal table.

Re: help in select

JozsefSzikszai — Mon, 24 Sep 2007 13:58:09 GMT

hi TAL,

WHERE vbak~ps_psp_pnr EQ l_project AND

( ( vbak~auart EQ 'YMC0' AND

vbak~vbtype EQ 'L' ) OR

( vbak~auart NE 'YMC0' ).

hope this helps

Re: help in select

Former Member — Mon, 24 Sep 2007 13:58:45 GMT

hi fred

maybe u can give example?

regards

Re: help in select

Former Member — Mon, 24 Sep 2007 14:00:21 GMT

SELECT vbak_{vbeln vbak}objnr vbak~audat

vbak_{netwr vbak}waerk vbak~kvgr3

tvv3t~bezei

FROM vbak LEFT OUTER JOIN

tvv3t ON tvv3t_{kvgr3 EQ vbak}kvgr3

AND tvv3t~spras EQ sy-langu

INTO CORRESPONDING FIELDS OF TABLE lt_vbak

WHERE vbak~ps_psp_pnr EQ l_project

and vbak~vbtype = 'L'

and vbak~auart = 'YMC0'.

SELECT vbak_{vbeln vbak}objnr vbak~audat

vbak_{netwr vbak}waerk vbak~kvgr3

tvv3t~bezei

FROM vbak LEFT OUTER JOIN

tvv3t ON tvv3t_{kvgr3 EQ vbak}kvgr3

AND tvv3t~spras EQ sy-langu

INTO CORRESPONDING FIELDS OF TABLE lt_vbak

WHERE vbak~ps_psp_pnr EQ l_project.

if not it_vbak[] is initial.

sort it_vbak by auart.

read table it_vbak with key auart = 'YMCO' binary search.

if sy-subrc = 0.

if it_vbak-vbtype ne 'C'.

delete it_vbak index sy-tabix.

endif.

endif.

Regards

vasu

Re: help in select

Former Member — Mon, 24 Sep 2007 14:05:38 GMT

hi vasu

i wont vbak_{vbtype = 'L' JUST WHEN vbak}auart = 'YMC0'

meaning i dont wont to get vbtype = 'L' when vbak~auart ne 'YMC0'

Regards

Re: help in select

Former Member — Mon, 24 Sep 2007 14:06:30 GMT

hi eric

i wont vbak_{vbtype = 'L' JUST WHEN vbak}auart = 'YMC0'

meaning i dont wont to get vbtype = 'L' when vbak~auart ne 'YMC0'

Regards

Re: help in select

JozsefSzikszai — Mon, 24 Sep 2007 14:07:02 GMT

hi TAL,

I gave you the solution, not just a very helpful answer...

Re: help in select

Former Member — Mon, 24 Sep 2007 14:08:05 GMT

i have to add to this select condition that

vbak_{vbtype = 'L' JUST WHEN vbak}auart = 'YMC0'.

what is the best way to do that?

I REWARD

Regards

loop at lt_vbak into lh_vbak.

if lh_vbak-vbtype <> 'L' or lh_vbak-auart = 'YMC0'.

perform process_data.

endif.

clear lh_vbak.

endloop.

Re: help in select

Former Member — Mon, 24 Sep 2007 14:09:43 GMT

hi eric

its not working well

i wont vbak_{vbtype = 'L' JUST WHEN vbak}auart = 'YMC0'

meaning i dont wont to get vbtype = 'L' when vbak~auart ne 'YMC0'

Regards

Re: help in select

JozsefSzikszai — Mon, 24 Sep 2007 14:13:13 GMT

TAL,

sorry it is still not clear for me...

if vbak_{auart = 'YMC0' than you need records where vbak}vbtype = 'L'

right?

but, in the opposite? I mean when vbak~auart NOT EQUAL 'YMC0'?

What should be the result?

thanks

Re: help in select

Former Member — Mon, 24 Sep 2007 14:26:09 GMT

hi eric

thankes for your time

i wont just vbtype = 'L'

only for vbak~auart = 'YMC0'

i dont wont any other vbtype = 'L' from table

Regards

Re: help in select

JozsefSzikszai — Mon, 24 Sep 2007 14:28:46 GMT

than it's simple:

WHERE vbak~ps_psp_pnr EQ l_project AND

vbak~auart EQ 'YMC0' AND

vbak~vbtype EQ 'L'.