help in select

[Former Member]

HI,

i have to add to this select condition that

vbak_{vbtype = 'L' <b>JUST WHEN</b> 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.

[Former Member]

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

[Former Member]

hi fred

maybe u can give example?

regards

[JozsefSzikszai]

hi TAL,

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

ec

[Former Member]

hi eric

its not working well

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

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

Regards

[JozsefSzikszai]

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

ec

[Former Member]

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

[JozsefSzikszai]

than it's simple:

WHERE vbak~ps_psp_pnr EQ l_project AND

vbak~auart EQ 'YMC0' AND

vbak~vbtype EQ 'L'.

[JozsefSzikszai]

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

ec

[Former Member]

hi eric

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

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

Regards

[Former Member]

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

or

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

endif.</b>

Regards

vasu

[Former Member]

hi vasu

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

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

Regards

[Former Member]

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.