topic Re: select statement to get value in Application Development and Automation Discussions

select statement to get value

Former Member — Mon, 25 Aug 2008 13:39:52 GMT

hi,

i need to get value field from table bseg for the same document number.

for the same document number, there are several line item. i just want to get :

where hkont = '400000' get the value and put in wa_itab-dmbtr1.

where hkont = '700000' get the value. and put in wa_itab-dmbtr2.

may i know how to use the select statement to get both value?

thanks

Re: select statement to get value

Former Member — Mon, 25 Aug 2008 13:42:09 GMT

Hi,

Select dmbtr from bseg into ( wa_itab-dmbtr1 ) where belnr = p_belnr and ( hkont = '700000' or hkont = '400000' ).

endselect.

Regards

Lekha.

Re: select statement to get value

bpawanchand — Mon, 25 Aug 2008 13:42:24 GMT

where hkont = '400000' get the value and put in wa_itab-dmbtr1.

where hkont = '700000' get the value. and put in wa_itab-dmbtr2.


         Select 
             field1
             field2
             from <tablename>
             into ( w_temp)
             where HKONT eq '400000' OR HKONT EQ '700000'.
    if HKONT EQ '400000' .
          wa_itab-dmbtr1 = w_temp.   
   elseif HKONT EQ '700000' 
      
    wa_itab-dmbt2 = w_temp.
  endif.
  endselect.
   " You need to use OR and one temporary variable

Regards

Pavan

Re: select statement to get value

Former Member — Mon, 25 Aug 2008 13:46:28 GMT

SELECT *

FROM bseg

INTO TABLE it_tab

WHERE hkont IN (''400000' ,'700000' ).

and then pass it to the work area..........

Regards

Anbu

Re: select statement to get value

Former Member — Mon, 25 Aug 2008 13:51:50 GMT

If you are using select........endselect, try this,


SELECT hkont
       dmbtr
  FROM bseg
  INTO (w_hkont,
        w_dmbtr)
 WHERE hkont IN ('400000','700000').

  IF w_hkont EQ '400000'.

    wa_itab-dmbtr1 = w_dmbtr.

  ELSEIF w_hkont EQ '700000'.

    wa_itab-dmbtr2 = '700000'.

  ENDIF.

ENDSELECT.