topic Re: query in Application Development and Automation Discussions

query

Former Member — Thu, 02 Nov 2006 21:33:26 GMT

hi folks,

I having a problem with the query.

data g_eeamt(9) type c,

g_eepct(4) type c.

select eeamt eepct from pa0169 into g_eeamt g_eepct where pa0169-bplan = 'RT04' and begda le pybegda and endda ge pyendda.

what is the problem here?

Thanks

Vinu

Re: query

Former Member — Thu, 02 Nov 2006 21:37:51 GMT

Hi,

Try this..

select eeamt eepct from pa0169 into <b>(g_eeamt,g_eepct)</b> where pa0169-bplan = 'RT04' and begda le pybegda and endda ge pyendda.

Thanks,

Naren

Re: query

Former Member — Thu, 02 Nov 2006 21:39:16 GMT

What's the problem? No data?

Rob

Re: query

Former Member — Thu, 02 Nov 2006 21:41:23 GMT

I see, it doesn't compile. Try:

DATA: g_eeamt(9) TYPE c,
      g_eepct(4) type c.

SELECT eeamt eepct
  FROM pa0169
  INTO (g_eeamt, g_eepct)
  WHERE bplan = 'RT04'
    AND begda LE pybegda
    AND endda GE pyendda.
    
endselect.

Rob

There were still some problems, but s/b OK now

Message was edited by: Rob Burbank

Re: query

Former Member — Thu, 02 Nov 2006 23:23:06 GMT

Yep, I having some problems in the query

select eeamt eepct from pa0169 into (g_eeamt, g_eepct) where bplan = 'RT04' and begda le pybegda and endda ge pyendda.

endselect.

because eeamt (dec) and eepct (Curr) where as the variables are char type.

How can i do that?

Thanks

Vinu

Re: query

Former Member — Thu, 02 Nov 2006 23:24:38 GMT

Hi,

Modiy the variables g_eeamt, g_eepct of the same type of the fields that you are selecting..

THanks,

Naren

Re: query

Former Member — Thu, 02 Nov 2006 23:28:54 GMT

Ultimately I need to have them, stored as char variables for further validation.

Re: query

Former Member — Thu, 02 Nov 2006 23:46:04 GMT

Hi,

Declare the variables like this..

DATA: g_eeamt_char(17) TYPE c,

g_eepct_char(6) type c.

DATA: g_eeamt like pa0169-eeamt.

DATA: g_eepct like pa0169-eepct.

SELECT eeamt eepct

FROM pa0169

INTO (g_eeamt, g_eepct)

WHERE bplan = 'RT04'

AND begda LE pybegda

AND endda GE pyendda.

ENDSELECT.

g_eeamt_char = g_eeamt.

g_eepct_char = g_eepct.

Thanks,

Naren

Message was edited by: Narendran Muthukumaran